2022/23 - This essay covers DISTINCTION level work for Unit 5: Data Modelling - Assignment 2 - Learning Aims B & C.
To complete your assingment in the quickest time use the NAVIGATION PANE in Word to follow my layout in order to achieve any grade. (Pass, Merit & Distinction).
All of the foll...
Nature of the Problem...........................................................................................................................5
Functions the Model must Perform.......................................................................................................6
Function 1..........................................................................................................................................6
Function 2..........................................................................................................................................7
Function 3..........................................................................................................................................7
Function 4..........................................................................................................................................8
Function 5..........................................................................................................................................8
Function 6..........................................................................................................................................8
Function 7..........................................................................................................................................9
User Interface........................................................................................................................................9
Test Plan..............................................................................................................................................20
Use of Formulas...............................................................................................................................38
Use of Functions..............................................................................................................................38
Use of Logical Functions..................................................................................................................39
Use of a Nested IF Function.............................................................................................................40
Data Manipulation...........................................................................................................................40
Auto Fill............................................................................................................................................40
Relative and Absolute Cell Referencing...........................................................................................41
Design of Database..........................................................................................................................41
Evaluated Outcomes – Including Justified Recommendation & Decisions.......................................71
Use of Effective Communication Methods......................................................................................72
Backup of Work...............................................................................................................................72
Creativeness in Layout & Research..................................................................................................73
4|Page
, Joshua Hall Assignment 2 – Learning Aims B & C Unit 5 – 2022
Unit 5 – Data Modelling
Introduction
In this assignment, I have recently been asked to design and create a spreadsheet model which can
predict the potential impact of changes in exercise and diet on a person’s BMI. Firstly, I will be willing
to produce an efficient spreadsheet model which can show a person how their BMI would change
over a period of at least 10 weeks, based on the activities they do and the foods that they eat. From
this, I will create designs for a data model so that each of the client requirements are met
successfully which will include worksheet structure diagrams and being able to provide a test plan.
Then, I will be reviewing the design with other clients to identify and inform improvements. The
model will be designed to be used by people who are not experts in spreadsheets and should include
a user interface which allows the user to enter personal data, activity choices, the length of time a
person wishes to spend on each activity, and food menu choices.
Furthermore, I will be explaining my justification to how the requirements are fully fulfilled and then
providing a well- detailed and reasoned evaluation of the optimised data model against client
requirements that already exist.
Nature of the Problem
As part of my assignment, I am designing and developing a spreadsheet model that will meet my
client's needs and requirements. For this task, I have been asked to develop, design, and build a
spreadsheet model that will first be able to predict the actual potential impact of changes made to
their exercise and diet, and how these changes will affect their BMI. A local leisure centre wants to
start a brand-new program that will help the people who attend to become fitter and healthier by
reducing their Body Mass Index.
5|Page
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller JoshuaHall. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £8.99. You're not tied to anything after your purchase.
