An interactive web tool built with Streamlit to transform raw grading data into navigable intelligence, used directly by coordinators and teachers in the Class Council.
Decisions without data
The Class Council meetings took place without structured access to data. Teachers debated from memory or based on scattered notes, with no consolidated view of each student's performance.
No subject-level analysis
Understanding how an entire class performed in a specific subject required manually cross-referencing spreadsheets. No one did this systematically, and pedagogical decisions were made without quantitative support.
Invisible individual trajectory
Knowing whether a student was improving, declining, or stable across mock exams was impossible without consulting multiple spreadsheets. Individual progress never reached the council.
A navigable dashboard with two complementary views: by student and by subject. Each screen was designed to answer exactly what coordinators and teachers need to know before and during the Class Council.
Real system interface
Individual student view
Student photo, overall average, class ranking position with percentile, comparison with the class average, strengths (above 8.0), subjects at average (7.0 to 8.0), and subjects needing attention (below 7.0). Everything on a single screen, without navigating between spreadsheets.
Radar chart by subject
Radar visualization with 20 subjects comparing individual performance against the class average. Identifies in which area a student excels or needs reinforcement within seconds, without reading a table.
Progress across mock exams
Line chart tracking the student's overall trajectory and by individual subject, with reference lines at 5.0 and 7.0. The improvement or decline trend is immediately visible to any teacher, with no technical interpretation required.
Subject trend table
Variation between the first and last mock exam with a visual up, down, or stable status for each subject. Quickly identifies where the student progressed and where they regressed throughout the year.
Subject view
Class traffic light (passing, at risk, recovering), historical ranking with the score per mock exam and each student's trend, and a boxplot chart showing the score distribution per exam. A complete view for the subject teacher.
PDF Study Plan Generation
With a single click, the dashboard generates an individual PDF for the student using the data already loaded on the screen. The plan comes out formatted with the institution's visual identity, ready to be delivered with no manual editing.
Data that previously never reached the council now appears on screen in real time.
The dashboard transformed the Class Council from a perception-based meeting into an evidence-based decision. Every student's story is told in data, every teacher arrives prepared, and every pedagogical decision has quantitative support.