Data Goldmine: YoY Enrollment Patterns by School

[Anonymous]

Ever wonder where kids go when they change schools? Or what schools kids were at before they entered a new school? Wonder no more!

https://edscape.dc.gov/node/1640846

[Anonymous]

Wow. WOW. This is so entertaining! I only wish that they had better DCPS data instead of sometimes treating it as one huge LEA.

[Anonymous]

Oh this is fantastic.

[Anonymous]

Anonymous wrote:Wow. WOW. This is so entertaining! I only wish that they had better DCPS data instead of sometimes treating it as one huge LEA.

Where do you see that? You should be able to drill down by school for both forward and backward looking.

[Anonymous]

Is this only for this year or can you see other years?

[Anonymous]

Anonymous wrote:

Anonymous wrote:Wow. WOW. This is so entertaining! I only wish that they had better DCPS data instead of sometimes treating it as one huge LEA.

Where do you see that? You should be able to drill down by school for both forward and backward looking.

Yeah, and if you click into it, you can see the individual schools within each block

[Anonymous]

Anonymous wrote:

Anonymous wrote:Wow. WOW. This is so entertaining! I only wish that they had better DCPS data instead of sometimes treating it as one huge LEA.

Where do you see that? You should be able to drill down by school for both forward and backward looking.

When I look at the second graphic, I wish I could pick each individual school from the list, but there's only one entry for all of DCPS. Clearly it's done at the LEA level.
Also, the second graphic doesn't change when I shift it from forward to backward.

[Anonymous]

Anonymous wrote:

Anonymous wrote:

Anonymous wrote:Wow. WOW. This is so entertaining! I only wish that they had better DCPS data instead of sometimes treating it as one huge LEA.

Where do you see that? You should be able to drill down by school for both forward and backward looking.

When I look at the second graphic, I wish I could pick each individual school from the list, but there's only one entry for all of DCPS. Clearly it's done at the LEA level.
Also, the second graphic doesn't change when I shift it from forward to backward.

The Tableau is not working today (was fine yesterday). That aside, no clue what you are looking at but it does allow you to choose schools. You need to choose, charter, DCPS or both, then next box is specific school. The graphs have boxes for each school (not just LEA). Another way to see what you want to see is just to download the data (link at bottom) in Excel and you can drill down as you see fit without relying on Tableau to render properly.

[Anonymous]

Anonymous wrote:

Anonymous wrote:

Anonymous wrote:Wow. WOW. This is so entertaining! I only wish that they had better DCPS data instead of sometimes treating it as one huge LEA.

Where do you see that? You should be able to drill down by school for both forward and backward looking.

When I look at the second graphic, I wish I could pick each individual school from the list, but there's only one entry for all of DCPS. Clearly it's done at the LEA level.
Also, the second graphic doesn't change when I shift it from forward to backward.

Huh? I am not sure I see what you are saying. You can select each school and then see the feeder schools backwards and forwards through on the chart.

[Anonymous]

Anonymous wrote:

Anonymous wrote:

Anonymous wrote:

Anonymous wrote:Wow. WOW. This is so entertaining! I only wish that they had better DCPS data instead of sometimes treating it as one huge LEA.

Where do you see that? You should be able to drill down by school for both forward and backward looking.

When I look at the second graphic, I wish I could pick each individual school from the list, but there's only one entry for all of DCPS. Clearly it's done at the LEA level.
Also, the second graphic doesn't change when I shift it from forward to backward.

Huh? I am not sure I see what you are saying. You can select each school and then see the feeder schools backwards and forwards through on the chart.

Oh I see, you are right. Thanks.

[Anonymous]

Observation: Walls truly pulls from all over the city. Only two schools (Deal-35, Hardy-16) sent more than 10 kids to Walls in 9th. The list of schools that sent at least one kid to Walls for 9th is below:

Cardozo Education Campus
Columbia Heights Education Campus
School Without Walls @ Francis-Stevens
Ida B. Wells Middle School
Brookland Middle School
McKinley Middle School
Wheatley Education Campus
Capitol Hill Montessori School @ Logan
Jefferson Middle School Academy
Stuart-Hobson Middle School (Capitol Hill Cluster)
Deal Middle School
Hardy Middle School
Oyster-Adams Bilingual School
Not in audit
BASIS DC PCS
Center City PCS - Capitol Hill
DC Prep PCS - Benning Middle School
Digital Pioneers Academy PCS - Johenning
District of Columbia International School
E.L. Haynes PCS - Middle School
Friendship PCS - Armstrong Middle
Friendship PCS - Chamberlain Middle
Friendship PCS - Woodridge International Middle
Howard University Middle School of Mathematics and Science PCS
Ingenuity Prep PCS
Inspired Teaching Demonstration PCS
KIPP DC - AIM Academy PCS
KIPP DC - KEY Academy PCS
KIPP DC - Northeast Academy PCS
KIPP DC - WILL Academy PCS
Meridian PCS
Paul PCS - Middle School
The Children's Guild DC PCS
The Sojourner Truth School PCS
Two Rivers PCS - Young Middle School
Washington Global PCS
Washington Latin PCS - Middle School
MacFarland Middle School

[Anonymous]

BASIS kids who left after 8th grade went only to:
Coolidge
SWW
Duke Ellington

Latin kids who left after 8th went only to:
Washington Leadership Academy
SWW
Duke Ellington

So basically, kids who aren't leaving for performing arts go to SWW or they stay

[Anonymous]

No student left BASIS for another DCPS or Charter school from 9th grade forward

Latin lost kid(s) (who stayed in DCPS/charter) to:
Coolidge (after 9th)
LAYC Career Academy (after 10th and 11th)
Ballou STAY (after 11th)
Luke C Moore (after 11th)

SWW lost kid(s) (who stayed in DCPS/charter) to:
JR (after 9th, 10th and 11th)
Latin (after 11th)

Seems like the handwringing on DCUM is a lot of noise, but the actual data says that kids who attend these schools are content.

[Anonymous]

Anonymous wrote:Is this only for this year or can you see other years?

This is 21-22 vs 22-23. I have never before seen this data.

[Anonymous]

This is a great way to get a sense of DCI feeder matriculation.

DCB: 57
Stokes: 34
LAMB: 18 (that's it?)
Mundo: 60
YY: 48

Kids from DCI feeders went to EL Haynes, Meridian, SWWFS, MacFarland, Latin, Cap City, Friendship, Truth, Paul, DC Prep, CMI, and Deal if they didn't go to DCI.