At the end of the semester, many associate deans request a report of student grades from each instructor. It is a simple process to export the Gradebook from your Canvas course to a spreadsheet file, which you can then email to your associate dean.
To export your Gradebook from Canvas:
- From the course menu on the left, select Grades.
- On the far right of the Gradebook, click the Export button.
- Select the Current option (if it appears).
- The spreadsheet downloads to your computer. The file's name includes the course name, today's date, and a .csv extension.
For step-by-step instructions, review this Canvas Guide:How do I download/export scores from Canvas Gradebook to a spreadsheet?
Gradebooks and Cross-listed Courses:
The exported Gradebook of a cross-listed course combines the grades of the students of all cross-listed sections in a single .csv file. One solution is to sort or filter the spreadsheet by section number, then copy the records for each section into separate worksheets in the spreadsheet file. Instructions for sorting a range or table:
- Instructions for sorting a range or table (Excel 2007)
- Instructions for sorting a range or table (Mac 2011)
Some additional considerations:
- Canvas can automatically add (next to the Totals column) a column with a letter grade (A+, A, A-, B+, etc.). To do this, enable the Letter Grades grading scheme before exporting the Gradebook. Review the Canvas Guide: How do I enable a grading scheme for my course?
- Instructors must manually enter all grades in Banner (MySLCC). There is no automatic transfer of grades from Canvas to Banner. For instructions, see How and When Do I Enter Final Grades? on SLCC's Faculty Services website.