ALEX Lesson Plan


All I Want for Christmas (a spreadsheet investigation)

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


All I Want for Christmas (a spreadsheet investigation)


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):
TC2 (6-8)
5. Use basic features of word processing, spreadsheets, databases, and presentation software.
Examples: word processing—reports, letters, brochures
spreadsheets—discovering patterns, tracking spending, creating budgets
databases—contact list of addresses and telephone numbers
presentation software—slideshow
TC2 (6-8)
6. Select specific digital tools for completing curriculum-related tasks.
Examples: spreadsheet for budgets, word processing software for essays, probes for data collection
TC2 (6-8)
11. Use digital tools and strategies to locate, collect, organize, evaluate, and synthesize information.
Examples: locating—Boolean searches, graphic organizers, spreadsheets, databases
collecting—probeware, graphing calculators
organizing—graphic organizers, spreadsheets
evaluating—reviewing publication dates, determining credibility
synthesizing—word processing software, concept-mapping software
TC2 (6-8)
13. Use digital tools to formulate solutions to authentic problems.
Examples: electronic graphing tools, probes, spreadsheets
TC2 (9-12) Computer Applications
5. Utilize advanced features of spreadsheet software, including creating charts and graphs, sorting and filtering data, creating formulas, and applying functions.
TC2 (9-12) Computer Applications
6. Utilize advanced features of multimedia software, including image, video, and audio editing.

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.

Additional Learning Objective(s):

 Preparation Information 

Total Duration:

31 to 60 Minutes

Materials and Resources:

Computer with Microsoft Excel (or other spreadsheet program)

Internet access

Instructions sheet

Technology Resources Needed:

Microsoft Excel

Internet connection


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.
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.

**Some files will display in a new window. Others will prompt you to download.

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.


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...



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.