Personal tools
You are here: Home > Grades > How do I export grades to Excel?

How do I export grades to Excel?

Filed under: , ,
Many instructors wish to save grades for archival purposes. Others wish to manipulate data in ways D2L does not currently allow.

Written Instructions

  1. Click Grades from the navigation.
  2. Click the Export button at the top of the page. 
  3. Choose the details to be included with the export.
    • Key field: Org defined ID is the student ID number, username is the section of the email address before the @ symbol.
    • Grade Values: Points grade refers to the number of points the student earned (I.e. 8/10), Grade Scheme may be a percentage or a letter grade depending on how your grade book is set up.
    • User Details: will include the students, first name, last name or email.
  4. Choose the grade items to include in the export file by clicking the associated checkboxes.
  5. Click the Export to CSV button.
  6. A new window will appear that contains a link to a .csv file.  Click the link to open the .csv in MS Excel. 
  7. Data can then be saved or manipulated as necessary.

 

D2L FAQ Feedback

If you have a question about D2L which we haven't answered in the Frequently Asked Questions or notice anything that is unclear please let us know and we will review the content.

Please contact d2l [at] uwosh [dot] edu

Filed under: , ,