How do I export English Learner information from PowerSchool?

To extract a list of student GPA’s 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.”

20140114 1052 Capture

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
CA_PrimaryLanguage
CA_ELAStatus
CA_DateELAStatus
CA_DateEnroll
CA_DateRFEP
CA_ELProfELA
CA_EL
CA_ELlt12mos
CA_BirthCountry
CA_FirstUSASchooling
CA_ImmigrantFunding

  • Student Number = School Assigned Student Number
  • Grade_Level = Grade Level
  • LastFirst = Student Name
  • CA_Primary Language = Student two digit code for primary language as reported on the Home Language Survey
  • CA_ELA Status = Current Student EL Status (EO, EL, RFEP, & IFEP)
  • CA_DateELA Status = Date of the Current Student EL Status
  • CA_DateEnroll = Date that the student was designated EL (Optional and used for storing historical information only)
  • CA_DateRFEP = Date that the student was designated RFEP (Optional and used for storing historical information only)
  • CA_ELProfELA = Proficient or advanced on the California English Language Arts Standards Test for three cumulative years after being reclassified/redesignated as fluent English proficient (RFEP).
  • CA_EL = English Learner Program
    • 1 – Primary Language Instruction and ELD Instruction and/or SDAIE Instruction
      • This course section is providing primary language instruction, English Language Development (ELD), and Specially Designed Academic Instruction in English.Primary language instruction is an approach used to teach academic courses in and/or through a primary language other than English. The curriculum must be equivalent to that provided to fluent English proficient (FEP) and English only students. Instruction must be provided by an authorized teacher (either certified or in training for the type of service provided). ELD is an academic subject of English language instruction appropriate for the studentÆs identified level of language proficiency. ELD is consistently implemented and designed to promote second language acquisition of listening, speaking, reading, and writing. ELD instruction must be provided by an authorized teacher (either certified or in training for the type of service provided). SDAIE is an approach used to teach academic courses to English learner (EL) students in English. SDAIE must be designed for non-native speakers of English and focused on increasing the comprehensibility of the academic courses normally provided to FEP and English-only students in the district. SDAIE must be provided by an authorized teacher (either certified or in training for the type of service provided).
    • 2 – ELD Instruction Only
      • This course section is providing only English Language Development (ELD) instruction, which is an academic subject of English language instruction appropriate for the studentÆs identified level of language proficiency. ELD is consistently implemented and designed to promote second language acquisition of listening, speaking, reading, and writing. ELD instruction must be provided by an authorized teacher (either certified or in training for the type of service provided).
    • 3 – SDAIE Instruction Only
      • This course section is providing only Specially Designed Academic Instruction in English (SDAIE) services, which is an approach used to teach academic courses to English learner (EL) students in English. SDAIE must be designed for non-native speakers of English and focused on increasing the comprehensibility of the academic courses normally provided to FEP and English-only students in the district. SDAIE must be provided by an authorized teacher (either certified or in training for the type of service provided).
    • 4 – ELD Instruction and SDAIE Instruction But Not Primary Language Instruction (Most Common)
      • The course section is providing English Language Development (ELD) instruction and Specially Designed Academic Instruction in English (SDAIE) but NOT Primary Language Instruction. ELD is an academic subject of English language instruction appropriate for the studentÆs identified level of language proficiency. ELD is consistently implemented and designed to promote second language acquisition of listening, speaking, reading, and writing. ELD instruction must be provided by an authorized teacher (either certified or in training for the type of service provided). SDAIE is an approach used to teach academic courses to English learner (EL) students in English. SDAIE must be designed for non-native speakers of English and focused on increasing the comprehensibility of the academic courses normally provided to FEP and English-only students in the district. SDAIE must be provided by an authorized teacher (either certified or in training for the type of service provided). The course section is NOT providing Primary Language Instruction.
    • 5 – None
  • CA_ELlt12mos = English Learner in US Public Schools less than 12 mos.
  • CA_BirthCountry = Student Birth Country information needed for First USA Schooling and Immigrant Funding information.
  • CA_FirstUSASchooling = Required if student Birth Country not equal to U.S or Puerto Rico, or if the ELA Status is ‘EL’.
  • CA_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.
Updated on April 27, 2018

Was this article helpful?

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.