| Day 1 |
November 17 |
| Objective |
Reinforce concepts learned in
Excel spreadsheet |
| Opening Activity |
|
| Presentation of Material |
Freeze panes, split screen,
"fit-to", absolute references, formulas |
| Guided Practice |
Add grades to grade
spreadsheet |
| Notes/Materials |
Hand back outlines |
|
Homework |
|
| Day 2 |
November 18 |
| Objective |
Reinforce concepts learned in
Excel spreadsheet |
| Opening Activity |
|
| Presentation of Material |
Pop Quiz |
| Guided Practice |
Continue modification of grade
workbook |
| Notes/Materials |
|
|
Homework |
|
| Day 3 (Block) |
November 19 |
| Objective |
Create 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 |
|
| Day 4 |
November 21 |
|
Objective |
Reinforce concepts learned in Excel
spreadsheet |
|
Opening Activity |
|
|
Presentation of Material |
|
|
Guided Practice |
Continue modification of grade workbook |
|
Notes/Materials |
|
|
Homework |
|