# How do I sort and display student data in the Gradebook?

The Student Name column displays the students in your course. You can view options to sort names by first or last name, SIS ID, Integration ID, and Login ID and display names by either first or last name. You can also choose to view concluded and inactive enrollments.

Additionally, the Secondary Info menu allows secondary information to display below the student’s name. Options include the student’s section, SIS ID, Integration ID, Login ID, Group, or no display. Only one secondary information option can be displayed at one time.

The following keyboard shortcuts are supported in the Gradebook:

<div id="bkmrk-s%3A-sort-the-grid-on-"><div><div>- S: Sort the grid on the currently selected column. Student name and Notes columns sort alphabetically. Other columns sort by grade (low to high).
- M: Open the menu for the currently selected column.
- Esc: Close the menu for the currently selected column.
- G: Open the Assignment Detail page for the currently selected assignment.
- C: Open the Grade Detail tray for the currently selected assignment.

</div></div></div>**Note:** Student names display according to the Sortable Name listed in a user's personal account settings.

## Open Grades

<div data-step-uuid="012e364e-a9dd-4a51-bc98-f0787b5f006b" id="bkmrk-"><div data-step-uuid="012e364e-a9dd-4a51-bc98-f0787b5f006b"><div>![Open Grades](https://media.screensteps.com/image_assets/assets/002/766/990/original/6cddc1bd-351d-4c6f-aaaf-b60efb182e2d.png)</div><div><div></div></div></div></div>In Course Navigation, click the **Grades** link.

## Open Student Name Menu

<div data-step-uuid="4088ea2b-d1ec-4b32-b9eb-458b109cd7c6" id="bkmrk--0"><div data-step-uuid="4088ea2b-d1ec-4b32-b9eb-458b109cd7c6"><div>![Open Student Name Menu](https://media.screensteps.com/image_assets/assets/001/242/095/original/1343c96c-880b-42d6-b9a0-6bbb8a9fe768.png)</div><div><div></div></div></div></div>Hover over the Student Name column header and select the **Options** icon.

## Sort Student Names

<div data-step-uuid="ff7d6007-bbd3-4d75-8a83-8684c0965f45" id="bkmrk--1"><div data-step-uuid="ff7d6007-bbd3-4d75-8a83-8684c0965f45"><div>![Sort by Name](https://media.screensteps.com/image_assets/assets/007/744/127/original/b27a3172-243b-4951-860b-6c762f72eb32.png)</div><div><div></div></div></div></div>To sort students by last name, select the **Sort by** link. By default, names are sorted alphabetically by last name from A-Z \[1\].

To sort students by SIS ID, click the **SIS ID** option \[2\].

To sort students by Integration ID, click the **Integration ID** option \[3\].

To sort students by Login ID, click the **Login ID** option \[4\].

To order students in ascending order, click the **A-Z** option \[5\].

To order students in descending order, click the **Z-A** option \[6\].

### Sort Student First Names

<div data-step-uuid="ff7d6007-bbd3-4d75-8a83-8684c0965f45" id="bkmrk--2"><div data-step-uuid="ff7d6007-bbd3-4d75-8a83-8684c0965f45"><div data-step-uuid="da98eead-4dd8-47e5-9bc0-5df8b406b6da"><div>![Sort Student First Names](https://media.screensteps.com/image_assets/assets/006/999/239/original/68e1a80d-8b29-4ae9-a10d-6be14aa9cb70.png)</div><div><div></div></div></div></div></div>When the Allow gradebook users to view and export student first and last names in separate columns account setting is enabled, you can sort students by first name.

To sort by first name, click the **Student First Name** option icon \[1\]. Then select the **Sort by** link \[2\] and select the **Name** option \[3\]. By default, first names are sorted alphabetically A-Z.

**Note:** Sorting students by last name continues to be available.

## Display Name Order

<div data-step-uuid="56b16671-016a-4947-9f52-4339f41c67de" id="bkmrk--3"><div data-step-uuid="56b16671-016a-4947-9f52-4339f41c67de"><div>![Display Name Order](https://media.screensteps.com/image_assets/assets/001/242/093/original/c53c16ae-4ce5-4138-82b4-3baf4279f693.png)</div><div><div></div></div></div></div>To display names in a specific name order, select the **Display as** link. By default, names display as first name, last name. To sort in descending order, click the **Last, First Name** option.

## View Secondary Info

<div data-step-uuid="25efe6f1-d5de-46fc-8f3b-acc72c0f7f1d" id="bkmrk--4"><div data-step-uuid="25efe6f1-d5de-46fc-8f3b-acc72c0f7f1d"><div>![View Secondary Info](https://media.screensteps.com/image_assets/assets/002/539/085/original/505e15c8-02ec-4f2b-8c1d-3a9c49212e31.png)</div><div><div></div></div></div></div>To view secondary information for students, select the **Secondary info** link. You can have the Student Name column display each student's section \[1\], SIS ID \[2\], Integration ID \[3\], Login ID \[4\], or Group \[5\]. You can also choose to have the column display no secondary information \[6\].

## Show Enrollments

<div data-step-uuid="89865cf6-eb5f-43fa-90f5-80655501fd3d" id="bkmrk--5"><div data-step-uuid="89865cf6-eb5f-43fa-90f5-80655501fd3d"><div>![Show Enrollments](https://media.screensteps.com/image_assets/assets/001/242/091/original/26621bb0-f685-4fae-9a46-eaa4ffaf6b18.png)</div><div><div></div></div></div></div>To [view grades for inactive or concluded enrollments](https://community.canvaslms.com/t5/Instructor-Guide/How-do-I-view-grades-for-inactive-or-concluded-student/ta-p/753), view the Show section and select the **Inactive enrollments** or **Concluded enrollments** link. You can view both enrollment types at the same time in the Gradebook.

## Search Students

<div data-step-uuid="a82713d1-a9b2-47f1-bdeb-b2c06dc50fcc" id="bkmrk--6"><div data-step-uuid="a82713d1-a9b2-47f1-bdeb-b2c06dc50fcc"><div>[![Filter Students](https://media.screensteps.com/image_assets/assets/007/722/963/medium/cf47dfd2-00c6-47ad-9957-f4852be11da8.png)](https://media.screensteps.com/image_assets/assets/007/722/963/original/cf47dfd2-00c6-47ad-9957-f4852be11da8.png)</div><div><div></div></div></div></div>By default, the Gradebook shows all active students. To search for students by name or SIS ID, enter your search query in the **Search Students** field. The Gradebook automatically filters results as you type.

The Search Students field allows multiple student names to be filtered at the same time.

The Search Students field also respects Concluded and Inactive Enrollment options. If the Concluded Enrollment or Inactive Enrollment options are selected as filters, no Concluded or Inactive enrollments display in the Gradebook.

\[Content retrieved from [https://community.canvaslms.com/t5/Instructor-Guide/How-do-I-sort-and-display-student-data-in-the-Gradebook/ta-p/1111](https://community.canvaslms.com/t5/Instructor-Guide/How-do-I-sort-and-display-student-data-in-the-Gradebook/ta-p/1111)\]