In addition to importing grades from Canvas Gradebook into GradePage, you also have the option to import grades from a CSV file. The file must be correctly formatted and can include 4.0 grades, percentages, and letter grades like CR and NC.

Frequently Asked Questions

1. How do I format the CSV for grade submission?
   • If I'm starting with a Canvas Gradebook download, how do I format the CSV?
   • If I'm starting with a MyUW class list, how do I format the CSV?
2. Does the order of columns in the CSV matter?
3. Which grade options can I enter in the ImportGrade column of the CSV?
4. How do I import grades in a CSV into GradePage?
5. If I have multiple sections in my course, do I need a separate CSV for each section?
6. What can I do if I have a problem importing a CSV?

How do I format the CSV for grade submission?

Files imported to GradePage must be in .csv format. The import will not accept Excel file types such as .xlsx or .xls. The CSV must contain at least two columns: a column for student identifier and a column for class grades. It is fine for you to include other columns, as long as these two columns with valid headings are there.

• Valid column heading for student identifier
  • SIS User ID (found in Canvas Gradebook) OR
  • StudentNo (found in MyUW class list)
    • Student number can also be found in the Canvas Gradebook as Integration ID, but you MUST change the column header to StudentNo
• Valid column heading for grades to be submitted
  • ImportGrade

The Integration ID column in the Canvas Gradebook .csv export contains UW student numbers. This column can be used for the student identifier, but the column name MUST be changed from Integration ID to StudentNo.

If you are using a file from another system, you can create new columns with the valid headings, or rename existing columns that contain the required data. You can use exported CSVs from Canvas Gradebook or the MyUW class list, as long as you include an ImportGrade column containing the final grades for each student.

Imported grades must be either percentages or valid UW grading system options for the section and student, such as numeric (4.0 scale), CR/NC, or valid letters such as HP, F, P, N. When you import percentage grades, GradePage will guide you to convert them to valid grades. Visit the UW Policy Directory to learn more about valid grades.

If I'm starting with a Canvas Gradebook download, how do I format the CSV?

When you export the CSV of your Canvas Gradebook it may contain many columns, depending on your Gradebook settings, the number of assignments, and the number of assignment groups. If you see a blank row after row 1, do not worry about it; the empty row will not impact your upload. For importing into GradePage, the CSV must contain at least two columns: a column for student identifier and a column for class grades.

• Column heading for student identifier
  • SIS User ID (found in the Canvas Gradebook export CSV)
• Column heading for grades to be submitted
  • ImportGrade (which will need to be manually created)

The Canvas Gradebook CSV already contains the SIS User ID column that GradePage will use to identify your students. Do not delete, change, or rename this column. It is one of the two columns required for uploading. You will need to create an ImportGrade column that contains the final grades for each student. You can add this column anywhere in the Canvas Gradebook CSV.

If I'm starting with a MyUW class list, how do I format the CSV?

For importing into GradePage, the CSV must contain at least two columns: a column for student identifier and a column for class grades.

• Column heading for student identifier
  • StudentNo (found in MyUW class list export CSV)
• Column heading for grades to be submitted
  • ImportGrade (which will need to be manually created)

When you export the class list CSV from MyUW it already contains the StudentNo column that GradePage will use to identify your students. Do not delete, change, or rename this column. It is one of the two columns required for uploading. You will need to create an ImportGrade column that contains the final grades for each student. You can add this column anywhere in the class list CSV exported from MyUW.

Does the order of columns in the CSV matter?

No, the order of columns in the CSV does not matter. The only requirement is the CSV must contain a column heading for the student identifier (SIS User ID or StudentNo).

Which grade options can I enter in the ImportGrade column of the CSV?

From a CSV, GradePage can import:

• Percentages - these will need to be converted during the import process
• 4.0 scale grades - Undergraduate and Graduate scale grades
• CR/NC -  if the course appears in the time schedule as credit/no credit
• P/F -  if the course appears in the time schedule as pass/fail
• HP/H/P/F -  if the course appears in the time schedule as honors/highpass/pass/fail
• N - in progress, final grade will be given at the end of the quarter the work is completed

How do I import grades in a CSV into GradePage?

1. Go to gradepage.uw.edu. The current term is selected and the classes for which you need to submit grades appear below the current term.
2. Click the section you wish to grade.
3. Click the Import Options button and select CSV File. 
4. Click Choose File, select the CSV file containing the grades for your course, and then click Verify CSV. If there is an error verifying the file, use the information provided in the error message to update your file and return to step 4.
5. If you are importing final grades and do not need to convert from percentage, cick Import Grades and move to Step 8. OR If you are uploading percentages, select the grade scale you want to apply (undergraduate, graduate, etc.).   
6. Create a grade scale to convert percentages to a 4.0 grade scale. On the grade conversion scale screen, you have the option to use the calculator to fill in the scale for you, or to fill in the scale manually.
   • To create a conversion scale: Enter values for at least two points into the calculator, and then click Apply to create the conversion scale to convert percentages to grades for submission. You can click Add a row to use more points to create the grade scale. The conversation scale is populated, you can modify values if desired. Scroll to the bottom, and click Review Converted Grades to proceed.
7. On the next page, review the converted grades for the students, and click Import Grades. You are returned to the grade roster, with converted grades imported from the CSV file.
8. On the grade roster, you can adjust final grades and select the checkboxes to assign Incompletes or Writing Credit. A grade must be entered for all students before you can submit grades for each class or section. After assigning grades to all students in the class, click the Review Grades button. 
9. Review the grades and scroll to the bottom of the list to click Submit Grades. 
10. To continue assigning and submitting grades for other classes, click the link at the top of the page to return to the current quarter. 

Using the conversion calculator

To create a scheme, set two or more points in the conversion calculator. The conversion calculator fills in the rest of the Grade Scale table for you. (Linear interpolation, a mathematical method for determining values on a straight line between two known points, is used to fill in the grading scale between the points you enter.) To use the calculator to create a simple linear scale, enter the minimum score for the highest grade, and the minimum score for the lowest grade receiving credit into the calculator.

Here are example values for an undergraduate grade point scale:  

You can refine the scale by adding rows and entering points in between the highest and lowest values. On the Grade Scale table, scores equal to or greater than the minimum percentage score will receive the equivalent class grade. For example, if 97% = 4.0 is entered in the conversion table, then scores of 97% and 98% will both receive a 4.0. You can also manually fill out the Grade Scale with the percentages that correspond to the grade points.

If I have multiple sections in my course, do I need a separate CSV for each section?

No. If you have a CSV that contains students in multiple sections you can upload that CSV for individual sections. GradePage will only import the grades for students listed in that section.

What can I do if I have a problem importing a CSV?

If you experience a problem with submitting grades using CSV import, email help@uw.edu with GradePage CSV Upload as part of the subject line. Please do not attach your CSV file or an image of your CSV file, as emailing student grade information is a FERPA violation.