Party
Last updated June, 2004
'THE YEAR 7 PARTY'
What you will do
This unit concentrates on setting up a model of the operation of a school party using a spreadsheet in Excel. Look at this PowerPoint show to see what is involved.
Task 1 Publisher
Do this tutorial in using Publisher to make tickets, invites and banners. DO NOT PRINT ANYTHING!!! You will not have a price for your tickets yet, but leave a space for it!!!
Task 2 Putting together the publicity materials
Use what you have learned to create the 'publicity materials' for your party. Try to use a 'house style' - that is, similar images, fonts, borders and colours.
Task 3 getting some food prices
Before you start, look at this PowerPoint show about spreadsheets
Collect information about food cost, room costs and disco hire. Use these on line food store links to help you find the cost of things for a great party! Click on the logos to go there. Try to compare costs and get the best prices!
You will need to enter the postcode BA1 5JU to make it work.
Enter the food type and costs into a spreadsheet like this.
| A | B | |
| 1 | Item | Cost |
| 2 | Crisps | £1.00 |
| 3 | Lemonade | £1.50 |
| 4 | Twiglets | £.80 |
| 5 | Party hats | £1.10 |
| 6 |
Task 4 Finding costs
Look at this model for finding the ticket price for a disco.
To find prices with spreadsheets you need first to look at this page about suing something called Goal Seek.
To keep the price affordable you will use a spreadsheet to enter costs and then change them to help you find a reasonable cost for a ticket t your party.
Spreadsheets can be very useful for this! Before making the party spreadsheet, you are going to have a quick look at how a spreadsheet can track your pocket money. Open up this spreadsheet and enter the numbers required - see how the spreadsheet does not have be set up each time - you can "model" different ways of spending your money. Read more about this project here.
Here is another spreadsheet set up to show you how you can model things.
Task 5 the party spreadsheet
Now you will use Excel to plan the costs of your party.
Enter your data like this:
| A | B | C | D | E | |
| 1 | Item | Cost | Shared | HOW MANY SHARE? | COST PER PERSON |
| 2 | Disco hire | £100 | Y | 250 | =B2/D2 |
| 3 | Room hire | £25 | Y | 250 | =B3/D3 |
| 4 | Bottle of drink | £1.50 | Y | 6 | =B4/D4 |
| 5 | Packet of crisps | .20 | N | 0 | =B5 |
| 6 | COST PER PUPIL | =E2+E3+E4+E5 |
-
In D2 you should enter the number of people attending the party.
-
In column E the formulas you need to enter are showing - what does each formula do?
-
You will need to make your spreadsheet allow you to find out what happens if there is a disaster (someone cancels coming to the party) and also what happens to ticket prices if the type or amounts of food and drink is changed. Use the spreadsheet to do some modelling - change the number of people, change the room costs, change the food costs. Add some more food.
A data file to use called PARTY is located here.
Task 6 Final versions
Once you have found the cost for your party, you must complete the Publisher documents to show the ticket costs. When you have done this, ask your teacher to check your work, then print out your final versions.
Task 7 Computer systems - what are they?
You have created a simple working computer system - read about computer systems here.
Task 8 On line models
Run through this exercise to find out how models on the internet can be used.
Task 8 Evaluation
Write an evaluation of your work. Click here to get a copy of the template or use this blank form to write on.
What level have you achieved?
Look at examples of work and check your level here!
At the end of this unit
- you should be working at level 5 if you can: produce a spreadsheet that meets a specific aim of meeting a target price for a ticket and construct and manipulate a spreadsheet model using formulae; enter prices found from the Internet and re-enter new prices to meet the target price. Find prices from two different web sites. Understand computers systems contain a number of different parts and name the inputs and outputs
- you are working at around level 4 if you can: enter some prices into a spreadsheet and find a total cost of all the items. Find some prices for party items. Name some ways of getting information into a computer and what outputs there are.
- you may be working at level 6 if you can: produce a spreadsheet that contains formulae and functions and solves the problem of what do we charge for the party accurately. Find and select prices from a range of web sites. Describe the four main parts of a computer system
The Projects
 |
Elvis and Ernie |
|
|
Fact or opinion? |
|
|
Lottery Bid |
|
|
Newspaper |
|
|
Party |
|
|
Sports Day |
|
|
Weather |
|
|
Changing Rooms |
Other links
|
|
Quiz Pages |
|
|
Teacher's guide |
|
|
What is your level? |
....................................