CorpusRecord 155428

Enrollment Projections from the UW Madison Applied Population Lab | 2/10/25 School Board Meeting

A searchable transcript preserved as part of the Discourse Corpus. Passage numbers provide stable references within this record; verify quotations against the original recording when available.

Source
YouTube / Sun Prairie Area School District
Date
2025-02-11
Location
Dane County, WI
Material
Transcript
Extent
2,106 words · about 12 min
Collected
2026-06-20

Transcript

Verbatim source text

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

This transcript may contain errors introduced by automated or source-provided captioning. Bracketed descriptions such as [Music] are retained from the source. Passage divisions are editorial aids and do not alter the wording.