Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Unless someone has spent a few years making a special program just for your
purposes...this is the tricky part "but have other study halls in which they could be scheduled". Maybe using a random number generators to schedule them and seeing how little never get scheduled. And let the randomness keep running until everyone gets scheduled. "Mort 62" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
excel 4.0 macro removal tool | Excel Discussion (Misc queries) | |||
Why not introducing worksheet for business students in MS EXCEL? | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
How do I create project schedule using excel - office 2000 | Excel Discussion (Misc queries) |