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.
Assign Peer Evaluation
Do the same with the names in column C and D. You have to do each range of names separately.
Check for Errors
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.
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.
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.
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.