Cengage Roster Data

Reference guide for completing the Cengage Roster template.

Each row of data represents the enrollment of one student in a course.
To add students to an existing course, match the existing course name, teacher, and school exactly.
To find course information, modify a row from a previous roster file or see Search NGLSync Courses.

If you are not using an optional data field, leave it blank.

Example Cengage Roster row

The following row of data represents a student enrollment in a third grade science course.

School Name	Teacher First Name	Teacher Middle Name	Teacher Last Name	Teacher Email Address	Teacher Password	Teacher LMS ID	Course Name	Course Grade	Course Start Date	Course End Date	Course SourceId	Copy From Course Key	Student First Name	Student Middle Name	Student Last Name	Student SIS	Student Grade	Student Password	Student Username	Student LMS ID	ISBN	Disable Google Classroom
Cengage Elementary	Sarah		Williams	sarah-williams@cengage-elementary.edu	Password1		Earth Science	3	08/04/2025	05/15/2026			Jason		Washington	111623	3	Orange-17	jason-washington@cengage-elementary		9788999321931

If the following entities are not already in NGLSync, they would be created when the roster is uploaded and processed:

Earth Science course using the product associated with ISBN 9788999321931
Teacher account for Sarah Williams
Student account for Jason Washington

Cengage Roster template fields

Column	Field	Required or optional	Information
A	School Name	Required	The school name must match the name used in NGLSync. To find a school name, see View District Information. Maximum 50 characters
B	Teacher First Name	Required	Maximum 80 characters
C	Teacher Middle Name	Optional	Maximum 80 characters
D	Teacher Last Name	Required	Maximum 80 characters
E	Teacher Email Address	Required	Maximum 225 characters
F	Teacher Password	Required	Enter a unique password for each teacher or a generic password such as `Password1`. Teachers should pick a secure password when they sign in. 6–50 characters Case-sensitive Any characters except: * \ # < >
G	Teacher LMS ID	Optional	Use if required for your district's single sign-on (SSO) integration.
H	Course Name	Required	Course names should remain consistent throughout the term. Uploading a roster file with a different course name will create additional courses for teachers and students. Maximum 255 characters
I	Course Grade	Required	`K–12` For multi-grade courses, enter a default grade and select Ignore Course Grade when uploading the roster file.
J	Course Start Date	Required	`MM/DD/YYYY`
K	Course End Date	Required	`MM/DD/YYYY`
L	Course Source ID	Optional	Enter a course source ID from OneRoster to copy a previous course. For LTI Integration only.
M	Copy From Course Key	Optional	Enter a course key to copy customizations from a previous course. Copied courses do not copy: due dates roster details gradebook settings To find a course key, see Search NGLSync Courses.
N	Student First Name	Required	Maximum 80 characters
O	Student Middle Name	Optional	Maximum 80 characters
P	Student Last Name	Required	Maximum 80 characters No special characters Accepts hyphens
Q	Student SIS	Required	Student ID number Maximum 50 characters
R	Student Grade	Required	`K–12`
S	Student Password	Required	Enter a unique password for each student. Students cannot change their own passwords. 6–50 characters Case-sensitive Any characters except: * \ # < >
T	Student Username	Required	Student usernames must be unique in NGLSync. To ensure uniqueness, consider formatting usernames like email addresses with `student name@school name`. Maximum 100 characters Any characters except: * \ # < > space
U	Student LMS ID	Optional	Use if a student has a different ID number in the LMS. Maximum 50 characters
V	ISBN	Required	13-digit ISBN of the digital product used in the class (not the print textbook ISBN). To find an ISBN, see Find Product ISBN.
W	Disable Google Classroom	Optional	To disable Google Classroom linking, leave blank. To enable Google Classroom linking, enter `false`.