Desire2Learn 8.3

Importing and Exporting Grades

You can import grades by adding a list of students and grades from outside the online course. You can also export online course grades to a text editor such as Word or Excel.

Desire2Learn's import/export feature uses a comma separated value (CSV) file format. Using a program such as Excel, you can easily open, work with, or create CSV files.

Importing Grades
Exporting Grades

Importing Grades

Imported grades can be any items that the instructor has been tracking outside of Desire2Learn (e.g., attendance or extra credit).

Before importing grades, the grade items must be added to the Desire2Learn grade book. For more information refer to Working with the Grades Tool.

Desire2Learn's import/export feature uses a comma separated value (CSV) file format. Getting the file in the correct format is critical to your success with the import feature. The following illustrates the correct format for the import file. As you can see, this is simply an Excel spreadsheet that is then saved as a CSV file.
Import sample

To import grades:

From the Course Home page, on the Navigation bar, click GRADES
The User List pane appears.
Click IMPORT
The Import Grades pane appears.
In the Import File text box, type the location of the CSV file
OR
To select the file,
1. Click BROWSE...
  The Choose file dialog box appears.
2. Navigate to and select the desired file
3. Click OPEN
When you have the information placed as you desire, click NEXT
The grades are imported to the User List.

Exporting Grades

Exporting grades from your Desire2Learn course produces a comma separated values file (.csv) with the students' information separated by commas. This file can then opened with Excel and saved as an Excel file (.xlsx).

NOTE: It is a good idea to export your Grades List a couple times during the semester and at the end of the semester so that you have a backup of your Grades List.

From the Course Home page, on the Navigation bar, click GRADES
The User List screen appears.
Click EXPORT
The Export Grades pane appears.
In the Export Options section, select the desired options
In the Choose Grades to Export sections, select the grade items you want to export
HINT: A grade item is selected when a check appears next to it.
Click EXPORT TO CSV
The Export Grades dialog box appears.
Click the grade link
The File Download dialog box appears.
Click SAVE
The Save As dialog box appears.
Navigate to and select the desired save location
Click SAVE
The Download complete dialog box appears.
Click CLOSE
The grades are exported.