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