Exporting Student Grade Information

EXPORT XLS - Data from the STUDENT/GRADE LIST can be exported to an Excel spreadsheet (or another spreadsheet application). Excel is the default.

EXPORT CSV - Data from the STUDENT/GRADE LIST can be exported to an Excel spreadsheet (or another spreadsheet application) with Comma Separated Values. Excel is the default.

The export file has the following information for each student:

  • Name
  • Username
  • MIT ID
  • Section number
  • Letter grade
  • Cumulative grade
  • Original, actual and makeup grade for each assignment (both approved and unapproved grades)

To export this information from the Gradebook:

  • Click the Students tab in the Gradebook.
  • Click the Export XLS, Export XLS with makeup grades or Export CSV button.
  • Select whether to open or save the file.

The data can also be exported from the Dashboard:

  • Select "Roster XLS", "Roster XLS with makeup grades" or "Roster CSV"from the "Download" drop-down menu.

    The full grade history, assignment summaries, and letter grades can also be downloaded from this menu.

This spreadsheet will include student name, username, MIT ID, section, letter grade, cumulative grade, and the grades for each assignment (Actual, Original, Makeup grades are optional)

  • When importing an excel sheet into the gradebook, you must use the same file you exported - you cannot copy and paste the data into another spreadsheet. There is hidden information contained within the exported spreadsheet that is required for the file to be recognized by the gradebook.
 
  • No labels