Exporting grades from GradeMark to Excel

This guide explains how to export a GradeMark summary for a Turnitin assignment.  The Grademark summary contains a list of students along with the title of their submitted work, and the grade awarded in GradeMark.

*NOTE* You can only export GradeMark details for assignments where anonymous marking is NOT active.  If anonymous marking is turned on and the post date has not yet passed then you will be unable to export the GradeMark summary.  Only users who have submitted a file will appear in the export file.

The GradeMark export will contain the following details:

Last Name, First Name, User ID (Username), Turnitin User ID (this is an internal Turnitin ID and can be ignored), Title, Paper ID, Date (& time) Uploaded, Grade (if entered), Overlap, Internet Overlap, PUblications Overlap, Student Papers Overlap.

Access Control Panel

Access Control Panel

1. From your course’s Control Panel, expand the Course Tools section and click on TurnitinUK Assignments.

Locate TurnitinUK Assignment

Locate TurnitinUK Assignment

2.  Click on the name of the Turnitin assignment for which you want to download a Grademark summary.

Click Export

Click Export

3.  Click on the Export button to download an excel file containing the GradeMark summary for the chosen assignment.  The way in which the file is downloaded will depend on the browser you are using.  Remmber that this button will NOT appear if your assignment is using anonymous marking.