r/learnprogramming • u/CapableWafer3140 • 5h ago
Program coding/creation recommendations
I’ve been tasked with creating an invigilation timetable. This involves assigning invigilators to specific venues to oversee school examinations. The current system is outdated and manual. Each invigilation session is then manually entered into an Excel spreadsheet to ensure even distribution. I’m not interested in purchasing an app or software to automate this process, I’d prefer to build it myself so that the system can be adjusted if there were to be changes on certain examination days and those who get this task after me don’t have to waste as much time. Given my lack coding skills, any advice on simplifying this task would be greatly appreciated. I’m open to learning coding but have less than a year to complete the project.
1
u/StatsDota_Dmitrii 5h ago
honestly i wouldnt start with a program. excel can already do most of it: one sheet with invigilators, one with sessions, and a COUNTIF column that shows how many sessions each person has, so you see the load at a glance. if you still want code later, a small python script with pandas reading the same excel file is something your successor can actually maintain, a custom app usually dies when you leave. how many invigilators and sessions are we talking, like 20 or 200?
1
u/jacksonanna373 5h ago
Write each session's venue/time, who is eligible and available, and what 'even' means (sessions or hours); test those rules on one exam day before coding.
1
u/joranstark018 4h ago edited 4h ago
There can be many criteria to considder, eg personal preference like a person only preferre late shifts, a person does not accept split shifts, how many consecutive hours are allowed, how many invigilators should be on each shift, how many shifts are there for each day. These has to be provided as "rules" into the "engine" and each rule should have a "penalty" for breaking it. Then it is just a matter of creating a permutation of different solutions, calculate the combined penalty for each solution, present the solutions with the least penalty cost. You may have different algorithms for creating the permutations (eg https://en.wikipedia.org/wiki/Travelling_salesman_problem)
My advice is to look for available libraries for this, it can become complex to build one from scratch your self. AI may not be the best tool to to make this type of planning as AI is based on probabillity rather then rules, but AI may help you if you want help with collecting your requirements and in iterating a plan (depending on ihow much you want to be a supervisor or a do -it-yourself).