Timetabling ESOL Classes

Problem:

I’m trying to help my wife who is a teacher of English as Second Language (ESOL) teacher.
After initial English language testing, she places her students in ESOL Groups (Group 1, Group 2 …) of between 1-5 members, depending on their level of English.

She then produces a timetable to bring her student out of their Homeroom classes in their ESOL Group (Group 1, Group 2 …) for English lessons. This has been done on a large hard copy template of the weekly timetable with lots and lots of pieces of paper with student’s names on them.


Attachment:
1. Excel Spreadsheet - to show the different layers of information that my wife needs to consider when developing the timetable for her ESOL Groups.
2. PDF Document - Key Points – Explanation of the Excel Spreadsheet.


What I Need:
I want to provide my wife with a spreadsheet with appropriate formulae that will generate the best fit for ESOL Groups on the timetable for all sessions.