for Secondary Education in the UK.
Product List
My Downloads
Checkout / Card
Find Resources By Subjects

Preparing for Compulsory Tests and Assessment in GNVQ L2: IT

Price: £35.00
Age Range: KS4+

Develops students ability to complete assignments and answer multiple-choice and short-answer questions. Each section covers one of the four compulsory units.

Topics include: Security systems; ICT versus paper-based systems; Understanding and testing computer control systems; Programming; Accurate records; Specifications. Case studies include: Computer consultancy; ICT in a supermarket.

Order this publication:

Quantity Format
Choose delivery option (CD or download) at checkout.
Size: 88 Pages
ISBN: 978 1 86025 259 4
Code: PACI
Popularity rank: 428

Teachers who bought this publication also bought:

Contents List

LESSONS

SECTION ONE - PRESENTING INFORMATION

Test

  • 11 READ ALL ABOUT IT Students show their understanding of documents and how they relate to an intended audience
  • 13 FONTS Students demonstrate their knowledge of the purpose of fonts and titles in relation to purpose and audience
  • 15 THE RIGHT WAY Students understand standard documents and why these are required
  • 17 GOT A NEW MOTOR? Students show how the intended audience relates to presentation style and medium
  • 19 IT'S SECURE Students show their understanding of the need for security and confidentiality within an organisation, and how to achieve it

Assessment

  • 21 TIME FOR CHANGE Students learn how companies use standard documents, and design examples to fulfil portfolio evidence
  • 23 REPORTING BACK Students learn to produce standard documents combining different forms of information
  • 25 WHAT'S ON THE AGENDA? Students will show further use of standard documents within a company
  • 27 SAVING TIME Students will demonstrate the benefits of using standard templates and spell checkers.
  • 29 SITUATION VACANT Students learn to evaluate the style and quality of documents used by organisations, as demonstrated in newspaper advertisements

SECTION TWO - HANDLING INFORMATION

Test

  • 35 SPREAD THE NEWS Students will show their understanding of spreadsheet use
  • 37 DATA, DATA EVERYWHERE Students will show their understanding of, and ability to use, databases
  • 39 FUNCTIONS AND FORMULAE Students show their understanding of, and ability to use, functions, formulae and cell formats for a given spreadsheet
  • 41 DATABASE DOCTOR Students will show their understanding of why IT is used so widely, by comparing a computer database with a paper-based system
  • 43 THE MISTAKE Students will show their understanding of the need for accuracy and validity of information within a database structure, and how to avoid errors

Assessment

  • 45 SUPERMARKET SWEEP Students will show how databases are used within the context of a supermarket, with particular reference to data capture
  • 47 STOCK CONTROL Students will show how a store database can be used to check stock levels of products
  • 49 IN THE WAREHOUSE Students show their knowledge of how tables within a database can be related in order to produce more effective outcomes 2
  • 51 ADDING IT ALL UP Students show how information from a database can be integrated into a spreadsheet
  • 53 PUTTING IT ALL TOGETHER Students will be able to show how organisations use relational databases

SECTION THREE - HARDWARE AND SOFTWARE

Test

  • 59 WHO WANTS WHAT? Students will be able to select IT systems to meet the needs of users
  • 61 THE SOFT OPTION Students' understanding of software and its purpose will be assessed
  • 63 STARTING TO MAKE SENSE Students show their understanding of the use and purpose of sensors in a control or data logging system
  • 65 WHO'S IN CONTROL? Students will be able to show their understanding of computer control systems
  • 67 DATA LOGGING Students will be able to show their understanding of the principles and purposes of data logging

Assessment

  • 69 COMPUTER CONTROL Students' understanding of process production control will be assessed
  • 71 NEVER MIND THE QUALITY Students will be able to show their understanding of quality control within a car factory
  • 73 IT AIN'T 'ALF 'OT MUM! Students will be able to show their understanding of environmental control
  • 75 NO WAY IN Students will be able to show their understanding of security control
  • 77 WHERE IN THE WORLD? Students' understanding of industrial and commercial control systems will be assessed

SECTION FOUR - PROGRAMMING

Assessment

  • 83 WHY PROGRAM? Students' understanding of the need to design and create computer programs will be assessed
  • 85 MIND YOUR LANGUAGE! Students show their understanding of the importance of languages in creating computer programs
  • 87 TESTING, TESTING, 1, 2, 3... Students will show their understanding of the need for testing through spotting mistakes
  • 89 PRESENT AND CORRECT Students explore appropriate security procedures and effective presentation techniques
  • 91 READ THE MANUAL Students understand the need to correctly document and record information about their programs

APPENDICES

  • 94-95 GLOSSARY A glossary of terms for GNVQ IT
  • 96-97 ASSESSMENT EVIDENCE Guidelines for assessment evidence requirements