Professional Learning Podcast Treasury Lesson Plans Personal Workspace Site Search ALEXville Learning Assets Home Courses of Study
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
Lesson Plan ID: 14761
Title: 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".
Content Standard(s):
TC2(6-8) 5. Use basic features of word processing, spreadsheets, databases, and presentation software.
TC2(6-8) 6. Select specific digital tools for completing curriculum-related tasks.
TC2(6-8) 11. Use digital tools and strategies to locate, collect, organize, evaluate, and synthesize information.
TC2(6-8) 13. Use digital tools to formulate solutions to authentic problems.
TC2(9-12) Computer Applications5. Utilize advanced features of spreadsheet software, including creating charts and graphs, sorting and filtering data, creating formulas, and applying functions.
TC2(9-12) Computer Applications6. 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):  
Approximate Duration of the Lesson: 31 to 60 Minutes
Materials and Equipment:
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.

Attachments:**Some files will display in a new window. Others will prompt you to download. All I want for Christmas is.doc
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.
Variations Submitted by ALEX Users:
Alabama Virtual Library
Alabama Virtual Library

Hosted by Alabama Supercomputer Authority
The University of Alabama at Birmingham
The University of Alabama at Birmingham
The Malone Family Foundation
The Malone Family Foundation
Best of the Web