top of page
BTEC IT Unit 5 Data Modelling Teaching Scheme of Work

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

bottom of page