Grade 7 Assignment 1: Organising a Music Event

You are going to organize a music event at AIS. You only have $100 dollars to spend on it and there are many costs to consider. However, you can earn extra money to pay for things by selling tickets and food for the event.

First: Design a spreadsheet that will calculate whether it is possible to hold the event. You will use functions and formula to calculate the totals. It must also help you decide on the prices of things such as tickets and food. Finally, it should show you if you can make a profit or not!

Costs
DJ (Hire) - $50
Music PA system (Hire) - $30
Lights (Hire) $30
Caretaker - $5
Cooks - $20

Second: Design an attractive poster which will advertise the music event. You should include ticket prices and the price of food available to buy.

Grade 8 Assignment 1: Planning a trip to New York

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 New York 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 New York 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. .

Can you make cartoons?

GoAnimate is a cool new online program for designing and creating your own animations. Use it as an exiting new way to present information, or just for fun! It's free, so enjoy

Powerpoint....or Prezi?

Why should you move beyond slides? on Prezi

Why Spreadsheets?

I have just been reading Terry Freedman's post on Excel spreadsheets and I was so pleased to see someone voicing my thoughts.

This spreadsheet was used for children to check their tables, there are different worksheets for each one.


I love spreadsheets for all sorts of things and you can make many that can be used in all sorts of interesting and useful ways.

This idea is simple and can be used in any subject area. It uses a if/then statement, it changes the red sad face to a smiling green one and gives the user their score.


I have found some ideas like this to be really useful and fun to use in the classroom.