In Desire2Learn (D2L) you can import and export grades to manage your grade book by using spreadsheet software such as Excel or Numbers. This can be easier than entering grades online, and it also helps to ensure that you have a back-up file of your grades stored on your computer. The information below will explain the guidelines for exporting and importing grades for D2L.
In order to import grades successfully, follow these guidelines:
*Note about Adding Columns: Numeric, Text, Pass/Fail and Selectbox grades can be imported to D2L. Calculated grades cannot. For definitions of grade types in D2L, visit the Grade Types page.
OIT recommends encrypting your grade book once exported in order to protect important student and course information. To learn how to encrypt your exported CSV file please visit one of the following tutorials based on your operating system:
Once you have added columns to the grade book, ensure that you save it as a comma delimited (.csv) file. For instructions on importing your grade book to D2L, visit Import a Grade Book documentation.