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.
Ändrades senast:28 maj 2025
Fungerar med:
Det finns inga recensioner
244
Översikt
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.

Ytterligare information
PriserKostnadsfritt
Utvecklare
Inte säljare
Integritetspolicy
Användarvillkor
Randomizer frågar efter de behörigheter som visas nedan. Läs mer
Randomizer behöver åtkomst till ditt Google-konto
Detta ger Randomizer behörighet att:
Se den primära e-postadressen för ditt Google-konto
Visa dina personliga uppgifter, inklusive personliga uppgifter som du har gjort offentliga
Recensioner
Språk:
Sortera efter:
Google verifierar inte recensioner eller betyg. Läs mer om recensioner
Inga kommentarer
Sök
Rensa sökning
Stäng sökrutan
Googles appar
Huvudmeny