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.
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.
Note If you skip this step, you will need to create the file and add your students' information
manually.
Under Download Template:
Select fullname or student
number if you want to include this information.
Select the file extension to use for the downloaded file.
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
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
To upload your GradeBook:
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.
In WebAssign,
for Upload Method, select Upload the entire file
containing your GradeBook.
Click Next.
Click Browse or
Choose File, depending on your
browser.
Navigate to the file you want to
upload.
Click Open or
Choose, depending on your
browser.
Select the file format you used.
Click Next.
To copy and paste your GradeBook:
Select all the spreadsheet cells with data (including the
student usernames) and copy your selection.
In WebAssign,
for Upload Method, select Copy and paste your GradeBook
from a file on your computer.
Click Next.
Paste the copied data into the box.
Your data should be pasted as tab-delimited text.
Click Next.
Optional: 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: