This project analyzes student marks using Microsoft Excel.
It helps in understanding performance using basic statistical calculations.
- To calculate total marks of students
- To find average performance
- To identify highest and lowest scores
- Microsoft Excel
- Total Marks Calculation
- Average Marks
- Maximum Marks
- Minimum Marks
The dataset contains:
- Student Name
- Subject
- Marks
- Average marks of students is calculated
- Highest scoring student identified
- Lowest performance also analyzed
- Open the Excel file
marks.xlsx - Check formulas used in the sheet
- View the chart for visualization
- marks.xlsx → Contains dataset and analysis
Total Marks: 417
Average Marks: 83.4
Highest Marks: 90
Lowest Marks: 76
- Neha scored the highest marks
- Average performance of students is good
- Maths subject shows higher scores compared to others
This project can help schools analyze student performance and identify weak areas to improve teaching strategies.
The analysis shows that overall student performance is good, but some students need improvement in specific subjects.
- Add more student data
- Use Power BI for better visualization
- Perform subject-wise analysis
Achal Wakade