Prepare a Roster File

Before you upload a roster file to enroll students in your class, make sure that the roster file includes the correct information specified in a way that can be read by the WebAssign application.

Important: WebAssign will not give, sell, rent, loan, or otherwise disclose your students' personal information, except when we have permission, are required to by law, or have a reasonable need to protect the rights, property, or personal safety of WebAssign, its users, or the public. For more information about WebAssign's privacy policy, see webassign.com/corporate/privacy/.
1. Decide what information you will include in the roster file.
Student Data Required? Description
Name Required Your students' first and last names.

Either use one column to specify the full name, or two columns to specify the first and last name separately.

• look up their username if they forget it
• set up email notifications for assignments
Student ID Recommended Including student IDs when available helps uniquely identify each student in WebAssign.
Username Optional If you know what your students' usernames should be — for example, if you received a list of usernames from your school or if your school uses a standard method for assigning WebAssign usernames — you can specify them in the roster file.

Password Optional If you want to assign different initial passwords for each student, you can specify them in the roster file; alternatively, you can let WebAssign set a unique password for each student.

Otherwise, you can select and set the same initial password for all of your students.

Either use one column to specify the full name, or two columns to specify the first and last name separately.

Full Name fullname, name
First Name first, firstname, fname
Last Name last, lastname, lname
Student ID studentid, studentnumber, studentnum, id#
Note: The order of the columns in your file does not affect the way students are added to your roster.
Student Data Notes
Name

Either use one column to specify the full name, or two columns to specify the first and last name separately.

Enter full names in one of two ways:
• first last — for example: John Smith
• last,first — for example: Smith,John
Student ID
Usernames in WebAssign can contain letters, numbers, and the following characters: underscore (_), hyphen (-), and period (.). Usernames are not case-sensitive, so MaryAllen, maryallen, and mArYaLlEn are all the same username.
Note: All usernames for an institution must be unique.

If a username is already taken, a period and a number are appended to it, for example, allen.mary.2.

Passwords are case-sensitive, so IAmCa3sar is not the same as iamca3sar.

Note:
• If you include usernames or passwords for some students, you must include them for all students.
• The order of the rows in your file does not affect the way students are listed in WebAssign.
4. Save the roster file to a supported file format.
The following file formats are supported:
• tab-delimited text file
• comma-delimited text file
Note: Microsoft Excel files can be saved in different versions of the file format. WebAssign can read a Microsoft Excel file only if it is saved as an Excel 97-2003 Workbook. More information

Daniel White dmwhite@example.org 250708 danielwhite08
John Rodriguez jgrodriguez@example.org 340067 johnrodriguez67
Mary Allen mrallen@example.org 242052 maryallen52
Patricia Garcia psgarcia@example.org 306586 patriciagarcia86
Betty Nguyen bsnguyen@example.org 326098 bettynguyen98

Example Tab-Delimited Roster File

firstname	lastname	email	studentid	username
Daniel	White	dmwhite@example.org	250708	danielwhite08
John	Rodriguez	jgrodriguez@example.org	340067	johnrodriguez67
Mary	Allen	mrallen@example.org	242052	maryallen52
Patricia	Garcia	psgarcia@example.org	306586	patriciagarcia86
Betty	Nguyen	bsnguyen@example.org	326098	bettynguyen98 

Example Comma-Delimited Roster File

"firstname","lastname","email","studentid","username"
"Daniel","White","dmwhite@example.org","250708","danielwhite08"
"John","Rodriguez","jgrodriguez@example.org","340067","johnrodriguez67"
"Mary","Allen","mrallen@example.org","242052","maryallen52"
"Patricia","Garcia","psgarcia@example.org","306586","patriciagarcia86"
"Betty","Nguyen","bsnguyen@example.org","326098","bettynguyen98"