WebAssign Instructor Help
- Sign In / Account
Roster columns for U.S. higher education institutions
Alternatively, see Roster Columns for Institutions Other Than U.S. Higher Education.
Your roster file must include the following columns with the indicated column headings specified in the first row:
Heading | Description |
|---|---|
Required: Student's email address is used as the student's username. | |
firstname | Required: Student's given name, up to 32 characters. |
lastname | Required: Student's surname, up to 32 characters. |
password | Required: Enter initial passwords for students with no preexisting account. Must be 6-17 characters and include at least one number and one capital letter. |
student id | Optional: Student's institutional ID, up to 20 characters. |
- Column headings are not case sensitive.
- Columns can be in any order.
- Columns with other column headings are ignored.
- Students can be listed in any order.
- Student data must not contain empty rows.
- Student data is case sensitive.
Valid roster file formats
Your roster file must be saved in one of the following formats:
- .xlsx Excel spreadsheet
- .xls Excel 1997-2004 spreadsheet
- .ods OpenDocument spreadsheet
- .csv comma-delimited text file
- .tsv tab-delimited text file
Example Roster Spreadsheet
firstname | lastname | password | student id | |
|---|---|---|---|---|
dmwhite@example.org | Daniel | White | dW250708 | 250708 |
jgrodriguez@example.org | John | Rodriguez | jR340067 | 340067 |
mrallen@example.org | Mary | Allen | mA242052 | 242052 |
psgarcia@example.org | Patricia | Garcia | pG306586 | 306586 |
bsnguyen@example.org | Betty | Nguyen | bN326098 | 326098 |
Example Comma-Delimited Roster File
Example Tab-Delimited Roster File