← All proof trees · MAYFAIR SCHOOL

1. 1
   What you seePVAAS growth — Science/Biology

   71.00

   the state's PVAAS growth index for science/biology.

   vs. peers

   50th percentile

   vs. citywide

   27th percentile

   unit

   index (publisher's scale)

   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 100 default-included schools with a value for this metric, year, and subgroup, this school has a higher value than 24 and ties 5. Midrank rule: (24 + 5/2) / (100 − 1) = 0.268.Stored: 0.268. ✓ 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; 9 of 40 peers have a value this year. This school is above 4 and ties 1 of them. Midrank: (4 + 1/2) / (10 − 1) = 0.500; stored 0.500. ✓ matches

   The peers and their values (9)

   Peer school	Value
   HANCOCK DEMONSTRATION SCHOOL	74.50
   WILLIAM H. ZIEGLER SCHOOL	74.50
   SOUTHWARK SCHOOL	73.50
   GILBERT SPRUANCE SCHOOL	72.00
   JUNIATA PARK ACADEMY	71.00
   STEPHEN DECATUR SCHOOL	69.50
   NORTHEAST COMMUNITY PROPEL ACADEMY	69.50
   THOMAS HOLME SCHOOL	69.00
   ANDREW J. MORRISON SCHOOL	68.50

   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: PVAAS growth — Science/Biology

3. 3
   The stored cellThe stored cell

   table

   philly_school_year_metrics

   value

   71

   denominator

   null (not published)

   suppressed

   false

   citywide_percentile

   0.2677

   comparison_group_percentile

   0.5000

   source_load_id

   2fdcb9ea-d4af-4a48-a7cf-a8e6166696b3

   Evidence: data model overview

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

   source id

   futurereadypa_performance_2023-24

   file URL

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

   SHA-256 of the file read

   89219f7a7ffbc6adc14f54e87f2872ab04ce12a9e0749c448cf54998e4930e90Copy hash

   bytes

   4,861,549

   year covered

   2023-24

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

   Pennsylvania Department of Education (Future Ready PA Index). Same structure as the 2024-25 file.

   format

   XLSX (wide)

   join key

   AUN + Schl → ULCS

   landing page

   https://futurereadypa.org/Home/DataFiles

   • Same as 2024-25.
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.

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