Hi im a 1st year student and this is my assignment in for the 26th of january 2007. i am really stuck and dont have a clue what to do i havent been well and cant catch up because the teachers wont help me. Can anyone out there help??

Scenario Albert is a fitness consultant who runs a weight control club for people who live in his village. They meet each week and measure their weight and percentage body fat.
Albert uses this data in various calculations to generate indicators that he can use to help advise the club members. The indicators he calculates are:
 Body Mass Index Target Weight Daily Calorie intake recommended
Albert has asked you to develop an application that will aid him in the above role. The application should meet the following specification. Specification The finished application should: Calculate target weight Calculate Body Mass Index (include text to advise result eg overweight) Calculate the Daily Calorific Intake recommended Store records of clients’ assessments Be easy to use

2
Tasks
1. Plan and design the application to be developed for Albert. Include designs/plans for all objects to be used (Worksheets, tables, procedures, functions, menus forms etc)
2. Create the application to the above designs.
3. Produce a test plan and test the above application. Correct any errors found.
4. Evaluate the production of the application.
Include
 What went well and what went less well? What was the most difficult task? What features would be included if tasks done again? Explain how the finished application meets the users needs / specification

3
Formulae required:
 To calculate the clients’ metabolic rate, Albert uses the Harris-Benedict equations:
Male MR = 66.47 + (13.75 * BW) + (5 * HT) – (6.75 * A) Female MR = 655 + (9.46 * BW) + (1.84 * HT) – (4.7 * A) Where BW is body weight in Kg, HT is height in cm and A is age in years. To calculate daily calorific intake multiply MR by 1.3 (this assumes client is moderately active). In order to lose weight at rate of 1Kg/week a calorific intake of 500 calories less than daily calorific intake is needed.
To calculate a client’s BMI the following formula is used:

BMI = Weight in Kg (Height in meters)2

BMI
Comment
Less than 20
Lean
20 to 25
Acceptable
26 to 30
Overweight
Greater than 30
Dangerously overweight
To calculate Target weight the clients %BF should be:

Lean weight = Weight-(Weight*BodyFat/100) Target weight = Lean weight / ((100-targetperCent)/100)