Home  |    Add Bookmark   |   Print Friendly   |   Rate This Lesson Plan   |   Suggest a Variation

## Lesson Plan

You may save this lesson plan to your hard drive as an html file by selecting "File", then "Save As" from your browser's pull down menu. The file name extension must be .html.

This lesson provided by:
 Author: Leah Drauch System: Cullman County School: West Point Middle School

General Lesson Information
 Lesson Plan ID: 14761 Title: All I Want for Christmas (a spreadsheet investigation) Overview/Annotation: Students will complete a Santa list using a Spreadsheet. Students will enter a list of items they want for Christmas, try to estimate the cost, and total their cost. They will then go on an internet shopping trip to find the actual cost of their items. They will then have an itemized list they can give to their special "santa".

Associated Standards and Objectives
Content Standard(s):

Local/National Standards:

Primary Learning Objective(s):

The purpose of this lesson if to reinforce the skills needed to create a spreadsheet. This lesson will allow students to practice entering data and setting up formulas. In addition, this lesson will allow students to see a practical use for spreadsheets.

Preparation Information
 Total Duration: 31 to 60 Minutes Materials and Resources: Computer with Microsoft Excel (or other spreadsheet program)Internet accessInstructions sheet Technology Resources Needed: Microsoft ExcelInternet connection Background/Preparation: Students should be introduced to basic data entry in spreadsheets prior to the use of this lesson. They should know the Sum formula and also basic internet navigation.

Procedures/Activities:
 1.)1. Give each student a copy of the first page of the instruction sheet (attached). Read through the assignment with the students to check for understanding of what they need to accomplish today. 2.)Circulate in the room to make sure the students are following the given instructions and staying on task. 3.)On the following day, give students a copy of page 2 of the instruction sheet (attached). Today students will visit the internet. You may wish to add sites to the instructions. I try to keep all my students on the same site so that I can monitor more closely.

 Attachments:**Some files will display in a new window. Others will prompt you to download. All I want for Christmas is.doc

Assessment
 Assessment Strategies Have students show their work to the teacher. If it is approved by the teacher, students can then print to give to their "Santa". Students will be given a grade in relation to how well they followed the instructions.

 Acceleration: You may wish to use this at other times during the year. You could simply change the instruction sheet to say that students have won a \$500 shopping spree to an internet store, etc... Intervention:
 Each area below is a direct link to general teaching strategies/classroom accommodations for students with identified learning and/or behavior problems such as: reading or math performance below grade level; test or classroom assignments/quizzes at a failing level; failure to complete assignments independently; difficulty with short-term memory, abstract concepts, staying on task, or following directions; poor peer interaction or temper tantrums, and other learning or behavior problems. Presentation of Material Environment Time Demands Materials Attention Using Groups and Peers Assisting the Reluctant Starter Dealing with Inappropriate Behavior Be sure to check the student's IEP for specific accommodations.