Grade 8 Project 1: Planning a trip to Tokyo

Click to see Project Overview and ITSE Assessment Standards

_______________________________________________________________________________

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

Grade 6 & 7: Rollercoaster Tycoon

Step 1 Vanilla Hills: Complete this question sheet for Vanilla Hills

Step 2 Vanilla Hills: Create a detailed mind-map in Prezi showing how you will invest your $10,000. Include all of the costs and the location of your new attractions/facilities

Step 3 Vanilla Hills: Using RCT3 Follow your mind-map and make adjustments to your park to see if you can increase the number of guests in your park and increase weekly profit. How successful were your changes? Complete the Vanilla Hills evaluation worksheet describing what you found

Step 4 Vanilla Hills: You are going to create a spreadsheet to accurately show the amount of money the park creates from operations over a 5 month period (April to August).

Step 5 Vanilla Hills: You will use your their completed spreadsheet to create a graph to compare the costs and income for Vanilla Hills. You will explain what the graphs tell them.

Step 6 Vanilla Hills: You will create a 3 slide PowerPoint presentation to show to the Board of Directors to tell them how well the park is running.

Step 7 Vanilla Hills: There are still problems with people coming to your park! You have decided to have a discount weekend to encourage more young people to come. Choose one of the following options and design the material to advertise the discount weekend.

-          Radio Commercial

-          VIP Ticket

-          2 Page Brochure
-      Poster