Unit 5 - Data Modelling Assignment 2/Learning aim B and C Distinction Grade Achieved
13 views 0 purchase
Course
Unit 5 - Data Modelling (CD510)
Institution
PEARSON (PEARSON)
The essay focuses on creating a data model using a spreadsheet to help a local leisure center promote fitness by tracking Body Mass Index (BMI) changes. The model allows users to input personal information, track diet and physical activities, and monitor their progress over 10 weeks. It features us...
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.
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 waqarmohammed997. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.61. You're not tied to anything after your purchase.