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.
Fortegnelse opdateret:28. maj 2025
Fungerer sammen med:
Ingen anmeldelser
244
Oversigt
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.

Yderligere oplysninger
PrisUden beregning
Udvikler
Ikke-forhandler
Randomizer anmoder om de tilladelser, der er angivet nedenfor. Få flere oplysninger
Randomizer har brug for adgang til din Google-konto
Dette giver Randomizer tilladelse til følgende:
Se den primære mailadresse på din Google-konto
Se dine personlige oplysninger, heriblandt personlige oplysninger, som du har gjort offentligt tilgængelige
Anmeldelser
Sprog:
Sorter efter:
Google verificerer ikke anmeldelser eller bedømmelser.Få flere oplysninger om anmeldelser
Ingen kommentarer
Søgning
Ryd søgning
Luk søgning
Google-apps
Hovedmenu