Menu Bar

Sunday, February 12, 2012

Grade 8 Project 1: Planning a trip to Tokyo


_______________________________________________________________________________

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 
Using the Internet you will need to find the costs of each trip, accommodation and flights. You will complete a trip worksheet using the research you have gathered.

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