Thread by @wdoyle42

1/ Some updates on this thread!

https://twitter.com/wdoyle42/status/1437456670611935243

2/ First, the number of institutions eligible was off, it's more like 1000 insts. Current best-guess list is here:github.com/wdoyle42/cc_pr… Thanks to @LadermanSophia and @kelsey_kunkle for catching this.

3/ Second, I did NOT include required fees in the calculation of median tuition! The updated number is $4,653, the average of WV and OK. Thanks to (you guessed it) @LadermanSophia and @kelsey_kunkle and @david_socolow for this correction as well.

4/ That means that the program is more generous than I stated originally. If fully implemented, 44 states would see an overall increase in per-student subsidy with this program, in addition to offering free tuition for eligible cc students.

5/ When comparing the federal subsidy with state match plus foregone tuition and fee revenues, it looks like there are about 30 states that would lose more in foregone tuition plus match than they would gain in federal subsidy.

6/ Of these 7 would need to increase funding by $500 per fte to maintain current overall subsidies, 10 would have to increase by 500-1000 and the remaining 13 would need to spend more than 1000 per student.

7/ Last, I misstated the eligibility requirement. It's not sixty credits, it's the first six semesters of enrollment (Q: at the current institution or ALL institutions? How would this be tracked across states?)

8/ Updated summary here: rpubs.com/wdoyle42/808800 , code and data here: github.com/wdoyle42/cc_pr… Please keep feedback coming! Pull requests also welcome, thanks to @btskinner for the updated library. Other thoughts? @ozanjaquette @SuJinJez @karinaGsalazar @tlharnisch

9/ A few other things that aren't right, but I also don't know how to fix: the numbers for CO aren't correct, as the Colorado Opportunity Fund, which is really state appropriations, gets counted as tuition, sometimes?Thanks to @kzaback for helping with this.

10/ Also, in-district vs. out-of-district enrollment complicates the picture a lot, in ways that I don't know exactly how to deal with.