Note: To complete the procedures in this document, 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.
From the Gradebook, you can export your students' scores to a
Microsoft Excel file by their cumulative score for the course and with
the student roster. To export scores from the Gradebook, in the
relevant course site, click Gradebook
from the
menubar, and then follow the appropriate steps below.
Under the list of assignments, click the Course Grade
link. You will see a course summary with an average score for your
entire class and your grading table. To export the course grades to
Microsoft Excel (.xls
) or .csv
format, click
the Export for Excel
or the Export CSV
button.
The default filename format for your file is
course_grade_[courseID]__date.*
. The exported fields and
the names of the Excel column headers are "Student Name", "Student
ID", and "CourseGrade".
At the top of the Gradebook, click the Roster
link. To export
your roster (including student grades) to Microsoft Excel
(.xls
) or .csv
format, click the Export
for Excel
or the Export CSV
button (located near the
bottom of the page). 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. For more information about exporting scores from the
student roster, see Using Gradebook to view and export your student roster.