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.
BTEC IT Unit 5 Data Modelling Teaching Scheme of Work
"Purchasing the entire suite of unit 4 resources has drastically reduced my workload and improved the learning experience for our students.
I can’t recommend enough, Thank you!!
Mr. Matthew McDermott, Teacher of ICT, City of Portsmouth College, Hampshire