I would list all the kids name in a column. I would then assign a teachers
name to a range. Teacher 1, 1-14, teacher 2 15-29, teacher 3 30-43 (Do not
put the teachers in the spreadsheet yet.)
put this formula in the column next to the kids names.
=RAND()
Copy the formula down to so that there is a rtandom number next to each kid.
Sort according to the random number. This will give you a random sorting of
the kids. Then stick the teachers names in another column as described above.

"CIL" wrote:

Good evening,
Well it happens every year when school starts; the Kids aren't happy with
the teachers or the parents aren't happy with the kids teacher or what ever
happens in between. There is a big brouhaha again this year.

What recommendations does the group have to make the student selection or
the teacher selection totally random? 43 kids and 3 teachers, there are no
twins to contend with.

How would you do this one?

thanks in advance..