Lesson Plan Title: Addition Spreadsheet

Teacher: Mrs. Laubach

Subject: Math

NJCCC Standards Addressed: 4.1A, 4.1B, 4.3B, 4.5B, 4.5F

Objectives: To learn the vocabulary of spreadsheets, to discover how to enter formulas in Excel

Required Materials: Computer with MS Excel

Anticipatory Set (Lead-In): Ability to save into student folder

Step-By-Step Procedures:

1.     Discuss history of spreadsheets and vocabulary associated with them.

2.     Using accompanying worksheet, students type in addends and formulas.

3.     Seeing the resulting spreadsheets, students examine how the formulas worked and explain in a paragraph.

Closure (Reflect Anticipatory Set):  Students share their paragraphs, Using projector students participate in teacher led discussion to make another spreadsheet where three columns of numbers are added (students provide formulas) 

Assessment Based On Objectives: Collection of printouts, Compare final products to requirements from worksheet