|
| |
-
Communication
Literacy
|
Grade Level |
K |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
S1 |
- Spreadsheet
Design
Students will:
|
Design a spreadsheet according to
needs (MS Works, MS Excel) |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
Create
Students will: |
Create a new spreadsheet |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
Enter labels
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
Enter information |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
Existing
Students will: |
Open existing file |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
Add new information in existing
spreadsheet |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
Save
Students will: |
Save updated records to existing file |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|

-
Communication
Literacy
|
Grade Level |
K |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
S1 |
Save As
Students will be
able to: |
Use Save as… to save a spreadsheet
with a new name and/or to a new location |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
Manage
Information:
Students will be
able to: |
Move to a specific cell
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
Select a cell or blocks of cells |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
Modify data (change data or correct
information in cells) |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
Use Fill Down, Fill Right, Fill Series
features |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
Layout
Students will: |
Format a cell or cells |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
Format text |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|

-
Communication
Literacy
|
Grade Level |
K |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
S1 |
Layout
Students will: |
Change number format |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
Emphasize cells with
bold, italics, or underline features |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
Emphasize cells with
borders |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
Change column widths
and row heights |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
Build a formula into
a cell |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
Copy and paste values
and formulas into selected cells |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
Insert or delete
rows, columns or blocks of the spreadsheet |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|

-
Communication
Literacy
|
Grade Level |
K |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
S1 |
Layout
Students will: |
Display or remove the grid lines,
column and row headers for printing |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
Set page layout and page breaks
for printing
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
Select printer and print document |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
Sort and
Arrange Data
Students will: |
Retrieve using greater than
(>), less than (<), and range criteria
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
Protect cells from changes |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
< |