CMPS 002 - Computer Literacy

Prof. Paulo Franca

CyberSlug Rules!

Classes

Class Syllabus

Grading Policy

Labs

• Assignments
• Schedule

Interact

Login

• enter system
• get attendance
• submit work
• take lab quiz
• check scores

Help

Help me!

Links

• UC Santa Cruz
• School of Engineering
• ACM
• IEEE

Staff only

Datacare   Ahshay

Spreadsheets - The basics

History and Products:

• Visicalc (Apple)

• Lotus 1-2-3 (Lotus)

• Excel (Microsoft)

• Many others

Principles:

• Malleable Matrix (indefinite size - rows x columns)

• Letters for columns, numbers for rows

• Cells - (may contain: value, text, formulas)

• Formulas may refer to other cells

• Automatic recalculation

• Relative x Absolute cell addressing

Advantages:

• can be sent as email attachment

• can be incorporated into documents

• all affected values change automatically

• "what if" analysis