← All proof trees · SOLOMON SOLIS-COHEN SCHOOL

1. 1
   What you see4th grade ELA proficiency (PSSA)

   23.3%

   the share of tested grade-4 students scoring proficient or advanced on the PSSA English language arts test. Based on 103 students.

   vs. peers

   52th percentile

   vs. citywide

   42th percentile

   unit

   percent

   direction

   higher is better

2. 2
   How it was computedvalue = published '% proficient or advanced' (accountability cohort by default)

   1. Unzip the district's PSSA/Keystone archive and read the accountability-cohort ('Acct') and all-tested ('Actual') school CSVs.
   2. Keep rows for the test, subject, grade, and subgroup this metric represents.
   3. Store the published '% proficient or advanced' as the value and the published number tested as the denominator; suppressed cells (asterisks/blanks) are stored as suppressed, not zero.
   4. Store the accountability-cohort cut as the default (population_cut = 'acct') and the all-tested cut alongside it ('actual').

   Citywide percentile, reconstructed right now

   Among 73 default-included schools with a value for this metric, year, and subgroup, this school has a higher value than 30. Midrank rule: (30 + 0/2) / (73 − 1) = 0.417.Stored: 0.417. ✓ 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; 31 of 40 peers have a value this year. This school is above 16 of them. Midrank: (16 + 0/2) / (32 − 1) = 0.516; stored 0.516. ✓ matches

   The peers and their values (31)

   Peer school	Value
   HACKETT SCHOOL	75.0%
   SAMUEL POWEL SCHOOL	70.0%
   ANNE FRANK SCHOOL	67.6%
   FOX CHASE SCHOOL	63.4%
   STEPHEN GIRARD SCHOOL	54.5%
   WILLIAM H. LOESCHE SCHOOL	52.4%
   JOHN B. KELLY SCHOOL	46.1%
   WATSON COMLY SCHOOL	42.5%
   FRANCIS SCOTT KEY SCHOOL	38.1%
   JAMES LOGAN SCHOOL	35.0%
   RICHMOND SCHOOL	33.3%
   J. HAMPTON MOORE SCHOOL	31.5%
   JAMES R. LOWELL SCHOOL	31.1%
   JOSEPH W. CATHARINE SCHOOL	28.0%
   RHAWNHURST SCHOOL	25.6%
   THOMAS G. MORTON SCHOOL	22.6%
   JOHN M. PATTERSON SCHOOL	21.1%
   LAURA H. CARNELL SCHOOL	19.6%
   FRANCES E. WILLARD SCHOOL	19.4%
   ELLWOOD SCHOOL	17.9%
   KENNEDY C. CROSSAN SCHOOL	17.4%
   JAMES J. SULLIVAN SCHOOL	17.2%
   HENRY W. LAWTON SCHOOL	17.1%
   FELTONVILLE INTERMEDIATE	15.5%
   JOHN H. WEBSTER SCHOOL	15.0%
   EDWIN FORREST SCHOOL	14.1%
   LEWIS ELKIN SCHOOL	8.5%
   CAYUGA SCHOOL	7.7%
   ALEXANDER MCCLURE SCHOOL	6.7%
   GLORIA CASAREZ ELEMENTARY SCHOOL	3.1%
   BAYARD TAYLOR 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: 4th grade ELA proficiency (PSSA)

3. 3
   The stored cellThe stored cell

   table

   philly_school_year_metrics

   value

   23.3

   denominator

   103

   suppressed

   false

   citywide_percentile

   0.4167

   comparison_group_percentile

   0.5161

   source_load_id

   96e07ea5-c26b-4f50-acf8-e159bd17d2e0

   Evidence: data model overview

4. 4
   The load that wrote itWritten on 2026-06-04 by sdp_pssa_keystone_2023-24.ts

   source id

   sdp_pssa_keystone_2023-24

   file URL

   https://cdn.philasd.org/offices/performance/Open_Data/School_Performance/PSSA_Keystone/2023_2024_PSSA_Keystone_All_Data.zip

   SHA-256 of the file read

   d89570e75caa9d30bd32f41de7a654b1df298e1a27a8bf6538f6dc4a6cfa9261Copy hash

   bytes

   802,929

   year covered

   2023-24

   code commit

   de835926d57d5e04d34ef3f4666df5b66fa57672

   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, 2023-24

   School District of Philadelphia (Performance Office). Same structure as the 2024-25 file, one year earlier.

   format

   ZIP of CSVs

   join key

   id_eos (= ULCS Code)

   landing page

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

   • Same as the 2024-25 file.
6. 6
   How it was checkedChecks: 0 passed, 2 flagged, 1 not run

   • ○ not runBase case not run for this grade/subject specifically (run for the all-grades aggregates and grade 3 ELA; same loader and file)
   • ⚠ flaggedAccountability-cohort vs all-tested files are byte-identical after sorting in SDP's 2024-25 archive — a publisher defect, so this check cannot distinguish the two populations
   • ⚠ flaggedCross-publisher sanity check vs the state's Keystone results

   Evidence: Accountability-cohort vs all-tested files are byte-identical after sorting in SDP's 2024-25 archive — a publisher defect, so this check cannot distinguish the two populations · Cross-publisher sanity check vs the state's Keystone results

7. 7
   Assumptions & caveatsAssumptions and caveats

   • The accountability cohort (students enrolled for the full year) is the intended canonical population. However, the two files SDP publishes for 2024-25 ('Acct' and 'Actual') are identical once sorted — 28,525 rows with no differing value or denominator — so the served 'acct' and 'actual' cuts carry the same numbers. We treat this as a publisher defect (one file published under two names) and cannot say which population the numbers describe.

   • District-run and alternative schools only from this file; charter schools' Keystone results come from the state's Future Ready file.

   Algorithms involved: Citywide and peer-group percentiles, Peer groups: 40 nearest neighbors on demographics