Skip to Main Content
UCQ

D2L - Instructor Guide

This guide is intended for helping faculties with setting up and maintaining their D2L Course.

Export final grades from D2L to PeopleSoft

PeopleSoft final grades must be entered in Letter format. Ensure that the grade book uses a Grade Scheme for the Final Grade. 

PART 1: Export D2L Final Grades into Excel format

1. Export D2L Final Grades in Excel format. Click on the Export button from the grade book. 

 

2. On the Export Grades page, ensure "Org Defined ID" and "Grade Scheme" are selected.

 

3. Under the heading Choose Grades to Export, select Final Calculated Grade, and Click Export to Excel.

 

4. A window will pop up and Click Download to save the Excel file on your computer.

 

 

5. Open the Excel file. There are two populated columns, The OrgDefinedId column contains Student UCID Numbers and the Calculated/ Adjusted Final Grade Scheme Symbol column contains the Final Grades in Letter form. 

 

 

6. IMPORTANT NOTE: The Excel cell  (A1, B1, and C1) must be updated before the file can be uploaded to PeopleSoft.

In cell A1, replace “OrgDefinedId” with the 4-letter Subject Area code (eg: NURS). 

In cell B1, replace “Calculated/ Adjusted Final Grade Scheme Symbol” with the Course Number (eg: 207).

In cell C1, type in the Lecture Number. (Leading zero is not required eg:1).

Below image  is an example of a file in the proper format:

 

 

7. Save the file for PeopleSoft upload in CSV format on your computer.

IMPORTANT NOTE:  Shorten the file name to prevent errors when uploading to PeopleSoft.  Do not exceed 30 characters. The file is now ready to be uploaded to PeopleSoft. 

 

PART 2: Importing final grades into PeopleSoft

1.  navigate to the MyUofC portal. Sign on with username and password

2. Navigate to the Academic tab. Under Direct Access, click Faculty Centre.

 

3. Click Administer Grades to access the grade rosters for courses.

 

4. IMPORTANT NOTE: The Roster Status must be set to "Not Reviewed". Click the Grade Roster Icon on the class to upload grades from a file.

 

5. Click the "Initiate Upload" button and choose the CSV Excel file that was exported from D2L modified and saved on the computer.

 

6. Click Browse and locate the CSV Final Grades file from the computer to upload.

7. Click Upload.

 

8. After uploading the file successfully, please verify grades. If no changes are required, modify the Approval Status to Ready for Review, then click SAVE. This allows the Approver to approve this grade roster. 

 

More Information

Refer to "Export and format D2L Gradebook file for final submission in PeopleSoft".