Hi everyone.
Looking for a way to quickly automate and work out class groups for an elective.
At the moment we do it old school with slips of paper but it takes about 2 hours (if I'm lucky) and is a lot of back and forth to get to the final result. Benefit is we almost always get them their 1st/2nd preference.
Hoping there's a way to do it faster with excel. Only way I've found so far takes just as long as doing it the old way and wasn't as good at getting everyone's top choices (lot more 3rd choices popping up)
How it works is students have a choice of 8 elective classes and choose their top 4 preferences. They do this 4 times a year and can't repeat an elective so they can't rank all 8 options.
Classes are then grouped based on that preference into classes; some classes need to be smaller than others but every class must be smaller than 20.
What I was planning was to make it a MS Form the kids filled in with their choices, giving a data set similar to this:
Name Elective A Elective B Elective C Elective D Elective E Elective F Elective G Elective H John 3 1 2 4 Sue 3 1 2 4
Would there be a way to take this and group kids by choice, trying to maximise the amount of 1st/2nd choices, into classes, while capping classes at different levels?
Thanks for any help you can offer!
Bookmarks