TheComputingTutor, is proud to present a complete 27 Lesson scheme of work for the BTEC IT Unit Data Modelling Unit
 
The resource has been developed with a primary focus on using Microsoft Excel with over 70 exercises, class tasks, discussion and research activities with suggested answers covering Learning Aims A, B and C for the Unit 5 Specification.
 
The Scheme of Work includes a brand new scenario that students can use to practice the coursework requirements for Learning Aim B and C before attempting the Assignment.
 
The resources include:​
Learning Aim A ​
lessons covering all specification content theory including:
Class tasks covering stages in the decision making process.
Class tasks covering spreadsheet features to support data modelling.
Lots of data model examples for analysis in the assignment.
Consistent use of data models within the lessons to promote student understanding.
Lots of practice data model questions with answers.
 
Learning Aim B Lessons covering all specification content theory including:
How to create a functional specification with suggested Answers.
How to design a data model to support a given scenario with suggested Answers.
How to review and refine data model designs with suggested Answers.
A new scenario with full worked answers is included for students where they can practice their design & documentation skills before attempting the assignment.
 
​Learning Aim C Lessons covering all specification content theory including:
Advanced spreadsheet features as detailed in the specification.
A fully worked original and revised solution for the new example scenario.
Answers for carrying out a test plan.
How to optimise a data model from testing, feedback and documentation.
How to carry out a data model review and evaluation.
 
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.
 
Also included is a full outline Scheme of Work for all suggested 27 lessons, which includes:
Learning objectives
Lesson overview
Assessment opportunities
EDI considerations
Homework
A format that can be used for SLT inspections.