We have a group of 100 students that are meant to have discussion amongst each other. For this we want to separate them into 10 groups of 10 people. We want to have three rounds of discussions, however we want the groups to be different each time. No one person should get to sit with the same person twice.
Say we assign our groups letters abcdefghij (10) Person1 gets Round1:A Round2:B Round3:C Person2 gets Round1:A but then can't have Round2:B or Round3:C because they would then meet again.
The "output" I need is that each participant will recieve a card telling him at which table to sit in which round.
Doing this by hand sounds pretty insane and I'm sure there is a pretty simple solution for this. Maybe even a program that does exactly this, but I just can't find it or don't know what to search for...
Maybe this can even be done in excel or sth like that?
Please keep in mind I have NO CLUE about mathematics. So please try and make the answers understandable for the average math idiot ;)
All help or tips apreciated. Thanks for taking the time!