Question 19: Summer Camp Database

💻 Summer Coding  Tracker

Use the Coding Bootcamp Tracker App to record and calculate how well students performed in their weekly coding challenges. The app helps display each student’s total points, average performance, and final achievement badge.

📖 Scenario:

You are one of the instructors at a Summer Coding Bootcamp where students complete weekly challenges in different coding areas: Python, Web Development, Robotics, and Problem Solving. At the end of each week, you’ll use this app to log scores, track progress, and motivate top performers.

Your job is to enter each student’s name and scores for the week. The app will calculate their total score, average, and assign a badge to show their achievement level.

✅ What You Will Do:

1. Open the app.

2. Go to “Enter Weekly Scores”:

   • Type the student’s name.

   • Enter their scores in:

     • Python

     • Web Development

     • Robotics

     • Problem Solving

3. Click “Submit Student Scores” to:

   • See the student’s total score, average, and achievement badge.

   • Save their data to the bootcamp tracker table.

4. View the Performance Table:

   • See how all students are progressing.

   • Use the table to track who’s improving and excelling.

🏅 Achievement Badges:

• Platinum for average ≥ 90

• Gold for average ≥ 80

• Silver for average ≥ 70

• Bronze for average ≥ 60

• Participant for average < 60

💡 Bonus Challenge:

Add a fifth skill called “UI/UX Design”

• Include a field to input the design score.

• Update the total and average calculations to include this.

• Ensure the updated score appears in the table.

🎊 Extra Feature:
Show st.balloons() when a student earns the Platinum badge!