I = Introduce R = Reinforce IU = Independent User
|
1. Create and save spreadsheet |
K | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| a. Identify intended use | I | R | R | R | R | R | |||||||
| b. Specify data organization | I | R | R | R | R | R | |||||||
| c. Determine columns and rows | I | R | R | R | R | R | |||||||
| d. Set cell attributes | I | R | R | R | R | R | |||||||
| e. Create simple calculation formulas | I | R | R | R | R | R | |||||||
| f. Enter and edit data | I | R | R | R | R | R | |||||||
|
2. Retrieve data |
K | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| a. Sort data | I | R | R | R | R | R | |||||||
| b. Create chart(s) | I | R | R | R | R | R | |||||||
| c. Print spreadsheet | I | R | R | R | R | R | |||||||
|
3. Edit data |
K | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| a. Insert column or row | I | R | R | R | R | R | |||||||
| b. Delete column or row | I | R | R | R | R | R | |||||||
| c. Use fill down/across | I | R | R | R | R | R | |||||||
| d. Save updated spreadsheet | I | R | R | R | R | R | |||||||
|
4. Generate graphs from spreadsheet |
K | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| a. Determine and create appropriate type of graph | I | R | R | R | R | R | |||||||
| b. Incorporate graphs in word processing | I | R | R |