Students Scores

This Excel sheet was done during my first week at the Data Bootcamp

Excel_Students_Scores  

This project analyses student results in English, Maths, and Science to calculate averages, identify highest scores, and assign performance categories.

Executive Summary

The dataset transforms raw exam scores into clear insights by automatically calculating each student’s average, highest subject score, and award category. This helps quickly spot top performers and students who may need extra support.

Tools Used

Microsoft Excel  

Used for data entry, formulas, conditional logic, and structured tabular analysis.

Key Processes

• Data Structure: Student Name, three subject scores, Average Score, Highest Score, Award Category.

• Average Score: =AVERAGE(B2:D2)

• Highest Score: =MAX(B2:D2)

Award Classification:  

• =IF(E2>=80,"Star Performer", IF(E2>=70,"Solid Achiever", IF(E2>=60,"On the Rise","Needs Support")))

Insights

• 80+ → Star Performer

• 70–79 → Solid Achiever

• 60–69 → On the Rise

• Below 60 → Needs Support

This streamlined approach makes student performance easy to interpret and supports data‑driven educational decisions.

Link to Github project: OwenMasterson/Excel_Students_Scores