{"id":1281,"date":"2018-03-18T21:58:05","date_gmt":"2018-03-18T21:58:05","guid":{"rendered":"http:\/\/moodleuserguides.org\/?post_type=kbe_knowledgebase&p=1037"},"modified":"2018-03-18T21:58:05","modified_gmt":"2018-03-18T21:58:05","slug":"use-an-offline-grading-worksheet","status":"publish","type":"bwl_kb","link":"https:\/\/support.epembelajaran.umt.edu.my\/knowledgebase\/elearning\/grades-feedback\/use-an-offline-grading-worksheet\/","title":{"rendered":"Use an Offline Grading Worksheet"},"content":{"rendered":"

Instructors can download a grading sheet to work with offline. After filling in grades and feedback, the file can be uploaded to Moodle to automatically update grades and feedback for each student in the original assignment and gradebook.<\/p>\n

\n
\n

this text will be removed<\/p>\n

\"\"<\/p>\n

Tips<\/h3>\n

If you don't see an option to upload files, check your assignment settings to make sure Grading worksheet<\/strong> is checked in the \"Feedback\" area. Speak to your school Moodle administrator if this option is unavailable or is not enabled on new assignments by default.\n<\/div>\n

\n

this text will be removed<\/p>\n<\/div>\n<\/div>\n

\n

\n
Part
1<\/span><\/div>\n

Download the grading worksheet<\/span><\/h2>\n

    \n
  1. Open the assignment you want to get submissions from.<\/li>\n
  2. Click View All Submissions<\/strong>.<\/li>\n

    \"\"<\/a><\/p>\n

  3. Select Download grading worksheet<\/strong> from the \"Grading actions\" drop-down menu.<\/li>\n

    \"\"<\/a><\/p>\n

  4. Depending on your browser, you will be prompted to choose a location on your computer to save a .csv<\/strong> file, or the file will begin downloading to your default downloads location.<\/li>\n<\/ol>\n<\/div>\n
    \n

    \n
    Part
    2<\/span><\/div>\n

    Grade submissions<\/span><\/h2>\n

      \n
    1. Locate and open the grading worksheet you downloaded (typically you want to open this file in a spreadsheet application like Excel).<\/li>\n
    2. For each student, fill in the \"Grade\" and \"Feedback Comments\" columns. Make sure to save your changes to the original CSV file (do not \"Save As\" or change the file format).<\/li>\n

      \"\"<\/a>\n\t\t<\/ol>\n<\/div>\n

      \n

      \n
      Part
      3<\/span><\/div>\n

      Upload the grading worksheet<\/span><\/h2>\n

        \n
      1. Return to the Moodle assignment's View all submissions<\/strong> page.<\/li>\n
      2. Select Upload grading sheet<\/strong> from the \"Grading Actions\" drop-down.<\/li>\n

        \"\"<\/a><\/p>\n

      3. Click Choose a file...<\/strong> to open the file picker.<\/li>\n
      4. In the \"File picker\" window, locate your CSV file.<\/li>\n
      5. Click Upload grading worksheet<\/strong>.<\/li>\n

        \"\"\/<\/a><\/p>\n

      6. Review and click Confirm<\/strong>.<\/li>\n

        \"\"<\/a>\n\t\t<\/ol>\n<\/div>\n

        FAQs<\/h2>\n

        No FAQs yet. Use the comment field below to ask questions.<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"template":"","bkb_category":[16],"bkb_tags":[],"class_list":["post-1281","bwl_kb","type-bwl_kb","status-publish","hentry","bkb_category-grades-feedback"],"_links":{"self":[{"href":"https:\/\/support.epembelajaran.umt.edu.my\/knowledgebase\/wp-json\/wp\/v2\/bwl_kb\/1281","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.epembelajaran.umt.edu.my\/knowledgebase\/wp-json\/wp\/v2\/bwl_kb"}],"about":[{"href":"https:\/\/support.epembelajaran.umt.edu.my\/knowledgebase\/wp-json\/wp\/v2\/types\/bwl_kb"}],"author":[{"embeddable":true,"href":"https:\/\/support.epembelajaran.umt.edu.my\/knowledgebase\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":0,"href":"https:\/\/support.epembelajaran.umt.edu.my\/knowledgebase\/wp-json\/wp\/v2\/bwl_kb\/1281\/revisions"}],"wp:attachment":[{"href":"https:\/\/support.epembelajaran.umt.edu.my\/knowledgebase\/wp-json\/wp\/v2\/media?parent=1281"}],"wp:term":[{"taxonomy":"bkb_category","embeddable":true,"href":"https:\/\/support.epembelajaran.umt.edu.my\/knowledgebase\/wp-json\/wp\/v2\/bkb_category?post=1281"},{"taxonomy":"bkb_tags","embeddable":true,"href":"https:\/\/support.epembelajaran.umt.edu.my\/knowledgebase\/wp-json\/wp\/v2\/bkb_tags?post=1281"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}