Tuesday, 10 December 2013

Santa's Shopping

L/Os: To develop your spreadsheet skills

Outcomes: You will develop your understanding of the MULTIPLY formula by filling in Santa's Shopping

Starter - 5 minutes


Find your Data Collection Form
Enter your data into my Year 7 Data Collection sheet

Main Task - 50 minutes


You are going to continue working on a spreadsheet - but this time it is one from Santa!!


  1. Open this link
  2. Download Santa's Shopping
  3. Open Santa's Shopping in Microsoft Excel
  4. Use the Internet to find the items on his list
  5. The winner is the person with the LOWEST total!
  6. Extension Task:
  • Open Microsoft Word
  • Take a PrintScreen of your shopping list and paste it onto your new document
  • Annotate the list and explain which formula was used to get a Subtotal


Plenary - 5 minutes


Swap seats with a partner and give feedback using 2 Stars and a Wish

No comments:

Post a Comment

Elite of the Week

Create your free online surveys with SurveyMonkey , the world's leading questionnaire tool.

Year 10/11 Deadlines