TheComputingTutor is proud to present the third and final 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 differentiated exercises, class tasks, discussion and research activities with suggested answers covering Part B of the Exam - Forms, Testing & Evaluation.
 
The resource includes lessons on:
Creating simple  data entry forms using the Form Wizard.
Input form validation using form fields.
Input form validation and save messages using VBA.
Form layout and formatting.
Creating simple data search forms from a single table.
Creating data search forms using queries.
Sending parameters to queries from a form.
Using AFTER UPDATE events and ReQuery Macros.
Using form functions - SUM(), MIN(), MAX(), COUNT() and AVG().
Using LEN(), DateDiff() and IIF() functions to create calculated fields and dynamic text.
Using Domain Aggregate functions, including DSUM(), DCOUNT(), DMIN(), DMAX() and DLOOKUP().
How to select and use test data.
How to complete the test plans.
How to complete an evaluation with a focus Quality, Usability and Performance.
 
The Scheme of Work includes two brand-new exam style scenarios that students can use to practice on, all included with full worked examples and in-lesson sample databses. The databases are fragment of the databases used in the Part A resources and containt extra data, just like in the real exam.
 
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.
Lots of exam tips and hints on how to score high marks.
Easy to use how-to videos on creating Forms.