"A wise investment indeed! "
​
Ms Josephine Kulandairaj, Teacher of IT, Brimsham Green School
The BTEC Unit 2 Creating Systems to Manage Information Unit is one of the mandatory units for all certification levels. Here is 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
​Resource content includes: • 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.
​The resource includes:• Teacher presentations, student worksheets, sample answers for each lesson. • Complete, functional databases are included for each lesson in case students miss any sessions. • Over 75 differentiated practice database questions with answers. •Two brand-new exam style scenarios with lots of differentiated questions and answers. • Lots of exam tips and hints on how to score high marks. • Easy to use how-to videos on creating queries and reports
"I would highly recommend this for teaching Databases".
Mr Damian Glyn, Lecturer in IT, North Shropshire College, Shropshire
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 70 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. • 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, based on a fragment of the Part A databases, containing dozens of differentated practice questions with full answers of how the solutions were achieved.
Teacher Notice: When the exams were changed in 2019 from a 10 hour exam to a 5 hour exam, some of the content in the official specification was no longer contained in the exam. The theory and content presented in this scheme of work is entirely focused only on the material required by students and teachers for the 2019 5 hour exam format. The exam board requires that all teachers still cover all theory contained in the syllabus. This material is not contained in this exam scheme of work and can be found in the official course textbooks. TheComputingTutor Ltd. assumes no responsibility for any penalty incurred by not delivering all syllabus content, including material that is no longer required in the exams.
The BTEC Unit 2 Creating Systems to Manage Information is a Mandatory unit for all BTEC IT Level 3 qualifications ​ Here is a set of teaching resources to help prepare for the 5 hour NEA exam. Each resource is designed to follow the 2019 NEA format closely, with Part A being 3 hours and part B being 2 hours. The resources take the form of three new scenarios based around the 2019 NEA Assessment Format revisions. Within each scenario there are many worked examples for each activity allowing you the flexibility to pick the range of activities that suit your classroom best. The scenarios are differentiated, with scenario 1 being straightforward and scenario 3 being more challenging. Scenario 4 is designed to follow the January 2022 paper in that the main junction table uses a composite key. The new scenarios are: - Scenario 1 - A Doctor's Surgery. - Scenario 2 - A Cinema Chain. - Scenario 3 - A Publishing Company. - Scenario 4 - A Vehicle Rental Company.
Within each scenario you get the following:
​
Part A - 3 Hours
• Activity 1- exam style instructions, input data, example database and classroom presentation of the model answer. • Activity 2 - exam style instructions, input data, example database and classroom presentation of the model answer. • Activity 3 - exam style instructions, 11 differentiated queries, 4 differentiated reports, classroom presentation of the model answer and example database. • Activity 4 - exam style instructions and classroom presentation of the model answer. • Activity 5 - exam style instructions and model answer. • Teacher notes on how the the solution was put together. • An OFSTED-ready Glossary of Terms in each document for your students to refer to, explaining key Exam terms and concepts.
Part B - 2 Hours
• Activity 6 - A new database, exam style instructions, 4 differentiated forms, classroom presentation of the model answer. • Activity 7 - exam style instructions and classroom presentation of the model answer. • Activity 8 - exam style instructions and model answer. • Teacher notes on how the the solution was put together. • An OFSTED-ready Glossary of Terms in each document for your students to refer to, explaining key Exam terms and concepts.
The table below shows the techniques used in each scenario.
Property | Scenario 1 | Scenario 2 | Scenario 3 | Scenario 4 |
|---|---|---|---|---|
Calculated Fields | * | * | * | * |
Table Lookup | * | * | * | * |
Value Lookup | * | * | * | * |
Composite Key | * | |||
Input Mask | * | * | * | |
LEN() | * | * | * | * |
DSUM() | * | * | ||
IIF() | * | * | * | * |
DATEDIFF() | * | |||
COUNT() | * | * | * | * |
SUM() | * | * | * | * |
Group By | * | * | * | * |
Sort | * | * | * | * |
Is Not Null | * | * | * | * |
Each classroom presentation goes through step by step how each table, report or form field was created with detailed guidance in the teacher notes on how the more complicated calculated fields were created. In addition it uses the Pearson guidance for the number of screenshots required as evidence. These scenarios have a range of questions for you to choose from so you can create an exam tailor made to your learners ability. Each activity database contains solutions for that activity, so students can see how their database needs to grow throughout the exam.
​"Your resources have been a lifesaver, to say the least!".
Ms Priya Suresh, Teacher of Mathematics and Computer Science, East Coast College, Suffolk
Sample Downloads
24 Documents are included in each sample download for each scenario including • Activity 1: instructions, teaching presentation with answers & example database. • Activity 2: instructions, teaching presentation with answers & example database. • Activity 3: instructions, teaching presentation with answers & example database. • Activity 4: instructions, teaching presentation with answers & example database. • Activity 5: instructions & example answer. • Activity 6: instructions, teaching presentation with answers & example database. • Activity 7: instructions, teaching presentation with answers & example database. • Activity 8: instructions & example answer. Teacher notes and technical information for Parts A and B. To view a free sample of all files available for the following resources click on the links below: