Skip to main content

Fields for Manually-Uploaded Student Accounts

Overview

This table lists the required and optional fields for creating or modifying student accounts through myLexia’s Manual Import function. With manual import, administrators can upload spreadsheets on an as needed basis.

For more information, see Guidelines for Manually Importing Students and Staff.

Column Heading

Column Description

Character Limit

First Name (Required)

Student’s first name. The first name may contain letters, numbers, underscores, periods, apostrophes, dashes, and spaces.

50

Last Name (Required)

Student’s last name. The last name may contain letters, numbers, underscores, periods, apostrophes, dashes, and spaces.

50

Username (Required)

Each student’s username must be unique within your school or district.

  • The username may contain letters, numbers, underscores, periods, apostrophes, and dashes.

  • The username cannot contain any spaces.

  • Usernames are not case-sensitive.

  • A unique code that students already know, such as their lunch number or student ID, can be a good option. Usernames based on names have a high likelihood of multiples/duplicates.

4-255

Password (Required)

Student passwords can only contain letters, numbers, and underscores.

Passwords are case-sensitive (i.e., a student with a password of “READ” cannot log in with “read”).

4-50

Grade (US only) (Required)

The student’s grade. It must be entered as follows:

PRE-K, K, 1, 2, 3, 4, 5, 6, 7, 8, 9,10,11,12, Graduate, OTHER

na

Year (UK only) (Required)

The student’s year. It must be entered as follows:

Nursery, R, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, Post 16/Adult, OTHER

na

Class (Optional)

Assign the student to a class or classes by entering the class name(s). You can place the student in an existing class or create a new class. Please note that classes in the class column will replace the student’s current classes, rather than adding to them.

  • To place the student in an existing class, make sure the class name is spelled identically* to how it appears in the Classes list in myLexia, or a new class will be created.

  • To create a new class, specify a class name. If all students in the class have the same grade, then the class grade will be created with that grade. If students have different grades, the new class will have a grade of Undefined.

  • To include a student in more than one class, list each class, separated by commas**, in the student’s Class column.

  • To add a student to an additional class rather than replace their current class(es), make sure to include both the student’s current class(es) and the new class in the import.

*Class names are not case-sensitive.

**Class names should be separated by a comma and with no space after the comma.

40

School (Required)

Assign the student to a school by entering the school name. To place the student in an existing school, make sure the school name is spelled identically to how it appears in myLexia, otherwise you will create a new school in myLexia (if you are a District Admin), or you will receive an error that you have entered an invalid school name (if you are a School Admin).

50

Lexia ID (Displayed in export)

The Lexia ID column displays if you export student data from myLexia. It is not visible in myLexia, or editable—that is, you can not change a Lexia ID with an import.

None

MI (Optional)

Student’s middle initial. Only the first letter will be accepted.

1

Suffix (Optional)

Use this field to add suffixes like Jr., Sr., III.

10

Date of Birth (Optional*)

Acceptable formats for US: mm/dd/yyyy

Acceptable formats for UK: dd/mm/yyyy

Months and days may be 1 or 2 digits; years may be 2 digits

na

Gender** (Optional*)

You may specify: M or F for Male or Female, or X for Non-binary/Other.

na

Race (Optional*)

Use the following values to indicate the student’s race:

0998 or 998 American Indian or Alaska Native 0999 or 999 Asian 1000 Black or African American 1001 Native Hawaiian or Other Pacific Islander 1002 White 5000 Other 5001 Multiracial

na

HispanicLatino (Optional*)

Use Yes or Y to indicate that a student is Hispanic/Latino. Use No or N to indicate no.

na

IDEA (Optional*)

Use Yes or Y to indicate that a student is receiving IDEA services. Use No or N to indicate no.

na

ELL (Optional*)

Use Yes or Y to indicate that a student is designated as an English Language Learner. Use No or N to indicate no.

na

Title1 (Optional*)

Use Yes or Y to indicate that a student is receiving Title 1 services. Use No or N to indicate no.

na

State ID (Optional)

Indicate the student’s State ID. Note that this field only displays in myLexia if a customer setting is enabled (Settings > Security Settings > Allow student State ID information).

50

SIS ID (Optional)

Indicate the student’s SIS (student information system) ID. Note that this field only displays in myLexia if a customer setting is enabled (Settings > Security Settings > Allow student SIS ID information).

50

Student Number (Optional)

Indicate the student number. Note that this field only displays in myLexia if a customer setting is enabled (Settings > Security Settings > Allow student number information).

50

*Student demographic data is only permitted to be imported into myLexia if the “Allow student demographics” setting is enabled.

**Both Gender and the previous column heading, Sex, are supported.

Be the first to reply!