001Hello everyone I'm David Egan-Robertson I'm with the UW Madison Applied Population Laboratory and over the next 15 minutes or so I'm going to talk about this year's uh enrollment projections for the Sun Prairie Area School District the results and graphs that I'll be showing in this presentation are included in our report if you want to get into more detail you can work through the report itself but with this talk I'm highlighting the results and explaining our methodology so what I'll be covering tonight the district's recent enrollment history and how our last set of projections perform compared to your fall 2024 enrollment and then they'll cover the projections how many students do we expect through our projections work uh over the next 10 years and then finally how do we get there I'll cover the methods
002we used to develop projections which involve projecting burst 5K kindergarten and grade progression ratios now I always like to start with some caveats about projections we produce a range of projections and and this is to reflect uncertainty in projections projecting is an imprecise science so we always provide a range of potential outcomes uh we make some assumptions about births from which your PreK 4K and 5K can kindergarten projected classes are built data from the state comes to us only at a municipal level based on municipalities so if the school district's uh boundaries don't follow Municipal boundaries precisely we make a judgment call on which communities to include and exclude in addition there's no good source about movement of families the grade progression ratios or GPR's which are the only way we can capture year-over-year change
003in enrollment so migration is actually implicit in our projections it's not explicit in our modeling and finally projections smooth out volatility and I put on the screen here uh your birth history in the Sun Prairie area and you can see an indicator like burst bounce up and down from year to year and chances are that your actual year-to-year changes will show more up and down patterns than our projections do so first on to uh the numbers look at your recent enrollment history and how our projections which we last prepared in late 2023 fared in predicting the fall 2024 enrollment for you so here's a graph of your total enrollment this is PreK through 12 these are your enrollment counts over the last 10 years and across the decade you've add about 6% more students but
004there were three distinct periods which caught my eye in terms of someone who who looks at these numbers a lot you had a strong gain of about 5% in the first three years but then you had a period of time where there was some decline not much you know minus 2% over several years and then in the last two years you you've now returned to a pattern of gaining about 3% gain over the last two years the red dash at the upper right indicates the approximate range of our projections from last year and we were about 2 and a half% low I noted that your ninth grade was larger than anticipated this year and also you had an uptick open enrollment particularly at the high school level this year again just looking at your history
005again a little bit this is patterns based on your grade groupings in your schools so 4K in Elementary grades 4K has fallen by about 70 across the decade or about 14% 5K through 5th has declined by 100 or about 3% down in contrast your middle school and high school middle schools in high schools excuse me 6 through eight have gained nearly 200 over the last decade or about 12% of and then 99th through 12th grade has grown substantially about 450 or 19% and some you know in Broad terms your lower grades have seen a decline but the upper grades have been increasing I mentioned earlier the Open Enrollment issue and what we've seen and your data is showing is an uptick in open enrollment incoming students and you've been averaging about 370 in the past
0063 years compared to about 300 in the prior 6 years um and so the the net change which we also look at the difference between your in and out open enrollment totals your net open enrollment game the last two years has been about plus 80 so that was uh just covering the past a little bit uh what about the future so as I mentioned uh we produced four projections not just one to give a sense of the potential range of student counts in the future so here again it's the district's past 10 years this the full PreK through 12 enrollment and here are the results of the four models in 5 years the projections range from about 8,400 a little under 8,400 to a little over 99,100 so it's about 200 lower to 520 or
007so higher than your current enrollment so a difference about minus 2 to plus 6% and uh remember that from a prior slide remember that you've gained about 6% over the past 10 years so our models here are showing the possibility of maybe gaining 6% over the next 5 years we do carry the projections out 10 years but we emphasize them for the first 5 years because most children entering their schooling beyond that year haven't been born yet which makes projections a little tricker looking at specific grade groupings here's the history of your 5K your Elementary grades 5K through 5th um in 5 years our projections are in a fairly tight range about 3,400 up to 3,575 a numeric change of possibly loss of 80 up to Plus 90 or about minus 2 to plus 3%
008middle schools grades um the four models increased for a few years is right now you have larger fourth and fifth grade those classes age forward your middle schools will bump up over the next couple years but then the model slip slightly as now younger cohorts enter the middle school so in five years we're projecting a range from about you know 1,710 up to 1,920 numeric change of 145 to plus 65 or - 8 to + 4% in percentage terms and finally your high schools in 5 years our projections range from about 2,725 up to 3,130 numeric change of - 60 to + 350 or - 2 to + 12% now the high model here I'm I decide to use a 2-year Trend in the past we've sometimes used Trend three years the three most recent
009years but with that uptick you've had in your enrollment in the last two years I decided to go with the two-year Trend the high school student counts have grown 10% over the past three years so using this very short-term trend is pushing up that particular set of projections in this case so that's a run through of the numbers uh what about our methods how how do we get here so I'll explain the projection models that we use so there are three primary building blocks for the projections there's the projection of birth, projections of 5K kindergarteners, and grade progression ratios so here's your birth history since 2006 when some of your current seniors were born as you can see it's a little bit of a bounce up and down over time but generally between 500 and
010600 annually and in 2023 was the most recent year for which we can get births through the department of health services um the births in 2023 were 44 fewer than in 2006 so if we project on a long-term basis across this whole period of time it shows a slight decline I mean actually at the end of this projections period the the number projected is basically the same as the actual count of births in 2023 if we use a shorter term pattern just the last 9 years show a little bit of a uptick so both trending methods do sort of do stay within this sort of 500 to 600 bounds of your past history so the these seem like pretty reasonable predictors of uh future bursts in the some per area the second building block we
011use is 5-year-old kindergarteners so here's your 5K student count for the past 10 years and not like births they bounce up and down there's some up and down variation across time but the uh as it turns out that your 5K count at fall in this past fall 2024 is exactly the same as it was in the fall 2015 the projection using these pass counts assuming a longer range pattern holds future 5K classes May decrease slightly about 5 to six students per year if the more recent pattern holds it basically holds the K 5K kindergarten population steady across the projection period the final building block are grade progression ratios in a nutshell we're capturing the change in class cohorts as they age through their schooling from year to year then we average these changes over three
012different time frames and apply them extending out into the future so I'm hoping my illustration here works okay with this uh presentation so just to try to get a sense of how we do this if you look at your fourth to fifth grade uh progressions what I've circled here with these red red circles in 2016-17 you had 600 fifth graders the prior year your fourth grade was 578 so you had an increase so the ratio there is about 1.04 about 4% more students in the fifth grade compared to the previous fourth grade class and conversely occasionally run into situations of course where classes shrink um from the 2018-19 fourth grade of 617 your fifth grade the next year had dropped to 597 so that fifth grade class was about 97% of its prior so it
013lost about three students per 100 um so we note down at the bottom this is where all our averages show up and I've got to outlined in the red box at the bottom of this slide so you can see for the fourth to fifth grade transitions all of them are just above one and these translate to basically one or 1 to 2% higher so over time over a number of different time periods that that we look at it's showing some increase from year to year in this particular case the fourth to fifth grade transition we have our three different modeling methods where we um use use these um grade progression ratios and this illustrates all three of them put together in in some car excuse me Sun Prairies case excuse me most grade transitions are
014above one meaning that your class cohorts tend to increase in size as they advance from grade to grade you see particularly large spikes at the 8-9 transition and this is influenced by students moving from private schools into the public high school note too that um the blue line that's the two-year Trend these GPR's are highest and the Bas line and five-year Trends which use longer historical patterns that capture some years when your student counts decline they have more muted GPRS than those generated from the past two years so to summarize all the information I put in here let me bring up to get the slide going here so some Sun Prairie Area School Districts total PK to 12 enrollment has risen over the last 10 years up you're up about 470 students are about 6%
015the first three years you didn't have Rising enrollment then you had four years where there was some Decline and then for the last two years your total enrollments been going up again your 4K and 5K through fifth classes are are smaller and your 6th through 8th and 9th through 12th grades are larger so births in the area as I showed are generally remaining level again 5K kindergarten also you know remaining level one model showed a little bit of a drop but not nothing too severe and your grade progression ratios as I pointed out are mostly above 1 so indicative of class cohorts growing as they age forward and also another uh factoid I guess I'd say between when you compared the district's number of households with children at the 2020 census compared to the 2010
016census you actually had 13% more household with children and that bucked the trend of the state which actually saw a drop of about 5.5% in households with children so to summarize then uh the projections or future Trends um the change in the total students is projected range from about - 2 to + 6% over the next 5 years and numerically as I have here about 200 possibly 210 students decrease up to a 520 student increase your Elementary classes projected to range from about -2 to + 3% middle schools the change May range from -8 to about 4% positive and finally high schools change May range from -2 to+ 12% one thing that's interesting in doing these projections was and I noticed is that using that longer historic time frame the Baseline which makes use of
017all 10 the history of the past 10 years the five-year trend which makes use of the five most recent years generally those are predicting declines and and those where I was modeling using the shorter time frame the 2-year Trend and the kindergarten Trend predict increases so thank you very much uh for watching this presentation and I will be available at the board meeting on February 10th to answer any questions you might have