top of page
Unit 5 SOW

 "Well worth the money."

Mrs J. Martin-Johnson, Teacher of Business and IT, Thomas Tallis School, London.


The BTEC Unit 5 Data Modelling Unit is an optional unit for all certification levels from the Extended Certificate upwards Here is 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 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 suggestions. • A format that can be used for SLT inspections. • Teacher notes on resource content with suggested ideas for unit delivery

Unit 5 Exemplar
Available for purchase - a full model answer for the Pearson Authorised Assignment 2 'The Cheese Shop'.

TheComputingTutor is pleased to announce the release of a full worked model Answer exemplar for the BTEC IT Unit 5 Data Modelling Assignment 2 "The Cheese Shop" and is one of the more challenging assignments from Pearson. 

Available for purchase - a full model answer for the Pearson Authorised Assignment 2 'The BMI Tracker'

TheComputingTutor is pleased to announce the release of a full worked model Answer exemplar for the BTEC IT Unit 5 Data Modelling Assignment 2 "The BMI Tracker". 

More Information

Both of these exemplars are fully worked model answers which includes Named Ranges, Macros, VBA code, Graphs, Functions and Formulas as well as cell Styles and Formatting, all of which are designed to answer the Assignment 2 Authorised Assignment Brief from Pearson.​ In addition to the spreadsheet,  there is also a Teacher Guide showing how the solution was designed along with explanation of key functionality.​ You will have full access to the worksheets, the macros and the functions so you can see how it works and then use this to help guide your students. The sample downloads are only available as a limited functionality excel sheet. All macros and functions have been removed and these will only be available in the full version.

Unit 5 Assignment

Assignment Resources for Assignments 1 and 2 are now available!

The Unit 05 Assignments are relatively straightforward, except that there is a lot of content to cover which could get missed. As part of the RQF BTEC assessment procedures, assessors are not allowed to give students a list of tasks to cover to achieve a grade once the assignment is running. This means that learners can often forget to include key pieces of evidence, or to not provide evidence in the right format. TheComputingTutor is pleased to announce the release of a full set of Student Guides for the Edexel BTEC IT UNIT 05 Data Modelling. The resources include: • A full set of Student Guide Assignment Resources covering what is required for Assignments 1 & 2. • A Teacher presentation showing your students how to approach each of the Assignments. • A Teacher resource document, with suggested hints and ideas for Unit delivery and how to structure the assignment content. • An editable PowerPoint and a printable PDF for each Student Guide. • A tracking sheet for your students to monitor their own progress based on COMPLETE, IN PROGRESS and NOT STARTED for all tasks. Each Student Guide covers all the marking requirements for Pass criteria for Learning Aims A, B and C as well as showing extensive opportunities for where to include Merit and Distinction criteria evidence. The Student Guides are ideal for weaker candidates, or students struggling to organise their work, as it gives a simple, easy to follow checklist of all required Assignment criteria.

Please note: this is not a theory resource; this resource focuses entirely on making sure that your students are able to answer the Assignment tasks independently. Theory content is covered in the associated Scheme of Work.

​Each guide has references on every page to where the required content is covered in the 2016 Authorised Pearson textbook as well as continual assessment opportunities so students can identify the areas they are struggling with so you can support them where allowed. You can use these learning resources for individual students who are finding the Assignment procedure challenging, or you can give the Guides to your entire group before they start each Assignment - the choice is yours.  The Student Guides only contain the required Assignment content headings, the actual theory content taught is entirely down to you. You have full control of each Guide PowerPoint, so you can edit the slides and move them around to suit your teaching and the needs of your classroom. ​ These resources will help your learners to know exactly what they have to do to independently achieve their grades.

Downloads and Pricing


Documents included in the teaching resource sample download include: ​ • 3x Teaching presentations, 1 each for Learning Aims A, B and C. ​ • 3x Student Guides, 1 each for Learning Aims A, B and C as an editable powerpoint. ​ • 3x Student Guides, 1 each for Learning Aims A, B and C as a read only PDF. ​ • 2x Student Checklists for Learning Aim A and Learning Aim B&C. ​ • 1x Student Tracking Document. ​ • 1x Teacher Notes with ideas and information about Unit Delivery. In addition, documents in the data model sample include: ​ • 1x Technical Information about the Data Model. ​ • 1x reduced functionality spreadsheet. To view a free sample of files available for the following resources click on the links below


See What People Think Of Our Resources!

"The resources for Unit 5 Data Modelling are excellent and are really saving me a lot of time particularly with the current climate. The resources have helped to differentiate the class and their learning abilities whilst at the same time encouraging students to work independently, as well as stretching and challenging them. Well worth the money!!"


Mrs. J Martin-Johnson, Teacher of Business and IT, The Thomas Tallis School, London

bottom of page