{"id":6576,"date":"2024-02-14T16:24:29","date_gmt":"2024-02-14T15:24:29","guid":{"rendered":"https:\/\/digi-ed.uk\/support\/?post_type=ht_kb&#038;p=6576"},"modified":"2025-05-27T15:54:01","modified_gmt":"2025-05-27T14:54:01","slug":"how-to-upload-exam-grades-using-moodle-assignment","status":"publish","type":"ht_kb","link":"https:\/\/digi-ed.uk\/support\/article\/how-to-upload-exam-grades-using-moodle-assignment\/","title":{"rendered":"How to upload exam grades using Moodle Assignment"},"content":{"rendered":"\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"How to upload exam grades using Moodle Assignment\" width=\"1200\" height=\"675\" src=\"https:\/\/www.youtube.com\/embed\/xEn0-v-91j8?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Overview<\/h2>\n\n\n\n<p>For assessment methods that take place outside of the DLE such as paper-based exams, live presentations, and many others. There are two methods can be used to upload the marks to UNIT-e and S4:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>If you are the Module Leader or Program Administrator for the School\/Faculty Office, you will have the required access, and be able to directly enter the marks to Markbook in UNIT-e. Once the marks have been uploaded to the student record system, they should automatically transfer across S4. Please note, you may need to request an account setup for Markbook which is handled by the Student Record team.<\/li>\n\n\n\n<li>The second method is if you\u2019re the Module Leader, you will be able to create an empty submission point as a placeholder in the DLE (Moodle). This submission point can be used to upload the marks, and transfer them across UNIT-e by using the \u2018Link to UNIT-e\u2019 setting. As it is an empty submission point, its settings would block students from uploading files to this activity. Students could only view the results once you <a href=\"https:\/\/digi-ed.uk\/support\/article\/releasing-grades-and-feedback-in-moodle\/\">released them as per usual<\/a>. For more information about how to set up an empty submission point for this purpose, please visit the <a href=\"https:\/\/digi-ed.uk\/support\/article\/how-to-add-an-empty-submission-point-to-your-moodle-course\/\">following supporting material<\/a>.<\/li>\n<\/ol>\n\n\n\n<p>These methods can be used if you know the student names in advance at the time of receiving the student results. However, there are circumstances (such as paper-based exams) where the student names are not received but you only have the student reference numbers and provided grades. If it is a small cohort (for example standing from 10-20 students), it may be easier to directly enter the marks in UNIT-e (Markbook) and identify the students based on student reference numbers. However, if the cohort stands from more students where identifying students based on reference numbers can be time-consuming, you may be able to use an Excel spreadsheet to automatically cross-reference and match student data (such as student names, e-mail addresses, reference numbers, and grades), upload the results to Moodle and automatically transfer them across UNIT-e and then S4.<\/p>\n\n\n\n<p>In this article, we will show you how to do this.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Export student data from S4<\/h2>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\">Please note, your S4 access may look different, depending on your role at the University. This supporting material was produced for the Module Leaders and covers their usual access to the system.<\/p>\n\n\n\n<p>To export the specific student data (class list) from S4, please follow the steps below.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Please navigate to S4 through the \u2018Tools and Resources\u2019 menu in the DLE (Moodle) and log in with your UoP credentials if needed.<\/li>\n\n\n\n<li>Once you are there, please navigate to the module where the exam grades are need to be uploaded. You can either search for it using the Search box at the top of the page or click on the \u2018My Modules\u2019 menu.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"411\" height=\"77\" src=\"https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/64.png\" alt=\"Screenshot of the search box and \u2018My Modules\u2019 button (highlighted) in S4.\" class=\"wp-image-6577\" srcset=\"https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/64.png 411w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/64-300x56.png 300w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/64-50x9.png 50w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/64-60x11.png 60w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/64-100x19.png 100w\" sizes=\"auto, (max-width: 411px) 100vw, 411px\" \/><\/figure>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>Once you are on the module page, please click on the arrow button pointing down at the top-right corner and select \u2018Enrolment List\u2019 from the drop-down list. Alternatively, you can click the \u2018Class List\u2019 button at the top-right corner which will bring you to the list of students. On that list page, please select \u2018Enrolment Report\u2019.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"602\" height=\"294\" src=\"https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/65.png\" alt=\"Screenshot of the \u2018Class List\u2019 and arrow buttons (highlighted) to navigate to the \u2018Enrolment List\u2019 in S4 under a module page.\" class=\"wp-image-6578\" srcset=\"https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/65.png 602w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/65-300x147.png 300w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/65-50x24.png 50w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/65-60x29.png 60w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/65-100x49.png 100w\" sizes=\"auto, (max-width: 602px) 100vw, 602px\" \/><\/figure>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li>Regardless of which option you selected, you will end up on the \u2018Enrolment Report\u2019 page where you will need to click on the \u2018Export\u2019 button at the top-right corner.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"485\" height=\"50\" src=\"https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/68.png\" alt=\"Screenshot of the \u2018Export\u2019 button (highlighted) under a module class list in S4.\" class=\"wp-image-6579\" srcset=\"https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/68.png 485w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/68-300x31.png 300w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/68-50x5.png 50w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/68-60x6.png 60w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/68-100x10.png 100w\" sizes=\"auto, (max-width: 485px) 100vw, 485px\" \/><\/figure>\n\n\n\n<ol start=\"5\" class=\"wp-block-list\">\n<li>A new window will pop up where you will need to select \u2018Details Only\u2019 from the \u2018Export View\u2019 setting. The \u2018Format\u2019 should be \u2018Comma Delimited .csv\u2019. To finalise your action, please click on the \u2018Export\u2019 button. This will download the needed Excel spreadsheet to your machine which will contain information about your students, such as engagement and attendance status code, student reference number (SRN), name, e-mail address, programme name, enrolment status, and many more.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"629\" height=\"463\" src=\"https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/69-1.png\" alt=\"Screenshot of the export options\/settings (highlighted) under a module class list in S4.\" class=\"wp-image-6581\" srcset=\"https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/69-1.png 629w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/69-1-300x221.png 300w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/69-1-50x37.png 50w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/69-1-60x44.png 60w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/69-1-100x74.png 100w\" sizes=\"auto, (max-width: 629px) 100vw, 629px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-danger\">Please make sure you do not change anything on this spreadsheet as we will need to copy-paste this information into the Excel template you can download below.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Set up an empty submission point in Moodle<\/h2>\n\n\n\n<p>You will need to set up an empty submission point in the DLE (Moodle) as a placeholder where the grades can be uploaded from the Excel template we will create (see instructions below). Once the grades are uploaded, you can then release them to your students as usual (see instructions below).<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\">This submission point can be visible to the students as based on its configuration, we will not allow students to submit files (this can be configured in the settings of the submission point). For more information about the process, please visit the <a href=\"https:\/\/digi-ed.uk\/support\/article\/how-to-add-an-empty-submission-point-to-your-moodle-course\/\">following supporting material<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-danger\">This submission point should not use anonymous submissions, as you will need to see the names of students in advance to upload back the grades to the DLE (Moodle). If you forgot to do this at the stage of setting up the submission point, you will be able to <a href=\"https:\/\/digi-ed.uk\/support\/article\/releasing-grades-and-feedback-in-moodle\/#revealing-student-identities\">reveal the student identities<\/a> but this will need to happen before you upload back the results.<br><br>You will also need to set up a timeframe for the submission point, even if it is fictional. If you do not set up this timeframe then the grades may fail to automatically transfer across UNIT-e and S4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Download the grading worksheet from Moodle<\/h2>\n\n\n\n<p>Once the empty submission point is set up, please download its grading worksheet as usually you would do if you graded the submissions outside of the DLE (Moodle)\/offline using the bulk download\/upload method. For more information about how to download the grading worksheet from a submission point, please visit the <a href=\"https:\/\/digi-ed.uk\/support\/article\/marking-offline-in-moodle-using-bulk-download-and-upload-2\/#download-the-grading-worksheet\">following supporting material<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Fill out the Excel spreadsheet template<\/h2>\n\n\n\n<p>The next stage is to fill out the Excel template with the information we collected previously. This spreadsheet is the location where we will cross-reference and match student information, such as student names, e-mails, reference numbers, and grades. You can download the grade mapping template <a href=\"https:\/\/liveplymouthac.sharepoint.com\/:x:\/s\/DigitalEducation\/ESsc8GnI51lChHgmQuLerFUBiDZv7NPK9HYro8ALWhcpBQ?e=afzsgq\">here<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-danger\">Please note, you will need to download the file to your machine as it is restricted to a \u2018read-only\u2019 view on our SharePoint site, so you will NOT be able to edit it there.<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\">All commands in Excel are set up and therefore, you will not need to do anything manually besides copying the information into the relevant tabs of Excel as shown below. Once it is done, the output will be automatically generated for you which you can upload back to the DLE (Moodle). The Output tab is the grading worksheet\/Excel format Moodle supports when it comes to uploading the grades back to the system. This is the tab we will upload back at the end of the process.<\/p>\n\n\n\n<p>Please open the Excel template. You will see four tabs in it. We explained each below.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"663\" src=\"https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/71-1024x663.png\" alt=\"Roadmap illustration of the Excel spreadsheet template.\" class=\"wp-image-6582\" srcset=\"https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/71-1024x663.png 1024w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/71-300x194.png 300w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/71-768x497.png 768w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/71-50x32.png 50w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/71-60x39.png 60w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/71-100x65.png 100w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/71.png 1265w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">S4 Module Enrolment List<\/h3>\n\n\n\n<p>Please copy all the information from the downloaded\/exported S4 Class List Excel spreadsheet to this tab. You can either manually highlight all the columns and rows by using your mouse and copy-pasting the information to this tab, or you can use the short keys\/commands on your Windows keyboard:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>CTRL and A for highlighting the table in the S4 Class List Excel<\/li>\n\n\n\n<li>CTRL and C for copying information in the S4 Class List Excel<\/li>\n\n\n\n<li>CTRL and V for pasting information to this tab of the Excel template<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"156\" src=\"https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/57-1024x156.png\" alt=\"Screenshot of copying content to the clipboard (highlighted) in Excel.\" class=\"wp-image-6583\" srcset=\"https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/57-1024x156.png 1024w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/57-300x46.png 300w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/57-768x117.png 768w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/57-50x8.png 50w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/57-60x9.png 60w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/57-100x15.png 100w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/57.png 1373w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"148\" src=\"https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/58-1024x148.png\" alt=\"Screenshot of pasting content from the clipboard (highlighted) to a spreadsheet in Excel.\" class=\"wp-image-6584\" srcset=\"https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/58-1024x148.png 1024w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/58-300x43.png 300w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/58-768x111.png 768w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/58-50x7.png 50w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/58-60x9.png 60w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/58-100x14.png 100w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/58.png 1373w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Once you copied the information across, this tab should contain the same information as the exported S4 list. Please do not re-organise or adjust the content.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Student Results<\/h3>\n\n\n\n<p>If you navigate to this tab, you will see that the student reference numbers are automatically filled in based on the information you copied from the exported S4 list to the \u2018S4 Module Enrolment List\u2019 Excel tab. You will only need to manually enter the marks here (from 0 to 100) by manually cross-referencing the results with the student reference numbers.<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\">If a student did not attend the assessment, please leave the field empty. If you add 0, it means they attended it but received 0 as their final mark.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"190\" height=\"208\" src=\"https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/59.png\" alt=\"Screenshot of entering assessment grades (highlighted) for students based on student reference numbers in Excel.\" class=\"wp-image-6585\" srcset=\"https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/59.png 190w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/59-46x50.png 46w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/59-55x60.png 55w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/59-91x100.png 91w\" sizes=\"auto, (max-width: 190px) 100vw, 190px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">DLE Grading Worksheet Template<\/h3>\n\n\n\n<p>Please open the DLE Grading Worksheet that you exported from the DLE (Moodle) and copy all the information from that template to this spreadsheet\u2019s tab. You can either manually highlight all the columns and rows by using your mouse and copy-pasting the information to this tab, or you can use the short keys\/commands on your Windows keyboard:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>CTRL and A for highlighting the table in the S4 Class List Excel<\/li>\n\n\n\n<li>CTRL and C for copying information in the S4 Class List Excel<\/li>\n\n\n\n<li>CTRL and V for pasting information to this tab of the Excel template<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"925\" height=\"208\" src=\"https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/60.png\" alt=\"Screenshot of copying content to the clipboard (highlighted) in Excel.\" class=\"wp-image-6586\" srcset=\"https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/60.png 925w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/60-300x67.png 300w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/60-768x173.png 768w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/60-50x11.png 50w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/60-60x13.png 60w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/60-100x22.png 100w\" sizes=\"auto, (max-width: 925px) 100vw, 925px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"142\" src=\"https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/61-1024x142.png\" alt=\"Screenshot of pasting content from the clipboard (highlighted) to a spreadsheet in Excel.\" class=\"wp-image-6587\" srcset=\"https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/61-1024x142.png 1024w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/61-300x42.png 300w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/61-768x107.png 768w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/61-50x7.png 50w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/61-60x8.png 60w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/61-100x14.png 100w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/61.png 1471w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Once you copied the information across, this tab should contain the same information as the exported DLE (Moodle) grading worksheet. Please do not re-organise or adjust the content.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Output<\/h3>\n\n\n\n<p>If you navigate to this tab, you will see that the output has been generated based on the three tabs we filled in previously. This output follows the format the DLE (Moodle) accepts. Please make sure you save this file on your machine for reference. You can name it as preferred, but please make sure you do not change the file type.<\/p>\n\n\n\n<p>Once that bit is done, you will also need to save the file <strong>again<\/strong> but this time as a \u2018CSV Comma Delimited\u2019 (.csv) as that is the file type Moodle supports. By doing this, you will lose the first three tabs from the Excel spreadsheet, and therefore, only the Output tab will be visible going forward. That is why we recommend saving the file first somewhere else on your machine for reference.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"144\" src=\"https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/62-1024x144.png\" alt=\"Screenshot of the Output tab (highlighted) in Excel.\" class=\"wp-image-6588\" srcset=\"https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/62-1024x144.png 1024w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/62-300x42.png 300w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/62-768x108.png 768w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/62-50x7.png 50w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/62-60x8.png 60w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/62-100x14.png 100w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/62.png 1524w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>To save the file as \u2018CSV Comma Delimited (.csv), please click on the \u2018File\u2019 menu at the top-left corner, select \u2018Save as\u2019 from the left-hand side panel and then select the location where you want to save the file. Please make sure the appropriate file type is selected. You can change the file name or leave it on default.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"367\" src=\"https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/63-1024x367.png\" alt=\"Screenshot of saving the Output tab in Excel as a .csv file (highlighted).\" class=\"wp-image-6589\" srcset=\"https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/63-1024x367.png 1024w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/63-300x107.png 300w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/63-768x275.png 768w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/63-50x18.png 50w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/63-60x21.png 60w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/63-100x36.png 100w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/63.png 1301w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Upload the grading worksheet to Moodle<\/h2>\n\n\n\n<p>Please navigate back to the empty submission point and upload the grading worksheet to the DLE (Moodle) as usually you would do if you graded the submissions outside of the DLE (Moodle)\/offline using the bulk download\/upload method. The grading worksheet is going to be the \u2018Output\u2019 tab that we saved above as a \u2018CSV Comma Delimited (.csv\u2019)\u2019 file type. For more information about how to upload the grading worksheet to a submission point, please visit the <a href=\"https:\/\/digi-ed.uk\/support\/article\/marking-offline-in-moodle-using-bulk-download-and-upload-2\/#upload-the-grading-worksheet\">following supporting material<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Release the grades to students in Moodle<\/h2>\n\n\n\n<p>Once the grades are uploaded back to the DLE (Moodle), you can still moderate them. At this stage, the results are not yet visible to the students. Once you are happy with publishing them, you will need to release them as usual for any submission point. This will ensure your students can access their grades in the DLE (Moodle) and will also automatically transfer them across UNIT-e and then S4. For more information about how to release the grades for this activity, please visit the <a href=\"https:\/\/digi-ed.uk\/support\/article\/releasing-grades-and-feedback-in-moodle\/#releasing-grades-and-feedback\">following supporting material<\/a>.<\/p>\n\n\n\n<p>This is the assessor\/Module Team view.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"218\" src=\"https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/01-70-1024x218.png\" alt=\"Screenshot of the Grading table (highlighted) for an empty submission point in the DLE (Moodle).\" class=\"wp-image-8045\" srcset=\"https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/01-70-1024x218.png 1024w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/01-70-300x64.png 300w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/01-70-768x164.png 768w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/01-70-50x11.png 50w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/01-70-60x13.png 60w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/01-70-100x21.png 100w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/01-70.png 1305w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>This is the student&#8217;s view.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"725\" height=\"558\" src=\"https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/01-71.png\" alt=\"Screenshot of the Submission Status page (highlighted) for an empty submission point in the DLE (Moodle).\" class=\"wp-image-8046\" srcset=\"https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/01-71.png 725w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/01-71-300x231.png 300w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/01-71-50x38.png 50w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/01-71-60x46.png 60w, https:\/\/digi-ed.uk\/support\/wp-content\/uploads\/2024\/02\/01-71-100x77.png 100w\" sizes=\"auto, (max-width: 725px) 100vw, 725px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>In this article, we will show you how to upload exam grades using the \u2018Assignment\u2019 activity in Moodle.<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[30],"ht-kb-tag":[108],"class_list":["post-6576","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-online-submission","ht_kb_tag-assignment"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/digi-ed.uk\/support\/wp-json\/wp\/v2\/ht-kb\/6576","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/digi-ed.uk\/support\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/digi-ed.uk\/support\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/digi-ed.uk\/support\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/digi-ed.uk\/support\/wp-json\/wp\/v2\/comments?post=6576"}],"version-history":[{"count":3,"href":"https:\/\/digi-ed.uk\/support\/wp-json\/wp\/v2\/ht-kb\/6576\/revisions"}],"predecessor-version":[{"id":8048,"href":"https:\/\/digi-ed.uk\/support\/wp-json\/wp\/v2\/ht-kb\/6576\/revisions\/8048"}],"wp:attachment":[{"href":"https:\/\/digi-ed.uk\/support\/wp-json\/wp\/v2\/media?parent=6576"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/digi-ed.uk\/support\/wp-json\/wp\/v2\/ht-kb-category?post=6576"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/digi-ed.uk\/support\/wp-json\/wp\/v2\/ht-kb-tag?post=6576"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}