Upload Assignment Scores to GradeBook

You can upload scores to your GradeBook from a file for assignments your students completed outside of WebAssign.

How-ToInstructor HelpWebAssign

Click Grades › Import Scores to GradeBook.
Select I want to upload a set of assignments from a file.
Click Next.
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.

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:

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.

If needed, add a blank column right of the student information or previous assignment.
Enter information about the assignment in the column, in the rows corresponding to the headers on the left.
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.
Assignment
Available
Whether the assignment scores are shown to students:

Y = yes
N = no
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.


Assignment

Available	Whether the assignment scores are shown to students: Y = yes N = no

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

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 a file containing scores.
Click Next.
Select the file to upload.
1. Click Browse or Choose File, depending on your browser.
2. Navigate to the file you want to upload.
3. Click Open or Choose, depending on your browser.
Select the file format you used.
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.

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.