How do I export grades in the Gradebook?
Notes about CSV files: Some columns that appear in the CSV file are read-only columns calculated by rules or percentages set in the LMS. Any changes made to these columns will be ignored when you re-upload the file to your course. When a grading period filter is applied in the Gradebook, the export displays the filtered grading period results. However, assignment group total columns will display across all grading periods. For assignment group columns, changes made to assignment scores will automatically be included in the assignment group calculation in the Gradebook. The Total Score displayed in the Gradebook reflects each student's score at the time of viewing, taking into account whether the instructor has hidden assignment scores, assignment due dates, etc. The CSV download includes read-only columns for current and final scores. Current score reflects the total while ignoring unsubmitted assignments, and the final score counts unsubmitted assignments as zero. Assignments with hidden scores are unposted grades and shown in separate columns for unposted current score and unposted final score, respectively. If a student has submitted an assignment multiple times, the CSV file only accounts for the most recent submission. Concluded and inactive enrollments are not included in the CSV file unless their respective option, Show Concluded Enrollments or Show Inactive Enrollments, is enabled in the Gradebook Settings menu. Complete/incomplete assignments are shown as full or no credit (e.g. for a 10-point assignment, 10 or 0). If you have the Final Grade Override option enabled in your course, the Gradebook export will include the override grade. Changes to the Final Grade Override display in the import confirmation page. Gradebook export files automatically save to your user files in an Unfiled folder. If you have set manual grade posting policies for specific assignments, those assignments will display the posting policy in the CSV file. However, the grade posting policy cannot be modified via the CSV file. |
Open Grades
Export Scores
When the export is completed, the LMS will download the CSV file automatically to your computer.
If you navigate away from the page during the export, the CSV file will appear as a previous download in the Actions menu so it can be downloaded again. The Gradebook will show the date and time you requested the export.
If you made changes to the Gradebook after exporting a file and want to export a new file, click the Export link again.
Notes: Gradebook export files include the date and time of the download to differentiate between multiple exports. The export filename format is YYYY-MM-DDTHHMM, followed by the course name. Gradebook export files automatically save to your user files in an Unfiled folder. |
Related Articles
How do I use the Gradebook?
The Gradebook helps instructors easily view and enter grades for students. Depending on the Grade display type, grades for each assignment can be viewed as points, percentage, complete or incomplete, GPA scale, or letter grade. Only graded ...Grades and Gradebook
Grades can serve as a communication tool between students and instructors and allow instructors to track the progress of students. The Gradebook stores all information about student progress in the course, measuring both letter grades and course ...How do I curve grades in the Gradebook?
You can use the Gradebook to curve grades for an assignment. In the academic community, curving grades is advisable if only a certain number of students can pass, or when you require a fixed distribution of grades distributed throughout the class. To ...How do I view grades for inactive or concluded student enrollments in the Gradebook?
You can view the grades for inactive and concluded student enrollments in the Gradebook. However, depending on the enrollment type, you may not be able to perform certain actions. For concluded student enrollments, all content in the Gradebook is ...How do I leave comments for students in the Gradebook?
If you want to leave simple feedback for your students, you can leave a text comment directly from the Gradebook. Open Gradebook In Course Navigation, click the Grades link. Open Grade Detail Tray Locate the student name and assignment where you want ...