This refers to Moodle 3.11 from August 2022 onward
There are several help sheets in this series. Start with Grades 1 - Introduction & Overview
Normally you will already have an existing assignment in your module. To upload grades via a spreadsheet, you would normally do so directly into the assignment.
If you need to return marks and feedback for an assignment which is not submitted via Moodle (e.g., a physical presentation or performance) we recommend you create a Moodle Assignment clearly marked that the students do not have to submit.
Even though students do not submit, you retain the facilities to mark and give feedback, including uploading marks via a spreasheet.
Given that you can create an "empty" assignment to receive marks, this is rarely needed. An "empty" assignment where students do not have to submit anything, but simply receive their marks and feedback, is a clearer solution and much easier for students to find.
In rare circumstances, where an assignment does not already exist in the module, you may need to upload a new set of marks into the module gradebook.
For example:
If you want to add a new set of grades to the Grade Book unrelated to any assessment or assignment in Moodle, then follow the following steps:
Step 1. add a new grade item (see Grades 3 - Adding a grade item (or column in the gradebook)
Step 2: Export the grade book as a spreadsheet
Step 3: Edit the spreadsheet to add the grades and save as CSV
Step 4: Import the amended file as CSV
If you wish to edit - outside Moodle - grades for existing assignments and assessments without creating a new column, miss Step 1.
Note: It is not advisable to attempt to upload grades into a Turnitin assignment column - these assignments should be graded from within the Turnitin Grademark tool.
4. The editing page appears for "Export to Excel spreadsheet". Select the item/s you want to include in your download and adjust the format options if necessary.
5. Click the Download button to start export. A pop-up will then appear (depending on your browser).
6. Select the location for the file and click 'Save'. (It will save to your Downloads folder if you do not choose a location.)
You can now open this file in Excel and add the grades to the relevant column
Save the file – but as a csv (Comma Separated Values) not an XLS file
If you are importing grades it is best to start from a spreadsheet exported from the module into which you want to add grades, then it will be in an appropriate format. So Export Grades first and then populate the saved document with the new grade information. Then import as follows:
3. Drag and drop your file or click ‘Choose a file…’ and browse for the document you wish to import, then use the Upload this file to load the data. Once this is done you will be returned to the previous screen. All other fields can be left as the default values, then click the Upload grades button.
4. You will then be shown a preview which you can check to see if the data and grades look as you expect.
5. During Import Preview, in the "Identify user by" section select ‘email address’ in the "Map from" drop-down box and ‘Email address’ from the "Map to" drop-down box. You can also use Student 'ID number' or 'Username' to map the import to the student Moodle account, as long as the two fields are mapped accurately together in both drop downs
You may also need to map some grade items, i.e, link columns in the spreadsheet to grade items in Moodle
6. Click the 'Upload grades button
Note: If you receive an error message stating "The export date is invalid because it is more than a year ago, or in the future, or because the format is invalid" then delete the column titled "Last downloaded from this course" in the csv file and try uploading again.
See also: How to export grades and download assignments from Turnitin
Please contact your local elearning support team.
|
|
|
If you have any comments on how you think this help can be improved then please email Learning-Technologies@nottingham.ac.uk
