Unit 2 Complete Teaching Scheme of Work Resource Now Available!
The BTEC Unit 2 Creating Systems to Manage Information Unit is one of the mandatory units for all certification levels.
TheComputingTutor is proud to present a complete scheme of work designed to guide students through the new 5 hour exam format implemented in 2019.
The resource has been developed for use with Microsoft Access with over 150 exercises, class tasks, discussion and research activities with suggested answers covering all activities in Parts A and B for the 5 hour exam.
The Scheme of Work includes two brand new exam-style scenarios that students can use to practice creating and normalising tables, creating validation rules, queries forms and reports, all with differentiated, exam-style exercises and suggested answers.
In addition, the new scheme of work scenarios include both single tables with multiple foreign keys, and mapping tables with compound primary keys.
Part A Teaching Resource 1 - Database Normalisation and Validation
lessons covering all content required for the first part of 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.
• Dozens of practice database questions with answers.
Part A Teaching Resource 2 - Queries, Reports, Testing & Evaluation
Query Resource content includes:
Teaching material covering all content required for the remainder of the Exam Part A including lessons on:
• Creating queries using the Query Designer.
• Creating simple, single table queries.
• Using query aggregate functions - SUM, MIN, MAX, COUNT AVG.
• Creating complex, multi-table join queries.
• Creating parameter based queries.
• Using GROUP BY and WHERE in a query.
• Creating calculated fields in a query.
• Using logical statements in a query.
• Using LEN(), DateDiff() and IIF() functions.
• Using Nested IIF() Functions.
Report, Testing & Evaluation content includes:•
Teaching material covering all content required for the exam including lessons on:
• Creating simple reports from Queries.
• Creating complex reports including row level calculated fields.
• Domain Aggregate functions, including DSUM, DCOUNT, DMIN, DMAX and DLOOKUP.
• Using aggregate functions in report footers
• Using logical statements in a calculated field.
• How to select and use test data.
• How to complete the test plans.
• How to complete an evaluation with a focus on minimising data duplication.
• How to complete a test plan with a focus on functionality.
Part B Teaching Resource - Forms, Testing & Evaluation
Lessons covering all exam content requirements including:
• How to create a data entry Form.
• 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 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
• Over 70 differentiated class tasks and exercises with full worked answers
The resource includes:
• Teacher presentations with learning objectives, lesson content and end of lesson review.
• Over 200 differentiated class tasks, from worked examples to discussion activities.
• Student Worksheets for all class tasks.
• Videos showing how to complete certain tasks in Access.
• Step by step guides on how to create forms, queries and reports.
• Suggested answers for the class tasks to encourage and promote discussion and further learning.
• Full sample databases with worked practical answers for each lesson, so your learners can be given these if they miss any lesson time.
• Extensive exam tips on how to tackle questions in the 5 hour exam.
• Resource links to relevant websites and videos that can be used in lesson.
• Two brand-new exam style scenarios, containing dozens of differentiated practice questions with full answers of how the solutions were achieved.
