Using the spreadsheet

The spreadsheet should be used to record the marks that you assign your students. It also contains a column to add plain text feedback - this can be in addition to giving feedback to the student in an actual file e.g. an annotated version of their submission.

Important

  1. Marks should be entered as the number of whole points achieved between zero and the maximum points possible (usually 100).
  2. Only the ‘Grade’ and ‘Feedback’ columns should be edited.
  3. You must not add student rows.
  4. Only use the spreadsheet created from the Marks and Feedback tool i.e. do not use a homemade version
  5. All students in the spreadsheet should be marked. If any are left blank, none of the marks will be released.

The spreadsheet will contain the following columns:

  • Student Number (anonymous) or Username (open)
  • First Name (open only)
  • Last Name (open only)
  • Group (groups only)
  • Date Submitted
  • Submission Status
  • Grade
  • Feedback

Take Note

  1. Enter number of whole points achieved
  2. Enter brief feedback
  3. Save file back to existing location retaining the .xls file type (.xlsx files will not be accepted)

example screenshot showing Take Notes A to C above

Back to top