NGLSync Admin Help
- 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 Courses (NGLSync).
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.
|
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:
To find a course key, see Search Courses (NGLSync). |
N | Student First Name | Required | Maximum 80 characters |
O | Student Middle Name | Optional | Maximum 80 characters |
P | Student Last Name | Required |
|
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.
|
T | Student Username | Required | Student usernames must be unique in NGLSync. To ensure uniqueness, consider formatting usernames like email addresses with
|
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. |