Heidi
Good to see you again! How about a try at working with a spreadsheet in your classroom. Here's a lesson plan using an interactive spreadsheet.

line

Spreadsheet Lesson Plan


1. Unit Goal:

The student will develop an appreciation for children's literature.

2. Instructional Objectives:

The student will perform math calculations using a spreadsheet.
The student will answer questions concerning calculations made.

3. Set:

Before we begin our lesson, let me ask if anyone has ever helped to plan a meal? Have you ever helped shop for the groceries? Today we're going to start our lesson by reading a popular story concerning a particular meal written by Dr. Seuss. Listen closely and think about all the ingredients that would be involved in preparing the meal. The story is called Green Eggs and Ham.

4. Instruction:

After reading the story, ask students what the meal was that "Sam I Am" refused to eat. Have students list the ingredients (eggs, cooking oil, ham, and green food coloring). Have a prepared interactive spreadsheet ready. Make sure to have already entered necessary addition formula into the spreadsheet. Have document contain the following instructions and information:

Read the instructions below, complete the questions that follow based on the information provided by the spreadsheet you have completed.

1. Click on cell B6 and highlight.
2. Move cursor to "calculate" menu and click on "calculate now".
3. Hit the return/enter key.
4. Repeat the process for cells C6, D6, and E6.

Fill in the cells as follows prior to your lesson. Amounts may be adjusted to allow for practice with regrouping:

A2--eggs
A3--ham
A4--cooking oil
A5--green food coloring
A6--TOTAL
B1--Krogers
B2--$1.10
B3--$4.00
B4--$.45
B5--$.23
C1--Food City
C2--$1.00
C3--$3.11
C4--$.50
C5--$.31
D1--Bi-Lo
D2--$1.12
D3--$4.00
D4--$.42
D5--$.35
E1--Winn Dixie
E2--$1.05
E3--$3.00
E4--$.53
E5--$.40

1. Which store sells eggs for the best price?
2. Where could you buy the least expensive butter?
3. At which store will you spend the least amount of money for all necessary items?

The questions above should be typed below the spreadsheet on the word processing document.

5.Closure:

After students have completed spreadsheet activity, take turns sharing their answers. Allow time for correction and discussion. Hand out copies of spreadsheet lesson for extra practice with manual calculation.

6.Reminders:

Any special circumstances?

Children with special needs?

7.Self-Evaluation:

What would you do differently?

What were the successes?

What were the problems?


line 
border

RED BALLBack to Technology Lesson Plans

RED 
BALLBack to Terrie's Tours