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.