← All proof trees · JULIA DE BURGOS ELEMENTARY

1. 1
   What you seeKeystone Literature proficiency

   7.5%

   the share of students scoring proficient or advanced on the Keystone Literature exam.

   vs. peers

   45th percentile

   vs. citywide

   45th 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 268 default-included schools with a value for this metric, year, and subgroup, this school has a higher value than 119 and ties 2. Midrank rule: (119 + 2/2) / (268 − 1) = 0.449.Stored: 0.449. ✓ 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-Middle / catchment / district schools; 40 of 40 peers have a value this year. This school is above 18 of them. Midrank: (18 + 0/2) / (41 − 1) = 0.450; stored 0.450. ✓ matches

   The peers and their values (40)

   Peer school	Value
   HANCOCK DEMONSTRATION SCHOOL	25.7%
   JOHN H. TAGGART SCHOOL	25.6%
   COPPIN, FANNY JACKSON SCHOOL	25.5%
   GEORGE W. NEBINGER SCHOOL	21.1%
   VARE-WASHINGTON ELEMENTARY	20.9%
   WILLIAM H. HUNTER SCHOOL	19.6%
   THURGOOD MARSHALL SCHOOL	18.0%
   GEORGE SHARSWOOD SCHOOL	17.9%
   STEPHEN DECATUR SCHOOL	17.3%
   THOMAS HOLME SCHOOL	16.1%
   MAYFAIR SCHOOL	15.4%
   ELIZA B. KIRKBRIDE SCHOOL	13.0%
   JUNIATA PARK ACADEMY	11.7%
   ROBERT B. POLLOCK SCHOOL	11.5%
   JOHN F. HARTRANFT SCHOOL	11.1%
   D. NEWLIN FELL SCHOOL	10.9%
   HON. LUIS MUNOZ-MARIN SCHOOL	10.8%
   GEORGE W CHILDS SCHOOL	10.6%
   H.A. BROWN ACADEMICS PLUS SCH	10.0%
   FRANCIS HOPKINSON SCHOOL	9.6%
   SPRING GARDEN SCHOOL	9.5%
   AMEDEE F. BREGY SCHOOL	8.3%
   LOUIS H. FARRELL SCHOOL	7.4%
   NORTHEAST COMMUNITY PROPEL ACADEMY	7.2%
   J.H. BROWN ACADEMICS PLUS SCHL	6.6%
   SOUTHWARK SCHOOL	6.5%
   ANDREW J. MORRISON SCHOOL	6.3%
   THOMAS K. FINLETTER SCHOOL	5.9%
   WILLIAM MCKINLEY SCHOOL	4.9%
   OLNEY ELEMENTARY SCHOOL	3.9%
   WILLIAM H. ZIEGLER SCHOOL	3.9%
   A.L. FITZPATRICK SCHOOL	3.7%
   GILBERT SPRUANCE SCHOOL	3.1%
   JOHN WELSH SCHOOL	3.1%
   POTTER-THOMAS SCHOOL	2.7%
   HAMILTON DISSTON SCHOOL	2.2%
   ETHAN ALLEN SCHOOL	1.8%
   MARY BETHUNE SCHOOL	1.7%
   BENJAMIN FRANKLIN ELEM. SCHOOL	0.0%
   ALLEN M. STEARNE 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 Literature proficiency

3. 3
   The stored cellThe stored cell

   table

   philly_school_year_metrics

   value

   7.5

   denominator

   null (not published)

   suppressed

   false

   citywide_percentile

   0.4494

   comparison_group_percentile

   0.4500

   source_load_id

   8ba7d9e6-a94a-4a6f-9e9b-ceb2707d43de

   Evidence: data model overview

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

   source id

   futurereadypa_performance_2024-25

   file URL

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

   SHA-256 of the file read

   a16ffc40e7d1851d5ac83dd63d8ca5348ead064e029bade593a0182ed085bc92Copy hash

   bytes

   5,113,152

   year covered

   2024-25

   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, 2024-25

   Pennsylvania Department of Education (Future Ready PA Index). The state's school-level accountability indicators for every public school in Pennsylvania — test proficiency, growth (PVAAS), persistent attendance, graduation — by subgroup.

   format

   XLSX (wide: one column per measure × subgroup)

   join key

   AUN + Schl (state IDs), mapped to ULCS via the Master School List

   landing page

   https://futurereadypa.org/Home/DataFiles

   • The chronic-absenteeism column exists in the file but is empty for individual Philadelphia schools; the state reports persistent attendance instead.
   • Publishes no student counts for the attendance measure.
   • Its 90%-attendance figure does not match the district's for the same schools (see the cross-publisher check).
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