Menu

E-Learning Unit

menu

Using the offline grading worksheet

Print Friendly, PDF & Email

For: StaffApplication: Grading & Feedback , QMplusTagged: assignment , feedback , grades

The offline grading worksheet allows teachers to enter grades and general feedback comments for student assignments in a spreadsheet format which can then be uploaded to QMplus.

Please note that the offline grading worksheet cannot be used to upload information for advanced grading methods such as rubrics and marking guides.

Enable the offline grading worksheet feature

To be able to use this function in QMplus, the ‘Offline Grading Worksheet’ has to be enabled for the assignment. To check this, go to the assignment administration:

qmplus005-image1

 

Under ‘Feedback types’, tick ‘Offline Grading Worksheet’ if it’s not already chosen. Remember to click ‘save changes’ if you have made any changes.

qmplus005-image2

 

Download the offline grading worksheet

Go to the assignment and click on the the ‘View/grade all submissions’ link, this will bring up the grading table.

qmplus005-image3

The grading table contains columns of information about the student, the status of their submission, a link to grade their submission, a link to each submission and feedback comments and files (if enabled). Use the scroll bar to navigate within the table.

To download the grading sheet from QMplus, choose ‘Download grading worksheet’ from the drop-down menu at the top of the grading table.

qmplus005-image4

Open the downloaded csv. file and you should be able to see a list of all the students. Input the marks for them and add comments if needed. Save the file when finished.

qmplus005-image6

Uploading the grading worksheet

Go back to the grading page and choose ‘upload grading worksheet’ from the drop-down menu. In the uploading page, choose the csv. file you have just edited and saved, then click ‘upload grading worksheet’.

qmplus005-image5

 

The system will ask you to confirm all the marks, make sure all grades are displayed correctly and select ‘confirm’.

qmplus005-image7

You will then be able to see that the grades can comments have been uploaded and the grading table now shows the student’s grades.

qmplus005-image8

 

Next steps

This guide covers how to mark a QMplus assignment, you might be interested in the following guides on marking using other tools:

Did this answer your query? If not, you can raise a ticket on the online Helpdesk or email: its-helpdesk@qmul.ac.uk . Alternatively you can also request a particular guide or highlight an error in this guide using our guides request tracker.

Produced by the the E-Learning Unit at Queen Mary University of London.
QP026-image015

Return to top