top of page
BTEC IT Unit 5 Exemplar Solution - The Cheese Shop

A full worked model Answer exemplar for the BTEC IT Unit 5 Data Modelling Assignment 2 "The Cheese Shop" which is one of the more challenging assignments from Pearson.

This exemplar answer is a fully worked model answer 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 explaination 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.

BTEC IT Unit 5 Exemplar Solution - The Cheese Shop

  • "The resources for Unit 5 Data Modelling are excellent and are really saving me a lot of time particularly with the current climate. Well worth the money!!"

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

bottom of page