You can bulk import student accounts. To bulk upload students: - Sign in to LaunchPad.
- In order to fill out the student template, you'll need a list of the organization IDs. Under Roster Data in the left navigation column, click Orgs.
- Sort the Name column.
- In the Actions menu (top right), select Export All Data.
- Next to your name in the top right, click the Downloads icon.
- Locate the export and click its download button. Keep this document handy for filling out the student template.
- Now that you have the Org IDs downloaded, click Data Import.
- Click the Single File Upload tab.
- Click Upload File.
- For File Type, select 'Student.'
- Select 'Student' as the user role.
- Review the instructions in the File Upload window.
- Click the Users Template CSV link to download the user template. This is the file you will fill in with new students and then upload from this same window.
- Open the downloaded template.
- Fill in the data as described in the Template Field Definitions section below.
- Once the template is filled in, save in .CSV format.
- Return to the File Upload window where you downloaded the template.
- 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.
- Click Upload File.
Template Field DefinitionsUse 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. | Column | Req? | Column Header Name | Field Definition & Notes | Valid Values |
|---|
| A | Y | sourcedId | Unique identifier for the student. | Actual grade(s) student is enrolled in during testing administration. | | B | Y | status | Identifies the status of the student. | active Tobedeleted | | C | Y | identifier | Student ID that will be used for display purposes. | Any consecutive character combination is supported, though this is generally a numeric value. | | D | Y | givenName | The full legal first name given to a person. | Alpha Space | | E | Y | familyName | The full legal last name borne in common by members of a family. | Alpha Space | | F | N | middleName | The full legal middle name given to a person. | Alpha Space | | G | Y | grades | Actual 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 | | H | Y | primaryOrgId | 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. | | I | Y | orgSourcedIds | 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 |
|
