Grades: How to Export, Transform and Upload Grades

Learn how to export course grades from DC Connect, transform them into an acceptable file type, then upload mid-term and final grades to banner.

Centre for Teaching and Learning
35 steps
4 minutes

Durhamcollege

Desire2Learn

Mycampus

Phase 1: Export Grades

Navigate to [DC Connect](https://durhamcollege.ca/dcconnect)

Select desired course.

Click "Grades"

Click "Enter Grades"

Click "Download Spreadsheet"

This next step is critical to the success of the grade submission process. Do not unselect the key field "Org Defined ID".

Click the "Weighted grade" field.

Click the "Grade Scheme" field.

Click the "Last Name" field.

Click the "First Name" field.

Click the "Email" field.

Click the "Section Membership" field.

It is critical that the **all** fields are selected on the DC Connect download page: - "points grade", - "weighted grade", - "grade scheme", - "last name", - "first name" - "email", - "section membership". - All grade items will be automatically selected, do not unselect. Note: If the gradebook does not include "weighted grades", this option will be missing. Please proceed with selecting all options available.

Click "Download as CSV"

Click "Download" to save file. The file will automatically be saved in the "Downloads" file on your computer.

Phase 2: Transform Grades

Navigate to[ Faculty Self Service Banner](https://ssp.mycampus.ca/FacultySelfService/?mepCode=DC)

Click "Mid-term and Final Grades Transformer"

Click "Browse My Computer" and locate the file that was downloaded from DC Connect.

Click "Midterm" or "Final"

It is critical that the correct option be selected in the transformer. Ensure you double check that you've selected the appropriate selection for "mid-term" or "final" grades.

Click "Transform". A success message will appear below the "Transform" button if transforming the file was successful. The success message reads *"Your transformed file is in your download folder! Now that the file is transformed, go back and select "Faculty Grade Entry" and upload the transformed file. Ensure the correct term is selected on the next step"*

**Troubleshooting Error Message in Phase 2:** If this error message appears, it is appearing because not all check boxes and radio buttons were selected when exporting the grades from DC Connect. Please go back to the instructions on "Phase 1: Export Grades" and ensure all download options have been selected. Instructions are also available within the error message.

Phase 3: Upload Grades

Navigate to[ Faculty Self Service Banner](https://ssp.mycampus.ca/FacultySelfService/?mepCode=DC)

Click "Faculty Grade Entry"

If uploading "Mid-term grades", click "Midterm Grades" tab. If uploading "Final grades", click "Final Grades" tab.

Selecting the incorrect grade entry tab ("Midterm grades" or "Final grades") will result in an error. **Ensure the correct tab is selected.**

Click the CRN where grades should be uploaded. If the incorrect CRN is selected, the grade upload will fail. Note: The "Grading Status" column indicating "Not Started" and "In-Progress" is not applicable. Disregard this column.

After the CRN has been successfully selected, press the gear cog in the top right corner.

Click "Import"

Click the "Browse" field. This will bring up file folders on the computer. Select the file that was transformed in phase 2. This file name will begin with "transformed_2026". For example, "transformed_202641.11333-PHRM-2182-001 - Pharmacology and Behaviour_GradesExport_2026-05-20-19-33". **Do not** select the original file downloaded from DC Connect.

Click "Upload"

Click "Continue"

In the "Preview File" page, click "Continue"

If the gradebook is numeric, the "Preview File" page will look like this:

In the "Map Columns" page, the headings of the transformed file are being mapped to the fields in banner. **Do not edit or change this page.**

Click "Continue"

On the "Validate" page, review the number of records being imported. This should align with the number of students in the CRN.

**Note:** If there is a number under "# records containing errors" or "# unchanged records will not be imported", there is an error with the upload. See troubleshooting steps below.

Click "Continue"

**Troubleshooting Error Message in Phase 3** When reviewing the "Validate" page, if the page indicates "0 records will be imported" or "# of records containing error will not be imported", the **import did not work.** This is most commonly due to misalignment between the transformed grades file and the students enrolled in the course in banner. Troubleshooting Steps: 1. Was the wrong transformed CRN file uploaded? 2. Was "final grades" selected when transforming the file in phase 2, instead of "mid-term grades"? 3. Did you already upload grades, then finish grading late assessments in DC Connect and re-upload grades? **If yes,** **it is expected** that you will have a "# of unchanged records" as you've already imported the grades for those students whose grade is unchanged. Only the changed grades will be imported. Confirm the number of records being imported aligns with the number of student grades being updated. For example, you've completed marking 5 students assessments and are re-uploading their grades, those 5 students would be noted as "5 records will be imported" and the rest of the class will be noted as "30 unchanged records will not be imported".

Review the "Finish" page, which indicates the number of records without errors that have been imported. Click "Finish".

It is recommended that uploaded grades are reviewed to confirm successful upload. After selecting "Finish" on the previous step, the screen will display all students.

Does a student grade need to updated in INC in alignment with [Academic Grading policy (ACAD-112)](https://durhamcollege.ca/wp-content/uploads/112-academic-grading.pdf), section 5.4? After the grades have been uploaded, select the CRN, and update the student grade to "INC" under the "Final Grade" column for the student. Then press "Save".

You have now finished exporting, transforming and uploading your grades.

Where can I get help? The [Centre for Teaching and Learning ](https://durhamcollege.ca/)will be available to support you throughout this transition. If there are questions after reviewing this resource, faculty members and facilitators are encouraged to: - Attend a [professional development session](https://durhamcollege.ca/ctl/events/) - Book [an appointment](https://outlook.office.com/book/CTLCurriculumCourseOutlineSupport@dconline.onmicrosoft.com/s/yJwEUb0EE0qAuPS6hI6F9g2?ismsaljsauthenabled), or - Email [dcconnect@durhamcollege.ca](https://mailto:dcconnect@durhamcollege.ca) Prefer a PDF version? [Download one here. ](https://durhamcollege.ca/ctl/wp-content/uploads/sites/6/2026/05/GradesHowtoExportTransformandUploadGrades-600c931f-c6c7-4cce-bfa2-de.pdf)

Grades: How to Export, Transform and Upload Grades

Learn how to export course grades from DC Connect, transform them into an acceptable file type, then upload mid-term and final grades to banner.

Centre for Teaching and Learning
35 steps
4 minutes

Durhamcollege

Desire2Learn

Mycampus

Phase 1: Export Grades

Navigate to [DC Connect](https://durhamcollege.ca/dcconnect)

Select desired course.

Click "Grades"

Click "Enter Grades"

Click "Download Spreadsheet"

This next step is critical to the success of the grade submission process. Do not unselect the key field "Org Defined ID".

Click the "Weighted grade" field.

Click the "Grade Scheme" field.

Click the "Last Name" field.

Click the "First Name" field.

Click the "Email" field.

Click the "Section Membership" field.

Click "Download as CSV"

Click "Download" to save file. The file will automatically be saved in the "Downloads" file on your computer.

Phase 2: Transform Grades

Navigate to[ Faculty Self Service Banner](https://ssp.mycampus.ca/FacultySelfService/?mepCode=DC)

Click "Mid-term and Final Grades Transformer"

Click "Browse My Computer" and locate the file that was downloaded from DC Connect.

Click "Midterm" or "Final"

It is critical that the correct option be selected in the transformer. Ensure you double check that you've selected the appropriate selection for "mid-term" or "final" grades.

Phase 3: Upload Grades

Navigate to[ Faculty Self Service Banner](https://ssp.mycampus.ca/FacultySelfService/?mepCode=DC)

Click "Faculty Grade Entry"

If uploading "Mid-term grades", click "Midterm Grades" tab. If uploading "Final grades", click "Final Grades" tab.

Selecting the incorrect grade entry tab ("Midterm grades" or "Final grades") will result in an error. **Ensure the correct tab is selected.**

After the CRN has been successfully selected, press the gear cog in the top right corner.

Click "Import"

Click "Upload"

Click "Continue"

In the "Preview File" page, click "Continue"

If the gradebook is numeric, the "Preview File" page will look like this:

In the "Map Columns" page, the headings of the transformed file are being mapped to the fields in banner. **Do not edit or change this page.**

Click "Continue"

On the "Validate" page, review the number of records being imported. This should align with the number of students in the CRN.

**Note:** If there is a number under "# records containing errors" or "# unchanged records will not be imported", there is an error with the upload. See troubleshooting steps below.

Click "Continue"

Review the "Finish" page, which indicates the number of records without errors that have been imported. Click "Finish".

It is recommended that uploaded grades are reviewed to confirm successful upload. After selecting "Finish" on the previous step, the screen will display all students.

You have now finished exporting, transforming and uploading your grades.