TheComputingTutor, is proud to present the first part of a complete Teaching Scheme of Work for IT Unit 2 - Creating Systems to Manage Information.

The resource has been developed with a focus on using Microsoft Access 2019 with over 70 exercises, class tasks, discussion and research activities with suggested answers covering the first part of the Exam Part A - Normalisation and validation.

The resource includes:

• lessons covering all content required for the exam including lessons on:

• Database basics including tables, fields and records.

• Design and Datasheet view.

• Identifying and creating tables and relationships from supplied data.

• Creating mapping tables using compound keys.

• Data validation theory.

• All types of validation requirements needed for the exam.

• Nearly 100 differentiated practice database questions with answers.

The Scheme of Work includes two brand-new exam style scenarios that students can use to practice building and normalising a database, all included with worked examples and sample databses.

In addition, sample question and answer databases are provided for each activity right the way through each resource, so if any students miss a lesson, they can use these ready made databases to revise and catch up on any missed progress.

The two practice scenarios will be used consistently through each of the other learning resources.

• Each lesson includes:

  • A teacher presentation with learning objectives, lesson content and end of lesson review

  • A range of class tasks, from worked examples to discussion activities

  • Student Worksheets for all class tasks

  • Suggested answers for the class tasks to encourage and promote discussion and further learning

  • Resource links to relevant websites and videos that can be used in lesson