Skip to main content

How Administrators Create New Classes Using the Import Users/Rosters Process

Discover how to create new classes using Import Users/Rosters bulk upload tools.

Tags

Direct Login and Manual Rostering

Single Sign-On (SSO) and Manual Rostering

This article applies to Manual Rostering districts. Manual Rostering means that teachers manually redeem program content and roster their own classes.

 

SSO applies to districts that use an SSO portal, district website, or Learning Management System (LMS) to access McGraw Hill digital programs, and Direct Login means that teachers, students, and administrators log in at my.mheducation.com.

Not sure which Access Service your district uses? Click here to learn more about the four Access Services that we support.

For a full page view of the demo, click here.

For a Spanish version of the demo, click here.

 

Article Contents

Download Template

Teachers with an Existing Account

Teachers Do Not Yet Have an Account

Upload Template

 

You have the option to create new classes without rostering students to those classes, allowing teachers to manually roster the students. However, to do so you have to roster a teacher to each class.

 

Download Template

1. From the Import Users/Rosters page, download the desired file format for the Blank Template.

2. Follow the steps to roster teachers for the new classes: 

 

Teachers with an Existing Account

A. From the Import Users/Rosters page, download the desired file format Export Teachers & Students.

B. On the Export Teachers & Students file, copy the User GUID, User ID, Role, First Name, Last Name, Grade Level, Email, Username, and Password (columns A-I) fields for the teacher you want to create the class for.

C. On your Blank Template, paste the teacher's information into the appropriate fields (columns A-I).

Note: If the teacher needs multiple classes created, you will need to paste the teacher's information into a new row for each class.

D. Enter the Class ID, Class Name, Class Grade Level, Class Start Date, Class End Date, and Master Code (columns K-P) for each teacher row. The Class GUID will auto-generate by the system when the class is created so leave this field blank.

For the Class ID, you will need to enter one for each class. Every different class will need to have their own class ID.

In the Master Code (column P) column, enter the Teacher Edition Master Code. The Student Edition Master Code will automatically be added to the teacher's account. For steps on finding the Master Codes needed, refer to the Admin Tools - Manage Products article.
 

  • 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).


For a detailed explanation of each field, review the Import Users/Rosters Template Instructions.

E. Follow the steps to Upload Template, or continue to the next steps to add new teachers to new classes.

 

Teachers Do Not Yet Have an Account 

Note: This process should not be followed by districts that use SSO (Single Sign-On).

A. On your Blank Template, enter each teacher's User ID, Role, First Name, Last Name, Grade Level, Email, Username, and Password (columns B-I) that you want to create a class for. The User GUID will auto-generate by the system when the class is created so leave this field blank.

Note: If the teacher needs multiple classes created, you will need to paste the teacher's information into a new row for each class.

B. Enter the Class ID, Class Name, Class Grade Level, Class Start Date, Class End Date, and Master Code (columns K-P) for each class you want to create. The Class GUID will auto-generate by the system when the class is created so leave this field blank.

For the Class ID, you will need to enter one for each class. Every different class will need to have their own class ID.

In the Master Code (column P) column, enter the Teacher Edition Master Code. The Student Edition Master Code will automatically be added to the teacher's account. For steps on finding the Master Codes needed, refer to the Admin Tools - Manage Products article.
 

  • 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).


C. Follow the steps to Upload Template.

 

Upload Template

1. Once your template file is complete, save it as a .XSLX or .CSV file in a location on your device that is easy to locate.

2. On the Import Users/Rosters page, click the Choose File button and select the completed copy of the template from your computer. 

3. Click the Upload button.

The page will automatically navigate to the Upload History page. Depending on how large the file is, the time will vary on the upload process.

The Status of your import shows its current stage of processing:  

  • Queued means that the import will be processed as soon as possible but has not started yet.  

  • In Progress means that the import has started processing   


To check the status of your import, click the Refresh button at the top-right. 

Once the status changes to Completed, your file has finished processing. If you see Completed with Errors in the Status column, this means a portion of your file was unable to process some of the entered data.  

You can click the Actions icon to download the Uploaded File, Completed File, or Error File. 


 

  • The Uploaded File is the exact file that you uploaded (minus account passwords if you included those on your original file). It's available so that you can access it later if needed. 
     

  • The Completed File is a summary of all student, teacher, and class information that was processed successfully.  

    • Each account created via the import process now has a system-generated User GUID.   

    • If you left the username and password columns blank, the file contains the system-generated usernames along with a temporary password for each account. 

      • The temporary password will expire when it is initially used; the student will be required to set their own permanent custom password once they log in to their account.

      • If the student(s) don't access their account within 90 days of the temporary password being set, an administrator or teacher will need to manually reset their password.  

    • Share the username (and password, if applicable) on this file with the teachers so they can access their accounts as well as provide the students with their logins.
       

  • The Error File is a summary of the students, teachers, and/or classes that did not process successfully. It shows the rows that triggered the error and the specific reason why these rows failed in the Error column on the far right.  

    • If the data was partially processed and a student, teacher, and/or class was created, the Error file will include the relevant GUIDs for those student(s), teacher(s), and/or class(es).  

    • You can review the error message(s) and correct the information. Correct the issues described in the error message, save the updated file to your computer, and re-import it.

Help us improve!

Let us know how we can improve our support information by providing feedback in this short survey.

Top