Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Google Sheets: Sort Names Randomly

Google Sheets: Sort Names Randomly

randomize range

Use Randomize Range

It seems there is a new trick in Google Sheets. When you highlight a range and right click you can choose “Randomize range.” This sorts the selected range in a random order. I used to have to insert a column, type the formula =rand() and then sort by the random number and then delete the random numbers. Clearly, this is a lot easier.

Choose a Student

I often times will use a spreadsheet to randomly select a student. If you have a roster of the students’ names, you can right click and choose “Randomize range.” A students name will float to the top. Randomize range

Data Menu

You can also find “Randomize range” in the Data menu.
Randomize Range

Assign Peer Evaluation

When I want students to peer evaluate each other’s work I will usually use a spreadsheet and indicate whose work they are going to look at.
Roster of student names and eval columns

I have a roster of students in column A. Column B, C and D indicate who they are going to peer evaluate. Copy and paste the roster into the columns indicating peer evaluation.
Paste Range of student names

For column B, highlight the range of student names and sort randomly.
Randomize Range

Do the same with the names in column C and D. You have to do each range of names separately.

Check for Errors

Since the names are randomly sorted it is possible for a student to be assigned to themselves or for a student to be assigned to the same project twice.
Check for errors

Control X

Control X cuts out the students name and copies it to the clipboard. What I will do is click on the duplicate name and use Control X.
Control X

My system is to rearrange some of the boo boo’s. I need to Control X remove a duplicate and Control V paste it to assign to another student.
ISwap Names

I will usually swap two kids names to make sure I don’t accidentally remove someone from getting their project reviewed. The problem is if I paste (Control V) the student’s name to another student I accidentally delete the name I am swapping. Instead, I paste the name in the column to the right so I can swap student projects.

Uh For Real?

Control X is awesome. I use it a lot. Allows me to move things around the spreadsheet. However, this system of manually looking for fixing up the peer evaluation spreadsheet is tedious and there is a high likelihood I will make a mistake. There are multiple possible solutions for using a formula to check for duplicates.

=COUNTUNIQUE()

In the blank column to the right type the formula =COUNTUNIQUE( and highlight the row of names. This will count up how many unique values there are. In my example, I am expecting there to be 4 unique values. Anything less than 4 has a problem.
Count Unique

I highlighted Column E and right clicked to choose “Conditional formatting.” Choosing to format the cells if they are less than 4 highlights the values I need to pay attention to. I still use the Control X method of rearranging the duplicates manually.
Conditional formatting less than 4

 

 

 

 

 

5 Easy Steps for Teaching with Digital Tools

Introducing digital tools into your teaching can seem challenging at first. There are many tools out there, and it might feel like there’s a lot to learn. But with easy steps for teaching with digital tools, you can start simply and gradually. There’s no need to dive in all at once – just take it one step at a time. Taking easy steps for teaching with digital tools starts with trying something!

Read More »
Students Prepare to Present

Help Your Students Prepare to Present

Maximize student success in presentations with ‘Speaker Notes by AliceKeeler,’ the ideal Google Slides add-on. Enhance how students prepare to present with easy transfer of speaker notes to Google Docs, promoting effective communication skills. Dive into the world of engaging, technology-aided presentations and empower students to shine in their academic endeavors. Discover the key to transforming student presentations into interactive, skill-building experiences.

Read More »

Infographic 7 Basic Steps for a Google Form

New to using Google Forms? This tool is essential for teachers to not only save time but to be adaptive to student needs. Use Forms to survey students, play games, personalize instruction, and assessment. This infographic on the 7 basic steps for a Google Form will help you get started.

Read More »

Online Workshop: Get Your Add-on Published

How can you make Google Workspace (Docs/Sheets/Slides) even better? You can create custom Add-ons with Google Apps Script. Wondering How to Get Your Google Workspace Add-on Published? Join Alice Keeler, Google Developer Expert, to learn the steps to get your Add-on officially published.

Read More »

1 thought on “Google Sheets: Sort Names Randomly

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d