Article ID: | iaor20021231 |
Country: | United Kingdom |
Volume: | 52 |
Issue: | 6 |
Start Page Number: | 623 |
End Page Number: | 629 |
Publication Date: | Jun 2001 |
Journal: | Journal of the Operational Research Society |
Authors: | Baker B.M., Benn C. |
Keywords: | heuristics, spreadsheets |
Comprehensive schools in the UK have the annual task of assigning their intake of new pupils to tutor groups. This case study describes how the problem has been addressed at one such school, where several factors are taken into account in order to make the groups as similar as possible and, since pupils have an induction day in June when they assemble in their tutor groups and meet their new tutors, where the time scale is short. Manual allocation has been used in the past, needing many staff-hours to achieve a satisfactory result. Heuristics implemented on a spreadsheet have enabled substantial savings in staff time and given more evenly balanced tutor groups.