Simulations and Modelling: Test without doing

Go Green Travel Company Presentation: Grade 6 + 7 Assignment 1

Dear Student,

You are going to create a presentation for the Go Green Travel Company website.

The presentation must have information about the importance of Green holidays and up-to-date information about the holidays that we are offering.

We would also like you to include information about what people can do to help green tourism.

The presentation must include contact details for Go Green Travel Company and information to customers about where they can book.

Each Slide should include up-to-date information about the date and time.

There could be a maximum of 1 image per slide and 4 bullet points of information.

You also might want to include sound effects or music

Thanks,

Go Green Holidays
The Grass Can be Greener with Go Green Holidays
Customer Service: 866-469-2464
Website: Http://www.GoGreenHolidays.com

Grade 6 and 7: Cover Lesson 29/08/11

Go to T:// Mr Michael and open the document called 'Online Auctions'

You are going to be using data from a business which specializes in selling music and celebrity items. Follow the instructions on the sheet and answer questions 1-13.

If you finish early then click the green button on Sheet 1 to see what to do next.

Video Help (watch these with headphones)

insert new columns and rows
Write a MAX and MIN formula
Calculate a Total with an =SUM formula
Write an AVERAGE formula

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