University Class Scheduler
An automated scheduling and admin dashboard built for Quchan University. Manages class assignments, instructor data, and schedule generation with manual admin override and Excel import support.
Overview
An automated scheduling and admin dashboard built for Quchan University. Manages class assignments, instructor data, and schedule generation with manual admin override and Excel import support.
Problem
Quchan University's manual scheduling process produced conflicts and created unnecessary administrative overhead. The system needed to automate room-lesson assignment while giving admins meaningful control over the output.
Solution
System automatically assigns lessons to classrooms based on capacity constraints and instructor availability. Admins can search, view, and override any assignment. Excel import enables bulk data entry for existing course records.
Architecture
Django backend with PostgreSQL. REST API serves a React/JavaScript frontend. Scheduling logic as a Django management command. Excel import via openpyxl. Deployed with Docker.
Challenges
Implementing a constraint-satisfaction algorithm that handles room capacity, instructor availability, and time slot conflicts simultaneously.
Building a robust Excel import pipeline that validates and transforms diverse real-world spreadsheet formats.
Outcomes
Deployed and used by Quchan University for course scheduling, eliminating manual conflict resolution.
Lessons Learned
Admin override workflows deserve first-class treatment — users will always need to correct automated decisions.