Uploading marks to Myplace with the grading worksheet

Uploading marks to Myplace with the grading worksheet

This page describes how to use the grading worksheet to collect and submit marking done away from Myplace.



Simple Direct Grading Only

This will only work if you are using Simple Direct Grading and not an advanced grading method such as marking guide or rubric!

Download the grading worksheet


Step 1 - Check/update "Feedback Types"

Navigate to the assignment and click "Settings".

Click on "Feedback types" and ensure "Offline grading worksheet" is ticked.



Step 2 - Select the grading action

Click the "Submissions" heading within the assignment.

Click "Actions" and select "Download grading worksheet" from the drop-down menu.

Save the worksheet somewhere convenient on your computer.

Working with Excel


Step 1 - Open the file and fill in grades and feedback

Double click the file from where you have saved it on your computer. For almost all work computers it will open in excel. If you do not have excel there are free programs available online to view and edit csv files.

Input the students grades. Here the assignment is anonymous - if it is not, you will see the student names, email and registration as well.

You can input feedback comments here too, if they are enabled for this assignment.

Step 2 - Save the file as a comma separated value (csv) file

Take care when saving the file - excel wants to add formatting to it that we don't need. 

Click "Save as" and ensure you select "CSV UTF-8 (Comma delimited) (*.csv)" from the drop down. 

Drop down the Save as type menu and select CSV (Comma delimited).

Overwrite the CSV you downloaded with the same filename.

Excel will warn you that you are losing some advanced spreadsheet features. Click Yes.



You can now close excel (you don't have to save again).

Returning your grades to the assignment


Step 1 - Select the grading action

Back on the assignment page in Myplace, drop down the menu and select Upload grading worksheet.

Step 2 - Drag the worksheet into the box

You can either click and navigate to the marked CSV file, or simply drag it into the box.

Click Upload grading worksheet when the box contains the filename of your CSV file.

Step 3 - Confirm changes

Myplace will ask you to confirm the changes the worksheet contains. Click Confirm if this is all correct.

You will see a final confirmation page - click continue and you are finished.

Step 4 - Check on the assignment page

The grades can now be seen on the assignment page, and corrected or supplemented further if required.


Related Articles