Y5 Spreadsheets 3 – Party budget

1. Finish party budget
2. Multiplication square
3. Conditional formatting pixel art

The task

• Imagine you are organising a class party.
• You need to buy the food but also cups, plates and serviettes
• You have a budget of £60
• Design a spreadsheet which will help you work out the costs and experiment to see what you could buy

Steps to success

1. Set up your spreadsheet
   • Columns: Item, link, pack size, number, cost, total cost,
   • Rows: headings, a row for each item, Grand total, Money left to spend
   • Formulae: total cost and Grand total, money left
   • ** Add more columns/worksheets to compare different supermarkets
2. Search for items and enter item, links, pack size and costs in your spreadsheet
3. Experiment by putting different values in the number cells to see what you can afford
4. Decide on your shopping list and explain your choices.

How did using a spreadsheet make this easier?