Student Scheduling
Marquardt School District
"I worked with Sprout Ops on the master schedule for a middle school of 100 staff and 800 students. Previously, our options were to randomize student schedules or hand-schedule all students.
Sprout Ops transformed our scheduling process, enabling us to create thoughtful, data-driven student schedules with ease and automaticity. I most appreciated that they tailored their process to meet the unique needs and challenges of our school and students. I HIGHLY recommend this company to any school looking to enhance their scheduling efficiency."
​
- Steve Olson
Assistant Principal
Goals:
-
Develop optimized schedules for over 800 students across three grade levels.
-
Minimize student composite scores across all courses.
-
Ensure compliance with state and federal guidelines for Individualized Education Programs (IEP) and English Learner (EL) services.
-
Achieve equitable student access to courses and balanced teacher workloads.
​
Constraints:
-
Three distinct teams per grade; students' courses restricted within their assigned team.
-
General education classes limited to a maximum of 30% students with IEPs.
-
EL students must receive mandated instructional minutes distributed appropriately across their classes.
-
Specific students require specialized courses, limiting their scheduling flexibility.
-
Different instructors required for English Language Arts (ELA) and Social Studies courses.
​
Outcome:
-
Implemented an automated Python scheduling tool executed annually.
-
Integrates data directly from Google Sheets, managing over 22 million unique scheduling combinations.
-
Algorithmically evaluates each potential course assignment, calculates class impact scores, and identifies the optimal class assignments.
-
Automatically enrolls students into courses to ensure minimal negative impact on overall class compositions.