Have open the Excel file budgeting for a holiday and all the children need to have the two price lists in front of them.

Scenario - Greece Holiday
This week we are going to pretend that they have won a certain amount of money on the lottery and they have decided to spend it on a holiday to Greece.

However to do this the need to be able to budget. 

• What does the word budget mean? 
• Why is it important to budget? 

If you didn’t budget then the chances are you would spend more money then you actually own. 

A spreadsheet can help you to budget.

REMEMBER:  YOU ONLY HAVE $3500 TO SPEND.

MODEL WHAT TO DO: Open the Week 4 – Budgeting for a holiday spreadsheet

Notice:

• All the activities have already been entered down column A. 
• Column B is the price of each activity. 
• They must remember that this is the price of 1 single flight, 1 person per night in a hotel, 1 person to take part in an activity etc. 
• Column C is the quantity. 
• What does quantity mean? 
• If 2 people are going on the holiday and they want both people to do the activity they must enter a 2. 
• If they want both people to do the activity twice they must enter 4.

• With the children fill in the quantity column for your own holiday. 
• The quantity column needs to be completely filled in. 
• If you don’t want to do certain activities fill it in with a zero.

• Now you need to calculate the total for each activity.

• Click into cell D5. 
• This will be the cost for the single flights – economy class. 
• Type in =B5*C5 then press enter. 
• Then click back into cell D5. 
• When the black cross appears drag down. 
• This carries the formula down for all the other cells and saves you typing the formula in for all of them! 
• Students: 
• Estimate whether you are going to be over or under budget at this point. 
• Why do they think this?

• Now to work out the grand total. 
• What do we need to do to work out the grand total? 
• What operation are we using? 
• Addition. 
  
  
• Click on to cell D20. 
• Can anyone remember how we could work out the grand total? 
• Write up possible ideas on the whiteboard. 
  
  
• One way you could calculate the grand total is by typing =SUM(D5:D19) then press enter. Make sure there are no spaces.
  
  
• Am I over or under budget? 
• How could I make the holiday more or less expensive so I spend around $3500? 
• Show the children that you can just click on the existing quantities and type over them. 
• This automatically changes the total and the grand total!
  
  
• Who can budget for a holiday closest to $3500?