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