Spreadsheet Learning objectives

1. What are spreadsheets? How are spreadsheets used in business and at home? (Spreadsheets are used to store and communicate numbers. You can also use spreadsheets to do "what-if" scenarios.)
2. What are the most popular spreadsheet applications?
3. How do you start the spreadsheet program?
4. How is the display organized? (Rectangle array of cells.)
5. How do you reference cells?
6. How do you navigate around?
7. How do you enter data?
8. What kinds of data can go in a cell? (Text, numbers, formulas)
9. How do you enter each type of data? (Don't forget, you must proceed a formula with an '='s)
10. How do you select one or more cells?
11. What is a function?
12. How do you format cells?
13. Understand how to enter and format the three types of spreadsheet data: numbers, text, and formula.
14. Be able to identify the parts of a simple spreadsheet: raw data, reference numbers, and first and second order calculations. Understand how to plan and format a simple spreadsheet.
15. Understand how to use the function browser to enter functions.
16. Understand how to specify cell references in a formula with the cursor.
17. Understand how relative references are different from absolute references.
18. Understand how spreadsheets can be used to perform "what if" analysis.
19. Understand how to create an amortization table.
20. [Extra. You will not be tested on this skill in class.] Understand how to create a chart from the raw data in a two dimensional table.