Created as part of the Data Science track, this project uses Python to process a real CSV dataset of mock exam results and produces a visual summary for teachers.
Tools used
- Python 3 + Pandas for data processing
- Matplotlib + Seaborn for charts
- Jupyter Notebook for presentation
What the dashboard shows
- Class average per subject
- Individual student trend lines across terms
- Colour-coded performance heatmap
- Automated flag for students below 50%
import pandas as pd
import matplotlib.pyplot as plt
df = pd.read_csv("results.csv")
below_avg = df[df["score"] < 50]
print(f"{len(below_avg)} students need extra support")