|Lesson Plan ID:
|| 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".
|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
|TC2(6-8) ||13. Use digital tools to formulate solutions to authentic problems. |
|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. |
|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)
|Technology Resources Needed:
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|
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
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
||Using Groups and Peers
|Assisting the Reluctant Starter
||Dealing with Inappropriate
Be sure to check the student's IEP for specific accommodations.
|Variations Submitted by ALEX Users: