Randomizer by Avi Megiddo is a handy tool built for teachers. Use Google Sheetsโข to manage classroom participation, grouping, and fairness in collaborative activities. With just a few clicks, this tool lets you:
Randomize the order of student names
Create random pairs, trios, quartets, or quintets
Prevent students from being grouped together based on prior conflicts or planning constraints ("bad pairings")
Quickly import a setup template with clear instructions
Maintain formatting consistency with pre-set fonts and styles
๐ฏ Why Use This Tool?
In the middle of a lesson or project, you donโt have time to fiddle with sorting formulas or dragging cells. Whether you need to:
Randomize presentation order
Pair students for peer reviews
Form small groups for cooperative learning
Exclude specific pairings due to social/emotional needs or accommodations
This add-on makes it instant and effortless โ right inside Google Sheetsโข.
๐ก Key Features
โ
Randomize Order
Instantly shuffle the list of student names in Column B. Set the number of randomizations in cell A2 to add variability, then click the Randomize Order button.
โ
Make Random Partners
Quickly form pairs from the student list. The tool checks for "bad pairings" (students who shouldn't be grouped together), and reshuffles if needed.
โ
Groups of 3, 4, or 5
Choose the group size you want, and let the tool handle the math and placement. Odd numbers? Leftover students are intelligently distributed into existing groups.
โ
Bad Pairing Exclusions
Add or edit a list of "bad pairings" so that two specific students will not appear in the same group or pair. The tool attempts up to 5 reshuffles to avoid those combinations before notifying you.
โ
Consistent Formatting
All results are pasted in clean, formatted ranges using the Barlow font and 14pt text size, keeping your sheet neat and readable.