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.