Welcome to Randomizer for Google Sheets™ by Avi Megiddo. You can make random student orders, partners, and groups groups of 3–5. Includes "bad pairing" option to avoid potential conflicts.
Vermelding geüpdatet:28 mei 2025
Werkt met:
Geen reviews
244
Overzicht
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.

Meer informatie
KostenKosteloos
Ontwikkelaar
Geen handelaar
Servicevoorwaarden
Randomizer vraagt u om de onderstaande rechten. Meer informatie
Randomizer heeft toegang nodig tot uw Google-account
Hiermee kan Randomizer het volgende doen:
Het primaire e-mailadres van je Google-account bekijken
Uw persoonlijke info bekijken, met inbegrip van persoonlijke info die u openbaar heeft gemaakt
Reviews
Taal:
Sorteren op:
Google verifieert reviews en beoordelingen niet. Meer informatie over reviews
Geen opmerkingen
Zoeken
Zoekopdracht wissen
Zoekfunctie sluiten
Google-apps
Hoofdmenu