{"id":5442,"date":"2023-02-21T15:55:15","date_gmt":"2023-02-21T06:55:15","guid":{"rendered":"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/?p=5442"},"modified":"2024-02-06T16:26:32","modified_gmt":"2024-02-06T07:26:32","slug":"15-01-03-import-to-grades","status":"publish","type":"post","link":"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/2023\/02\/21\/15-01-03-import-to-grades\/","title":{"rendered":"15-01-03.Import to Grades"},"content":{"rendered":"

You can upload data managed by other than Waseda Moodle (e.g. classroom quiz results) in a batch to Grades.
\nThere are two ways to upload.<\/h3>\n

\u30fbCopy and paste cells in Excel<\/a>
\n\u30fbUpload using CSV file<\/a><\/p>\n

The following is an example of uploading the grades of five students (Student Taro 1 ~ Student Taro 5) in the \u201cClassroom quiz results\u201d item.<\/h4>\n

\"\"<\/a>
\nTo see how to add grade item \u201cClassroom quiz results,\u201d refer to following.<\/p>\n

\n
Refer to:<\/dt>\n
\u21d215-01-02.Setting of Grades<\/a><\/dd>\n<\/dl>\n
\n
memo<\/dt>\n
Grading of assignments should be done on the assignment content, see below.
\n\u21d209-01-10.How to Use the Offline Grading Worksheet | Waseda Moodle User Manual<\/a><\/dd>\n<\/dl>\n

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

 <\/p>\n

Copy and paste cells in Excel<\/h5>\n
    \n
  1. \n
      \n
    1. Choose \u201cPaste from spreadsheet.\u201d
      \n      \"\"<\/a><\/li>\n
    2. Prepare the data to be uploaded to the Excel file on your PC.
      \n\"\"<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
      \n
      memo<\/dt>\n
      The prepared Excel can be any format. Only the student ID number is required as it identifies the student at the time of upload.<\/dd>\n<\/dl>\n
        \n
      1. Copy the student ID and grades columns including the title.
        \n\"\"<\/li>\n
      2. \n
      3. Set \u201cIdentify user by\u201d and \u201cGrade item mappings.\u201d
        \n

        Identify user by<\/h4>\n

        This is a setting to uniquely identify students when uploading grades.
        \nSpecify \u201cUser ID\u201d for Map from (item prepared in Excel).
        \nSpecify \u201cID number\u201d for Map to.<\/p>\n

        Grade item mappings<\/h4>\n

        Set the information you actually want to upload.
        \nChoose \u201cIgnore\u201d for the \u201cUser ID\u201d as it is only for identification and not needed to upload.
        \nSpecify to which item of the grade to upload the information of \u201cquiz result.\u201d In this case, \u201cClassroom quiz results\u201d is specified.<\/p>\n

        \n
        memo<\/dt>\n
        You can upload two types, grades and feedback. You can upload both items at the same time<\/dd>\n<\/dl>\n

        \"\"<\/a>
        \nAfter setting, click [Upload grades].<\/li>\n

      4. Upload is now completed.
        \n        \"\"<\/a><\/li>\n
      5. If you see \u201cGrader report,\u201d the grade you uploaded in \u201cClassroom quiz results\u201d is displayed.
        \n        \"\"<\/a><\/li>\n<\/ol>\n

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

        Upload using CSB file<\/h5>\n
          \n
        1. Choose \u201cCSV file.\u201d
          \n          \"\"<\/a><\/li>\n
        2. Prepare the data to upload in CSV file in your own PC.
          \n\"\"<\/p>\n
          \n
          memo<\/dt>\n
          Only the student ID number is required as it identifies the student at the time of upload.<\/dd>\n<\/dl>\n<\/li>\n
        3. \n
          Drag and Drop the CSV file to [File] in \u201cCSV file\u201d of Waseda Moodle (or specify the file from \u201cSelect file\u201d).<\/div>\n
          Leave the other items at their defaults and click [Upload grades]<\/div>\n

          \"\"<\/li>\n

        4. Set \u201cIdentify user by\u201d and \u201cGrade item mappings.
          \n

          Identify user by<\/h4>\n

          This is a setting to uniquely identify students when uploading grades.
          \nSpecify \u201cUser ID\u201d for Map from (item prepared in Excel).
          \nSpecify \u201cID number\u201d for Map to.<\/p>\n

          Grade item mappings<\/h4>\n

          Set the information you actually want to upload.
          \nChoose \u201cIgnore\u201d for the \u201cUser ID\u201d as it is only for identification and not needed to upload.
          \nSpecify to which item of the grade to upload the information of \u201cquiz result.\u201d In this case, \u201cClassroom quiz results\u201d is specified.<\/p>\n

          \n
          memo<\/dt>\n
          You can upload two types, grades and feedback. You can upload both items at the same time.<\/dd>\n<\/dl>\n

          \"\"<\/a>
          \nAfter setting, click [Upload grades].<\/li>\n

        5. Upload is now completed.\"\"<\/a><\/li>\n
        6. If you see \u201cGrader report,\u201d the grade you uploaded in \u201cClassroom quiz results\u201d is displayed.
          \n          \"\"<\/a><\/p>\n
          \n
          memo<\/dt>\n
          Click the\"\" icon of \u201cClassroom quiz results\u201d to switch to \u201cSingle view,\u201d and you can check the contentof uploaded feedback.<\/dd>\n<\/dl>\n

          \"\"<\/a><\/li>\n<\/ol>\n\n

          \r\n
          \r\nDid it help you?<\/B><\/span>\r\n

          <\/i>Good<\/a>\u3000\u3000<\/i>No good<\/a>\r\n

          0 out of 0 people said that this help was helpful.<\/span>\r\n<\/center>\r\n<\/div>\n\n<\/div>\n","protected":false},"excerpt":{"rendered":"

          You can upload data managed by other than Waseda Moodle (e.g. classroom quiz results) in a batch to Grades. Th […]<\/p>\n","protected":false},"author":50,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"no","_lmt_disable":"no","footnotes":""},"categories":[5],"tags":[],"class_list":["post-5442","post","type-post","status-publish","format-standard","hentry","category-chapter15"],"modified_by":"umezawa","_links":{"self":[{"href":"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-json\/wp\/v2\/posts\/5442","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-json\/wp\/v2\/users\/50"}],"replies":[{"embeddable":true,"href":"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-json\/wp\/v2\/comments?post=5442"}],"version-history":[{"count":4,"href":"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-json\/wp\/v2\/posts\/5442\/revisions"}],"predecessor-version":[{"id":6199,"href":"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-json\/wp\/v2\/posts\/5442\/revisions\/6199"}],"wp:attachment":[{"href":"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-json\/wp\/v2\/media?parent=5442"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-json\/wp\/v2\/categories?post=5442"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-json\/wp\/v2\/tags?post=5442"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}