Formatting Grades for Canvas

Download a template from Canvas
  1. Log in to Canvas and go to Grades.
  2. Click on Export > CSV file.
  3. In this CSV file, delete everything below row 3. You can also delete everything to the right of column E (Section), apart from columns corresponding to the scores you're about to import (if they exist).
Add scores to the template
  1. Open the scores spreadsheet which you downloaded from WeBWorK.
  2. If you want each homework assignment to be worth the same amount, then you will have to manually rescale each column to be out of the same total. If you rescale each column to be out of 100, you can then set Canvas to display scores as percentages. After rescaling each column, be sure to copy your columns and paste them as numbers (not formulas).
  3. Instead of separate columns for “First name” and “Last name”, you need one column for “Last name, First name”. A formula such as =CONCATENATE(C8,“, ”,D8) should accomplish this. After making this column, be sure to copy this new column and paste it as text (not formulas).
  4. Copy the “Last name, First name” column and all the scores columns to the template spreadsheet from Canvas. Every other column can remain empty.
  5. If you haven't already created the corresponding homework assignments in Canvas, then in rows 1 and 2 of each score column, enter an assignment title and the total number of points.
  6. Save the template spreadsheet, which should now contain scores.
Upload the scores to Canvas
  1. Back in the Canvas gradebook, click “Import”.
  2. Select your modified template spreadsheet and follow the onscreen instructions.