← All proof trees · LEWIS ELKIN SCHOOL

1. 1
   What you seeKeystone Algebra I proficiency

   0.0%

   the share of students scoring proficient or advanced on the Keystone Algebra I end-of-course exam.

   vs. peers

   0th percentile

   vs. citywide

   1th percentile

   unit

   percent

   direction

   higher is better

2. 2
   How it was computedvalue = the state's published percentage for the school × subgroup, as-is

   1. Read the state's wide-format datafile: one row per Pennsylvania school, one column per measure × subgroup (e.g. PercentPersistentAttendance_Black).
   2. Keep Philadelphia rows by mapping the state's AUN + Schl codes to the district's ULCS code through the Master School List.
   3. Unpivot each recognized measure × subgroup column into one served cell; state suppression codes ('IS', '--', '*') are stored as suppressed.

   Citywide percentile, reconstructed right now

   Among 256 default-included schools with a value for this metric, year, and subgroup, this school has a higher value than 0 and ties 3. Midrank rule: (0 + 3/2) / (256 − 1) = 0.006.Stored: 0.006. ✓ matches

   How percentiles are computed · How peer groups are chosen

   Peer percentile, reconstructed right now

   Peer group: up to 40 of the demographically nearest schools among Elementary / catchment / district schools; 39 of 40 peers have a value this year. This school is above 0 of them. Midrank: (0 + 0/2) / (40 − 1) = 0.000; stored 0.000. ✓ matches

   The peers and their values (39)

   Peer school	Value
   A.S. JENKS ACADEMICS PLUS SCH	50.0%
   ANNE FRANK SCHOOL	42.8%
   WILLIAM H. LOESCHE SCHOOL	42.8%
   WATSON COMLY SCHOOL	39.4%
   SAMUEL POWEL SCHOOL	30.6%
   RHAWNHURST SCHOOL	29.9%
   FOX CHASE SCHOOL	24.6%
   J. HAMPTON MOORE SCHOOL	22.4%
   HACKETT SCHOOL	22.3%
   RICHMOND SCHOOL	21.3%
   KENNEDY C. CROSSAN SCHOOL	20.0%
   SOLOMON SOLIS-COHEN SCHOOL	19.6%
   JOHN MOFFET SCHOOL	18.5%
   STEPHEN GIRARD SCHOOL	17.3%
   JOHN M. PATTERSON SCHOOL	16.7%
   JOSEPH W. CATHARINE SCHOOL	11.8%
   HENRY W. LAWTON SCHOOL	11.5%
   HOWE ACADEMICS PLUS SCHOOL	10.8%
   JAMES R. LOWELL SCHOOL	10.0%
   EDWIN FORREST SCHOOL	9.9%
   FRANCIS SCOTT KEY SCHOOL	9.0%
   JOHN H. WEBSTER SCHOOL	8.3%
   FELTONVILLE INTERMEDIATE	7.9%
   JOHN B. KELLY SCHOOL	7.3%
   BAYARD TAYLOR SCHOOL	6.5%
   ELLWOOD SCHOOL	5.2%
   JAMES LOGAN SCHOOL	5.2%
   LAURA H. CARNELL SCHOOL	5.1%
   ROWEN SCHOOL	4.8%
   FRANCES E. WILLARD SCHOOL	4.2%
   CAYUGA SCHOOL	4.1%
   RICHARD WRIGHT SCHOOL	3.9%
   ISAAC A. SHEPPARD SCHOOL	3.8%
   GLORIA CASAREZ ELEMENTARY SCHOOL	3.8%
   WILLIAM CRAMP SCHOOL	3.7%
   ALEXANDER MCCLURE SCHOOL	2.9%
   JAMES J. SULLIVAN SCHOOL	2.7%
   THOMAS G. MORTON SCHOOL	2.1%
   JOHN MARSHALL SCHOOL	80.0%

   Note: stored percentiles are computed by a batch script after loads; a difference from the live reconstruction means a newer load changed the comparison set and the batch has not been re-run.

   Evidence: metric tree: Keystone Algebra I proficiency

3. 3
   The stored cellThe stored cell

   table

   philly_school_year_metrics

   value

   0

   denominator

   null (not published)

   suppressed

   false

   citywide_percentile

   0.0059

   comparison_group_percentile

   0.0000

   source_load_id

   8709f04a-70da-4969-8d69-7d01a830daea

   Evidence: data model overview

4. 4
   The load that wrote itWritten on 2026-09-08 by futurereadypa_performance.ts

   source id

   futurereadypa_performance_2021-22

   file URL

   https://futurereadypa.org/home/getdatafile?id=39

   SHA-256 of the file read

   4efe1b1b120f327f19f9541636a4d5f97592b0ac6f28662d0496875c09c09387Copy hash

   bytes

   4,821,070

   year covered

   2021-22

   code commit

   c19ea6ec845c65bcc40eb49644be1c7e67b05f25

   To confirm you have the same file: download it from the URL above, then run shasum -a 256 <downloaded file> Copy command — the output should equal the hash above. If the publisher has since replaced the file, the hashes will differ, which is itself useful to know.

   Evidence: loader script · first-fetch findings for this file · source registry

5. 5
   The publisher's fileFuture Ready PA Index datafile, 2021-22

   Pennsylvania Department of Education (Future Ready PA Index). Same structure as the 2024-25 file.

   format

   XLSX (wide)

   join key

   AUN + Schl → ULCS

   landing page

   https://futurereadypa.org/Home/DataFiles

   • Same as 2024-25.
6. 6
   How it was checkedChecks: 1 passed, 1 flagged

   • ✓ passedBase case (district file, 2024-25): 54 of 54 unsuppressed cells match
   • ⚠ flaggedCross-publisher sanity check (state vs district)

   Checked at ±1: 0 mismatches, 0 cells served but absent from the file, 0 in the file but not served (ALL, acct, latest year).

   Evidence: Base case (district file, 2024-25) · Cross-publisher sanity check (state vs district)

7. 7
   Assumptions & caveatsAssumptions and caveats

   • The state's AUN + Schl → ULCS mapping from the 2024-25 Master School List is correct. State rows for schools not in that directory — district schools that closed before 2024-25 — are not loaded, so every year of state data is a survivor-only panel; cyber charters have their own AUNs and are outside the district's directory.
   • Where two directory schools share a state code (a school and its Continuation Academy), the state's single row belongs to the main school (deterministic rule; the full absenteeism QA lists every shared code).

   • Served from both the district's file (district-run schools) and the state's file (all schools); check the load record on a cell to see which.

   Algorithms involved: Reading the state's wide-format datafile, Citywide and peer-group percentiles, Peer groups: 40 nearest neighbors on demographics