Skip to main content

Posts

Showing posts from April, 2019

Visibly Random Grouping in Excel

So I was in the Lounge the other day and one of the teachers mentioned that she heard I used Excel for Visibly Random Grouping and asked me to explain it (previous blog post).  Well, I use Excel just to assign my students to one of five tables - at the tables, they can sit in whatever arrangement they prefer.

Well, she wasn't happy with that so asked if she could have a tool that she could design her seating arrangment (sometimes a U, sometimes groups, sometimes rows/columns) and have the students randomly assigned in that.

Well I did a few searches online and there were a few apps but many of them cost money (no way, buddy) so during a class coverage where the students had free work time (i.e. I didn't have to actual teach or ensure they were doing something) I whipped up an Excel macro (well, VBA, but you know what I mean) that would let her design the seating map and then drop the students in randomly.
You are welcome to download the Zip file and use/edit it as you like :