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
Voordelen van het kopen van samenvattingen bij Stuvia op een rij:
Verzekerd van kwaliteit door reviews
Stuvia-klanten hebben meer dan 700.000 samenvattingen beoordeeld. Zo weet je zeker dat je de beste documenten koopt!
Snel en makkelijk kopen
Je betaalt supersnel en eenmalig met iDeal, creditcard of Stuvia-tegoed voor de samenvatting. Zonder lidmaatschap.
Focus op de essentie
Samenvattingen worden geschreven voor en door anderen. Daarom zijn de samenvattingen altijd betrouwbaar en actueel. Zo kom je snel tot de kern!
Veelgestelde vragen
Wat krijg ik als ik dit document koop?
Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.
Tevredenheidsgarantie: hoe werkt dat?
Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.
Van wie koop ik deze samenvatting?
Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper JoshuaHall. Stuvia faciliteert de betaling aan de verkoper.
Zit ik meteen vast aan een abonnement?
Nee, je koopt alleen deze samenvatting voor €11,10. Je zit daarna nergens aan vast.
