Hi - I’ve been looking through all of the MySchoolDC data and haven’t been able to find two data points. Hoping someone can point me to them if they exist:
1. Waitlist offers by preference group. I see data published for total waitlist offers, and for matches by preference group on match day, but I don’t see any data breaking down waitlist offers by preference group (in-boundary, proximity, no pref, etc.) 2. Race by grade. There is data published showing the racial makeup at a given school, but I haven’t seen the racial makeup broken down by grade. My instinct is that within individual schools, there may be significant differences in racial makeup between, for example, Prek3 and 5th grade. Thanks |
1) I'm not aware of this being published anywhere. 2) You can look at the OSSE test score spreadsheets and may gain some insight, at least into the testing grades (3rd and up) taken as a whole. But I urge caution here-- there's a category for More Than One Race without any specifics, and the data is redacted if the numbers are small. So you can do this if you enjoy it, but it's not necessarily going to be that helpful to you, and can actually steer you astray. There tends to be a lot of variation from year to year, too, without necessarily any reason for it. |
1) it is shown on here, scroll below for the second chart: https://public.tableau.com/app/profile/aaron2446/viz/MSDCSeatsandWaitlistOfferData_draft/MSDCPublicDisplay
|
Oh wait sorry, you meant for waitlist. |
1) This doesn't include waitlist offers but it does include results day waitlist by preference group: https://enrolldcps.dc.gov/node/216 2) They don't publish this directly, but PP is correct that you can sometimes figure it out by looking at "Total Count" tested in each category in the CAPE data. You can usually mostly work around the data suppression, but it can require some real effort to do so. https://osse.dc.gov/assessmentresults2024 2) Alternatively if you're just interested in the PK vs K-5 split, you can look at the breakdowns here: https://edscape.dc.gov/page/enrollment-trends-specific-public-schools |
There is also the OSSE enrollment audit data, which might be a slightly larger data set than the test scores data, and includes all grades. I would start there, OP. |
Thanks a ton. This was super helpful and I was able to find most of what I was looking for. I did find some anomalous results in the waitlist data, though. For some schools where students with “no preference” matched with the school, those schools list as having on the waitlist some students who are in the “sibling attending” or “sibling offered” groups. How can that be? If a school is filling spots on match day with “no pref” seats, why would there be any students who aren’t “no pref” on the waitlist? |
I believe that's because is a kid is a sibling at one school but ranks another school higher and gets in, they are allowed to be waitlisted at the school where they are a sibling, even though they would not be waitlisted if they were not a sibling. |
Sibling added the school post-lottery. They simply move to top of waitlist at that point. |