for Secondary Education in the UK.
Publications My Downloads Yacapaca Blog
Select subject

Cover Lessons in ICT

Price: £25.00
Age Range: KS3

You know the scenario: the ICT teacher is absent and nobody is sure how to cover ICT. These resources will save teachers hours of trying to devise meaningful Key Stage 3 ICT cover lessons. Organising worthwhile ICT cover work is easy because these lesson plans and worksheets are written with the non-specialist in mind. KS3 students do not require a computer to complete over half of these lessons.

Topics include: Visiting and evaluating websites; Data Protection Act; Bar codes; Design a CD cover; Design a database for a sports club.

Order this publication:

Quantity Format
Choose delivery option (book, CD or download) at checkout.
Size: 65 Pages
ISBN: 987 1 86025 271 6
Author(s): Mark Leighton
Code: CLII
Popularity rank: 24
Average Customer Review:  * * * * *  based on 2 reviews

Teachers who bought this publication also bought:

Contents List

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.

Reviews

12/02/10

A great resource for those last minute 'Rarely Cover' situations.
Was this review helpful to you?
01/08/08

Norman Johnsen at Tyne Metropolitan College

Very useful set of resources to have at hand. They will surely be used at some time during the year.
Was this review helpful to you?
18/06/02

D Benvin at George Stephenson High School

I bought this book in a previous school and I am now considering buying it in my new school. It is extremely handy especailly when key members of staff are off on the round of meetings and with the new KS3 starting in Sept. I think it is a book I can not be without.
Was this review helpful to you?
15/03/01

Louise Mair at ICT Teacher at Auchterarder High School

This little book does a BIG job! "saved the day!
Was this review helpful to you?