math - Creating non reoccuring random groups of people -
so isn't informatics question i'm guessing solution lies in informatics.
we have group of 100 students meant have discussion amongst each other. want separate them 10 groups of 10 people. want have 3 rounds of discussions, want groups different each time. no 1 person should sit same person twice.
say assign our groups letters abcdefghij (10) person1 gets round1:a round2:b round3:c person2 gets round1:a can't have round2:b or round3:c because meet again.
doing hand sounds pretty insane , i'm sure there pretty simple solution this. maybe program this, can't find or don't know search for...
sadly have no skills whatsoever in programming, maybe can done in excel or sth that?
all or tips apreciated. taking time!
yes, can done in excel. need 3 step approach:
- mix students in random fashion.
- create 1 set of mixes don't repeat students
- apply transformation of order students
the tricky 1 2nd.
the exemplary mix is:
since order of students random, can divide them in 10 groups of ten people, easy. have 1st discussion done.
for second discussion can take 1st person of each group (take every 10th person) not in same groups @ 1st time.
then take 1st person 1st group, 2nd 2nd, 3rd 3rd. in way can see no person same person in group. rest of groups go different starts 1st person 2nd group goes 2nd person 3rd group etc.
even though not solution reasonably easy implement. doable in excel.
Comments
Post a Comment