Sakai KB home

Using Sakai 2.9 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. 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.

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 on all graded items, 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 can filter the roster to display those sections or groups one at a time by selecting the section, group, or category from the View drop-down list. If your course does not yet have any students enrolled, you will see the message, "No students to display".

  4. To export grades, in the upper right, click Export as PDF, Export as CSV (results in a .csv file), or Export for Excel (results in an .xls file).

    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 Name", "Student ID", and the name of the Gradebook item (with the relative weight or point value for the item enclosed in square brackets). The full student names and complete Gradebook item names are exported. Gradebook item point values will only be exported 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 or the reset button ( 
    The reset button appears to the left of the tool name
     ) to return to the main Gradebook menu.
Last modified on June 10, 2015.