Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Excerpt

You can bulk import student accounts.

To bulk upload students:

  1. Sign in to LaunchPad.
  2. In order to fill out the user student 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 student template.


  7. Now that you have the Org IDs downloaded, click Data Import.
    Image Removed
  8. Click the Single File Upload tab.
    Image Removed
  9. Click Upload File.
  10. For File Type, select Non-'Student Users.'
  11. Select a '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 students 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 Template Field Definitions section below.
  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

Template 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.

*The fields denoted with an asterisk may or may not be included based on demographic configurations for the client account. There may also be additional metadata fields, depending on account configurations. 

  • Repeat for other user roles as needed.
  • If you created teacher accounts, you will also need to link them to their classes; see also:  Course and Class Creation and Management.
  • ColumnReq?Column Header NameField Definition & NotesValid Values
    AYsourcedIdUnique identifier for the student.Actual grade(s) student is enrolled in during testing administration.
    BYstatusIdentifies the status of the student.

    active

    Tobedeleted

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

    Alpha

    Space

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

    Alpha

    Space

    FNmiddleNameThe full legal middle name given to a person.

    Alpha

    Space

    GYgradesActual 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

    HYprimaryOrgId

    The primary organization/school responsible for the student.

    Refer to the Org export you downloaded earlier. You can copy and paste it from that document.

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

    IYorgSourcedIds

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

    For OrgSourcedID, refer to the Org export you downloaded earlier. You can copy and paste it from that document.

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

    J *

    Y

    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 *

    Y

    Sex

    Student gender.

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

     L*

    N

    americanIndianOrAlaskaNative

    Federal race category value.


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

    M *

    N

    asian

    Federal race category value.

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


    N *

    N

    blackOrAfricanAmerican

    Federal race category value.

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


    O *

    N

    nativeHawaiianOrOtherPacificIslander

    Federal race category value.

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


    P *

    N

    white

    Federal race category value.

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


    Q *

    N

    demographicRaceTwoOrMoreRaces

    If student has multiple federal race category values.

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

    R *

    N

    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 *

    N

    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 *

    N

    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 *

    N

    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 *

    N

    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 *

    N

    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 *

    N

    homeless

    Student is experiencing homelessness.

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

    Y *

    N

    parentInMilitary

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

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

    Z *

    N

    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/GgE-CQEQA4Cw