15-01-03.Import to Grades

You can upload data managed by other than Waseda Moodle (e.g. classroom quiz results) in a batch to Grades.
There are two ways to upload.

Copy and paste cells in Excel
Upload using CSV file

The following is an example of uploading the grades of five students (Student Taro 1 ~ Student Taro 5) in the “Classroom quiz results” item.


To see how to add grade item “Classroom quiz results,” refer to following.

Refer to:
15-01-02.Setting of Grades

 

Copy and paste cells in Excel
    1. Choose “Paste from spreadsheet.”
    2. Prepare the data to be uploaded to the Excel file on your PC.
memo
The prepared Excel can be any format. Only the student ID number is required as it identifies the student at the time of upload.
  1. Copy the student ID and grades columns including the title.
  2. Paste to [Data] in the “Spreadsheet” on Waseda Moodle.
    Leave the other items at their defaults and click [Upload grades].

  3. Set “Identify user by” and “Grade item mappings.”

    Identify user by

    This is a setting to uniquely identify students when uploading grades.
    Specify “User ID” for Map from (item prepared in Excel).
    Specify “ID number” for Map to.

    Grade item mappings

    Set the information you actually want to upload.
    Choose “Ignore” for the “User ID” as it is only for identification and not needed to upload.
    Specify to which item of the grade to upload the information of “quiz result.” In this case, “Classroom quiz results” is specified.

    memo
    You can upload two types, grades and feedback. You can upload both items at the same time


    After setting, click [Upload grades].

  4. Upload is now completed.
  5. If you see “Grader report,” the grade you uploaded in “Classroom quiz results” is displayed.

Upload using CSB file
  1. Choose “CSV file.”
  2. Prepare the data to upload in CSV file in your own PC.

    memo
    Only the student ID number is required as it identifies the student at the time of upload.
  3. Drag and Drop the CSV file to [File] in “CSV file” of Waseda Moodle (or specify the file from “Select file”).
    Leave the other items at their defaults and click [Upload grades]

  4. Set “Identify user by” and “Grade item mappings.

    Identify user by

    This is a setting to uniquely identify students when uploading grades.
    Specify “User ID” for Map from (item prepared in Excel).
    Specify “ID number” for Map to.

    Grade item mappings

    Set the information you actually want to upload.
    Choose “Ignore” for the “User ID” as it is only for identification and not needed to upload.
    Specify to which item of the grade to upload the information of “quiz result.” In this case, “Classroom quiz results” is specified.

    memo
    You can upload two types, grades and feedback. You can upload both items at the same time.


    After setting, click [Upload grades].

  5. Upload is now completed.
  6. If you see “Grader report,” the grade you uploaded in “Classroom quiz results” is displayed.

    memo
    Click the icon of “Classroom quiz results” to switch to “Single view,” and you can check the contentof uploaded feedback.

Last Updated on 2021-03-31

Did it help you?

Good  No good

0 out of 0 people said that this help was helpful.

ページの先頭へ