Learn how to upload a spreadsheet to Canvas to add extra-credit items to the gradebook.

1. In your Canvas course navigation, click on Grades to get to the gradebook.
   
2. In the upper right corner, click Export, then select Export Current Gradebook View to download the Canvas Gradebook template.
   
3. Open the downloaded file in Microsoft Excel and create a new Sheet in the Canvas Gradebook template. 
   
4. From your EoS survey respondents list, copy and paste the NetIDs of the survey participants into the newly created sheet. 
   
5. Click on the current gradebook sheet. 
   
6. Delete the columns with the existing Assignments so the other grade items and assignments are not affected by this procedure. 
   
7. Create a new column, then rename the column to "EOS Survey Extra Credit". 
   
8. Identify the row of the first student listed in the spreadsheet. 
   
9. Then identify the intersection between the extra credit column and the row of the first student. 
   
10. In the intersection, insert the formula: =IF(ISNUMBER(MATCH(C4, Sheet1!A:A, 0)), 5, 0) and press enter. 
    • Note: #4 in formula is for example purpose only. This may differ on a case-by-case basis. Please adjust C4 in the formula if your row number is different. 
    • 5,0 are numbers that can be modified based on the required extra-credit points that are assigned. 
      
11. Now click on the cell with the pasted formula, hold and drag the plus sign down to copy the formula to the entire column.
    
12. Click on Export and export the spreadsheet as a CSV file.
    
    • Above image is an example of Window's Excel file export process. Images may look different on different operating systems. 
13. Begin the uploading process by going back to your Canvas course site and clicking on Grades and locating the Import button on the upper right corner.  
    
14. Click on the CSV file saved, and click Upload Data button.
    
15. Once the data is uploaded, set new column with extra-credit points as A new assignment and set maximum points to 0, then click Continue.
    
16. Click Save Changes at the end of the page after confirming the upload of extra-credit. 
    
17. Navigate back to Grades. 
    
18. Click on the assignment column for EOS Survey Extra Credit and click on Set Default Grade, then set Default Grade to 0. 
    
19. When you are ready to share the extra-credit points with your students, you can publish the assignment to be counted towards the final grade.