Computing Spreadsheets Year One Computing Year 56 Spreadsheets

Computing Spreadsheets Year One Computing | Year 5/6 | Spreadsheets | Party Plan Budget | Lesson 5

• I can plan and calculate a spending budget. • I can select and add items from a given list. • I can calculate totals based on price and quantity of items. • I can calculate a running total. • I can calculate an amount remaining from a budget.

What type of food might you have for a party? Can you suggest how a spreadsheet could be helpful for planning party food?

Your task is to create a shopping budget for a party. There will be 20 people attending the party. Everyone must have something to eat and drink, including a choice of meal, some type of snacks and something healthy. Aim to give guests as much as you can afford Spend as close as you can to the limit, without going over! You can only choose items from the list provided. You have a budget of: £ 60

You will need a whiteboard or pen and paper. Make a plan of a potential set of food and drink for one person. Provide at least two alternative choices (you can edit the sandwich filling if you wish!). What items are required?

Examples If there are 20 people and you get 4 yoghurts per pack, how many packs will you need to buy to cater for everyone? Is it cheaper to buy 3 packs of 8 cupcakes or 2 packs of 12 chocolate bars?

Which cells have beenyou merged How will entertogether the price, here? number of items and total? These cells can be copied and pasted from the Available Items list. Decide how many of each item here. What formula could you enter here?

Use the Party Plan Budget Activity Sheet to build a shopping list from the available items on the Spreadsheet. Calculate a running total and amount remaining. Try the Challenge(s) on your activity sheet if you get time.

Your solutions. What amount did you spend and how much did you have remaining? What other similar budget planning could the spreadsheet be used for? Weekly shopping? Packed lunches? Meal planner?

• I can plan and calculate a spending budget. • I can select and add items from a given list. • I can calculate totals based on price and quantity of items. • I can calculate a running total. • I can calculate an amount remaining from a budget.