← All proof trees · KENSINGTON HEALTH SCIENCES

1. 1
   What you seeKeystone Biology proficiency

   19.5%

   the share of students scoring proficient or advanced on the Keystone Biology exam. Based on 87 students.

   vs. peers

   80th percentile

   vs. citywide

   54th 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 53 default-included schools with a value for this metric, year, and subgroup, this school has a higher value than 28. Midrank rule: (28 + 0/2) / (53 − 1) = 0.538.Stored: 0.538. ✓ 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 16 of them. Midrank: (16 + 0/2) / (21 − 1) = 0.800; stored 0.800. ✓ matches

   The peers and their values (20)

   Peer school	Value
   NORTHEAST HIGH SCHOOL	33.2%
   GEORGE WASHINGTON HIGH SCHOOL	25.6%
   HORACE FURNESS HIGH SCHOOL	21.3%
   ABRAHAM LINCOLN HIGH SCHOOL	21.2%
   OLNEY HIGH SCHOOL	17.9%
   FRANKFORD HIGH SCHOOL	17.8%
   SAMUEL S. FELS HIGH SCHOOL	15.4%
   JOHN BARTRAM HIGH SCHOOL	13.3%
   STRAWBERRY MANSION HIGH SCHOOL	12.9%
   SAYRE HIGH SCHOOL	12.2%
   MARTIN L. KING HIGH SCHOOL	9.4%
   KENSINGTON HIGH SCHOOL	9.0%
   THOMAS EDISON HIGH SCHOOL	8.9%
   ROXBOROUGH HIGH SCHOOL	8.2%
   OVERBROOK HIGH SCHOOL	8.0%
   KENSINGTON CAPA	7.9%
   SOUTH PHILADELPHIA HIGH SCHOOL	7.0%
   VAUX BIG PICTURE HIGH SCHOOL	6.7%
   BENJAMIN FRANKLIN HIGH SCHOOL	5.4%
   WEST PHILADELPHIA HIGH SCHOOL	5.3%

   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 Biology proficiency

3. 3
   The stored cellThe stored cell

   table

   philly_school_year_metrics

   value

   19.54

   denominator

   87

   suppressed

   false

   citywide_percentile

   0.5385

   comparison_group_percentile

   0.8000

   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: 0 passed, 1 not run

   • ○ not runBase case against the state file not yet run for this metric (the loader is shared with keystone_algebra_proficiency, whose SDP-side base case passed)
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).

   • The state publishes no student counts for most measures, so served cells carry no denominator.
   • Served from both the district's and the state's files; check the cell's load record.

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