This Excel project analyzes student performance using data-driven techniques.
It demonstrates data cleaning, use of formulas, and visualization to extract insights from marks data.
The goal is to understand student progress, identify top performers, and summarize subject-wise results.
- File:
Student_Marks_Data.xlsx - Columns: Student Name, Subject, Marks, Total, Average, Grade
- Records: 10 students, 3 subjects each (Math, Science, English)
- Formulas:
SUM,AVERAGE,IF,COUNT,ROUND - Conditional Formatting for Grades
- Data Validation for clean inputs
- Sorting and Filtering
- Charts: Pie Chart & Column Chart
- Identified top-performing students
- Compared subject-wise averages
- Displayed grade distribution visually