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 |