Importing/Exporting Grades

• Only Numeric, Pass/Fail, Selectbox, and Text grade items, and the Final Adjusted Grade can be imported.
• The import file must follow a standard format. See D2L’s File Format for Importing Grades for more information.

Export 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, click 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 or Groups from the drop-down menu.
   • Key Field: Org Defined ID is selected by default, meaning that the export will identify students by their ID. You can select username, or both to customize the export.
     

     NOTE: If you intend to import the file back into the same or another course page, select the Both option for the exported document. Brightspace requires both key fields to complete the import.

   • Grade Values: Points grade is selected by default.
   • User Details: Select any additional identification options you want to include in the export.
8. Scroll down to Choose Grades to Export, then select or deselect the grade items you want to export.
9. Click Export to CSV or Export to Excel.
10. When the export is complete, click Download.                 

You will now be able to open the exported file on your computer. Where you access the downloaded file is dependent on your Operating System and browser. 

Prepare your file for import

1. Save your Excel workbook (e.g. your .xlsx file) as a .csv file by clicking File > Save As.
2. Select the file format extension .csv, then click Save.

Import 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, click Progress.
4. In the drop-down menu, select Grades.  
5. Click the Enter grades tab. 
6. Click Import.
7. Click Choose file.
8. Select the .csv file you want to import, then click Open.
   

   TIP: You can opt to select the Item Creation checkbox if you would like to create a new grade item when an unrecognized item is found in your file.

9. Click Continue.You will see a Processing… message while your file is loading.
10. You will see a page displaying any errors and warnings that were found. Click Continue.
11. You will see a preview of the new grades for each student. Click Import.

You will see an “Imported Successfully” message and your imported grades will appear under the Enter Grades tab of your gradebook.