Exporting grades

Home » Grades » Managing users’ grades Exporting grades

We recommend that you set up your grade book in Pilot even if you want to enter grades in a CSV or TXT file. You can then use the Export Grades option to create an appropriately structured file.

Export grade items to a CSV or Excel file

  1. On the Enter Grades page, clickExport.
  2. Select All users from the Export Grade Items For drop-down list, as well as the Key Field you want to use to identify users.
  3. Select the Grade Values and User Details you want to export.
  4. Select the Grade Items you want to export.
  5. Click Export to CSV or Export to Excel.
  6. A pop-up window will appear. Click on your file’s link to download it. Click open. Save the file to your computer.

Export grades by group or section to a CSV or Excel file

  1. On the Enter Grades page, click Export.
  2. Select the group or section you want to export from the Export Grade Items For drop-down list, as well as the Key Field you want to use to identify users.
  3. Select the Grade Values and User Details you want to export.
  4. Select the Grade Items you want to export.
  5. Click Export to CSV or Export to Excel.
  6. A pop-up window will appear. Click on your file’s link to download it. Click open. Save the file to your computer.

NoteGrade items that contain French characters do not display correctly in Microsoft Excel. Do not correct the characters in the CSV file if you want to import the file back into Pilot. Use Notepad if you want characters to display correctly.

‹ Importing grades up Using the Milestone Grade Calculation for calculated grade items ›

    

Copyright © 1999-2014 Desire2Learn Incorporated. All rights reserved.

Grades