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.
- 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
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.
The file is downloaded as either an Excel spreadsheet or a tab-separated text file.
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.
The first column of your spreadsheet contains row headings for your GradeBook data, and must include (in order):
- 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.
- Save the spreadsheet to your computer as either a comma- or tab-delimited text file.
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:
Instructor Posted Grades
|Project 1||80||100||February 10|
|Project 2||76||100||March 17|
|Project 3||97||100||April 21|
After you upload your GradeBook, you can:
|To do this||Do this|
|Edit a GradeBook cell||
|Edit all GradeBook cells for a student||
|Add a column or row||