Export final grades from myCourses to Minerva
If you are using the Grades tool in myCourses, you can export your final grades to Minerva. Refer to the instructors below to ensure a successful export. Please also note that:
J and K grades must be entered directly in Minerva, and
You can only export grades from myCourses to Minerva before the final grade submission deadline, set by the department. Any submission after the deadline will need to be done manually in Minerva via the Grade Change form.
Export final grades from myCourses
Copying your final grades from myCourses into Minerva requires three steps:
Step 1: Setting your final grade scheme
All decimals must be removed before copying your grades to Minerva. Setting a final grade scheme will automatically remove any decimals from your students’ final grades.
On the main Grades page, click Manage Grades.
Click Final Adjusted Grade at the bottom of the list.
From the Grade Scheme drop-down list, select Final Grade - Numeric - 100 to 0.
Click Save and Close.
Step 2: Exporting your final grades to a spreadsheet
On the main Grades page, click Enter Grades.
Click Export at the top of the page.
On the Export Grades page, select the data you want to export:
Under Export Grade Items for, select All users and click Apply.
Under Key Field, select McGill ID.
Under Grade Values, select Grade Scheme
Under Choose Grades to Export, select Final Adjusted Grade.
Click Export to CSV or Export to Excel.
In the pop-up window that appears, click the exported spreadsheet to save it on your computer.
Step 3: Preparing the exported spreadsheet before copying grades to Minerva
Open the saved file with Excel. There should be no decimal places in the exported data.
The only two columns required for submitting grades to Minerva are the OrgDefinedID and Adjusted Final Grade Scheme Symbol columns. Delete all other columns.
Remove the # symbol from the OrgDefined ID column:
Select the OrgDefined ID column.
Click Edit > Replace or Find and Select to edit the column.
Enter the # symbol in the Find what field and do not enter anything in the Replace with field. Click Replace All.
Click Close.
Select and copy all the data from the OrgDefinedId and Adjusted Final Grade Scheme Symbol columns. (do not include the column titles.)
Paste the data into Minerva, using the instructions found on the Final Grades form on the Faculty menu. See Enter/modify final grades in Minerva for details on this procedure.
Have a question that was not answered in this article? Visit our FAQs.
While this resource is accessible worldwide, McGill University is on land which has served and continues to serve as a site of meeting and exchange amongst Indigenous peoples, including the Haudenosaunee and Anishinabeg nations. Teaching and Learning Services acknowledges and thanks the diverse Indigenous peoples whose footsteps mark this territory on which peoples of the world now gather. This land acknowledgment is shared as a starting point to provide context for further learning and action.
McLennan Library Building 3415 McTavish Street Suite MS-12(ground level), Montreal, Quebec H3A 0C8 | Tel.: 514-398-6648 | Fax: 514-398-8465 | Email: tls@mcgill.ca