Grade 8 Assignment 1: Planning a trip to New York

You will learn how to manage a budget and organise a trip. The aim of the project is to create a spreadsheet which  will calculate the costs for a class trip to New York and which will tell you whether the trip is possible or not.

First: Create an itinerary including the following minimum elements

• Flights (There and Back)
• Accomodation
• Trips 

Using the Internet you will need to find the costs of each trip, accomodation and flights. You will complete a trip worksheet using the research you have gathered.

Second: Create a layout for the New York Budget spreadsheet using the example given.

• You will complete the revenue worksheet and add it to your spreadsheet.
• You will use functions and formula to calculate the totals.Calculate how much each student will need to pay over a four month period. Is the trip over budget or under budget?
• Create a chart showing the costs of each trip and the flights

Third: Create a leaflet giving all of the relevant information to parents about the trip and the different activities on it such as where the trips are, Cost breakdown of the trip and flight information. .