Upload Files Containing Category Averages

You can upload category average scores from a file to your GradeBook for categories, such as participation, for which no assignments exist.

How-ToInstructor HelpWebAssign

From the GradeBook, click Settings.
In the Category drop-down list, select the category.
If the category you want to use is not listed, first add it to the GradeBook.
Select Upload a file containing averages.
Click Next.
Download a category average template for your class.
Download the template to get a file — prepopulated with your students' information — formatted correctly for you to add category scores.

If you skip this step, you will need to create the file and add your students' information manually.

Under Download Roster:
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 category scores.

Enter each student's category average score in the Average column. You can add scores only for one category at a time.

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.

For example:

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.
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 Next.
Review the scores.
To make changes, you use your browser's Back button.
Click Next.
Click Update GradeBook.