LESSONS

• 7 ADVERTISE IT In this ICT cover lesson, students learn how to vary the presentation of information for different audiences, using appropriate ICT software.
• 9 HELPING OTHERS * This worksheet asks students to consider how information about computer operations is conveyed, as they instruct others how to carry out a specific task.
• 11 A HUNTER'S LIFE Students practise their word processing skills to reformat a document for a specific purpose.
• 13 DESIGNER ICONS * Students improve their familiarity with the toolbar icons and their functions, as they design icons of their own. (Preparation: photocopy Appendix 1, page 62.)
• 15 IN A WORD This lesson plan familiarises students with some of the screen messages they may encounter in Word and teaches them appropriate responses.
• 17 FINDING INFORMATION Students consider the sources of information available and evaluate their usefulness for different purposes.
• 19 THE SCHOOL VISIT Students practise their word processing skills in a practical context, as they write a letter to arrange a school visit to a local company.
• 21 ALL ABOUT ME Students practise their word processing skills, to create an information sheet about themselves.
• 23 SURVEY DATA Students practise the collation of data and then present it in a different format. It is assumed that students know how to produce graphs from the software package. (Preparation: ensure all students have access to a spreadsheet program.)
• 25 DATA ENTRY FORM 1 * This worksheet asks students to consider how to design user-friendly data entry and invoice forms. (Preparation: ensure all students have access to a spreadsheet program.)
• 27 DATA ENTRY FORM 2 Students convert their paper-based design for data entry forms and invoices into the real thing, using a spreadsheet program.
• 29 THE CHECK DIGIT Students learn how barcodes are created and used, as they create a spreadsheet that will calculate the 13th or 'check' digit in a barcode. Suitable for more able students.
• 31 THE SUPERMARKET QUEUE Students learn to create a spreadsheet that models a real situation - and provide solutions for it. Suitable for more able students. (Preparation: ensure all students have access to a spreadsheet program.)
• 33 GRAPHIC FORMULAS * Students learn the principles behind the formulas used in spreadsheets and are shown how they can be documented on paper. Suitable for more able students.
• 35 SPREADSHEET FUNCTIONS * Students learn the principles behind functions used in spreadsheets and are shown how they can be documented on paper. Suitable for more able students.
• 37 WALKING MENU Students use their spreadsheet skills to create a model for planning purposes. (Preparation: ensure all students have access to a spreadsheet program.)
• 39 CLASS DATABASE * Students consider the constituent elements of a database and issues involved in database design and structure.
• 41 DATA NORMALISATION * This lesson plan consolidates students' understanding of database fields, formats and sizes. It assumes previous learning.
• 43 DATA PROTECTION ACT * This worksheet introduces student to the purposes and provisions of the 1984 Data Protection Act. (Preparation: photocopy Appendix 4, page 65.)
• 45 DATA CAPTURE FORM * Students consider the design requirements of a data capture form, creating one for members of a sports club.
• 47 SPORTS & LEISURE CLUB * Students continue to explore concepts associated with databases, as they extend their plans for a sports club.
• 49 SPORTS CLUB MEMBERS Students consolidate their understanding of databases by transferring their paper-based designs to the computer and creating a working database. Knowledge of how to search a database is assumed. (Preparation: ensure all students have access to a database program.)
• 51 POLICE CAR DATABASE In this lesson plan, students create from scratch a database for a specific purpose. (Preparation: ensure all students have access to a database program.)
• 53 COMPUTERS AT WORK * Students demonstrate their understanding of how computer hardware and software works, as they analyse computer use in four different workplace situations.
• 55 WEB INFORMATION SHEET Students discover how to find information on the Web and then transfer it into a word processor or DTP package for a specific purpose. (Preparation: ensure all students have Internet access.)
• 57 DESIGN A CD COVER In this Internet-based lesson plan, students find graphic images on the Web and transfer them into a drawing or DTP package for a specific purpose. (Preparation: ensure all students have Internet access.)
• 59 WEB READER* Students evaluate the design features of Web pages and learn how and why they differ from traditional printed pages.
• 61 WEB SITE DESIGN Students visit various Web sites and evaluate them according to a set of criteria they devise for themselves. (Preparation: ensure all students have Internet access.)
• 62-5 APPENDICES

The resources marked * are paper-based, and do not require computer access.