How do I export English Learner information from PowerSchool?

To extract a list of student English Learner information into a tab delimited text file, we will follow a simple two step process:

1. Select the students that you wish to export
2. Use the Quick Export Function with the English Learner Fields code

Step 1: Select the students that you wish to export

Selecting students is easy. You can make this selection from the start page using queries or click on the groups that you wish to isolate. Once you have the students selected, you will be able to see a pulldown menu to “Select a function for this group of students.” It is here that you can select “Quick Export.”

Step 2: Use the Quick Export Function with your custom English Learner Fields code and Submit.

English Learner Fields

If you want to use a very basic code set that will export the CALPADS English Learners and Immigrant Information page fields as they show on a student’s “State/Province – CA” page:

Student_number

Grade_Level

LastFirst

S_CA_STU_X.PrimaryLanguage

S_CA_STU_X.ELAStatus

S_CA_STU_X.ELAStatusDate

S_CA_STU_X.BirthCountry

S_CA_STU_X.FirstUSASchooling

S_CA_STU_X.ImmigrantFunding

• Student Number = School Assigned Student Number
• Grade_Level = Grade Level
• LastFirst = Student Name
• S_CA_STU_X.PrimaryLanguage = Student three digit code for primary language as reported on the Home Language Survey
• S_CA_STU_X.ELAStatus = Current Student EL Status (TBD, EO, EL, RFEP, & IFEP)
• S_CA_STU_X.ELAStatusDate = State Date of the Current Student ELA Status
• S_CA_STU_X.BirthCountry = Student Birth Country information needed for First USA Schooling and Immigrant Funding information.
• S_CA_STU_X.FirstUSASchooling = Required if student Birth Country not equal to U.S or Puerto Rico, or if the ELA Status is ‘EL’.
• S_CA_STU_X.ImmigrantFunding = The foreign-born student has been enrolled in one or more public or private schools in the U.S. or Puerto Rico for a cumulative period less than or equal to three full academic years.