Year 10 - GNVQ
KS4_10GNVQ_pcworld.mdb
A sample Access database for use with the GNVQ ICT

GCSE_Speadsheet_example.xls
A handy example spreadsheet

Generic_grades_presentation.ppt
This can be tailored for your use to feedback grades to pupils

html_flash_interactive.fla (Flash MX file)
A nice little Flash MX file for you to use. can be edited as you wish

KS4_Christmas_list.xls
Pupils have to create a Christmas Shopping Wish list - asks them to research the Internet and find URLs and images if possible.

KS4_Conditional_formatting.xls
Shows how to create conditional formatting on cells

KS4_10_GNVQ_Multimedia Assignment Report template.doc
A useful report template for pupils to use

KS4_10GNVQ_Database coursework.doc
GNVQ coursework document

KS4_10GNVQ_Unit2_project.doc
The Unit 2 documentation

Year 10 - GCSE (Short Course ICT B)


KS4_GCSE_hairsalon_spreadsheet.doc

KS4_mailmerge_worksheet.doc

KS4_Spreadsheet_helpsheet.doc


KS4_Example_macro.xls
A simple Macro in a spreadsheet - view the code

KS4_Exchange_rate.xls
A spreadsheet that converts currency.

KS4_Football_league_data.xls
Useful football league data to use

KS4_Lottery.xls
Strategy Lotto Excel demo - great as a starter

KS4_vlookup_example.xls
Simple Vlookup working spreadsheet to be used as a demonstration.

KS4_C2_salon_logo_scenario.doc
Pupils create a logo for a Hair Salon

KS4_logo_design_scenario.doc
Pupils create a logo based on a scenario

KS4_logo_research.doc
Find logos form the Internet and compile a report


KS4_Brewsters_Millions_worksheet.doc
A fantastic pupil activity - This is the ORIGINAL one here - pupils spend a £100 million pounds by creating a list of things they want to buy, including URL's and photos.

KS4_Design_brief.doc

KS4_Dreamweaver_Guide.doc

KS4_GCSE_ICT_retail.doc

KS4_gcse_revision_exam_questions.doc

KS4_Networks_worksheet.doc

KS4_Security_policy_worksheet.doc

KS4_website_evaluation_form.doc

KS4_Flowcharts_explained.ppt

Year 11 - GCSE (AQA - Short Course ICT B)