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                   
Instructions                   
Any questions?  @sig225 on Twitter or calarmstrong AT onenoteschool.com
                   
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.                     

Comments

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

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  https://teacher.desmos.com/  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

Escape Room / BreakOut in OneNote

[[Part 2 of this article is here: Link] ] So when I was visiting  Anna in Edinburgh  during March Break, she showed me how she used Password-Protected OneNote sections within the OneNote ClassNotebook to help students check their work -- she set the password to the correct answer, so they knew they had it right when the Section opened up. I figured I could use this for Math Review, so I set aside a couple of hours (turned out to be 3 hours but a fair chunk of that was solution-time) the other night to put an Exam Review together for my Grade 10 Mathematics course.  I pulled together as many multiple choice questions and short answer questions on the topics as I could Google and tried to balance each Section with a mix of topics and then threw in a couple of pop-culture questions, too.  The students worked on the problems in each section and used the answers as passwords to unlock the next section until they got to the Prize section. Result?  Near total continual engagement