| Day 1 |
November 17 |
| Objective |
Reinforce concepts learned in
Excel spreadsheet, introduce new concepts |
| Opening Activity |
|
| Presentation of Material |
Freeze panes, split,
"fit-to", absolute references, formulas |
| Guided Practice |
Add grades to grade
spreadsheet |
| Notes/Materials |
Hand back outlines |
|
Homework |
2nd outline of paper due December 5 |
| Day 2 |
November 18 |
| Objective |
Reinforce concepts learned in
Excel spreadsheet |
| Opening Activity |
|
| Presentation of Material |
|
| Guided Practice |
Continue modification of
grades workbook |
| Notes/Materials |
|
|
Homework |
2nd outline of paper due December 5 |
| Day 3 (Block) |
November 19 |
| Objective |
Create a new spreadsheet,
reference other spreadsheets in workbook, create a custom header |
| Opening Activity |
|
| Presentation of Material |
Identifying cells using
worksheet address and place value in another worksheet to be used in computations |
| Guided Practice |
|
| Notes/Materials |
Timed writings |
|
Homework |
2nd outline of paper due December 5 |
| Day 4 |
November 21 |
|
Objective |
Reinforce concepts learned in Excel
spreadsheet |
|
Opening Activity |
|
|
Presentation of Material |
|
|
Guided Practice |
Continue modification of grades workbook |
|
Notes/Materials |
|
|
Homework |
2nd outline of paper due December 5 |