Importing Grades from a CSV into the Gradebook

Let’s say you want to import grades from an external platform or maybe you recorded grades in an CSV file and you want to post them to the Gradebook. Well you’re in luck as Quercus allows you to import grades from CSV files. The process starts with downloading the CSV export of your Gradebook first as you will need the correct template for the import to work. After you have the exported CSV from Quercus, you simply add a new column with a new assignment name, add the grades, and import it back into Quercus. See all the details below.

Getting the CSV Export:

Open Grades

In Course Navigation, click the Grades link.

Export Scores

Export Scores

Click the Actions menu [1], then click the Export link [2].

When the export is completed, Quercus will download the CSV file automatically to your computer.

Export current scores

If you navigate away from the page during the export, the CSV file will appear as a previous download in the Actions menu so it can be downloaded again. The Gradebook will show the date and time you requested the export.

Adding a New Assignment Column and Grades to the CSV Export:

Once you’ve downloaded the CSV, you can add a new column with a new assignment name and grades.

View Example CSV File

Importing the Updated CSV

Upload Scores

Click the Actions menu [1] and then click the Import button [2].

Choose File

Choose File

Click the Choose File or Browse button (depending on your browser).

Open File

Open File

Locate the CSV file [1] then click the Open button [2].

Upload Data

Upload Data

Click the Upload Data button.

Upload New Data

Upload New Data

If you add a new column to the CSV file and then upload the file, Quercus will ask you what you want to do with the new column. In the drop-down menu, choose the A new assignment option [1]. Then assign the number of points possible [2]. Click the Continue button [3].

Save Changes

Save Changes

Review the changes made to your Gradebook [1]. Any changes that will result in a lower grade than the previous version are highlighted in red [2].

If you upload assignments with no grade changes, they will be hidden from the upload [3].

Click the Save Changes button [4].

View Updated Gradebook

View Updated Gradebook

View the updated data in the Gradebook.

Leave a Comment

Your email address will not be published.