Google Sheets Holiday “Shopping”

Teach an introductory lesson to Google Sheets by doing some holiday shopping!

Link to Template (Click TEMPLATE in the right corner to make a copy)

Screen Shot 2018-12-18 at 5.23.07 PM

What will students learn?

Students will learn how to enter data, enter basic formulas, use FUNCTIONS, and create a graph by following the directions in the second tab. They can even checkoff the items as they work using the checkboxes.

Screen Shot 2018-12-18 at 5.25.38 PM.png

Where do students “shop”?

Students shop using this imaginary inventory. Shop for toys, household items, electronics, or even clothes and personal items!

Screen Shot 2018-12-18 at 5.38.40 PM

How can I differentiate for different learners?

This activity is geared towards students in Grades 3-5. You may differentiate the activity by using different templates linked using the Tabs at the bottom of the Sheet. For example, if you want a template with the formulas or headings already inserted, you could use the tab labeled “Differentiation with Formulas”.

Screen Shot 2018-12-18 at 5.27.59 PM

What do students graph?

I added this easy activity for students to graph sales of popular toys. Then, use the checklist below to analyze the data and enter formulas!

Screen Shot 2018-12-18 at 5.39.53 PM.png

How may I assess learning?

Use this nifty exit ticket to assess learning! Add questions, tasks and activities as needed! You can pretty much turn Google Sheets into an activity pack! Or, add a rubric on a new tab!

(Example Exit Ticket Tab)

Screen Shot 2018-12-18 at 5.31.31 PM.png

Do your students do any “holiday shopping” using Google Sheets? I’d love to see your lesson!