Export scores, times, or difficulty ratings from the Gradebook

As an instructor, or a section instructor with the Gradebook privilege , you can export Mastering Gradebook data. The data you export goes into a .csv (comma separated values) file, which can be opened in a spreadsheet application or imported into a different gradebook.

Why export Gradebook data?

Track grades for all assignments in one place: Exporting grades offers a standardized way of using Mastering grades in other gradebook formats. Note: Export does not preserve some Mastering Gradebook features, such as assignment categories or weighting. If you prefer not to lose those Mastering capabilities, you can pull in other grades and track Offline Activities (non-Mastering) activities in the Mastering Gradebook.
Archive student grades: Exporting grades at the end of the term is a recommended practice for archiving student grades. You might also want to export a student's grades to give to another instructor if a student transfers to a different section of the same course during the term.
Analyze scores for a subset of students: If you want to export scores for only selected groups of students, you can filter the Gradebook data before you export.
Analyze time and difficulty patterns: Exporting and examining time spent or difficulty ratings for Mastering assignments can provide insight into areas where students need more study or instruction, or it can reveal possible student cheating. After you have opened the exported data in a spreadsheet application, such as Microsoft Excel, you can sort the rows by any column.

Export student scores

Click Instructor Tools > Gradebook.
Prepare for export:
- Filter the data as you want to export it; for example, scores for only one group of students.
- If you plan to use exported scores in a learning management system that is not already integrated with the LMS course, check the consistency of student IDs. Display student IDs in the Mastering Gradebook and compare them with student identifiers in the LMS course. If you notice inconsistencies, you may want to edit the student IDs in Mastering.
- If you plan to use exported scores in a spreadsheet, ensure that the Gradebook displays scores as you want them exported, or change the points or percentages format in Course Settings.
Click Manage > Export Gradebook Data.
From the Export Scores list, select a format based on how you'll use the data.

Modified Mastering grades might be able to be automatically synced with your LMS, but you can still export those scores with proper formatting for the selected integration by using one of these options.
For a Moodle integration, select the Canvas export option.
Mastering assignment exemptions are not transferred to the Blackboard Grade Center. To exempt a student from a Mastering assignment, use Blackboard's exemption feature.

You can later use your saved file in either:

The program you selected during export
Any program that recognizes generic .csv files, such as Microsoft Excel

See that program's documentation for instructions for importing or working with the data.

Assignments for practice have no grades to export. Grades in these assignments are indicated by dashes in the Gradebook and in exported files.
When you select the Standard Gradebook Format, only grades for assignments that are already due are exported. Grades are not exported for assignments that are not yet due.
In specialized exports (for instance, for export to Blackboard), all assignment grades are exported, even for assignments that are not yet due. However, these are not necessarily final grades; they represent only what the student has submitted so far.
The Gradebook exports grades to 2 decimal places of precision. This is precise enough for most purposes, but slightly less exact than the Gradebook internal calculations, which are calculated to approximately 9 decimal places.
Exported data is weighted according to the weighting scheme defined for the Mastering course. The category to which an assignment belongs is not exported, however.
If a Gradebook filter is active when you export, only scores meeting the filter criteria are exported.

Export time or difficulty data

From the Export page, click Export for either Export Times or Export Difficulty, and if prompted, click OK. You can select only one of these export options at a time.
Save the file on your computer. Keep the .csv extension if you rename it, and leave the type as Microsoft Office Excel Comma Separated Values File. You can later open the saved file with any program that recognizes .csv files, such as Microsoft Excel, and sort the data by any column.

Times are rounded up to the nearest minute. Because the time data reported is not absolute (some rounding may be done due to periods of inactivity, for example), use this data only for comparison purposes among students.
This data includes the time that each student spent working on individual assignment, whether they completed all items, whether they took time to answer any available hints, and so forth.
The total time that each student spent working on ALL assignments in the course is in the last column.

Important: This data is NOT intended as a sole indicator of possible student cheating.

The difficulty is rated from 1-5, with 5 being the most difficult.
The rating for each assignment represents each student's individual difficulty with the contents of the assignment, including time taken, number of wrong answers, and the final grade.
Difficulty data is not available for Dynamic Study Module assignments, Learning Catalytics sessions, or Offline Activities.
An average difficulty rating for each student's work on ALL assignments in the course is in the last column.