← All proof trees · BUILDING 21

1. 1
   What you see5-year cohort graduation rate

   87.9%

   the five-year cohort graduation rate (district file). Based on 33 students.

   vs. peers

   20th percentile

   vs. citywide

   55th percentile

   unit

   percent

   direction

   higher is better

2. 2
   How it was computedvalue = published 5-year cohort graduation rate, by cohort entry year

   1. Read the district's graduation CSV and store the 5-year rate by cohort year.

   Citywide percentile, reconstructed right now

   Among 63 default-included schools with a value for this metric, year, and subgroup, this school has a higher value than 34. Midrank rule: (34 + 0/2) / (63 − 1) = 0.548.Stored: 0.548. ✓ 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 / lottery / district schools; 10 of 11 peers have a value this year. This school is above 2 of them. Midrank: (2 + 0/2) / (11 − 1) = 0.200; stored 0.200. ✓ matches

   The peers and their values (10)

   Peer school	Value
   CONSTITUTION HIGH SCHOOL	97.7%
   JULES MASTBAUM HIGH SCHOOL	97.2%
   RANDOLPH TECHNICAL HIGH SCHOOL	96.4%
   PAUL ROBESON HIGH SCHOOL	95.9%
   HIGH SCHOOL OF THE FUTURE	95.2%
   PHILADELPHIA MILITARY ACADEMY	93.1%
   THE U SCHOOL	90.3%
   THE LINC	88.2%
   SWENSON ARTS/TECH HIGH SCHOOL	87.0%
   MURRELL DOBBINS HIGH SCHOOL	85.5%

   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: 5-year cohort graduation rate

3. 3
   The stored cellThe stored cell

   table

   philly_school_year_metrics

   value

   87.88

   denominator

   33

   suppressed

   false

   citywide_percentile

   0.5484

   comparison_group_percentile

   0.2000

   source_load_id

   8ecdf1ea-7780-4200-bd21-8e8d089c99f1

   Evidence: data model overview

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

   source id

   sdp_graduation_school_2014-2025

   file URL

   https://cdn.philasd.org/offices/performance/Open_Data/School_Performance/Graduation_Rates/OD_SDP_Graduation_Rates_School_S_2026-02-12.csv

   SHA-256 of the file read

   8ae3969118c3a9f01e4d8d04aa634855571ab71e914f3d2b689ad811d5639225Copy hash

   bytes

   3,919,459

   year covered

   2010-11..2021-22

   year of this cell

   2014-15 — this measure is stored under a different year than the file's report year; see the metric page

   code commit

   f75e33137e8166eec3f8b5a4b39463d306ef710c

   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 fileGraduation rates by cohort, 4/5/6-year

   School District of Philadelphia (Performance Office). Four-, five-, and six-year cohort graduation rates by school and subgroup, indexed by the cohort's 9th-grade entry year.

   format

   CSV

   join key

   ULCS Code

   landing page

   https://opendataphilly.org/datasets/sdp-school-performance/

   • Indexed by cohort start year, not graduation year; the state's Future Ready file indexes the same rate by report year.
6. 6
   How it was checkedChecks: 0 passed, 1 not run

   • ○ not runSame file and loader as graduation_rate_4yr (base case passed); not separately reconciled
7. 7
   Assumptions & caveatsAssumptions and caveats

   Stored as published; no modeling assumptions.

   • District-run schools only.

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