Make random orders, partners, and groups
This is a handy tool that will make organizing random orders, partners, and groups a breeze in your classroom. With just a few simple steps, you can randomize student names, create random partners, and form groups of three or four. This tool is designed to save you time and ensure fairness in your classroom activities and assignments.
To get started, follow these instructions:
Version 3.0 Make Random Orders, Partners, Groups TEMPLATE
Latest Version July 16, 2023: This version handles remainders well. If there is an odd number and you are making partners, it adds the remaining person to pair, randomly. If similarly, if there is a remainder for groups of three, it makes 1 random group of 4. if there are 2 remaining, they are a pair. Similar handling for group of 4, ensuring no group has less than 3 or more than 5 students each.
Version 3.0 also allows adding/editing bad pairings, to ensure certain pairs do not end up in the same group. Use at your discretion!
- Open the template preview of the Google Sheet.
- Click the ‘USE TEMPLATE‘ button in the top-right corner.
- Paste the names of your students in Column B, starting from cell B3.
- To randomize the order of the names, click the ‘Randomize‘ button.
- To create random partners, click the ‘Make Partners‘ button.
- Click the ‘Groups of 3‘ or ‘Groups of 4‘ buttons as you wish.
Version 2 code:
What data do we handle? Our application does not actively collect any personal data. However, the application verifies ownership of the Make Random Orders Groups Google Sheet Template for certain permissions using the user’s Google account.
Google Data Usage Compliance This application’s use and transfer to any other app of information received from Google APIs will adhere to Google API Services User Data Policy, including the Limited Use requirements. This ensures that your data received via Google APIs is used and handled according to strict standards.
How do we use your data? The user’s Google account is solely used to check the ownership of the Make Random Orders Groups Google Sheet Template and to grant permissions accordingly within the context of the application.
How is your data stored? All data inputted by the user is stored within the Make Random Orders Groups Google Sheet Template, and not elsewhere. Users can manually delete the data in the Make Random Orders Groups Google Sheet Template.
Limited Use Compliance Disclosure We comply with the Google API Services User Data Policy, including the Limited Use requirements. For more information, please review the Google API Services User Data Policy by clicking here What are your data protection rights? You have the right to access your own personal data, which is stored directly in the Make Random Orders Groups Google Sheet Template you are using. Your data is not stored anywhere else.
Terms of Service
1. Agreement to Terms
By using this Make Random Orders Groups Google Sheet Template application, you agree to abide by these Terms of Service. If you disagree with any part of the terms, then you may not access the application.
2. Changes to Terms
I reserve the right, at my sole discretion, to modify or replace these Terms at any time.
3. Use of the Application
You are responsible for any activity that occurs through your use of the application. You agree not to distribute any part of the application without my explicit permission.
The application, including the associated Make Random Orders Groups Google Sheet Template and Apps Script code, is owned by me. You are granted a limited, non-exclusive, non-transferable license to use the application for its intended purpose.
5. Limitation of Liability
In no event shall I, nor my partners, agents, suppliers, or affiliates, be accountable for any indirect, incidental, special, consequential or punitive damages, including without limitation, loss of profits, data, use, goodwill, or other intangible losses, resulting from your use of the application.
6. Governing Law
These Terms shall be governed and construed in accordance with the laws of [Your Country], without regard to its conflict of law provisions.
7. Contact Information
If you have any questions about these Terms, please contact me at
megiddo at gmail.com.
Version 1.0 Make Random Orders, Partners, Groups TEMPLATE
This is an earlier version that does not handle remainders well; it just lists them on a new row, but this doesn’t really work, for example, to have groups and then 1 person working alone.
I am in the process of verifying this app. In the meantime, running the unverified Google Apps Script I’m sharing is a safe and straightforward process. Here’s what you can expect:
Version 1 code:
- Authorization Request: When you run the script, you’ll encounter an authorization request. This is a standard procedure and necessary for the script to access specific data within your Google account.
- Clicking “Advanced”: During the authorization process, you will be prompted to click on the “Advanced” option. This step allows you to review and understand the script’s permissions before proceeding.
- Allowing Script to Run: After clicking “Advanced,” you might encounter a warning about the script being unverified. Rest assured, this doesn’t mean any malicious activity is occurring. To proceed, simply select the option to allow the script to run.
Please note that by allowing the script to run, you are basically giving it permission to read from and modify the contents of cells in the sheet. This is necessary for the script to perform the requested actions for you.
Additionally, I want to clarify that the code for this script was authored with ChatGPT. However, it is self-contained and does not involve any external APIs or calls to AI when it is run. Your data and device will remain secure. Feel free to use and modify the code as per your requirements.
I hope this tool simplifies your classroom management and fosters a collaborative and inclusive learning environment. If you have any questions or feedback, please don’t hesitate to reach out.
Lastly, check out my Scratch version of Make Random Partners & Groups