DUAL CREDIT LESSON PLANS
Feb 1 – Feb 5, 2010

Objectives: enter data in a spreadsheet, understand difference in cells, rows, & columns, Align data, change width of columns & rows, sort data, use auto fill, format cells as currency & dates, understand and use formulas

Modifications: 1. Close monitoring by teacher
2. Shortened assignments
3. Extended time for assignments
4. Less points per error on assignments

Monday 2/1 Math Warm-up
Excel – Payroll
Supplementary overtime wages spreadsheet

Tuesday 2/2 Math Warm-up
Excel – Payroll
Supplementary gross pay/deductions/net pay spreadsheet


Wednesday 2/3 Classes 1, 3, 5, 7 meet
Math Warm-up
Excel – Payroll
TEST - Spreadsheets


Thursday 2/4 Periods 2, 4, 6 meet

Friday 2/5 Math Warm-Up
Excel - Filters