» ICT Projects for High Ability Students

LESSONS

Section 1: Communicating Information

• 9 CHILDREN'S BOOKS (1) Level 5/6 Using a DTP package to produce the cover of a book aimed at pre-school children.
• 11 CHILDREN'S BOOKS (2) Level 6/7 Using a DTP package and electronic sources to produce pages of a pre-school children's book.
• 13 CHILDREN'S BOOKS (3) Level Exceptional Using a DTP package to produce a template for a book aimed at pre-school children.
• 15 SCHOOL HOMEPAGE Level 5/6 Using a HTML editor to produce a school homepage.
• 17 SCHOOL WEBPAGES (1) Level 7 Using a HTML editor to produce webpages for a school department.
• 19 SCHOOL WEBPAGES (2) Level 8/Exceptional Using a HTML editor to produce a template for a school department's webpages.
• 21 SCHOOL WEB SITE * Level 8/Exceptional Using a professional HTML editor to produce a school web site.

Section 2: Modelling

• 23 HAPPY LANDINGS (1) Level 5/6 Using a spreadsheet to change variables in a model.
• 25 HAPPY LANDINGS (2) Level 7 Extending a spreadsheet to change variables in a model.
• 27 THE DRINKS CAN Level 5/6 Using a spreadsheet to explore the effects of changing variables in a model.
• 29 THE MILK CARTON Level 7 Designing a spreadsheet to explore the effects of changing variables in a model.
• 31 PAPER TOWELS (1) Level 5/6 Using a spreadsheet to explore the effects of changing variables in a model.
• 33 PAPER TOWELS (2) Level 7/8 Designing a spreadsheet to explore the effects of changing variables in a model.
• 35 EASY MODELLING * Level 8 Designing an interface for a spreadsheet model suitable for use by the lay user.

Section 3: Handling Information

• 37 THE BATTLE OF BRITAIN Level 5/6 Using information sources to test a hypothesis.
• 39 WHAT'S SO SPECIAL ABOUT OZONE? (1) Level 5/6 Selecting information through complex queries then using a database to organise the information.
• 41 WHAT'S SO SPECIAL ABOUT OZONE? (2) Level 7 Designing a user-friendly data entry form for a database.
• 43 WHICH SOFTWARE? Level 7/8 Justifying the choice of a software application to solve a particular problem.
• 45 STOCKS AND SHARES (1) Level 5/6 Using multimedia sources to find specific information.
• 47 STOCKS AND SHARES (2) Level 6/7 Creating a user-friendly query form.
• 49 REPORTS * Level Exceptional Designing, creating and testing an labour-saving reporting system.

Section 4: Controlling and Measuring

• 51 THE WASHING MACHINE (1) Level 5 Developing a set of simple instructions to perform a task.
• 53 WASHING MACHINE (2) Level 6 Designing a system to measure and record physical variables.
• 55 THE WAREHOUSE (1) Level 5 Developing and refining a set of instructions to perform a task.
• 57 THE WAREHOUSE (2) Level 6/7 Designing a system that utilises feedback devices.
• 59 ANIMAL HOUSE (1) * Level 7 Using ICT software and equipment to measure physical variables.
• 61 ANIMAL HOUSE (2) Level 7/8 Designing an environmental control system that utilises feedback devices.
• 63 THE GREENHOUSE * Level 7/8/Exceptional Designing and implementing a control system that utilises feedback devices.

Appendices

• 64 APPENDIX 1 Spreadsheet Models
• 65 APPENDIX 2 Spreadsheet Solutions