Question : Health Database 20

🩺 Student Health Checkup Tracker

Use the Health Checkup Tracker App to record, monitor, and assess the health status of students based on their physical checkup scores. The app calculates a health score and assigns a health status grade.

📖 Scenario:

You are assisting the school nurse during the annual student health checkup week. Each student is evaluated in four areas: Body Mass Index (BMI), Vision Test, Fitness Test, and Blood Pressure. You’ll use this app to input the scores for each test, and the system will calculate their total health score, average, and health grade.

Your job is to ensure that each student’s record is entered correctly and saved for review.

✅ What You Will Do:

1. Open the app.

2. Go to “Enter Health Check Scores”:

   • Enter the student’s name.

   • Input the scores for:

     • BMI (0–100)

     • Vision Test (0–100)

     • Fitness Test (0–100)

     • Blood Pressure Assessment (0–100)

3. Click “Submit Student Scores” to:

   • Automatically calculate their total health score and average.

   • See their health status grade (A+ to F).

   • Save the information to the health checkup database.

4. View Health Records:

   • Check the full table to see all students and their health scores.

   • Use it to identify students who may need follow-up care.

🩻 Health Status Grades:

• A+ for average ≥ 90 (Excellent Health)

• A for average ≥ 80 (Very Good)

• B for average ≥ 70 (Good)

• C for average ≥ 60 (Fair)

• D for average ≥ 50 (Needs Attention)

• F for average < 50 (Immediate Medical Attention)

💡 Bonus Challenge:

Add a fifth checkup category called “Dental Hygiene”

• Add a score input for Dental Hygiene.

• Recalculate total and average to include all five areas.

• Update the table to display this new score.

🎈 Extra Feature:
If a student scores an average of 90 or above (A+), show st.balloons() to celebrate excellent health!