This is the Pearson BTEC Level 3 Information Technology, Unit 5, assignment 2. Covering the criteria in detail and was awarded a Distinction. With an easy to follow format and structure, guaranteed to help you get the best grade possible! Led me to receive a Distinction* overall in IT.
Reliablez cooperative worth the money quality assignment
By: AcademicElevateHub • 3 months ago
Thank you for your kind review! :)
Seller
Follow
AcademicElevateHub
Reviews received
Content preview
1
Unit 5:
Data Modelling
Learning Aim B: Design a data model
to meet client requirements
Learning Aim C: Develop a data
model to meet client requirements
design, create and evaluate a data
model
, 2
INTRODUCTION
In this assignment, I will be assisting the local leisure Centre who would like to begin a new program to help
people become fitter and healthier by reducing their Body Mass Index (BMI), and this will be calculated on a
spreadsheet model that I will be creating. The spreadsheet will be constructed in a certain manner so that it
can predict the potential impact of the changes in exercise and diet on a person’s BMI. It will have specific
features to show a change over a period of at least 10 weeks, based on the activities they undertake and the
foods they eat. The spreadsheet model that I will be developing will be user-friendly, so can be used by people
who aren’t the best at using spreadsheets or by people who have never used spreadsheets before. Not only
this, but it will include a user interface that allows the client to enter their personal data, activity choices, the
length of time they wish to spend on each activity, and food menu choices. The spreadsheet model will
calculate, for each week, a person’s calorie intake, calories burned, weight, and BMI so the user knows and
understands the amount of progress they are making and it if what they are doing is working or not.
CLIENT REQUIREMENTS
• The model should predict the potential changes in a person’s BMI whilst they are exercising and
dieting. (CR1)
• It should calculate the BMI, weight, calories intake, and burned end of each week and the end of the
10 weeks accurately (CR2).
• Shows the difference between the first BMI results and the ones after the 10 weeks (CR3).
• Easy to use for non-IT users (CR4).
• The user interface should allow you to enter personal data, activity choices, the length of time that a
person wishes to spend on each activity, and food menu choices (CR5).
• There have to be buttons (Macros) to aid navigation around the spreadsheet (CR6).
• Automated Processes (CR7).
ADDITIONAL REQUIREMENTS
• Neat, Presentable, and Easy to read (CR8).
• Secure so the data doesn’t get lost or hacked by externals (CR9).
• Presents data in a way that the user can understand and that is easy to follow (CR10).
• Is accurate and clearly shows the progress made (CR11).
• Use house styles (colours/layout) to match the leisure centres style
, 3
GANTT CHART
Here is the Gantt chart which shows how I managed my time when creating the spreadsheet and the time it took to complete each of the labelled tasks. This enabled me to
keep a timely report on what I was doing and how much I was doing, in order for me to use my time efficiently and productively.
, 4
DESIGN 1: TITLE PAGE/INTRODUCTION
(CR8) (CR10) (CR12)
(CR10)
Here I have used a bright blue colour for the title so
that it is clear and prominent to the user what they Here I have included a short description of
are looking at. This makes it easier for them to read what the spreadsheet does, in order to
and follow. debrief the users and give them an overview
of what to expect.
(CR6)
I have also included buttons (Macros) which allow
you to navigate around the spreadsheet more
efficiently and by having them labelled it shows the
user what action they undertake and this eases the
use of it for them. The ‘NEXT’ button (Macro) allows
you to go ahead to the next slide. Whereas the
‘EXIT’ button (Macro) is to quit the spreadsheet and
go off it.
, 5
DESIGN 1: PERSONAL DETAILS PAGE
(CR8) (CR10) (CR12)
(CR10)
Again, I have included a bright colour, this time
Here again is a short summary as to what is
orange, for the title in order for it to stand out
happening in this part of the spreadsheet.
and for the user to get a good understanding as
to what this page is about.
(CR5)
(CR6)
Here I have designed a table in which users can enter their personal
The ‘NEXT’ button should allow the user to move ahead
details. It is important for the user to fill in the required information
to the next stage of the BMI calculator. The ‘PREVIOUS’
correctly if they want to have accurate BMI score as then they can
button should take the user back to the last slide if they
compare these to their end score’s and see how much they have
want to check anything or change anything. The ‘MAIN
progressed and if it was worth it. =S12/(S13*S13) is the formula used to
MENU’ button would take you back to the first slide
work out the current BMI of the user, where S12 is the weight in
(Introduction).
kilograms and S13 is the height of the user who is inputting the data. This
will automatically calculate the BMI as soon as the weight and height is
filled in so then the user doesn’t have worry about working it out
themselves and it eases their job.
(CR4)
In the table, I have also included the options of title,
gender, age and active level to have drop down boxes,
which gives the user a chance to choose out of some
possibilities. This essentially makes inputting data in a
lot quicker and more efficient.
, 6
DESIGN 1: 10 WEEK BMI CALCULATOR PAGE
(CR2) (CR3)
(CR1)
The user can enter their calorie intake and the number
of calories burnt per week so they can be calculating At the end of the 10 weeks of the procedure the
their new BMI accurately. The tables are easy to read calculator will evaluate the total calories that were burnt
and understandable so if someone whose first and will check their BMI to see if difference has been
language is not English utilises it, they won’t struggle. made.
(CR6)
The ‘NEXT’ button should allow the user to move ahead to the next
stage of the BMI calculator. The ‘PREVIOUS’ button should take the
user back to the last slide if they want to check anything or change
anything.
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 or Stuvia-credit 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 AcademicElevateHub. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.35. You're not tied to anything after your purchase.
