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.