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.

How-ToInstructor HelpWebAssign

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.

From the menu, click Grades › GradeBook.
If needed, select a class section.
Click Wizard.
Select Use my own spreadsheet as a GradeBook and click Next.
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.

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:

Open the template file in your spreadsheet editor — both Excel and Google Sheets work well — and add your GradeBook data.

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

To upload your GradeBook:
1. 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 Browse or Choose File, depending on your browser.
To copy and paste your GradeBook:
1. In WebAssign, for Upload Method, select Copy and paste your GradeBook from a file on your computer.
2. Your data should be pasted as tab-delimited text.
Select Post to Students.
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	Click the cell. Change its value. Click Save.
Edit all GradeBook cells for a student	Click the student's name. Edit the cells. Click Save.
Add a column or row	Click Add Column or Add Row. Edit the new cells. Click Save.