How do I sort by Last Name? How do I split Full Names?

Updated

Course Roster page showing a roster sorted by last name and then first name.

To sort by last name on Gradescope you will need to upload two separate columns for first and last names (rather than a single full name column). By uploading split names you will also get separate columns when you download grade spreadsheets.

If you have already uploaded a roster with full names or if you synced your roster with your LMS and only got full names back, you can redownload the roster by clicking the Download Roster button in the bottom right corner of the Course Roster page. Then in Excel, you can then quickly split up the full names into two separate columns of first and last names by going to Data->Text to Columns.

This technique assumes that the first word in a full name is the first name. You will have to manually tweak any names that don’t follow this pattern.

Once you have a spreadsheet with separate first/last name columns, you would upload it to your existing Gradescope roster page (all grades and other student data will be preserved). If you do this, the “swap” button will appear for your course, and you’ll be able to sort alphabetically by last name.

Was this article helpful?
Awesome, glad that it's helpful! 🙌 Have ideas on how we can improve? Sorry to hear that. Let us know what we can improve!
Need help?

Can multiple people grade at once?

Can students add group members to their submission after the submission window has closed?

Contact