continuing last lesson…

Print your Text document. 

Print preview your work BEFORE you print it.  Check that your NAME is in the header.  Have you included:

• BEFORE – with web address. 
• CHANGES – font type, size, style, colour and (MOST IMPORTANT) wording
• AFTER  – Text wich will be included in your leaflet.  

NOW print your work to the KC2mono printer.

LESSON 4

Starter: What do you know about spreadsheets? Try this QUIZ  to find out. 

Task C – Developing numbers

1. From the website catalogue and the printed catalogues you have found, identify a selection of outfits which will be suitable for a teenager to attend a formal event. 

2. In MS Excel, open a new spreadsheet and save it with a sensible name (e.g. “Cost of Formal Outfit for Teenager”) and put a suitable heading at the top (e.g. “Cost of Formal Outfit for Teenager”). 

3. For each of your shops you need to list the items and their prices which you have chosen for the outfit (e.g. hat or other head wear, dress, suit or other suitable attire, footwear, outer clothing such as a coat, jacket if required, other accessories such as handbag or bouquet if required). 

4. You will need to calculate;

• a total for each using =SUM 
• an average cost across the outlets using =AVERAGE 
• rank the total costs using =RANK

5. Print out your spreadsheet ON ONE PAGE with the numbers showing.  Add your NAME, FORM / GROUP and DATE to the header and PAGE NUMBERS to the footer.  

If time… (or else we will continue next lesson)

6. Print out your spreadsheet ON ONE PAGE with the formulas showing (Tools-Options-Formulas) as well as gridlines and row and column headings.