Google Classroom: Sorting Student Scores by Student Last Name

Google Classroom Grade Export

For now, Google Classroom sorts students by their first name. This of course does not match how the students are listed on our rosters or in our gradebooks. If you are putting student scores into Google Classroom you can export the scores, per assignment.

Click on Download

Google Classroom Download Grades

Go into the assignment in Google Classroom. Click the “Download” button to download a CSV file. If you open the file it will open in an Excel spreadsheet.

Google Sheets

If you prefer to use Google Sheets you can drag the CSV file into Google Drive. Right click on the grades.csv file and choose to “Open with” “Google Sheets.”
right click on file in google drive

Insert Columns

For both Excel and Google Sheets you will want to insert blank columns to the right of the name column. You are going to separate the first and last name into the blank columns.  I would recommend 3-5 blank columns. You need enough columns to account for students with two last names or extra middle initials.
insert blank columns

Google Sheets

Freeze the top row.

In the B column write this formula =Split(A2,” “) into cell B2. This will split up the names at the spacebar. Press enter.
Screen Shot 2014-09-16 at 1.56.56 PM

Click back on cell B2 and double click on the fill down square in the bottom right hand corner of the cell. This will copy the formula down to the bottom of the student roster list.
double click fill down

Excel

If you opened the CSV file in Excel you will need to select “Text to Columns” from the data tab and choose the space as the delimiter.

Sort by Column C

Column C should be the student last names. In Google Sheets you can hover over the column indicator to reveal a drop down arrow. Choose to “Sort sheet A->Z.” Now your grades are listed alphabetically by last name.
google sheets sort A to Z

 

Excel users will go to the “Data” tab in the ribbon and choose the “Sort” icon.