Click the Import Students button found on the right-hand side of the page.
Click on Download Student Template to obtain a pre-formatted copy of the student template. If prompted, save the file to the location of your choosing.
Note:All of the column headings must appear in the spreadsheet, but only columns marked “(required)” are mandatory for completion of this process. Please do not delete any of the columns from the spreadsheet or change the column titles; changing this information will render the template invalid. The acceptable values for each field are as follows:
Last Name:(required) : 1–50 characters. Only letters, spaces, apostrophes, and hyphens are allowed.
First Name:(required) 1–50 characters. Only letters, spaces, apostrophes, and hyphens are allowed. Note: The First and Last Name columns must contain 3 characters combined. For example, “Li, Y” is acceptable, but “L, Y” is not.
Middle Initial: (optional) One letter
Gender: (optional) M or F
Grade Level: (optional) One of the following: PK, K, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10,11, 12, NA
Disability Flag: (optional) Y or N
Free Lunch Eligibility: (optional) Y or N
Limited English: (optional) Y or N
Migrant Status: (optional) Y or N
Race: (optional) one of the following: ‘Native American’, ‘African-American', 'Asian/Pacific Islander', 'White/Caucasian', 'Hispanic'
Student ID (optional) Up to 30 characters. Any character is allowed.
Username: (recommended) Usernames must be between 3-20 characters, cannot be numeric only, and are not case-sensitive. Usernames must be unique nationally, not just within your account. NOTE: You may also leave this field blank, and the system will generate usernames. Symbols are allowed, and you may use a student's full email address.
Password: (recommended) Passwords must be between 6-16 characters containing at least 1 letter and 1 number (examples: password1, a12345). Passwords are case sensitive. NOTE: You may also leave this field blank, and the system will generate passwords.
Redemption code: (recommended) Multiple redemption codes can be used in each template but only one code can be specified per student. Codes can be entered with or without dashes. NOTE: If you leave this field blank, teachers will have to assign the content to their students manually. ***see clarification below***
Once you have completed adding student information, save the completed file to a familiar location on your computer.
Select the account that you wish to add your students to from the Account dropdown. If you do not have a dropdown box, please simply proceed to the next step.
Click the Browse button and select the completed copy of the template from your computer.
Click the Check File for Errors button. The systems will now check your file for any errors. If an error appears, you will be prompted to view the invalid data and correct the spreadsheet.
NOTE: These changes will need to be made locally, and a new, corrected copy of the spreadsheet will need to be uploaded (see step 2). If no errors appear, you will be notified to complete the upload.
*** Clarification - For a student who will have multiple books ie. Science, History, Math (multiple redemption codes) leave this field blank. The teachers can "assign content" from their account. For a student who will have only 1 book you may key in the redemption code so this upload will: 1. Create student account. 2. Load said account with the needed book.