I am currently working as a maths teacher at a small tutorial college, which offers one-on-one tuition.
There are around a dozen tutors and a dozen students at any one time.
Currently timetabling is done in an arcane way; the week is divided into 5 x 8 slots, so there is one Microsoft word template showing this table. Then the secretary creates one copy for each student and one copy for each teacher and fills all the slots in by hand.
This means that every lesson has to get written into two separate documents, one for the student and one for the teacher.
This means that it is possible for things to get out of sync.
It also means doing it at all is a logistical nightmare.
Can anyone recommend a sane solution?
I've been looking through timetabling software, and everything I've seen is far too complicated, or at least far more complicated than anything the school could possibly require.
It's small enough that everything could be done by hand, i.e. no need for some intelligent timetabling algorithm, no need for any of that complexity.
I'm wondering whether to look at creating something out of Microsoft Access that is capable of exporting a word document containing the timetable for each student and teacher.
Requirement would be:
a table of students; each student arrives on a certain day and leaves on a certain day, they have x maths lessons, y chemistry lessons, z english lessons, but I think it's probably best just to have a text field into which their requirements can be entered
a table of tutors; each tutor has a list of subjects they are willing to teach, but I think this could also be just entered into a text field. each tutor also needs to be able to mark off times or days that they are unavailable
for each week, every student and every tutor needs a timetable. adding a lesson in the student's timetable should make it appear at the right location in the tutor's timetable.
when adding a lesson in the students timetable, the secretary should be able to visually see the availability of various tutors.
What I am hunting for at the moment is a range of viable options.