The table below outlines how specific computer hardware and software skills progress as students progress through the school.
At the end of each school year, students will be able to...
| Year |
Spreadsheets |
| Kindergarten |
- Recognize simple spreadsheets.
|
| Grade 1 |
- Recognize cells, row headings and column headings
- Create a spreadsheet as a large group inserting data in columns and rows
|
| Grade 2 |
- Use a spreadsheet template to classify and compare research information with teacher assistance
- Save a spreadsheet
- Print a spreadsheet
|
| Grade 3 |
- Create a simple spreadsheet with teacher assistance
- Select the type of graph to display information with teacher assistance
- Insert a graph into word processing documents
- Name, test and edit a spreadsheet
|
| Grade 4 |
- Create a simple spreadsheet independently
- Determine data items to use in a spreadsheet
- Insert data in column and rows
- Select the type of graph to display information independently
- Insert a graph into word processing documents with teacher assistance
- Use tools to manipulate color, labels, and titles.
|
| Grade 5 |
- Determine data items to use in a spreadsheet independently
- Insert data in column and rows independently
- Select the type of graph to display information independently
- Insert a graph into word processing documents independently
- Name, save, test and edit a spreadsheet independently
- Print a spreadsheet independently
- Use tools to manipulate color, labels, and titles independently
- Use a spreadsheet to display a chart, table or graph independently
- Manipulate cell sizes to accommodate data
- Incorporate borders
|
| Grade 6 |
- Create a simple spreadsheet to simulate and explore a situation with teacher assistance
- Use a spreadsheet to calculate and display comparisons
- Cut, copy, and paste data
- Select a font to display the information
|
| Grade 7 |
- Create a simple spreadsheet to simulate and explore a situation independently
- Insert a spreadsheet into a word processing document
- Determine print range
- Sort data in ascending and descending order
- Create and manipulate tables in a word processing document
|
| Grade 8 |
- Create a complex spreadsheet using multiple mathematical operations (formulas, graphs and tables) with teacher assistance
- Insert formulas and calculate equations with teacher assistance
- Insert a header and footer
- Choose a spreadsheet program to graph statistical data
|
| Grade 9 |
- Create a spreadsheet using mathematical operations such as formulas, graphs and tables
|
| Grade 10 |
- Create graphs and table to analyze statistical data
- Use a spreadsheet for mathematical mapping
- Use a spreadsheet for advanced mathematical functions
- Use a spreadsheet to make mathematical predictions
|
| Grade 11 |
- Create graphs and table to display complex data to show relationships
- Interface spreadsheets with external devices such as probes and graphing calculators.
|
| Grade 12 |
- Use spreadsheets to compile and analyze data for original research
|