Skip to main content

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 : link to download
 The process aims to be straightforward (the teacher did say later in the day that it was the best email she had ever received).
0) Open the spreadsheet in Excel and click ENABLE MACROS (otherwise the NEW button won't work.)
1) Put in your student list

2) Design your map. The only requirement is that you need have a "seat" (cell) numbered 1 through to the number of students in your class, no repeats.  These will get replaced with the randomized students.  The teacher has already created a map of the U shape, the four-table groups and a row/column for testing.  Just copy the Seating sheet and design your classroom!

3) Click the NEW button. It will create a new sheet dated with today's date with the randomized students shown.  You can project, print or email this sheet.

That's it.  Let me know if you find this useful.

(from the Excel file, the Instructions sheet)
Random Seating Plan Generator                   
Any questions?  @sig225 on Twitter or calarmstrong AT
Class Lists                   
Fill up the student list with your class list, one per cell in the B column of the ClassList Sheet, up to 50 students.                   
The sheet counts your class list so you don't need to change the number at the top of the sheet.                   
Seating Maps                   
Use the sheet to design your seat arrangements -- it doesn't matter how it's designed or how much space you use.                    
You can color code, fill, use fonts, italics, add images, whatever. I use the BORDER to indicate the "seat" for each student but feel free to get creative.                   
The ONLY requirement is that you have each cell that represents a seat be numbered 1 through your # of students (no repeats).                   
If you want a student to always be in a particular seat, do not put them in the class list but instead put their name in the seat you want them in.                   
You can have as many different seating arrangements as you want -- but it will only let you have one seating arrangement per day (it overwrites the day).                    
You can delete the daily sheet if you don't want to save it but don't delete your Seating maps - they can be re-used (and cut-and-pasted between Classes).                   
When cutting & pasting between classes be sure not to copy the NEW button -- just the seats!             
If you want an additional seating map, right-click the SEATING tab and chooose MOVE                   
Then, in the PopUp click on CREATE A COPY and click OK.                   
You can rename the "Seating" sheet to match your needs.                     


Popular posts from this blog

So you want to hack your OneNote Class Notebook

Taking a brief break from my "Getting Started with OneNote Class Notebook" series (you can start that one here )... This is a little advanced so if you're not comfortable setting permissions inside of Office365 you may want to avoid this.  Or set up a Class Notebook to play with so that it doesn't affect any existing Class Notebooks.  Yeah, the latter is a good option. One of the great powers of OneNote is that you can do some really neat permissioning of the Section Tabs. When the Notebook is created, of course, it gives you an "open permissions" on the Collaboration Space and student-read-only on the Content Library.  And then each student space is wide open to each individual student. But we've found that occasionally you want to mix up the permissions a little.  For example, you could create a space in a student section for your private notes that the student couldn't see, or maybe you want a tab in the Collaboration Space that students cou

Online assessment

Sorry... I forgot I was supposed to write things here :) And thanks to David Cox's recent post on ExamView to prompt me to return to writing ... not to mention that I'm at Educon this weekend and everyone there is a prodigious blogger. But back to ExamView. ExamView seems to be another online assessment tool and David writes how he is using it in his classroom and how he plans to use it. I've been using an alternate tool, MapleTA and had considerable success with it. I think the strength of MapleTA over the other assessment tools is that it is based on the computer algebra system Maple -- and therefore, when you ask a question or the student enters a solution, it can involve any manner of mathematical content. Not just numbers but also algebra and graphs. And we managed to jury-rig Geometer's Sketchpad to provide dynamic diagrams (yes, we'll be switching over to GeoGebra when I find some time). I think the most important aspect of online assessment is the us

Desmos, OneNote & Replay

So using Desmos activities are a great way to encourage exploration and discussion in math class -- if you haven't tried them, I encourage it.  They're collected at  But ... Desmos doesn't give you quite enough.  It doesn't have a way of capturing the work that the student does within their space, and it doesn't allow for annotation of class contributions as we come together to discuss.  Well, not surprisingly, OneNote comes to the rescue.  Using the Windows shortcut Windows-Shift-S it is really quick to snag the Desmos screen and pop it into a waiting OneNote page.  From there, we can grab our pen and (using wireless projection) talk about what all the different responses mean and where to go from there. (An aside : one of the nice features of Desmos activities are the way you can hit PAUSE and it will pause all the screens of the students working.  I always give them a heads up "10 seconds to pause..." and it's refr