Today you will

• Build a practice budget for a class trip to Galway.
• Write formulas that add up the numbers for you.
• Make a spreadsheet for your own Something Real project. We call this your Numbers Sheet.

You will build a budget for a pretend TY trip to Galway. Follow the steps in the box below and tick each one as you go.

If something goes wrong

• If a cell shows the formula instead of a number, change its format to Number and type the formula again.
• If autofill gives the same number in every row, check that {{cell:D2}} starts with = and drag again.
• If you see $ instead of €, open the currency menu again and choose Euro (€).

Which shape fits your project?

Your Something Real is the one real project you picked in lesson 1 to plan and pitch. Next you will build a spreadsheet for it, your Numbers Sheet.

A shape is a plan for that sheet: the four headings to type into row 1, and the summary formulas to put at the bottom of one column. Pick the shape that fits your project.

• Budget, for what a trip, event or fundraiser will cost. Row 1: Item, Cost per person (€), Quantity, Total (€). Work out each total with {{formula:=B2*C2}} and autofill it down, as in the Galway sheet. At the bottom of the Total column, use SUM, MAX and AVERAGE.
• Inventory, for what you need to buy or borrow. Row 1: Item, Unit price (€), Quantity, Total price (€). Work out each total price with {{formula:=B2*C2}} and autofill it down. At the bottom of the Total price column, use SUM, COUNT and MIN.
• Timeline, for the jobs to do before your launch or event. Row 1: Task, Person responsible, Week, Hours needed. At the bottom of the Hours needed column, use SUM, COUNT and MAX.
• Survey results, for what people told you in a survey. Row 1: Question, Yes, No, Maybe. At the bottom of the Yes column, use SUM, MAX and AVERAGE.

Or make up your own, with at least 5 rows of real data and three different summary formulas.