Skip to main content

Spring 2023 - Process for Grade Reporting from Canvas to Faculty Center

Since grades cannot currently be imported into Campus Solutions (Faculty Center) directly from Canvas, we have established a workaround using ReggieNet as an intermediary. This process will create a snapshot of your current grades; if any grades are changed in Canvas, you will need to repeat the process for any subsequent grade reporting. 

Please note: This is only for the Spring 2023 semester. A new process is being developed for the summer of 2023 and beyond.

Print this page

Download grades from Canvas

  1. Go to Grades
  2. Select "Export Entire Gradebook" from the Actions dropdown menu
  3. A CSV file will be downloaded

Edit CSV file

  1. Open the CSV file Three column letters and two row numbers highlighted in orange; cell D1 highlighted in yellow
  2. Delete any rows between the first row (containing headers) and the first row of student data (e.g. where it says Points Possible in the first column) 
  3. Delete any columns before the one containing SIS Login ID
  4. Change the entry in row 1 for what is now the first column (SIS Login ID) to "Student ID"
  5. Highlight the entire first column and use the Find and Replace option to remove "@ilstu.edu" from all the entries. In the Find box, type "@ilstu.edu," leave the Replace box empty, and select Replace All
    column A highlighted behind a Find and Replace box with @ilstu.edu in the Find field
  6. Delete all the other columns except "Current Score"
  7. Insert a blank column between the Student ID and Current Score columns. Enter "Name" in the first row. You can leave the rest of the rows blank for this column
    column B with cell B1 labelled "Name" and blank cells underneath
  8. Save this as a CSV file

Import into ReggieNet

Note: These instructions assume that the ReggieNet Gradebook is completely empty.

  1. Go to your course in ReggieNet and select Gradebook
  2. Select the Import/Export tab
  3. Under the Import section, click Browse; browse to and select the CSV file saved above
  4. Click the checkbox next to "Current Score;" click Next
  5. On the New Item Creation page: enter 100 for the Point Value; make sure the "Include item in course grade calculations" box is selected; click Next
  6. Confirmation page should indicate a new Gradebook Item will be created for Current Score for 100 points
  7. Click Finish

Check grades and enter any overrides

Once the grades are imported, you should probably do some spot-checking to make sure things match. You will also need to enter any grade Overrides in ReggieNet.

You should now be able to go to Faculty Center and import the grades from ReggieNet; the ReggieNet course site does not need to be published.

2023-05-09T13:30:47.695978-07:00 2023