"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.
Unit 2 Teaching Resource 1:
Part A - Normalisation and validation
Resource content 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. • Dozens of practice database questions with answers.
Unit 2 Teaching Resource 2:
Part A - Queries
Resource content includes: • lessons covering all content required for the exam including lessons on: • Creating queries using the Query Designer. • Creating simple, single table queries. • Using aggregate functions. • Creating complex, multi-table join queries. • Using GROUP BY. • Creating calculated fields. • Using logical statements in a query. • Using Datediff and Domain functions. • Dozens of practice database questions with answers. •Two brand-new exam style questions with lots of differentiated questions and answers.
Unit 2 Teaching Resource 3:
Part A - Reports, Testing & Evaluation
Resource content includes: • lessons covering all content required for the exam including lessons on: • Creating reports based on a query. • Creating simple, bound fields in a report. • Creating row level calculated fields • Creatin report summary calculations • Using logical statements in a calculated field. • Using Datediff and Domain functions. • How to carry out a test plan. • How to complete an evaluation with a focus on minimising data duplication. • How to complete a test plan with a focus on functionality. • Dozens of practice database questions with answers. •Two brand-new exam style questions with lots of differentiated questions and answers.
Unit 2 Teaching Resource 4:
Part B - Forms, Testing & Evaluation
Lessons covering all exam content requirements including: • How to create a data entry Form. • How to create a data search Form with a single search criteria. • How to create a data search Form with multiple search criteria. • How to validate Form input using VBA code. • How to create calculated fields in Forms. • How to evaluate and test user Forms. • Lots of exam style questions based on the Part A scenarios, with new databases supplied.
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. • Videos showing how to complete certain tasks in Access. • Step by step guides on how to create tables, queries, reports and 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 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
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: