Scenario- The local leisure centre wants to begin a new programme to help people become
fitter and healthier by reducing their Body Mass Index (BMI). You have 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. The model should 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. The model you develop should 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. The model should calculate, for each week, a person’s calorie
intake, calories burned, weight and BMI
All the slides contain design and layout of my BMI model I
used EXCEL to make my model
Message me if you want the whole model
,
fitter and healthier by reducing their Body Mass Index (BMI). You have 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. The model should 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. The model you develop should 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. The model should calculate, for each week, a person’s calorie
intake, calories burned, weight and BMI
All the slides contain design and layout of my BMI model I
used EXCEL to make my model
Message me if you want the whole model
,
