Y5 Spreadsheets 3 – Party budget

May 152023
 
  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?

Y5 Spreadsheets – investigations

May 022023
 

1 Going up the wall

  1. Open the Going up the wall spreadsheet
  2. Follow the instructions under the wall and write your answers in the boxes

2 Giant multiplication grid

  1. Start a new Google Sheets
  2. In A1 put an X
  3. In A2 to A11 put the numbers 1 to 10
  4. In B1 to K1 put the numbers 1 to 10
  5. You could format your spreadsheet – change text size, change column widths, colour column A and row 1, add grid lines
  6. In B2 put this formula: =A2*B1 (this does 1 X 1 and shows the answer 1)
  7. Copy the formula by selecting it and dragging the corner down
  8. This should give the 1 times table. Is it right?
  9. Can you work out what has gone wrong with the formulae?
  10. Change the formula in B2 to: =$A2*B$1
  11. The $ symbol means that when we copy it doesn;t change the A or the 1
  12. Now copy again to get the 1 times table
  13. Now drag across to get the other times tables
  14. Can you extend your mutliplication grid to be 25 x 25? Even bigger?

Giant multipication grid video

Conditional formatting

  1. Select the range of answers
  2. Conditional formatting:
    • custon formula is
    • =iseven(B2)
    • choose a cell colour
  3. This shoud highlight even numbers

3 1-100 grid

  1. Set up a 1-100 grid
    • Put 1 in the top corner cell A1
    • Put =a1+1 next to it in cell B1
    • Drag this cell to the right up to 10 (cell J1)
    • Put =a1+10 underneath in cell A2
    • Drag this to the right up to J2
    • Then drag this row down
  2. Use conditional formatting to highlight different multiples
    • custon formula is
    • =mod(b2,2)=0 should hightlight multiples of 2
    • choose a cell colour
  3. Screenshot the patterns and paste onto a j2e5 page