← All proof trees · KENSINGTON HIGH SCHOOL

1. 1
   What you seeKeystone Algebra I proficiency

   10.9%

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

   vs. peers

   60th percentile

   vs. citywide

   43th 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 47 default-included schools with a value for this metric, year, and subgroup, this school has a higher value than 20. Midrank rule: (20 + 0/2) / (47 − 1) = 0.435.Stored: 0.435. ✓ 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 High / catchment / district schools; 20 of 20 peers have a value this year. This school is above 12 of them. Midrank: (12 + 0/2) / (21 − 1) = 0.600; stored 0.600. ✓ matches

   The peers and their values (20)

   Peer school	Value
   GEORGE WASHINGTON HIGH SCHOOL	27.6%
   NORTHEAST HIGH SCHOOL	24.7%
   ABRAHAM LINCOLN HIGH SCHOOL	17.7%
   KENSINGTON HEALTH SCIENCES	15.9%
   SAMUEL S. FELS HIGH SCHOOL	15.8%
   HORACE FURNESS HIGH SCHOOL	14.6%
   KENSINGTON CAPA	14.0%
   OLNEY HIGH SCHOOL	10.9%
   VAUX BIG PICTURE HIGH SCHOOL	9.1%
   FRANKFORD HIGH SCHOOL	8.4%
   THOMAS EDISON HIGH SCHOOL	7.9%
   SOUTH PHILADELPHIA HIGH SCHOOL	3.9%
   WEST PHILADELPHIA HIGH SCHOOL	3.2%
   JOHN BARTRAM HIGH SCHOOL	3.1%
   ROXBOROUGH HIGH SCHOOL	3.1%
   SAYRE HIGH SCHOOL	2.8%
   MARTIN L. KING HIGH SCHOOL	2.5%
   OVERBROOK HIGH SCHOOL	2.3%
   BENJAMIN FRANKLIN HIGH SCHOOL	1.8%
   STRAWBERRY MANSION HIGH SCHOOL	0.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

   10.87

   denominator

   46

   suppressed

   false

   citywide_percentile

   0.4348

   comparison_group_percentile

   0.6000

   source_load_id

   bba25088-d2c0-415a-b47e-c47d1dcb2edc

   Evidence: data model overview

4. 4
   The load that wrote itWritten on 2026-06-03 by sdp_pssa_keystone.ts

   source id

   sdp_pssa_keystone_2024-25

   file URL

   https://cdn.philasd.org/offices/performance/Open_Data/School_Performance/PSSA_Keystone/2024_2025_PSSA_Keystone_All_Data.zip

   SHA-256 of the file read

   d040e16c1b88f33dd481efbdb1a3924951ab7cc81869c8dee52458280574c13aCopy hash

   bytes

   705,262

   year covered

   2024-25

   code commit

   63ddc08c2a63170cecb6e78b991559cef9aa3926

   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 filePSSA & Keystone results, 2024-25

   School District of Philadelphia (Performance Office). State test results by school, test, subject, grade, and subgroup: counts and shares at each performance level, in two population cuts — the accountability cohort (students enrolled for the full year) and all tested students.

   format

   ZIP of CSVs (accountability-cohort and all-tested cuts)

   join key

   id_eos (= ULCS Code)

   landing page

   https://opendataphilly.org/datasets/sdp-pssa-keystone-performance/

   • Two cuts of the same results; the accountability cohort is the canonical one served by default.
   • District-run and alternative schools only; charter results come from the state's Future Ready file.
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