_______________________________________________________________________________
You will learn how to manage a budget and organize a trip. The aim of the project is to create a spreadsheet which will calculate the costs for a class trip to Tokyo 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)
- Accommodation
- Trips
Second: Create a layout for the Tokyo 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
________________________________________________________________
Project Resources
Gantt Chart
Systems Life-cycle
Trip Worksheet
Testing Sheet
Project Rubric
No comments:
Post a Comment