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.
Unit 2 Part B Teaching Resource - Forms, Testing & Evaluation
"The Unit 2 Creating Systems to Manage Information has helped me a lot to teach RDBMS to the BTEC Level 3 students. The resources clearly explain each of the Learning Aims giving clear examples and instructions.
I would highly recommend this resource for teaching Databases."
Mr Damian Glyn, Lecturer in IT, North Shropshire College, Shropshire
"The ready-to-use resources I purchased for teaching BTEC Unit 2: Creating Systems to Manage Data have made delivering this unit so much easier.
These materials are completely out-of-the-box, requiring no additional preparation, which has saved me so much time.
They are perfectly aligned with the syllabus and include clear, step-by-step guides for database concepts, from foundational theory to advanced SQL queries.
The pre-designed activities and sample solutions are a huge bonus, ensuring students are well-prepared for assessments. These resources have streamlined my teaching and helped my students build confidence and skills with databases.
I would recommend them to any educator looking for a hassle-free, high-quality solution for teaching Unit 2."
Mr J Flower, Computing and IT Lead, Heathfield Knoll School, Worcestershire
This teaching resource has been designed specifically for the 5 hour exam format that was introduced in 2019. Some of the required content in the original specification has not been included. The exam board requires that this non-examined content still be delivered.