Submitting Final Grades to E-grades

1. Assign a Letter Grade Scheme to your Final Grade Column
2. Export Grades from Brightspace
3. Organize the Columns in Excel for E-grades
4. Copy and Paste Grades from Excel to E-grades

E-grades is Carleton’s final grade entry and approval system accessed through Carleton Central. Within E-grades, instructors can enter grades manually for each student or import/copy and paste grades into E-grades.

While D2L Brightspace can be used for grading and assessment, there is no direct connection between Brightspace and the E-Grades system. However, grades can be exported from Brightspace as a letter grade and then copied into E-grades for final grade submission.

Assign a Letter Grade Scheme to your Final Grade Column

There are two types of final grades in Brightspace: Final Calculated Grade and Final Adjusted Grade. If you want to leave your grades without any changes, you can export the Final Calculated Grades. If you need to modify any final grades, you should export the Final Adjusted Grades. Whether you are using Final Calculated Grades or Final Adjusted Grades, you will need to select a letter grade scheme before you export your grades.

→For instructions on how to release final grades to students, see Releasing Final Grades to Students.

Assigning a Letter Grade Scheme to Final Calculated Grades

1. Log in to Brightspace using your MyCarletonOne credentials. 
2. On the Brightspace homepage, locate your course in one of the following ways:
   • • Click on the course tile under the My Courses widget.
     • Click the Course Selector Grid  and select the course from the drop-down menu. If you are enrolled in more than 20 courses, you can search for the course name using the search bar.
3. In the navbar, select Progress.
4. In the drop-down menu, select Grades.  
5. Click the Enter grades tab. 
6. Click the arrow next to the Final Calculated Grade column and select Edit from the drop-down menu.
7. Scroll down to the Grade Scheme drop-down menu and change the scheme from Percentage Grade to Carleton Letter Grading Scheme (high, medium, or low will all work for this purpose).
8. Click Save and Close.

You are now ready to export your final grades.

Assigning a Letter Grade Scheme to Final Adjusted Grades

To release final adjusted grades, you need to assign a letter grade scheme, then transfer student grades from the Final Calculated Grade column to the Final Adjusted Grade column.

To assign a letter grade scheme:

1. Log in to Brightspace using your MyCarletonOne credentials. 
2. On the Brightspace homepage, locate your course in one of the following ways:
   • • Click on the course tile under the My Courses widget.
     • Click the Course Selector Grid  and select the course from the drop-down menu. If you are enrolled in more than 20 courses, you can search for the course name using the search bar.
3. In the navbar, select Progress.
4. In the drop-down menu, select Grades.  
5. Click the Enter grades tab.
6. Scroll to the Final Grades column and click the arrow next to Final Adjusted Grade.
7.  Select Edit from the drop-down menu.
8. Scroll down to the Grade Scheme drop-down menu and change the scheme from Percentage Grade to Carleton Letter Grading Scheme (high, medium, or low will all work for this purpose).
9. Click Save and Close.

To transfer student grades from the Final Calculated Grade column to the Final Adjusted Grade column:

1. Click the Enter Grades tab.
2. Click the arrow next to the Final Calculated Grade column and select Enter Grades from the drop-down menu.
3. Click the arrow next to the Final Grades title.
4. Select Transfer All. This will move the Calculated grades into the Adjusted column.
5. You will be prompted to confirm that you want to transfer the Final Calculated Grade to the Final Adjusted Grade. Click Yes.
6. Click Save and Close.
7. Adjust any final grades that need to be changed.

You are now ready to export your final grades.

Export Grades from Brightspace

1. Log in to Brightspace using your MyCarletonOne credentials. 
2. On the Brightspace homepage, locate your course in one of the following ways:
   • • Click on the course tile under the My Courses widget.
     • Click the Course Selector Grid  and select the course from the drop-down menu. If you are enrolled in more than 20 courses, you can search for the course name using the search bar.
3. In the navbar, select Progress.
4. In the drop-down menu, select Grades.  
5. Click the Enter grades tab. 
6. Click Export.
7. Configure the following export options:
   • Export Grade Items for:
     • Select All Users if the course only has one section/course code. 
       

       NOTE: For crosslisted and merged courses, select Section and click Apply to view the additional menu for isolating individual course codes.

   • Key Field: Org Defined ID (i.e., Student ID) is selected by default, meaning that the export will sort the exported list according to Student ID number.
   • Sort by: This controls the order of the columns in the exported file. Select Org Defined ID, Username, Last Name, First Name from the drop-down menu.
   • Grade Values: Select Grade Scheme.
   • User Details: Select Last Name and First Name.
8. Scroll down to Choose Grades to Export, then select or deselect the grade items you want to export.             
9. Click Export to Excel.
10. When the export is complete, click Download. The file will download to your computer.

Organize the Columns in Excel for E-grades

E-grades is very particular about the column headings and column order it will accept. E-grades will only accept the following columns in this order: Student ID, Last Name, First Name and Final letter Grade.  (See the screen image below for a visual of an excel spreadsheet with appropriately titled columns.) Any other columns in the Excel file must be deleted or moved.

Copy and Paste Grades from Excel to E-grades

Students will see their final grades in Carleton Central after approval and a processing period.

Was this page helpful?

Still need help? Contact us

Posted in Grading Share: Twitter, Facebook
Short URL: https://carleton.ca/brightspace/instructors/?p=3509