TheComputingTutor, is proud to present a complete 27 Lesson scheme of work for the BTEC IT Unit 5 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
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 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 identify practice their design documentation skills before attempting the assignment
​
Learning Aim C
Lessons covering all advanced spreadsheet features as specified in the course content
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.
Teacher notes on resource content with suggested ideas for unit delivery
 
A sample of all programs and associated documentation are available in the Downloads Section
​If you have any questions about purchasing our resources, please take a look at our Purchasing FAQ.