Hi All -
I am looking for some help with a problem for work (assistant principal).
What I would like to have done is to take the following information (Student Name, Behavior, Academics, Gender) and then generate a certain number of class lists that represent approximately equal distribution (within a specified range) of traits in each area.
I wouldn't need this to operate for more than about 200 students and to place them into more than 10 groups.
[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 64"]Student Names[/TD]
[TD="class: xl64, width: 64"]Behavior Ratings[/TD]
[TD="class: xl64, width: 64"]Academic Ratings[/TD]
[TD="class: xl64, width: 64"]Gender[/TD]
[/TR]
[TR]
[TD]Joe[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Larry[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Sue[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Karen[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Mary[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]
I am looking for some help with a problem for work (assistant principal).
What I would like to have done is to take the following information (Student Name, Behavior, Academics, Gender) and then generate a certain number of class lists that represent approximately equal distribution (within a specified range) of traits in each area.
I wouldn't need this to operate for more than about 200 students and to place them into more than 10 groups.
[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 64"]Student Names[/TD]
[TD="class: xl64, width: 64"]Behavior Ratings[/TD]
[TD="class: xl64, width: 64"]Academic Ratings[/TD]
[TD="class: xl64, width: 64"]Gender[/TD]
[/TR]
[TR]
[TD]Joe[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Larry[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Sue[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Karen[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Mary[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]