Bulk import comments

Steps

Prepare the file for upload

  1. Create a csv file in Excel.

  2. In column A, the first row should be: SIS User ID. The rest of the columns should be the students' NUS-ID e.g. e0123456.
    You can download NUS-IDs of students in your course via NUS Tools.

  3. In column B, the first row should be: Assignment title (Assignment ID).

    1. The assignment ID is the assignment number.

    2. You can see the assignment ID in the assignment URL:

      assignment-ID.png

      In this example, the assignment ID is 3938. So, if the title of the assignment is Essay 1:

    3. The first row of column B should be: Essay 1 (3938)

  4. You may edit this template as needed.

  5. Enter the students' IDs from second row of column A and comments for the respective ID in column B, then save the file.

Upload the file

  1. Go to Grades.

  2. Click Browse for Import comments.

    import-comments-browse.png

     

  3. Select the csv with the comments.

  4. Upload the file. You will be asked to confirm you are uploading x number of new comments.
    If you upload a new set of comments, you will add a new comment to the respective students' submission, not overwrite existing comments.

  1. Click Confirm.

     

  2. If processed successfully, you will see the following message. Check your comments in SpeedGrader.

  3. If not, you will see an error message. Please check the formatting of your spreadsheet.