BCIS Lesson Plans
January 25-29, 2010

TEKS: 1A-E, 3A, 3B, 3C, 4A, 4B

OBJECTIVES: The students will produce correctly formatted spreadsheets.

The students will complete these tasks while producing spreadsheets:
1. create a workbook, save and enter data
2. enter numeric labels, fractions, center
3. change column width, height, indent text, add comments
4. use undo, clear, check spelling, AutoComplete
5. enter line breaks, dates, format dates
6. use formulas, use formatting toolbar

MODIFICATIONS:
1. Shortened assignments.
2. Extended time for completion.
3. Fewer points per error.
4. Peer tutoring.

TAKS SUPPORT:
1. Proofreading and spelling—Language Arts
2. Math Warm-ups

Monday Report Test
Handout: America’s Castles

Tuesday Math Warm-up
Finish all reports.

Wed/Thurs Math Warm-up
Introduce Excel. Have students create a new Excel folder for saving work.
Discuss workbooks, rows, columns, cells.
Do together on the overhead the handout: How I Spent the Week
Explain formula for Totals and how to copy formulas.
Handout: Roadside Fruit Stand. Do formatting together. Explain formulas for sum and multiplying.
Handout: Attendance and Proceeds
Handout: Fulton Asphalt Paving
Show how to print normal copy and formula copy.

Friday Math Warm-up
Handout: Tall Man’s Closet
Handout: Umbrella Insurance Agency