TheComputingTutor is pleased to announce the release of a full worked model Answer for the BTEC IT Unit 5 Data Modelling Assignment 2.
This is a full worked answer for "The Cheese Shop", inlcuding Named Ranges, Macros, VBA code, Graphs, Functions and Formulas, all of which are designed to answer the Assignment 2 Authorised Assignment Brief from Pearson.
In addition there is a Teacher Guide showing how the bulk of the sheet is put together.
You will have full access to the sheet, the macros and the functions so you can see how it works and then use this to help guide your students.
Check out the 'for schools' section on BTEC resources to download a free sample as a limited functionality excel sheet. All macros and functions have been removed and will be available in the full version.
If you are interested in buying the resources, please email me for purchase options.