View Single Post
  #1   Report Post  
Mort 62
 
Posts: n/a
Default How can I use Excel to schedule students for classes?

I have to schedule a large number of students for remediation. I have some
students who have five study halls and some that have only one or two. I
need to find a way to create a remediation schedule that limits the number of
students that can come each period, but still gets each student to a
remediation period. I have already thought about naming each period of the
week as 11, 12, 13 (day 1, period 1; day 1, period 2; day1, period 3) up to
57, 58 (day 5, period 7; day 5, period 8). I can list the study halls that
each student has by using these numbers. If anyone has any suggestions as to
how to proceed so that I can schedule those students who have one study hall
before the students who also have the same study hall period but have other
study halls in which they could be scheduled, I would appreciate your help.