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
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.
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.
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.
Excel users will go to the “Data” tab in the ribbon and choose the “Sort” icon.