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

Electronic Spreadsheets

Software designed to help display and process a set of interdependent numeric values

Glossary:

• Cell - one square where you can have a formula, a value or a label (text)
• Malleable Matrix - The set of all cells (including the ones you don't see)
• Rows and Columns

Common Features:

• You can enter, copy, cut and paste values or set of values
• Use formulas to compute values
• Use predefined functions
• Automatic Recalculation
• What if? analysis

Evolution of Spreadsheets

• Visicalc (Apple II),
• Lotus 123 (IBM PC)
• Currently, there are many others, but market is dominated by MS Excel

Example:

Purchase Analysis