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:
In Course Navigation, click the Grades link.
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.
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.
Importing the Updated CSV
Click the Actions menu [1] and then click the Import button [2].
Choose File
Click the Choose File or Browse button (depending on your browser).
Open File
Locate the CSV file [1] then click the Open button [2].
Upload Data
Click the Upload Data button.
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
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 the updated data in the Gradebook.