JHH

=**Lesson Objectives:**=


 * Know how to set up a basic spreadsheet
 * Be able to add simple formula & functions
 * Understand how to create an appropriate graph

Starter Activity
Split into 2 groups - one for boys and one for girls Each group to write on the whiteboard a list of things you will need to spend money on for the Prom

Task
Set out the spreadsheet with the labels shown below. DO NOT add colour or lines!



**Activity** Set yourself a budget for how much you want to spend. Add some data into your spreadsheet. The items you think you will need to purchase and the prices - remember to use the lists the boys and girls made at the beginning to help you remember what you might need to include. Below is price list that might help you.


 * ===**Limo**=== || ===**Price**=== ||
 * 8 Seater || £100 ||
 * Party Bus (12 seats) || £130 ||
 * Fire Limo (10 seats) || £150 ||
 * Pink Limo (8 seats) || £120 ||
 * Hummer (10 seats) || £150 ||


 * Format the Price cells as Currency (right click, format cells, currency)
 * Format the labels
 * Format the title
 * Use the Autosum button to calculate your total

Don't add any lines yet!



Task
Insert 2 extra columns before the Cost column (right click on the column header, Insert, Column) Add the labels "**Share**" and "**Discoun**t"

If you are sharing a cost you will need to DIVIDE the cost by the number of people sharing
 * Start the formula with an **=** sign
 * Click on the **Cost** for that item
 * Type **/** to divide
 * Type the **number** of people you are dividing by
 * Press **Enter**

If you have negotiated a discount you need to calculate this


 * Start the formula with an **=** sign
 * Open a bracket **(**
 * Click on the **cost** for that item
 * Type **/** to divide
 * Divide by **100**
 * Close your bracket **)**
 * Type * to multipy
 * Multiply by your **remainder**

Add a **Total** label and use the **=click** method to copy across the relevant totals. Use the **AutoSum** button to add up your totals.

Add a label for **Budget Difference** and add the formula

Start the formula with an **=** sign Click on your **Prom Budget** Type **-** to minus Click on your **Total**

** If you have time - add some colour and lines to your spreadsheet. **

Activity
Highlight the labels and totals (use control!) and create some appropriate graphs to display your data.

Plenary
Add a Sticky to the wall to explain one thing you have learned today. media type="custom" key="8725064"