What is a Grading Worksheet?

A grading worksheet is a feedback type you can use to grade and provide feedback on your student submissions while you are offline and not logged into LEO.

The worksheet is a CSV file that you download from LEO, which will open in Microsoft Excel. You are able to enter grades and feedback directly into the spreadsheet while working offline, save to your computer, then re-upload into the LEO environment. The feedback and grades you entered into the grading worksheet will then be added into the Gradebook for your students to access.

Note: a grading worksheet will only work if the Grading Method option in your Assignment settings is set to Simple direct grading. It will not be downloadable if you are using the Marking Guide or Rubric options.

How to enable the Offline Grading Worksheet option

1. Edit the settings of your Assignment activity.
2. Expand the Feedback types settings, then check the box for the Offline grading worksheet option:
   
3. Ensure the Grading method option under the Grade settings is set to Simple direct grading:
   
4. Click the Save and display button to save your changes and open the assignment.

How to download the grading worksheet

1. Click the assignment link in your LEO unit to open it.
2. Click the View all submissions button.
3. From the Grading action dropdown box, choose the Download grading worksheet option:
   
4. Save the file to your computer. You may now open this file and add your grades and feedback into the appropriate cells of the spreadsheet.

Important note: When editing the grading worksheet in Excel, ensure you only add numeric grades in the Grade column and feedback in the Feedback comments column for each assignment. You should not edit any of the existing information in other columns, or the worksheet may not upload correctly. When you save your file, ensure you save it as CSV UTF-8 format.

How to upload the grading worksheet

1. Click the assignment link in your LEO unit to open it.
2. Click the View all submissions button.
3. From the Grading action dropdown box, choose the Upload grading worksheet option
4. Click the Choose a file button, then click the Browse button to select the file from your computer.
5. Click the Upload this file button, then click the Upload grading worksheet button.
6. When you are asked to confirm the changes, review the information presented, then click the Confirm button.

The grades and feedback will now be uploaded.

You can return to your assignment to View all submissions or navigate to the Gradebook using the Grades link in the unit menu to see the uploaded grades and feedback.