Import Students/Rosters - Template Instructions

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 

• Required to update a student who does not already have a Student ID 

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: 

• Student ID
• SIS ID
• State-issued ID  
• TEA ID*

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 

Email 

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: 

• Minimum of 3 characters
• Alphanumeric
• Accepted special characters: % & ! ^ $ @ ( ) ~ # _
• No spaces

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: 
 

• 1 upper-case letter
• 1 lower-case letter
• 1 number
• It cannot have 5 or more consecutive repeatable case-insensitive characters.
• The password cannot exactly match the username and email address.

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

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 

• Required to update an existing class that does not already have a Class ID. 

• Not required if classes are not being created/updated through the import process.

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 

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 

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 

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 

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 

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)