Upload a GradeBook Spreadsheet

If you use a scoring rubric that you can't implement in the WebAssign GradeBook, you can use your own spreadsheet to perform GradeBook calculations and then upload or copy and paste it to display to your students.

Important If you use your own spreadsheet, it is display-only and not used for any calculations in WebAssign:
  • it can't be updated automatically from your students' work in WebAssign
  • you need to perform all the calculations yourself
  • you need to assign letter or pass/fail grades yourself
  • your students can't see how your score or grade calculations were performed
  • your students can't see your grading scale

If you can't implement your scoring rubric in the WebAssign GradeBook, consider contacting Customer Support. You can submit a request that we consider supporting your rubric the future.

  1. From the menu, click Grades > GradeBook.

    If needed, select a class section.

  2. Click Wizard.
  3. Select Use my own spreadsheet as a GradeBook and click Next.
  4. Download a GradeBook template for your class.

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

    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 either an Excel spreadsheet or a tab-separated text file.

    For example:

    Name		Enter Your Assignment Here	
    Due		Today's Date	
    Total		100	
    maryallen52@webassign	Allen, Mary	
    patriciagarcia86@webassign	Garcia, Patricia	
    bettynguyen98@webassign	Nguyen, Betty	
    johnrodriguez67@webassign	Rodriguez, John	
    danielwhite08@webassign	White, Daniel	
  5. Open the template file in your spreadsheet editor — both Excel and Google Sheets work well — and add your GradeBook data.
    Note

    Your assignment information can only use the following characters:

    a b c d e f g h i j k l m n o p q r s t u v w x y z
    A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
    0 1 2 3 4 5 6 7 8 9
    SPACE ! " # $ % & ' ( ) * + , - . / : ; < = > ? @ [ \ ] ^ _ ` { | } ~

    If you enter a disallowed character, scores might not upload correctly.

    The first column of your spreadsheet contains row headings for your GradeBook data, and must include (in order):

    Name
    Row header for the GradeBook column names.
    any of the optional keywords Due, Total, Average, Minimum, Maximum, or StDev
    Row headers for data you can provide for some or all GradeBook columns.
    student usernames
    Each student is identified by their WebAssign username.

    Each column after the first one represents an assignment score or calculation — for example, category totals, final scores, and letter grades — to be displayed.

    For example, in the following GradeBook, students' final scores equal the sum of their highest project score and the average of the other two project scores:

    Name Project 1 Project 2 Project 3 Final Grade
    Due February 10 March 17 April 21
    Total 100 100 100 200
    maryallen52@webassign 74 72 83 156 C
    patriciagarcia86@webassign 84 88 87 173.5 B
    bettynguyen98@webassign 88 76 94 176 B
    johnrodriguez67@webassign 78 71 71 149 D
    danielwhite08@webassign 80 76 97 175 B
  6. To upload your GradeBook:
    1. Save the spreadsheet to your computer as either a comma- or tab-delimited text file.

      Older versions of the Excel file format also work, but the text formats are more universally supported and work consistently.

    2. In WebAssign, for Upload Method, select Upload the entire file containing your GradeBook.
    3. Click Next.
    4. Click Browse or Choose File, depending on your browser.
    5. Navigate to the file you want to upload.
    6. Click Open or Choose, depending on your browser.
    7. Select the file format you used.
    8. Click Next.
  7. To copy and paste your GradeBook:
    1. Select all the spreadsheet cells with data (including the student usernames) and copy your selection.
    2. In WebAssign, for Upload Method, select Copy and paste your GradeBook from a file on your computer.
    3. Click Next.
    4. Paste the copied data into the box.

      Your data should be pasted as tab-delimited text.

    5. Click Next.
  8. Optional: Select Post to Students.
  9. Click Save.

Your GradeBook shows a table of the data you added.

If posted to students, each student sees their own data from the table along with data for any of the keywords you provided. For example:

Instructor Posted Grades

Name Score Max Possible Due
Project 1 80 100 February 10
Project 2 76 100 March 17
Project 3 97 100 April 21
Final 175 200
Grade B

After you upload your GradeBook, you can:

To do this Do this
Edit a GradeBook cell
  1. Click the cell.
  2. Change its value.
  3. Click Save.
Edit all GradeBook cells for a student
  1. Click the student's name.
  2. Edit the cells.
  3. Click Save.
Add a column or row
  1. Click Add Column or Add Row.
  2. Edit the new cells.
  3. Click Save.