# data[].attributes.attachment_link.readable_text
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.

Data Menu

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

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.
I

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()

Copyright secured by Digiprove © 2017

# data[].attributes.attachment_link.title
Google Sheets: Sort Names Randomly - Teacher Tech

# data[].attributes.attachment_link.description
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.

# data[].attributes.attachment_link.title
12 keyboard shortcuts every Chromebook owner needs to know

# data[].attributes.attachment_link.description
A dozen keyboard shortcuts to make Chrome OS even easier to use.

# data[].attributes.attachment_link.title
Noun Project: Free Icons & Stock Photos for Everything

# data[].attributes.attachment_link.description
Noun Project has the most diverse collection of free icons and stock photos. Download SVG and PNG. Over 5 million art-quality icons and free photos.