Using Oncourse Gradebook, how do I view and export all student grades?

Note: To complete these procedures, you must be assigned a role having the necessary permissions. To determine your role, follow the directions in Participant roles. To view a list of permissions associated with a given role, see Permissions, roles, and tools. For a basic understanding of roles and permissions, see Permissions and roles: Overview.

To export only course grades, see Calculating and exporting course grades from the Gradebook

About exporting student information

If you plan to export and maintain local offline copies of any student information (including but not limited to names, University ID numbers, or grades), you are responsible for taking adequate security measures to handle and safeguard such data, as it remains sensitive university data.

The University Information Policy Office (UIPO) has more at Protecting Data.

For more on handling sensitive data, see:

• What is sensitive data and how is it protected by law?
• What is institutional data?

Viewing and exporting student grades

To view and export student grades for all graded items from Gradebook:

1. In your site's menubar, click Gradebook.
   
   
2. At the top, click All Grades.
   
   
3. You will see a list of students whom you are authorized to grade, their scores or grades on all graded items, and their cumulative scores, if applicable. 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 yet have any students enrolled, you will see the message, "No students to display".

   Next to "View", use the drop-down lists to view the roster by section, group, or category.

4. To export grades in .csv format, in the upper right, click Export Gradebook.

   Note: All visible class data is exported. If you filter your roster or sort by column before exporting, it will be reflected in the output.

5. The exported fields and the names of the column headers are "Student ID", "Student Name", and the name of the gradebook item. The full student names and complete gradebook item names are exported. Gradebook item point values will only export up to two decimal places. Scores are listed in the gradebook item name column.
   
   
6. When you are finished viewing and exporting grades, click Gradebook Items to return to the main Gradebook menu.

Comments/Questions/Corrections