← All proof trees · TILDEN MIDDLE SCHOOL

1. 1
   What you seeAverage daily attendance

   88.3%

   the school's year-to-date average daily attendance rate — the share of enrolled student-days actually attended.

   vs. peers

   13th percentile

   vs. citywide

   50th percentile

   unit

   percent

   direction

   higher is better

2. 2
   How it was computedvalue = published 'Average Daily Attendance (YTD)'

   1. Read the district's ADA CSV; keep directory schools; store the published rate (all students only).

   Citywide percentile, reconstructed right now

   Among 213 default-included schools with a value for this metric, year, and subgroup, this school has a higher value than 105. Midrank rule: (105 + 0/2) / (213 − 1) = 0.495.Stored: 0.495. ✓ 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 Middle / catchment / district schools; 8 of 9 peers have a value this year. This school is above 1 of them. Midrank: (1 + 0/2) / (9 − 1) = 0.125; stored 0.125. ✓ matches

   The peers and their values (8)

   Peer school	Value
   SCIENCE LEADERSHIP ACADEMY MS	93.6%
   BALDI MIDDLE SCHOOL	93.4%
   GROVER WASHINGTON JR. MIDDLE	92.9%
   GEN. LOUIS WAGNER MIDDLE SCH.	91.7%
   CASTOR GARDENS MIDDLE SCHOOL	91.4%
   FELTONVILLE ARTS & SCIENCES	91.1%
   ROBERTO CLEMENTE MIDDLE SCHOOL	88.4%
   WARREN G. HARDING MIDDLE SCH	87.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: Average daily attendance

3. 3
   The stored cellThe stored cell

   table

   philly_school_year_metrics

   value

   88.33

   denominator

   null (not published)

   suppressed

   false

   citywide_percentile

   0.4953

   comparison_group_percentile

   0.1250

   source_load_id

   991bf9c1-3c0a-4123-a2e4-047cd97088e6

   Evidence: data model overview

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

   source id

   sdp_attendance_ada_school

   file URL

   https://cdn.philasd.org/offices/performance/Open_Data/School_Performance/Attendance/Student_ADA_Yearly_School_20260211.csv

   SHA-256 of the file read

   04e0893c5f84e6280c21682db3f653c2578ad68c7d12ded39f6e3f3165cb50c7Copy hash

   bytes

   59,816

   year covered

   —

   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 fileAverage daily attendance, by school and year

   School District of Philadelphia (Performance Office). Each school's year-to-date average daily attendance rate (share of enrolled days attended), all students only.

   format

   CSV

   join key

   ULCS Code

   landing page

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

   • District sector only.
6. 6
   How it was checkedChecks: 0 passed, 1 not run

   • ○ not runNo separate base-case report; same loader and file family as attendance_rate_above_90
7. 7
   Assumptions & caveatsAssumptions and caveats

   Stored as published; no modeling assumptions.

   • District-run schools only.
   • All-students figure only; no subgroups published.

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