Grade 8 Cover Lesson 29/08/11

This lesson you should be formatting V.1.0 of your budget model for the Tokyo trip.

In other words, you must change the appearance of your model so that it is simple and easy to use. Your model should have a design so that all of the information that people do not need to see is hidden (usually cells containing formulas).

Also, you can use hyperlinks to link your sheets together and include validation to prevent people from making mistakes. Choose a good color scheme, attractive fonts and select a few images wisely.

Save your work and embed your model into your Blog. Call it 'Budget Model v2.0

Extension:

Check out this video tutorial.

What does the VLookup tool do? How could you include this feature in your spreadsheet model?

Environmental Tourists: The Go Green Travel Company

This spreadsheet shows sample light and temperature data logged in the Go Green Shop.

The data is organized into two columns.The first column shows the time at which the data was logged. The next columns show the data recorded - in this example, temperature and light levels.





https://spreadsheets.google.com/spreadsheet/ccc?key=0Ak_9n59uf3FJdDA2c2ZGZ2t6UWxrbmFqQjJsRzJVVXc&hl=en_US

Grade 8 Assignment 1: Planning a Trip to Tokyo

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 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)
• 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 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






Gantt Chart 
https://spreadsheets.google.com/spreadsheet/ccc?key=0Ak_9n59uf3FJdGJtTl9hQWNod3pCYlZ5Um5xOHllV1E&hl=en_US

Systems Lifecycle
https://docs.google.com/present/edit?id=0AU_9n59uf3FJZGhkZmR3dmpfMjR0Y3J6Z3Fudw&hl=en_US

Trip Worksheet
https://spreadsheets.google.com/spreadsheet/ccc?key=0Ak_9n59uf3FJdDNyYmxMLS0yV2lzdUZoczk3Tm9TRHc&hl=en_US

Design Your Coat of Arms

Create a coat of arms or shield design that best represents you.

You can use the following design or make your own.

You may draw images or symbols that show:

• Favourite subjects
• Sports
• Hobbies
• Family
• Places
• Something you are good at

Using Google Docs to Share and Collaborate

Google Documents allow the live updating of a shared workspace.

However, there are limits on the number of synchronous collaborators for each Doc type.

10 people can edit a Presentation at the same time.
50 people can edit a Spreadsheet simultaneously.
50 people can edit a Document at the same time.

There is a limit of 200 combined viewers/ collaborators for all of the different Doc types.

Classwork:
https://spreadsheets.google.com/spreadsheet/ccc?key=0Ak_9n59uf3FJdE11emlTSkpaeE5LSElCYkkzMUlLZkE&hl=en_US

Homework:
Use formula's and functions to analyze, average, chart and explore the data.

Can you notice any trends?

Set up a Blog using Google Blogger