Automated Course Scheduler Tool
Budget: $30 – $250 USD
I have several CSV files—course lists (with numbers, requisites, labs and any concurrent pairings), faculty-preference forms in Excel, student-preference forms in Excel, and a record of which courses each instructor has previously taught. From those inputs I need a standalone scheduling tool that will:
• read the CSVs directly (no manual re-formatting)
• assign flexible time slots and days to every course, pairing each section with a qualified instructor such that each instructor either teach Mon/Wed or Sun/Tue/Thur but not both.
• export the finished timetable as a single CSV laid out exactly like the sample I will share, showing day, start/end time, and instructor name
• automatically flag overloads (any instructor teaching more than two courses) and anyone whose teaching pattern is limited to only Mon/Wed .
Conflict checking is critical. If I later open the output file, change an instructor or move a time by hand, the tool must immediately warn me of either of the two conflicts I care about: instructor time conflicts or any overlap between courses on the master schedule. Student load limits are not required.
Time slots are completely flexible; the algorithm can choose any logical blocks that satisfy the above rules. If you need guidance on our usual day-part lengths I can supply them, but please build in a simple way for me to edit or add slots later.
I am language-agnostic—Python, JavaScript, C#, anything that can deliver a small desktop or browser-based utility is fine as long as I can run it on Windows with minimal setup. The code should be clean, commented and accompanied by a short read-me explaining how to:
1. point the tool to my CSVs
2. generate a fresh schedule
3. override a cell and rerun the conflict check
Acceptance will be a fully functioning executable (or local web app) plus source code, the read-me, and a sample output CSV that validates correctly against my test data.
• read the CSVs directly (no manual re-formatting)
• assign flexible time slots and days to every course, pairing each section with a qualified instructor such that each instructor either teach Mon/Wed or Sun/Tue/Thur but not both.
• export the finished timetable as a single CSV laid out exactly like the sample I will share, showing day, start/end time, and instructor name
• automatically flag overloads (any instructor teaching more than two courses) and anyone whose teaching pattern is limited to only Mon/Wed .
Conflict checking is critical. If I later open the output file, change an instructor or move a time by hand, the tool must immediately warn me of either of the two conflicts I care about: instructor time conflicts or any overlap between courses on the master schedule. Student load limits are not required.
Time slots are completely flexible; the algorithm can choose any logical blocks that satisfy the above rules. If you need guidance on our usual day-part lengths I can supply them, but please build in a simple way for me to edit or add slots later.
I am language-agnostic—Python, JavaScript, C#, anything that can deliver a small desktop or browser-based utility is fine as long as I can run it on Windows with minimal setup. The code should be clean, commented and accompanied by a short read-me explaining how to:
1. point the tool to my CSVs
2. generate a fresh schedule
3. override a cell and rerun the conflict check
Acceptance will be a fully functioning executable (or local web app) plus source code, the read-me, and a sample output CSV that validates correctly against my test data.