LAERI DATA ARCHIVE

RESOURCES

LAERI Codebooks

LAERI Codebook

The LAERI codebook includes all student, staff, and school-level files except the district’s annual School Experience Survey (SES) and College and Career Readiness Survey (CCRS).

Location: LAERI Server

I:\LAUSD_Data\documentation\codebook_V#.xlsx

LAERI District Survey Codebooks

The LAERI district survey codebooks are organized by survey, respondent (i.e., student, staff), and year.

Location: LAERI Server

I:\LAUSD_Data\documentation\School_Experience_Survey

Other Archive Documentation

Data File Specific Documentation

Documentation specific to selected data files is available (e.g., College Board documentation related to SAT format and score changes).

Location: LAERI Server

I:\LAUSD_Data\documentation

UPDATES

2/23/2022 Update

New Files:

  • 2020 Suspensions
  • 2021 Attendance
  • 2021 Demographics (spring term)
  • 2021 SBAC (Smarter Balanced Assessments – 11th-grade exams only)
  • 2020 and 2021 DIBELS (Dynamic Indicators of Basic Early Literacy Skills)
  • 2012–2020 IDEL (Indicadores Dinámicos del Éxito en la Lectura)
  • 2019–2021 A–G Annual Files
  • 2017–2019 OLSAT (Otis-Lennon School Ability Test)
  • 2011–2014 Algebra End of Course Exam
  • 2019 CSA (California Spanish Assessment)
  • 2017-2019 Graduation Exemptions
  • 2016 6th-Grade Math Placement Exam
  • 2020-2021 Advanced Placement Exams
  • 2020–2022 School Rosters
  • 2021 National Student Clearinghouse data (includes class of 2013 through immediate fall enrollment for the class of 2021)

Updated Files:

2009 Secondary Transcripts: The 2009 transcript file only includes 10th, 11th, and 12th graders and is missing several variables the district typically provides (i.e., teacher pseudo identification code, work effort marks, cooperation marks, and class period). We received a new, complete version of the file which contains all secondary students (i.e., 6th–12th graders) and transcript variables.
2003–2018 CELDT: We converted several string variables to numeric format (exam proficiency level, school location code, and grade level). There are also small changes to Pre-Kindergarten, Transitional Kindergarten, and Extended Transitional Kindergarten students’ standardized exam scores.
2019 ELPAC: We added a variable that describes students’ overall performance exam level.
2006 Demographics: We replaced the categorical homelessness variable with a binary variable that indicates whether students experienced homelessness during a given term (e.g., end fall). We replaced the categorical variable because there was no district documentation for the 2006 file and we could not ensure the categorical coding was correct.
2014 School Roster File: We converted the 2014 charter school variable to numeric format.
2016 and 2017 School Roster Files: We renamed the charter school variables to match the 2006–2015 and 2018–2022 data files.
2018 and 2019 School Roster Files: We corrected a coding error in the school type variable (lausdschtype). This correction affects self-contained middle school magnets and opportunity schools/units.

For additional information about the updated files, see the LAERI Codebook.