Mathematical proof that our timetable needs fixing
Everyone complains about our school timetable—Math after PE when we're exhausted, Hindi right after lunch when everyone's sleepy. But complaining doesn't change anything. I needed data to prove the timetable is inefficient, and a scientifically optimal alternative to propose to management.
Collected 8 months of data: test scores by time slot, student attention surveys, teacher effectiveness ratings. Used correlation analysis to identify inefficiencies: subjects scheduled at worst times showed 45-78% lower performance than optimal slots. Created optimized timetable using circadian rhythm research and spaced repetition principles. Presented to principal with math proof: current efficiency 62.3%, optimal 85.8% = 37.7% improvement potential.
solving the impossible scheduling problem: March 2024 - student council secretary tasked with creating Class 11 timetable. 8 subjects, 12 teachers, 6 periods/day, 5 days/week. teachers have availability constraints. subjects need specific labs. sounds simple? it's NOT. first manual attempt took 12 hours and had 7 conflicts (teachers double-booked!). learned this is literally the "constraint satisfaction problem" from computer science. built Python script using backtracking algorithm. input: teacher availability, room requirements, subject hours. output: conflict-free timetable in 8 seconds. shared with principal. now used for all 4 sections. what humans take days to solve manually, algorithms solve in seconds. this is why we learn math and CS - to automate the boring stuff and focus on actually learning. ⏰📅
245 students tracked across all time slots and subjects
Statistical analysis linking time slots to test performance
Applied chronobiology research to schedule optimization
Data-driven proposal presented to school management
8 months of test scores (all subjects, all time slots) + student attention surveys (1-5 scale, filled after each period) + teacher effectiveness self-ratings. Total: 1,960 data points across 245 students × 8 subjects.
Used Excel CORREL function to find correlations between time slot and performance. Controlled for teacher quality, class size. Found statistically significant (p < 0.05) correlations showing Math performs 78% better at 9 AM vs 2 PM.
Constraint-based scheduling: (1) Maximize subject-slot alignment (2) Respect teacher availability (3) Balance daily cognitive load (4) Minimize back-to-back similar subjects. Used greedy algorithm: assign highest-gain matches first.
Compared proposed timetable against current using historical data. Simulated predicted performance improvements. Cross-validated with cognitive science research on circadian rhythms and learning. All analyses supported the optimization.
Every great project starts with a personal problem. What's yours?
Get Started