Import Students/Rosters - Template Instructions
Review instructions for using the student roster import template.
This article applies to districts that use Direct Login and Manual-Rostering. Direct Login means that teachers, students, and administrators log in at my.mheducation.com. Manual Rostering means that teachers manually redeem program content and roster their own classes.
If you are unsure which Access Service applies to your district, please see this article for more information.
Import Students/Rosters allows teachers to export and import student and class data within their organization(s).
- If you are using McGraw Hill digital platforms for the first time, download and fill out the blank import template to create student accounts and classes. To prevent the creation of duplicate accounts, always check with your school administrator before importing new students. Class information is not required if you only wish to import student accounts.
- If you have already started using McGraw Hill digital platforms, you should start by exporting existing students. You can also export existing classes.
- If a future-dated Start Date is entered, students will not see their classes until 3 days before the start date entered for the class.
Each template version will contain the following fields:
| Column Name |
Required? |
Description |
| Student GUID |
Required to update an existing student |
The Student GUID is a system-generated ID that is unique to each McGraw Hill user. This ID is generated in the following format: abcd1234-ef56-gh78-ij90-klmnop123456 To update a student or affiliate an existing student to a class, you must provide the Student GUID along with the other user details. If you start with an export of existing students, this field will be populated for you. If you are using the import to create new students, leave this field blank. |
| Student ID |
• Required to create a new student |
Enter an alphanumeric Student ID that is unique to the student. Student IDs must be between 2 to 255 characters in length. Some examples include:
This field is required to ensure that user accounts are not duplicated. If you are not sure of which ID to use, check with your school administrator. *Texas users: It is recommended that the 10-digit Texas Education Agency (TEA) number be assigned to student profiles. |
| First Name |
Required to create a new student |
Enter the student's first name. 255 characters max. Non-acceptable values: Parentheses/Round Brackets ( ) |
| Last Name |
Required to create a new student |
Enter the student's last name. 255 characters max. Non-acceptable values: Parentheses/Round Brackets ( ) |
| Grade Level |
Not required, but recommended for all students |
Enter the student's grade level. Acceptable values are: PK, K, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, Other |
| |
Not required, but recommended for all students |
Enter the student's school-provided email address. The email address must be unique for each student. If possible, we recommend providing an email address for student accounts to avoid duplication. |
| Username |
Not required. The system will auto-generate a username if this field is left blank. |
You can choose custom usernames for students, or you can leave the column blank to have the system auto-generate their usernames. If you decide to set custom usernames, you must meet these requirements:
A recommended best practice is to set students’ email addresses as their usernames. This ensures each student has a consistent and unique username, and it will be easy for them to remember. |
| Password |
Not required. The system will auto-generate a temporary password if this field is left blank. |
If you are using the import to create new student accounts, you can choose a custom, permanent password for the student’s account or leave the password field blank to have the system generate a temporary password for the account. The temporary password will expire after 90 days or when it’s initially used, and the student will be required to set their own permanent custom password once they log in to their account. If you decide to set custom passwords, they must be a minimum of 9 characters and contain the following:
If you use the import to update existing students and leave the password field blank, the students’ current passwords will be unaffected. However, if you do enter a password when updating existing student accounts, it will be set as a temporary password and the system will prompt them to set a new permanent password. Permanent passwords are not stored anywhere in McGraw Hill systems for security reasons. If you wish to retain a record of the permanent passwords you’ve created, you’ll need to save the import file locally to your device. |
| Class GUID |
• Required to update an existing class • Not required if classes are not being updated through the import process. |
The Class GUID is a system-generated ID that is unique to each McGraw Hill class. This ID is generated in the following format: abcd1234-ef56-gh78-ij90-klmnop123456 To update an existing class or affiliate students to your class, you must provide the Class GUID along with the other class details. You can view Class GUIDs by exporting existing classes. If you are using the import to create new classes, leave this field blank. |
| Class ID |
• Required to create a new class |
Enter an alphanumeric Class ID that is unique to the class. Class IDs must be between 2 to 255 characters in length. For example, this could be the class ID generated by your SIS. If rostering to an existing class and the class export does not contain a Class ID, create one. |
| Class Name |
• Required to create a new class • Not required if classes are not being created/updated through the import process. |
Enter a class name; this will be visible to students. If you have multiple sections which use the same product, you can use the Class Name to differentiate between the sections. For example, if Mrs. Smith has 3 English classes, she can identify them as: Smith English Period 1, Smith English Period 2, and Smith English Period 3. Note: Parentheses cannot be used within a class name. |
| Class Grade Level |
• Required to create a new class • Not required if classes are not being created/updated through the import process. |
Enter a grade level for the class. Acceptable values are: PK, K, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, Other If multiple grade levels apply to a class, you can select one of the applicable grade levels, or you can select Other. |
| Class Start Date |
• Required to create a new class • Not required if classes are not being created/updated through the import process. |
Enter the start date of the class in MM/DD/YYYY format Note: In some cases, Excel may auto-abbreviate the date i.e. '03/05/2021' becomes '3/5/21.' This will not interfere with the upload. Future-dated class start dates - students will not see the class until three days before the start date. |
| Class End Date |
• Required to create a new class • Not required if classes are not being created/updated through the import process. |
Enter the end date of the class in MM/DD/YYYY format Note: In some cases, Excel may auto-abbreviate the date i.e. '03/05/2021' becomes '3/5/21.' This will not interfere with the upload. |
| Master Code |
• Required to create a new class • Not required if classes are not being created/updated through the import process. |
Enter the 16-digit Master Code for the product the class will use. You can include or omit the dashes in each code. Assign students the Master Code for the Student Edition. The Student Edition will automatically be assigned to your teacher account. If you have not yet redeemed the corresponding Teacher Edition, then the Teacher Edition will also be assigned to you. Your Organization Administrator can locate the correct master codes and resource codes for you to assign content. These Master Codes can be used to assign both ConnectED and Open Learning products. In addition to entering the Master Code, some content requires a Resource Code to be entered into the import to ensure students are assigned to the proper course (such as ALEKS and Redbird). They will need to be entered into the Master Code column in the following format: XXXX-XXXX-XXXX-XXXX:rrrr (MASTERCODE:resourcecode) |