Viewing and exporting student roster from the Gradebook

Note: To complete the procedures in this document, you need to be assigned a role that has the necessary permissions. To find out what your role is, follow the directions in Participant roles. To see a list of what permissions are associated with a given role, see Permissions, roles, and tools. For a basic understanding of roles and permissions, see Permissions and Roles: Overview.

Viewing your roster

To view your student roster from the Gradebook, follow these steps:

  1. In the menubar of the relevant course site, click Gradebook.

  2. At the top of the Gradebook, click the Roster link.

  3. You will see a list of students whom you are authorized to grade, their scores on all graded assignments, and their cumulative scores. You can search for a particular student by name or ID. If your course has defined sections or groups whose members you are authorized to grade, you will be able to filter the roster to display those sections or groups one at a time. If your course does not have any students enrolled yet, you will see the error message, "No students have been added to this course".

    To view the roster by section or group, next to "View", select the section or group.

  4. When you are finished viewing your roster, click the Overview link to return to the main Gradebook menu.

Exporting your roster

To export your student roster from the Gradebook to your computer, follow these steps:

  1. In the menubar of the relevant course site, click Gradebook.

  2. At the top of the Gradebook, click the Roster link.

  3. To export your roster to Microsoft Excel (.xls) or .csv format, click the Export for Excel or the Export CSV button (located near the bottom of the roster).

  4. The default filename format for your exported roster is gradebook_[courseID]_assignment_name_date.*. The exported fields and the names of the Excel column headers are "Student Name", "Student ID", and "[assignment name]". The full student display names and complete assignment names are exported. Assignment point values will only export up to two decimal places. Scores are listed in the assignment name column.

Note: All available class data is exported. If you sort or filter your roster by your student names before exporting, it will not affect the output.


This is document aqzg.
Last modified on January 17, 2006.