LESSON 5 – 10^th November

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

Finishing and printing off spreadsheet. 

1. From the website catalogues and the printed catalogues you have found, identify a selection of clothes which will create a formal outfit for a teenager from each retail outlet.
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 outlets you need to list the clothes and their prices which you have chosen for the outfit. 
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

1. 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.   
2. Print out your spreadsheet ON ONE PAGE with the formulas showing (Tools-Options-Formulas, click here for help on this). These printouts should have your name in the header and be on one page.  The formulas printout should also show row and column headings   and gridlines.  Click on the relevant links for tutorials on how to do these tasks.

EXTENSION TASK

What have you learned about spreadsheets?  Click HERE to test yourself.  If you get them all correct then try THIS.

continuing lesson 4…

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 – 20^th October

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.  

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

EXTENSION TASK

What have you learned about spreadsheets?  Click HERE to test yourself.  If you get them all correct then try THIS.

continuing lesson 3…

Printing your evidence document. 

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

1. KEYWORDS
2. RESULTS (HITS)
3. HOMEPAGE
4. OUTFIT (Main item of outfit e.g. dress, suit, etc)
5. PRICES
6. CONTACT DETAILS
7. OTHER – MAP, VIRTUAL TOUR
8. SELECTION of IMAGES (e.g. Logo, banner, etc)

NOW print your work to the KC2mono printer. 

LESSON 3 – 6^th October

Starter: What do you know about webpages? Try this SPOT the TEACHER quiz to find out. 

Developing Text for the Leaflet

1. Either by coping or pasting from the internet or writing in your own words, in Word write a few short paragraphs about your Retail Outlets. Call this document Text Information about my Retail Outlets; add your NAME, FORM / GROUP and DATE to the header and PAGE NUMBERS to the footer.   Write this in plain text; don’t use headings or bullet points at this stage. 
2. Print out your paragraphs and then annotate them to show which words you will change, how you will create headings, formatting you might apply and where you will insert bullet points etc. 

EXTENSION TASK

What have you learned about websites?  Click here to test yourself.  If you get them all correct then try this.

STARTER: What do you know about the reliability, validity and bias in information or data?  Click here to find out!!! First one to acheive an A* can have a house point. 

Activity Brief 1: Retail Clothing Outlet Leaflet

Your job is to research different clothes shops in order to provide an outfit for a teenager who is going to attend a formal event.

You will be required to produce a folded information leaflet which provides details of at least four clothes shops in an area of your choice.  You will need to collect information about your chosen clothes shops and this information could be found on the internet, in a printed catalogue provided by the shop, written notes made by you in the shop or any combination of these sources.

Your leaflet should contain; contact details for each shop, a brief description of the type of clothing they provide, pictures which will have been amended and developed by you, maybe a map of the area highlighting the location of the shops, a selection of clothes from each shop which would provide an outfit for a teenager who is going to attend a formal event, the total cost of the outfit from each shop, the average cost of the outfit for the teenager, a total cost ranking for each shop with 1 being the cheapest and 4 being the most expensive.

Tasks you need to complete for activity 1

Task A – Collecting printed information

1. Visit your chosen shops and pick up their catalogues or make some written notes about clothes and how much they cost.  Remember you need at least four shops.  You might decide to focus on one type of outfit e.g. daywear (for a wedding, christening, garden party, fete) or evening wear (for a prom ball, “leavers” dinner or concert) or a selection of both types of clothes. 

Task B – Searching the internet for information and developing your text

1. Using a search engine on the internet, search for retail clothing outlets. This should be a multiple criteria search so, for example, “Clothing” AND “Formal wear” AND “Shrewsbury” should be typed in.  Using the advanced search option may help. 

2. Take a screen shot of the search results page making sure that it includes evidence of your multiple criteria search.  Add this screenshot to a word document.  Name this document Internet Search Evidence for Activity 1, add your NAME, FORM / GROUP and DATE to the header and PAGE NUMBERS to the footer. 

3. You are aiming to find out as much as you can about each shop so you might need to follow some of the links on your search page – take screen shots of various pages that will be useful and add these to your word document.  Useful pages on websites might include; contact details, descriptions of the shop, catalogues

4. Print out your screenshots and along with the printed information from your shop (you may want to scan or photocopy this information), highlight the information that you think will be useful for your leaflet.  You should highlight text, pictures and figures that you might use and write next to them why they will be useful. 

5. Either by coping or pasting from the internet or writing in your own words, in Word write a few short paragraphs about your shops. Call this document Text Information about my Retail Clothing Outlets; add your NAME, FORM / GROUP and DATE to the header and PAGE NUMBERS to the footer.   Write this in plain text; don’t use headings or bullet points at this stage. 

6. Print out your paragraphs and then annotate them to show which words you will change, how you will create headings, formatting you might apply and where you will insert bullet points etc.

LESSON 1 – 7th September

Introduction to ICT Key Skills Level 2

During this year, you will work towards achieving your ICT Key Skills Level 2 qualification. There are two parts to your qualification.

1. a multiple choice exam paper which you will complete online
2. a portfolio of work

Today you will take a past paper to give you an idea of the questions you will need to deal with and then we shall look at the requirements of the portfolio. When you complete the exam paper then have a look at the requirements of the portfolio.

The requirements of the course can be found at P:\Senior Pupils\ICT\Key Skills\Key Skills Level 2.  The document is called Level 2 task list (09-10).