This article describes the process for importing Codon scores into Canvas when you are not using our grade sync feature. We are looking for ways to improve this process, so if you have thoughts please send them to alexa@codonlearning.com and ashley@codonlearning.com



Step 1 - Go to the Codon Student Scores tab and click the "Download Scores .csv File" button.


You will see the following column headers

  • Student Name (Last, First)
  • Student LMS ID (LTI ID) - if you have an LMS integration
  • Student institution ID (student ID) - if you have an LMS integration, and if your institution shares this information through the integration
  • Student email address - if you do NOT have an LMS integration
  • Assignment names
  • The total points possible for each assignment is shown in the second row.


If no LMS integration:


Or with an LMS integration:


Step 2 - Download the current Canvas gradebook as a csv file.





Step 3 - In a spreadsheet software, you will transfer grades from the Codon spreadsheet to the Canvas spreadsheet. We generally recommend this approach because it ensures the spreadsheet that you will import back into Canvas is in the correct format. Additionally, Canvas requires student details like section that we do not have access to. 


If you've already created copies of the Codon assignments in Canvas, you will transferring scores into the existing spreadsheet columns.


If you have not yet created copies of the Codon assignments in Canvas, add new columns to the spreadsheet with the assignment name as the column header. Canvas will create these assignments for you upon import.


In the example spreadsheet below, Class 1 Preclass is an assignment that was already created in Canvas (and therefore has an assignment ID), and Class 2 Preclass was not already created, so I added its name and total points.



Step 4 - To transfer scores in small courses, you can sort scores by last name, ensure that the order of students is the same, and then simply copy and paste scores from the Codon to Canvas spreadsheet. 


In larger courses, use the VLOOKUP function to transfer grades from the Codon spreadsheet to the Canvas spreadsheet. You can use either the student email or student ID column, depending on what you have available, to match the rows.


To use VLOOKUP, copy the Codon scores off to the right of the sheet. The screenshot below shows where I've copied the Codon scores into columns J-L in the Canvas spreadsheet shown above.

In the column in the Canvas spreadsheet corresponding to the Codon assignment, enter =VLOOKUP(search_key, range, index, [is_sorted]), where:

- The search_key is the individual cell in the Canvas spreadsheet corresponding to the student ID or student email for that row. For example, D3 in the screenshot above.


- range is the range of cells where you copied the Codon scores. Tip: use the $ to keep the row positioning consistent when you copy the VLOOKUP function down to other rows to repeat for every student or across assignments in other columns. For example: $J$3:$L$6, if J is the column where the student email or ID has been copied to and L is the column where the last assignment has been copied to.


- index is the position counting from the left, starting with 1, in the range of the particular assignment you want to copy scores over for. For example, the index would be 2 since column K is the second column to the right starting at column J.


- [is_sorted] is FALSE. This prevents partial matches.



Step 5 - Save your edited Canvas spreadsheet and import it back into Canvas. Here is the Canvas Support Article that describes this.