Copy and Paste Assignment Scores to GradeBook

You can copy and paste scores to your GradeBook for assignments your students completed outside of WebAssign.

  1. Click Grades > Add Scores to GradeBook.
  2. Select I want to upload a set of assignments from a file.
  3. Click Next.
  4. Download an assignment scores template for your class.

    Download the template to get a file — prepopulated with your students' information — formatted correctly for you to add assignment scores.

    Note: If you skip this step, you will need to create the file and add your students' information manually.

    Under Download Template:

    1. Select fullname or student number if you want to include this information.
    2. Select the file extension to use for the downloaded file.
    3. Click Download.

      The file is downloaded as a tab-separated text file with the filename extension you selected.

    For example:

    Assignment	Fullname	Student Number
    Category
    Description
    Points
    Due
    Available
    maryallen52@webassign	Allen, Mary	242052
    patriciagarcia86@webassign	Garcia, Patricia	306586
    bettynguyen98@webassign	Nguyen, Betty	326098
    johnrodriguez67@webassign	Rodriguez, John	340067
    danielwhite08@webassign	White, Daniel	250708
  5. Open the template file in your spreadsheet editor — both Excel and Google Sheets work well — and add assignment data.

    You can add one or more assignments. Each assignment's data is in its own column in the table.

    1. If needed, add a blank column right of the student information or previous assignment.
    2. Enter information about the assignment in the column, in the rows corresponding to the headers on the left.
      Item Description
      Assignment How the assignment will be listed.
      Category Assignment category for GradeBook calculations.
      Description Optional description.
      Points How many points the assignment is worth.
      Due Assignment due date.
      Available Whether the assignment scores are shown to students:
      • Y = yes
      • N = no
    3. Enter each student's score in the student's row in the assignment column.

      Scores must be numeric and specified as points out of the total point value.

      Letter grades and missing scores are displayed as NA in WebAssign and are counted as 0 points.

    For example:

    Assignment Fullname Student Number Project 1 Project 2
    Category Research Research
    Description
    Points 50 50
    Due 2/1/2017 3/1/2017
    Available Y Y
    maryallen52@webassign Allen, Mary 242052 42 44
    patriciagarcia86@webassign Garcia, Patricia 306586 38 39
    bettynguyen98@webassign Nguyen, Betty 326098 48 47
    johnrodriguez67@webassign Rodriguez, John 340067 46 39
    danielwhite08@webassign White, Daniel 250708 36 42
  6. Select all the spreadsheet cells with data (including the student usernames) and copy your selection.
  7. In WebAssign, for Upload Method, select Copy and paste scores from a file on your computer.
  8. Click Next.
  9. Paste the copied data into the box.

    Your data should be pasted as tab-delimited text.

    If your data are not pasted correctly, save your spreadsheet as a tab-delimited text file, open the file with a text editor, and copy from that.

  10. Click Review.

    The assignments and scores you provided are listed.

    Values that can't be used, like invalid dates, are indicated so you can correct them.

  11. Click Save.

If you try to add an assignment with the same name as another assignment already scheduled or entered for the section, you are prompted to rename the new assignment or update the existing assignment information and scores. You can also create the new assignment with the same name as the existing assignment if needed.