You can bulk import student accounts.

To bulk upload students:

  1. Sign in to LaunchPad.
  2. In order to fill out the user template, you'll need a list of the organization IDs. Under Roster Data in the left navigation column, click Orgs.
  3. Sort the Name column.
  4. In the Actions menu (top right), select Export All Data.
  5. Next to your name in the top right, click the Downloads icon.
  6. Locate the export and click its download button. Keep this document handy for filling out the user template.


  7. Now that you have the Org IDs downloaded, click Data Import.
  8. Click the Single File Upload tab.


  9. Click Upload File.
  10. For File Type, select xxxxxxxxxxx.
  11. Select 'Student' as the user role. Only one role can be added at a time.
  12. Review the instructions in the File Upload window.
  13. Click the Users Template CSV link to download the user template. This is the file you will fill in with new users and then upload from this same window.
  14. Open the downloaded template.
  15. Fill in the data as described in the Field Key:
    - Source ID can be email or another unique identifier.
    - For OrgSourcedID, refer to the Org export you downloaded earlier. You can copy and paste it from that document.
  16. Once the template is filled in, save in .CSV format
  17. Return to the File Upload window where you downloaded the template.
  18. In step 3 in the File Upload window, select Choose File and upload the completed template. 

    After the file is selected, a pre-scan is automatically performed on the file to validate the file layout. If the file format does not align with the expected layout, the user is alerted and the file cannot be imported.  If the file format aligns with the expected layout, the user is notified of the number of records the file contains.

  19. Click Upload File
  20. Repeat for other user roles as needed.
  21. If you created teacher accounts, you will also need to link them to their classes; see also:  Course and Class Creation and Management.


Field Definitions

Use the comma separated values format (CSV) for all Student Import file uploads. CSV files should contain field values separated by commas, with line breaks between rows. Double quotes around fields are optional.

A header row is required. Headers must match the header names in the specification exactly. The order of the columns does not matter. All column headers are required, but not all fields are required. For required fields, if a value is not present then the row will not be processed. Some fields are optional and may be left blank.

ColumnColumn Header NameField Definition & NotesValid Values
AsourcedIdUnique identifier for the student.Actual grade(s) student is enrolled in during testing administration.
BstatusIdentifies the status of the student.

active

Tobedeleted

CidentifierStudent ID that will be used for display purposes.Any consecutive character combination is supported, though this is generally a numeric value.
DgivenNameThe full legal first name given to a person.

Alpha

Space

EfamilyNameThe full legal last name borne in common by members of a family.

Alpha

Space

FmiddleNameThe full legal middle name given to a person.

Alpha

Space

GgradesActual grade(s) student is enrolled in during testing administration.

K or KG = Kindergarten

1 or 01 = First Grade

2 or 02 = Second Grade

3 or 03 = Third Grade

4 or 04 = Fourth Grade

5 or 05 = Fifth Grade

6 or 06 = Sixth Grade 

7 or 07 = Seventh Grade

8 or 08 = Eighth Grade

9 or 09 = Ninth Grade

10 = Tenth Grade

11 = Eleventh Grade 12 = Twelfth Grade

HprimaryOrgIdThe primary organization/school responsible for the student.

This value must match a sourcedId value of an existing org record.

IorgSourcedIdsAll organizations responsible for the student. If multiple, then this will be a comma-separated list.

This value must match a sourcedId value of an existing org record.

J

birthDate

The month, day, and year on which a person was born.

mm/dd/yyyy

mm-dd-yyyy

mm/dd/yy

mm-dd-yy

K*

Sex

Student gender

M, Male, m, male
F, Female, f, female
 Other, other,
unspecified, Unspecified

L*

americanIndianOrAlaskaNative

Federal race category value


Y, Yes, yes, y, T, true
 N, No, no, n, f, false

M*

asian

Federal race category value

Y, Yes, yes, y, T, true
 N, No, no, n, f, false


N *

blackOrAfricanAmerican

Federal race category value

Y, Yes, yes, y, T, true
 N, No, no, n, f, false


O *

nativeHawaiianOrOtherPacificIslander

Federal race category value

Y, Yes, yes, y, T, true
 N, No, no, n, f, false


P *

white

Federal race category value

Y, Yes, yes, y, T, true
 N, No, no, n, f, false


Q *

demographicRaceTwoOrMoreRaces

If student has multiple federal race category values

Y, Yes, yes, y, T, true
 N, No, no, n, f, false

R *

hispanicOrLatinoEthnicity

A person who traces their origin or descent to Mexico, Puerto Rico, Cuba, Central and South America, and other Spanish cultures, regardless of race.


Y, Yes, yes, y, T, true
 N, No, no, n, f, false

S *

ell

An indication that a limited English proficient (LEP) student is served by an English language instruction educational program supported with the Title III of ESEA funds.


Y, Yes, yes, y, T, true
 N, No, no, n, f, false

T *

giftedTalented

An indication that the student is participating in and served by a Gifted/Talented program.
 

Y, Yes, yes, y, T, true
 N, No, no, n, f, false

U *

section504

If a student has a disability and an IEP, they are automatically covered by Section 504. If a student has an IEP and needs academic intervention, this should be included in their IEP. The IEP is required to address ALL of a student's needs that are related to the disability.

Y =student receiving special education services
 N = Student not receiving special education services

V *

migrant

 A migration student's parent/guardian is a migratory fisher, dairy worker, lumber or agricultural worker, and who has in the preceding three years moved from one school district to another in order to obtain temporary or seasonal employment in agricultural or fishing work.

Y, Yes, yes, y, T, true
 N, No, no, n, f, false

W *

economicDisadvantage

Report 'economically disadvantaged’ as directly certified and eligible for the National School Lunch Program as approved by USDA if the student is directly certified or thought participation in specified programs such as Head Start, SNAP, TANF, Medicaid.

Y, Yes, yes, y, T, true
 N, No, no, n, f, false

X *

homeless

Student is experiencing homelessness

Y, Yes, yes, y, T, true
 N, No, no, n, f, false

Y *

parentInMilitary

One or more parent(s) have active military status.

Y, Yes, yes, y, T, true
 N, No, no, n, f, false

Z *

inFosterCare

Student has confirmed participation in foster care.

Y, Yes, yes, y, T, true
 N, No, no, n, f, false


Tiny Link: https://support.assessment.pearson.com/x/EQA4Cw