r/learnprogramming • • 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.

3 Upvotes

6 comments sorted by

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/CapableWafer3140 4h ago

The Excel spreadsheet is useful for tracking session allocations and comparing afternoon versus workday sessions. The basic basics I have figured out luckily. The invigilator assignments, however, are managed in a Word document, and unlike Excel, I have not found a way to link the two so that updates transfer automatically like with the =Sheet1!A1

We have around 40 invigilators each exam season and up to 92 possible sessions per person (each lasting 1 hour 10 minutes), but the disconnect between word and excel is what is creating some manual work. Is there an autofill function which is randomised? Then I can move the whole process over to excel and conditional format for sessions that are double booked. Thank you for the advice against the coding. I would have wasted a lot of time.

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/CapableWafer3140 4h ago

We currently use a system that has a document of all things to consider but I still have to fill in the invigilators manually. I wish to automate that process as it is too time-consuming currently.

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).