Unit 5 Data Modelling Assignment 2
Introduction
In this task, I'll be supporting the local leisure centre in their efforts to start a new
programme that will lower people's Body Mass Index which will be determined using a
spreadsheet model I make. This will help people get fitter and healthier. The spreadsheet
will be built in a specific way to ensure that it can forecast how a person's BMI would be
affected by eating and physical activity modifications. It will have specific qualities that
demonstrate a shift in the activities people engage in and the meals they consume over a
minimum of ten weeks.
Because of its ease of use, even those who are not skilled with spreadsheets or have never
used one before can benefit from the spreadsheet model that I will be creating. Moreover,
it will have an interface for users that enables the customer to input their personal
,information, activity preferences, the amount of time they would like to commit to each
engagement and the menu items they want to eat.
The spreadsheet approach will determine a person's weight, BMI, calories burned, and
caloric intake for each week, allowing the user to assess their progress and determine
whether their current course of action is effective.
P3 Designs/annaoations
, When users initially access the spreadsheet, this page appears on the home screen, making
it simple for them to move around the document. Four buttons with the labels "BMI
Calculator," "Data Log Pivot Table Contents Table," and "Pivot Table" are included on the
left side. Each button is set up with a macro to lead to the appropriate sheet. To limit access
to the contents table to administrators only, a password macro has been included. Displays
a backdrop picture of the Blackburn College gym in the leisure Centre to let users know that
the BWD leisure BMI calculator is being used.
Introduction
In this task, I'll be supporting the local leisure centre in their efforts to start a new
programme that will lower people's Body Mass Index which will be determined using a
spreadsheet model I make. This will help people get fitter and healthier. The spreadsheet
will be built in a specific way to ensure that it can forecast how a person's BMI would be
affected by eating and physical activity modifications. It will have specific qualities that
demonstrate a shift in the activities people engage in and the meals they consume over a
minimum of ten weeks.
Because of its ease of use, even those who are not skilled with spreadsheets or have never
used one before can benefit from the spreadsheet model that I will be creating. Moreover,
it will have an interface for users that enables the customer to input their personal
,information, activity preferences, the amount of time they would like to commit to each
engagement and the menu items they want to eat.
The spreadsheet approach will determine a person's weight, BMI, calories burned, and
caloric intake for each week, allowing the user to assess their progress and determine
whether their current course of action is effective.
P3 Designs/annaoations
, When users initially access the spreadsheet, this page appears on the home screen, making
it simple for them to move around the document. Four buttons with the labels "BMI
Calculator," "Data Log Pivot Table Contents Table," and "Pivot Table" are included on the
left side. Each button is set up with a macro to lead to the appropriate sheet. To limit access
to the contents table to administrators only, a password macro has been included. Displays
a backdrop picture of the Blackburn College gym in the leisure Centre to let users know that
the BWD leisure BMI calculator is being used.
