March 10, 2025 | OKCPS Board Meeting Livestream

001e [Music] it is 5:30 so if everybody grab your seats all right everybody found your seats that was impressive right it's a little a little different today welcome thank you for spending another Monday evening with us and we're excited to talk about uh Financial oversight and then also see this cool dashboard that's coming up um before I have Craig call us to order I do want to recognize a very special guest in the audience former board member for District 5 Ruth vills is here and if you go back and watch live stream I would bet we should count how many times Ruth Phil said the word dashboard and and that's why she's here is to see this dashboard for for all of you guys who got the dashboard going that's why Ruth is here tonight

002and so we're very excited to see this come to F because she's the one that began it so thank you all right Craig we go ahead and call order thank you madam chair before I call the role I want to just go over a couple of quick little house cleaning items if everyone would please um take a moment to silence your cell phones we would appreciate that very much I would like to point out this meeting is being live streamed so we ask all participants involved in the convers ation please be sure to speak into a microphone we have microphones distributed throughout the uh seating area if you don't have one in front of you you could please borrow your neighbor's microphone that way the people on live stream will be able to hear what

003you're saying and I would like to ask everyone to please be careful walking around the room tonight we do have several power cords and HDMI cables strown about we've tried to minimize that but there are a few and I just don't want trip and with that I will call the role Paula Lewis present Carol Thompson present Lori Bowman pres and she is present I can you test your mic for me present thank you Miss Bowman I appreciate that Jessica sentes present Dana me present Mike Shelton present Juan Lona present mag Melaney we have a quorum thank you okay so we uh this is a work session just so REM mindful that we are hard stop that's kind of an agreement we've had at 7:30 so we'll stay on task the first hour is going to

004be talking about um the board's responsibility of financial oversight and just engaging in conversation with the District staff and what does that look like and then the second half is the District staff presenting to us the dashboard um there's it's kind of an interactive work session um to get going right now this is the board and this is and our superintendent up on the slide right now this is who is currently responsible for um serving as the board and our core responsibilities as you know are over you know approving the budget um once it is presented to us and making sure it aligns with the goals and good for student outcomes the hiring and supervision of the superintendent passing policy which becomes our guard rails and setting goals which becomes the vision of the district

005yes yes all right but we got to go with the vision so we start with this uh here we go by providing Equitable access to a world class education every Oklahoma City public school student will graduate ready to fulfill their unique purpose in a healthy Vibrant Community there we go all right so here's our role um again just as a quick reminder and this is um in State Statute it is what it is uh we're trying to dive deeper into it and really be um good guardians of what we have been elected to do as a district okay so the why I sent you guys um out kind of some information that I had watched the press conference on Sunday and just you know Tulsa Public Schools their board members did not inherently not have

006oversight they didn't go in and be like hey I'm not going to oversee the budget but but without clear direction of how we're going to do it and clear understanding between the district and the superintendent then that's how that happens and it all comes down to policy and internal um checkpoints and that's why we're here is to really figure out how can we prevent anything from that happening in the future not we're not trying to catch anybody doing anything we don't think that's a thing but how do we prepare ourselves so that this district is safe so that our our our stakeholders our taxpayers they really believe and they know that we are doing everything we can to be responsible for their tax dollar that's ultimately it and not only be responsible for it but

007making sure that tax dollar is going to programs and activities that are good for kids that help kids reach their academic goals um that's it thank you uh chair Lewis from this point on we will hear from different uh cabinet level uh people or design needes in order to ground Us in the work that we will do together Mr Gallow it's my pleasure tonight to introduce a little bit about okcps so okcps is one of the largest organizations in Oklahoma just want to take that in for a second we uh we're comprised of 58 schools across 135 square miles each day we serve over 32,000 students if you add in our Charter Partners it's over 35,000 students we employ nearly 5,000 staff which makes us one of the largest employers in the state of Oklahoma

008and certainly the Oklahoma City metro area we have broad representation in our school district and that is evidenced by 84 Native American tribes over 16,000 bilingual Learners which is just about half of our student population 78 languages spoken we're also a high-capacity service provider we transport about 10,500 students daily provide over 34,000 meals daily and we have one of the largest volunteer partnership networks in the state that we are incredibly grateful for and it gives us amazing reach throughout our community thank you Galloway seio just reflecting back on where we've been and where we're going this is our current reality um on the screen you see our vision which we just kicked off our meeting with our mission our core values and then our portrait or our profile of a graduate um this is the

009perfect time in our work with our SG to pause reflect and refine the foundational elements or our commit to our community around what we're uh producing it's important that we continue to lean in to the feedback that was provided by our community and take consideration around what our vision or our profile of a gra graduate will look like as we move forward ensuring that we honor the voices and the feedback that they have provided to us um we want to align our aspirations and reaffirm our commitment to Excellence to Ure that every single one of our students walks across the stage with a plan in their hand to either be employed enlisted or enrolled or have the opportunity to engage in whatever their dreams are for the future thank you all right thank you so

010as most of you know there are really two driving factors when it comes to school Finance there is the law which governs how and when and What expenses we can use our money on but we also have District policy and the law lives leaves a little discretion to schools to make determinations when it comes to how money will be spent but the school district any time that it wants to can go beyond those requirements and as you can see in our policy co1 it does a few things the first thing is it draws that connection between the importance of what we're doing every day when we're making those decisions on how to spend money and how that affects our students and if we go back to our training that we've been getting through student outcomes

011focused governance right that's that reminder that our adult decisions our adult our adult policies our adult practices have a direct outcome on the success of our students so we want to be sure that the expenditure of our funds lines up with our vision and with our goal to provide a world-class education and we do that in multiple ways but one that is really clearly called out here is one complying with the law right that's always important but two making sure that we have within our own system internal controls to make sure that it money as it's spent is being spent according to law and that it's being spent efficiently so that we know that the money that is there for students gets there when it needs to get there that it's getting to the school

012to benefit students in a timely way so we're looking not just at making sure we have compliance which is number one but also that we're using that money in appropriate way and that we're doing it in a way that affects students now and when the money is needed it gets there quickly so as part of it I think we can use that as part of our conversation today when we're looking at internal controls the first thing that we're keeping in mind is the students and that's always what we're keeping in mind but also give us the opportunity to ask questions how do our policies work what do our Pro processes look like what internal controls do we have so that when we're going through those processes we can sure that we're in line we're in

013alignment with our own policy co1 which really outlines and serves as that guidepost for the board thank you so much now I'm going to transition and I'll ask Sydney Ward what you're going to see is what I call a flat dashboard which means it's the beginning of please note all departments will be uh showing dashboards but Sydney if you'll just take a moment and ground Us in Revenue okay before that so uh Journal records power list for women in accounting Banking and finance came out today and CFO Sydney Ward was on L [Applause] congratulations okay now green button great okay so on this dashboard this is our uh projections for revenue for our general fund our main operating funds through January of 2025 we got three big buckets we have local Revenue state revenue and

014federal revenue the local Revenue mainly consists of current and prior your tax collections interest and it's about right now we're projecting about 108 million it's about 30% of the the revenue budget our state money um that we get is based off of mainly Foundation Aid so that's our uh state aid that we get flexible benefit allowance motor vehicle collections School land earnings miscellaneous State programs that's the biggest bulk of our uh Revenue budgets about 186 million about 51% and then the last big bucket is our federal dollars that we received so this consists of all of our federal grants pass through from the State Department of Education um Indian aded uh DHS anything that it considers to be a federal dollars that is what makes up to about the $62 million that we're projecting this

015year and that's about 177% of the budget your next Slide the expenses the EXP expenses for the general fund through January as you can see salaries and benefits are our biggest bucket uh about $295 million is what we're projecting to be for the end of the year and that's about 80% of our budget um purchase Services consist of like contracted Services um uh purchased Property Services like to operate and maintain the buildings uh Communications advertising Etc that's about we're projecting about $39 million to end the year at with about 10 11% of our budget and then the last big bucket is supplies and materials that consist of all our supplies um fuel a lot of utilities um and we're looking at about $28 million projected expenses in there and that's about 7.6 of our budget

016um Sydney um Mrs Ward thank you so much uh board members what we're trying to do is be as transparent as possible but you will receive a report similar to this each month so you can lay it out and be able to see in regards of how the finances are as well as please note uh Mrs Ward is having meetings with departments and we're breaking this down so we all understand so it's not cloudy but on today we needed to ensure when we're talking about finances we cannot not talk about enrollment because this is how we receive the finances and if Dr uh love will come to the podium and just briefly we would like to monthly give you a look at what the enrollment looks like they won't be scheduled for them to speak

017but you will have this at your access monthly thank you thank you Dr pulk you welcome uh yes I do track enrollment by month I have it for the last six years tracked by month um but I just gave you a snapshot and again when a snapshot uh it can change we can enroll 50 or 60 students on just a regular old Monday like we did today or it can also go the other direction when we have students who either leave our district or are dropped for treny um you can see that 2021 October that was Co year it's one of our it's one of our lowest years and the year before that was quite a bit higher um then the last three years have been significantly or have considerably different and higher this year

018was a little bit lower on um in October 1 with 32740 we notice that generally October 1 is our highest enrollment number but if there are a few times where it's it's into November which is not what we want to have we like October 1 because that's what funds Sydney's buckets so um application School data I looked at the last three years of course February 1 2025 that's going on right now I don't have numbers about acceptance yet just numbers um in terms of how many applications they received so typically they receive about this number and they're they're on track for that and in terms of projections um we have have had projections over the past years in terms of a a very scientific formula and last year made a decision to shift to a

019projections basically looking at the October one and then it was January 17th I believe mid January date and looking at the highest of those two numbers it seemed to work out much better in terms of Staffing and um we were more prepared at least last year so new new um a new process that worked pretty well for us this year and looking at it again for next year thank you Dr love and I'd like to do a Shameless plug here we have opened enrollment uh the earliest we ever have and uh please note families can go on uh the web site and enroll now because Finance enrollment all lead into how we staff our buildings which now takes us to Mr Herer you good evening good evening board um so the data that you'll see

020tonight is based off of our October one um and Staffing and vacancies on October 1st this year we were 98% staffed we had a 2% vacancy uh of those 43 vacancies there were 19 of those that were special education um our goal every year on July first is to be 95% staffed remember back to Mr Galloway's comments we have um 4,900 staff members about half of our staff are teachers so 2400 25 00 teachers so you know 40 um 40 plus vacancies on October 1st we felt very confident about um traditionally around uh the 1 of August we're 95 to 98% staffed um over the last several years so we feel very confident about that another point is around teacher retention and support uh this past year our teacher retention rate was uh and thanks

021to Maloo and her team for pulling that together for us was 79.9% the national average is around 84% some things to think about there is this past year um one reason it was probably of a a dip was that we um because of the Esser we lost some positions and when we track teacher retention we're tracking it two ways one is if they stayed within the district and then we also track it by site so if a teacher leaves from one site and moves to another site that still counts for the district but may not count for that site so we have that and we can share that information as well and another point that you'll see uh moving forward too is this our Recruitment and pipeline development currently we have 94 total um staff

022members that are enrolled in the the foundation one of the foundation pipelines uh either the bilingual pipeline the diversity pipeline or the high school to teacher pipeline so um those are things that we look to continue to expand and grow um those pipelines because those retention rates for those staff members is in excess of 95% so thank you so much and many of you may have noticed there were a group of students uh in the hallway they are doing round one for to be accepted into the high school pipeline we're pretty excited that this is our largest group yet uh students who want to become Educators and and it's exciting for us so all of that needed to be shared so I could set the reason or our purpose for today board members you have

023been strategically placed by a cabinet or a senior level person what we expect on today is for us to have a little clearer guidance of what the board would like to see in the change if any in policy c-01 let's do a materials check please you should have this document close to you if you will take one moment and look and write down one key question you have before we even get started in regards of this process we're about to go through in regards of looking at policy c-01 what are your expectations please place that on that first line there for personal reflection and we'll wait for thank you your next sheet in our packet is the policy itself for your reference I have had an opportunity to already speak with cabinet level and what

024they would like to do there's three sections if we get a chance to go through I'm going to ask board members that you take this document with you we'll get it back from you you'll actually will turn it into to Tony that'll be your responsibility to get it into him but we need true feedback on the expectations for if there are any changes to the policy uh in the name of that policy for those of you who do not have it in front of you is entitled fiscal management goals so that's what we are looking at on today the first is there's three sections academic growth operational excellence and then expanded student opportunity if you will sh up beside a board member cabinet level what I need to happen now is for the two of

025you to discuss and look at each one of these goals and cabinet members please guide their conversations if you look number one aligns with the policy number one and it reads across for instance Advanced planning to ensure funding supports instruction curriculum and student learning outcomes the internal assumed responsibility there for a strategic alignment is fiscal Audits and tracking of resource allocations in impact on student achievement we have a document that is our comprehensive District action plan it's aligned here we're looking to ensure literacy math proficiency and graduation rate improvements through data driven instruction and targeted intervention as a board member dialogue with your partner what internal controls are you looking for as a board member cabinet level if they get stuck please look at the bank that's below to activate any conversations I'm going to

026get us started give us three minutes only for me to stop and do a checkin so that you can go back to work but I only want to give you three minutes to start so I can see if you have any questions cabinet level do you have any questions before we move on board members do you have any questions please begin all right my questions were a simple question said we consider Department good good that's good that's the question somewhere here and that's why yes this in theal there should be some internal control so you're not just out there willingly spinning and then making people feel back the kids don't get what they need but they had mismanagement of adults so to me that's the piece is like yeah Advanced planning but how do we

027get to oversee that the Bond's the easy one I think that like should be on the bond is that every single invoice like if we have it put it freaking on the yeah yeah yeah so look down here these are some Poss suggestions a 5year financial forecast perhaps the annual budget performance report smart goals costing reports these are just suggestions that could go for just that one number two these are just some suggestions what I hope is You all take this with you Circle these get them back to us and then collectively Tony would put it together my team today has the because we ET so much so much not get them access yet I think it's based on attendance yeah is that and and is it helping the instruction I mean how it relates

028um and I totally agree with this I mean you want to make sure your Staffing matches with student needs and so for I we got the request to move a teacher to a school because are we just yeah three minute checkin does anyone have any questions in regards of the process great conversation I'm going to ask if you will please switch now to the second which is the operational excellence do the same thing again because please note cabinet level you're just helping the board member process this they will take this away for homework they may call you and ask a question but when we get these back we will go to work three more minutes please do we've never not did them so yeah I it's required by so many different yes and I and

029I am all about getting up and communicating need to know where it stand so just know that we do do reports every month this wasn't communicated out does me okay that's great doesn't mean no but I agree we could do I mean I don't I don't mind doing things monthly but we could do quarterly deeper Dives and maybe monthly like the little high Lev Dash um I mean I'm all about you know making everybody aware of things so um the Erp we are you know been in the new Erp so I think so I think it's going to be so much it's not like it but it's so yeah it does the job to to some degree I mean we pull everything to excel because you know oracle is going to be me like I

030thinking capabil absolutely yeah I've been been working with the uh people that we to impl change the partner yeah and U yeah there she's a she actually was the Chief Financial offer for the wit public Sports well she impation they hire oh yeah we used to yes we used to train the principles years and years ago kind of got away from it but I think it's important for them to understand especially when they have t of one money and communicate wasn't come up aside to get I think they had more knowledge more input beneficial I actually did a principal training cabinet members please take a moment and go ahead and switch to the last and the third sheet e yeah we are trying to finish that right now and then I know Rex the state

031requires us to follow so every year at the end of the year we upload all of our financial data to the state it has to be error free so asked us to do um ask and then they and they government would find to I mean we have to comply with the state um they have to comply with the feds in order to get reimbursement for Grants read I was shocked really I hav I'm read probably the bottom I got at a dist a district our size I thought you I thought they did those [Music] I mean I think a lot of yeah I agree glad you're here gosh I'm glad you're here a lot ofation check so I mean we have a lot of checks and balances in place there's levels of approvals that I

032have to go through um Rex is very strict with his money which is a big b of the federal dollars but we don't do anything different if it's general fund or building fund or Child Nutrition we keep everything the same so I mean I feel very comfortable um job but that's why I was so surprised that like they could submit an invoice and say hi R check and there was no PO advice or were they ch oh yeah holy cow that would make me cringe right we are so we are a PO based district and I know there people make intentional yeah we can't write a check and we can't write a check until all three things match up you know and I mean a lot of times that upsets sites because they have to

033go and nobody goes to jail right I know there's risks but you know we try to minimize as much as possible right I mean the whole purpose is to be physically responsible for that's everybody in my family is in education sister's a high school counselor my brother's a high school principal oh wow one thing like you said though I would like to and I would even like to know we do these B sure she didn't even show up to her we what are we doing what are we doing M to just on a software oh sure like I said nobody provides out what has happened what what kind of effect has it had has it done the right thing with the students that is our biggest one of our biggest trouble bring back together if

034I may please I want to say thank you for your engagement board members please ensure your thought partner uh if you need to get back with them that that's an availability we just ask that anytime time you do so you also CC me however I want that communication so if anything came about that you need further explanation of because this sheet I need back from you all so that we can look for the commonalities and as I've shared once we look at this information I'll be checking the capacity of the people I have and if this is doable now or does this go on our projected two years 3 years so that we can have fiscal responsibility the last thing I'm going to share is in regards of District Department budgets so that's where we're

035getting to because in the past we did not have District budgets and so as cabinet is getting that aligned and as the board helps with our goal setting then as departments we will align ourselves with that goal as well as our finances so that we're not all over the place we'll be a little more laser focused in regards of how we even request um funds before it gets too far I'm going go to another slide but before I do I'd like to turn that over for a moment to our board chair to see if you have anything that you would like to talk about in regards of this process and the takeaways for the board anyone at the table to speak but I'm turned it over to you for you to lead us well just

036you know I mean I know this is a short session but we got to start somewhere so this is the starting point and you know go through this turn it in we can have additional work sessions this is not a oneandone um it's going to be a kind of a living Beast for a while its own I mean we're a big big Corporation and it's going to take a while to get everybody um feeling like their voice was heard and that they feel comfortable when they take a vote on a budget that they know that we're doing the right thing by that so with that said it is 6:15 5 6:15 so let's do a real quick if anybody has kind of an aha moment um anything of that nature but do we know we

037have some exciting stuff on the dashboard so anybody have anything pressing that they want to say that they learned or excited about no no anybody mik no one go ahead go ahead I just need you to know that go ahead yes one so um people if have asked me in the past how can they look up how we spend our money and Brad you show me on the website because I try to look for it but I couldn't find it but then again if you don't ask you know you don't know so if you don't ask for help you're not going to get it cuz not everybody in this room is going to be able to read my mind and oh Mr Lon is this no no you you have to you have to ask

038in order to get the help so now that he showed me I'm going to tell parents how to do it and it's piece of cake so I'm excited about that cuz people have asked me that that question multiple times so thank you can you sh that oh yes uh so on the website you go to uh you press home there's the of uh you go on the Departments you click under financial services and then click uh what's the other one Financial reports Financial reports I found it all listed and then they're all listed on on financial reports there's the budget edits bonds contract all that stuff so it's uh pretty cool cuz people have tried to Sir can we can't find it are like oh yeah well let me look for it but now I

039know so next time they ask me like I got you man I got you yeah thanks sir Jessica yes um for me um and I was here with Laura McGee um yeah we we were talking a little bit about just of how um what are the things that we are purchasing of course and so I know that sometimes um outside Consultants were an issue with other districts um and so just wondering um how we pick those uh outside Consultants or how we pick our um our curriculum for instance um are they evidence-based um and so um I think it was pretty eye- openening to me that we have been pretty transparent but I think making it more easy to digest um is something that I think is good to work for and so just thank

040you for that yeah so ult ultimately the goal is to strengthen our financial transparency and oversight but in order to do that we have to understand what it is as well and we all come from different backgrounds different things that we do um and we rely heavily on the District staff to be able to point that out to us but in order we can't trust blindly we have to know that there's checkpoints in place and that um at every level you know one of my questions was you know you know when you talk about transparency and oversight you know first thing people think is oh you're looking for something Miss spent no not really like I like my question was do we consider if a department spends money that's not in alignment with the goals

041a weak point in our system like it could be as simple as that so it doesn't necessarily have to be a Mis expenditure like legally when Tony talked about compliance it could simply be it's not in line with the vision and the guard rails that this the go the board has set forth so there's two different sides of that um and that is the financial planning with student enrollment trends like we know um that we can project at some level but things change there's lots of things that can change whether it be you know rhetoric that comes out that scares people they don't come to school or you know the opposite of that that we start telling our story and it's so exciting to come so more people want to come to our district because

042we're first choice but at the same time you have to have that trust and belief in the superintendent her team but it's not blind trust it's trust that we've put the checkpoints in place and because of that they have to work in these areas and that we can see that through reporting and then just cck we this what this is is the board expectations and it's going to take us a while to get there because policy is how we set our expectations but if we don't answer these questions and we don't continue to have these conversations then you end up with a policy that is very compliant with the law co1 is very compliant with the law but it doesn't have a lot of meat to it in the fact of like what the board

043really believes is important in our budget um I'll use another Ruth Phil statement cuz she's here and she taught me how to be a board member long long time ago so um that if you want to see you know if we talk about Equity it better say it in the budget it better show that we're putting our money for Access for kids and Equity is a different word you don't have to use that word but basically if you're saying we're giving kids more opportunities then the budget better show that and so that's the piece that I mean I think here um anyone have any thoughts on those yes Jessica yes and you also said something that um kind of like resonated with me and also what we talked about with Laura you said the word

044team um you also said the word meet which is funny because those are palindromes but and I think they go together and so uh but we discussed a little bit about how um it's not fair for maybe one person to be in charge of all the finances but we have teams we have teams of people that rely on each other um that was quite eye open uh just to think about that uh maybe not all the responsibility should fall on one person but rather than a team of people that are ensuring those checks and balances like like the paper said um yes yeah absolutely anyone Paula I was just oh yes Lori sorry and then Mike um and I was just gonna add to that that Alicia and I talked about um maybe opportunities for

045different types of quarterly report outs that um highlight and I think this will work nicely with our efforts on student outcome focused governance and how we've we're making a commitment to spend 50% of our time together in um meetings talking about our goals and I think it's going to force you know that even in the context of budget expenditures and Reporting out how does um how did the way we spend money how does that align with the goals that this board has set and the district is you know committed to too so um I think there are opportunities to strengthen the um communication that comes out that helps us understand it but also taxpayers understand it and how it all works together with our district goals yes thank you first and foremost um we had

046a robust conversation and where I thought I might be a bit off I feel like I'm more in line well I am off but on this conversation I'm more in line than I thought I was uh but uh and a lot of my thoughts and feelings have come from the the Tulsa audit which which is was shocking and so you know my initial question I opened up with well who's the buck stop with and which is the ultimate Foundation to my the question I asked who does the buck stop with it stops with the superintendent but we approve the superintendent's budget or okcps budget and so my you along with Lori and a couple others talked about like quarterly reports and stuff like that look into you know I'd like to truly see at some

047point contracts and again looking at Tulsa budget when when you start spending so much somebody needs to really look at okay this this money's gone we' paid $500,000 is it working is it not working uh what did we get from from this so I I'm just hoping like Lori said that that it may not be for 90 things that are $999,000 and down but maybe $100,000 and up really having a better uh uh guard some guard rails really in place to ensure that the stuff that we're spending money on is working so absolutely so s when you sit here and listen to this does that seem reasonable I me you're in your new CFO position here like so uh yeah tell us your thoughts on it okay is this still y i i do I

048I appreciate the feedback because you guys do need to know how everything works and and it is concerning like I spoke to Meg and I said you know when I read the Tulsa report I'm shocked because we have I thought everybody did things like we did and they don't and so you know that's but I do think it's important that everybody understands how the process works because like Mike said you guys are the EV inevitability the buck stops with you I mean you know we I'll be in trouble and Jamie will be in trouble but the buck stops with you guys too so thank you for that but uh um I mean it it is important that you understand and and we want to be very transparent I I also spoke to me I said

049you know we've always done monthly Financial reports since I've been here in the 17 years that I've been here we've never not done monthly Financial reports they've just never been communicated out and so I I think it's important that you guys see that we don't have to be in the weeds every time but maybe you know quarterly or something however that needs to look but it is important that you see so all right if I may also share some of the work that cabinet is doing uh with the other leaders is how do you determine the return of investment how do you actually ask before you purchase what are your expected outcomes and then we put in our 30 45 90day measurements to say that's not working and they have authority to disrupt meaning to

050say not yet or this isn't working we must go in a different direction I shared even on today our kids can't wait on us to get this right we should come ready and how we come ready is to put our money where our mouth is and please note board chair I want to take a personal uh time of privilege here to thank cabinet level today because they did read the audit from Tulsa cover to cover cuz it's been our conversation all day in regards of let me check with legal let me check with and it's no longer huh it gave us pause on today because we want to get it right I'm even excited to share with you we had a financial literacy conversation with students this morning and and so this didn't just as

051you said on one and done this is how we become better citizens is to be better stewards and so I'm excited um we're going to hit some bumps but do something don't sit and wait our kids need us now all right yes thank you okay anyone else on this okay before I hand it over to is it Jason for the thing all right uh District 5 has some exciting new go ahead and tell them Mike tell them what's going on come on oh I was just making sure that everybody tunes into to our state championship tournament uh they all our schools are out of District Five matter of fact uh that's what I was saying class of SAS U Douglas boys and girls basketball team so their state championship there you [Applause] go okay we're

052not going to take a break anybody be good take it on all right we're not taking a break when does this need to be turned in Tony about when's our next board meeting so right before that board meeting because we don't want them to have to I think it's in two weeks yeah so you want to turn it in that board meeting or before that board meeting if they have any questions please get with their partner before but that day is we need to shut it down down for him to go to work okay so you can bring it to the board meeting on April yes I'm sorry we do have a work session on the calendar for Monday the 24th of March are we going to proceed with that do we know I don't

053know the answer to that one yet so then there is an April 7 business meeting yeah so April 7th that is your last date for this and then we'll figure out the 24th thank you thank you Craig okay who's up who's next all right I'm going to take it away I was like I'm looking I was like uh board members at your uh at your station uh there is a vocabulary sheet for you it's okay as we speak uh on the dashboards tonight uh it's my pleasure to be here with you all a data minor is someone who systematically collects analyzes and interprets large sets of educational data to uncover patterns Trends and insights to inform decision making I stepped into my first leadership role 20 years ago and one of my first responsibilities was

054to take on the data mining for our campus I spent countless hours pulling information from various sources organizing it making sense of it not not just for our faculty and staff but also to report externally to our district I wasn't alone in this work I had colleagues across the district also doing very similar work but each of us were trying to piece together a clear picture for where our student students stood over time state level data reporting has improved giving us access to summi of data in ways we didn't have two decades ago however as helpful as that data is it tells us where we've been not where we are it does little to inform us about our current reality and the real-time needs of our students tonight I have the privilege of introducing a

055signature project that has been a major Focus for our district this year the development of our district data dashboards centered around our six key performance indicators of academic growth academic achievement chronic absenteeism English language proficiency postsecondary opportunities and graduation rate these dashboards represent a significant step forward in our ability to access realtime data visualizations while also fostering a culture of data transparency across CPS by streamlining how we access and analyze data we are not only reducing the amount of time our leaders and teams spend searching for this information but also ensuring that our leaders are looking at the same data in a consistent and transparent manner these tools allow us to own and act on our data with greater Clarity and efficiency given our time tonight we will focus on two of these kpi dashboards

056post secondary opportunities and graduation rate which by the way are the two most difficult dashboards to create as we've learned to walk us through these dashboards I am so excited to introduce Dr Malo Smith our director of planning research and evaluation also known as P internally and a key leader in this work Emily Murphy whose Creative Vision along with several other other members of the pr team have played for Emily and bringing these dashboards to life and since it's the night for Shameless plugs I'll also put in a Shameless plug that just a few years ago Emily Murphy was a student in a school I was the principal of so this is a proud principal moment for me uh and Emily and uh and the entire PR team have done some really amazing work in

057a really short amount of time and so we're excited to get to highlight uh some of that tonight I will also say that when we were preparing for this engagement uh I was sharing with Dr Smith um I'd like to have some interactivity in this process and uh and so Dr Smith took that back to the team and one of the interactive ways that we're going to engage you tonight is through um a platform called cahoot and so you have that up on your uh computers uh there and Emily's going to walk us through that but Dr Smith I'll turn it over to you and okay let's get started and I'll try not to knock anything else off the table um good evening everyone um as we look at the numbers tonight it's important to

058remember that they are not just numbers they represent real experiences and challenges and successes in our department we look at numbers and statistics and equations and Trends every day and we always remember that every data point is a child so our goal in putting this dashboard together and other dashboards and we actually have other dashboards we do um is to bring together key data in one place where it's easy to access and use and understand so that district and school leaders can have the information they need to support students so Emily is going to get us started and you have you should have on your screen a cahoot website because you're there's a pop quiz we're giving you just kidding um but if you will go ahead and put in the meeting number Ma I

059don't have it all right so if nobody um if you don't have it up on your screen yet the website is kahoot.it and I'll spell that out it's k a h o o t and then period it t and that is the website in here in just a second I will display a game pin that you'll enter and that'll enter you into the game and I want to welcome everybody in the room if you want to participate in this not just people at the table I want as many people as possible hopping on to this interactive data activity I would like to say uh please do not use your real name when make up a name maybe a vegetable or animal or whatever you like and you can choose your own icon where you get

060to decorate it it's it's a fun activity time so here's the game pan at the top it's 7981 know it's me oh here we go some people joined Moon pie9 anyone need help anyone need help mentally or our kids do this all day every day rabbit he jumps like a rabbit all righty does anybody else want to join oh we still got people coming in you're going to be in trouble yay these are cool names look out look out talk about interaction how about that Eric all right does anybody else need to join it looks like it's slowed down oh [Laughter] tomato all righty um so the questions that we put together today are just we want to get you thinking about the data before we just show it to you I want to know

061what you think about our district maybe it's right maybe it's wrong no judgment this is not a we got you a trick question type thing we just want to see how much do we know about the data and then we're going to show you um this first question is not anything data related it's just an easy introduction question getting you used to the platform so the question will display on one of these big screens in front of you and then the answer choices will be on your screen that you then select and get points based off of that not that the points count for anything but maybe some bragging rights all right I'm going to go ahead and start true or false okcps is a First Choice district and everybody better get this right red

062is false right true blue is true yeah it doesn't say on here I was like I was looking like taking forever and everybody did awesome all right so I'm gonna be hopping back and forth between this game and our dashboard um I do just want to say please don't close out um the cahoot website I don't want you to think that I'm done just when I hop off on my screen I'm going to be hopping back and forth all righty so we're going to start off with our postsecondary opportunities dashboard and I want to give a shout out to Maryann Smith she um was the pr team member in charge of the specific page she couldn't be here tonight um but she worked very hard on that um postsecondary opportunities refer to opportunities that align

063with students interests and goals and prepare them for Life After High School um and the state has approved certain um post-secondary opportunities to be counted towards points for participation on our state report card and those include um college preparatory courses including our um advanced placement and international baloria courses um internships Career Tech courses like through metroe as well as our concurrent courses um at our College and universities so I want to see what we think about how we offer post-secondary opportunities in the district so I'm going to switch back to the game in a quick introduction on this next question um I'm sure we all have varying levels of knowledge about the state report card um basically the state assigns us a letter grade based on our varying performance on key performance indicators one of

064those being the um postsecondary opportunity um we got 38% on our level of completion for all Juniors and seniors in the district 38% of our Juniors and seniors completed one or more post-secondary opportunities we hear that we don't necessarily know how that translates to the number of points we receive or the grade that we receive as well so we are going to put that in perspective and see how do you think that translates to a grade and then we'll tell you and double points because it's a toughy we got a C last year on our post-secondary opportunities for 38% participation in order to move from a c to a b what percentage of completion for post-secondary opportunities do you think we would need and again we got a 38% completion last year don't know she

065I think just about everybody is answered so I'm going to go ahead and call that completed it's 50% so in order to move up from a c to a b we would need 50% of our Juniors and seniors to have completed one or more post-secondary opportunities which I think is definitely manageable all right so now now on to the dashboard um first up what's displayed is our post-secondary opportunities completion um last school year so 41% of our Juniors and seniors enrolled in a post-secondary opportunity last year and 37% or 38 when you round up um have completed a post-secondary opportunity one more question about this and some of you might have caught the answer if you looked ahead shout out to for Education all right so what percent of the 11th and 12th graders that

066did complete a postsecondary opportunity wait excuse me what percent of all 11th and 12th graders completed a post-secondary opportunity course during school year 23 24 I think I just told you the answer I'm so sorry I got a little mixed up I think I gave gave you the answer and then I showed you the question we're just going to skip it my apologies it's Jeopardy come on I got a little head of [Laughter] myself well we got some points there it's all right here's our next question there we go of all the 11th and 12th graders who enrolled in a post-secondary opportunity last year more than 90% passed that course true or false yes and that was true and I think most of you got it but I wanted to clarify 37% of all of

067our Juniors and seniors in the district completed a post-secondary opportunity but among those 37% or among the 41% that enrolled we had a pass rate of 92% which is very high so when you're enrolling in a post-secondary opportunity you're most likely passing that post-secondary opportunity and here we can see that displayed by school with our district average completed of 20 37.5% excuse me and you can just see how all the schools compare to the district average with class and SAS by far being ahead of the game um most of that is made up by college preparatory courses including advanced placement and international baloria courses and you can see the percent completed um all of our Juniors and seniors what percent um completed per opportunity type mostly made up by our College Prep courses then internship

068Career Tech and 5% at concurrent and I do want to point out the capabilities of this dashboard are very vast you can filter by school up here I won't do that for every widget but if you wanted to see a certain School you absolutely can do that um grade or cluster referring to our principal supervisor groups are these forward- facing are they District facing just out of curiosity like can the public see them or is it only District just District okay thank you and here you can see um buy opportunity type by school and I won't go into specifics on all of these widgets but just demonstrating the capabilities of the dashboard and we also have each post-secondary opportunity percent completed displayed by demographic Group which can be especially useful if either you're looking at

069the district level or the site level to see what groups may or may not be be being their needs are being met excuse me and I'm going to go ahead and highlight um our economically disadvantaged students which make up 92% of our district if I can find it here we go so you can see for 11th and 12th graders there is a vast difference between the percent completed post-secondary opportunity between economically disadvantaged and not economically disadvantaged students especially for our College Prep courses all righty I'm going to go ahead and switch back to our game here another double points question which post-secondary opportunity type do you think saw the largest increase in in enrollment from last year to this year wow had a large distribution of answers there the correct answer is Career Tech um

070last year we had 8% of our Juniors and seniors enrolled in Career Tech and this year we had we have 16% so that pretty much doubled I'm going to switch on over to our next post-secondary opportunities page which highlights our enrollment this year and here you can see that 16% for Career Tech so if you go back to the first question that we asked you about post-secondary opportunities in order to increase a letter grade from last year we would have needed 50% completion and I want to highlight what percent of our kids our Juniors and seniors are now enrolled nearly 50% you can tell today so that is a great increase and I do want to point out I can't definitively say that that means we are going to increase letter grade this year because

071not only is our state report car grade based on our performance but as well as the performance as our surrounding districts but still that is a phenomenal increase and I'm sure it'll only keep going up all righty and here you can again see um buy postsecondary opportunity type with call prep still being um our most common enrollment and I'm going to again highlight our economically disadvantaged vers not disadvantaged students here we go there is still that disparity between those two groups of students and I'm only highlighting this just to think about the needs of our students all righty now I'm going to transition over to our senior survey page we give a senior survey H spring um and uh I guess for two years now we have done that and we decided to include uh

072some questions to look at our profile of graduate so we developed those that's part of this dashboard too they're just uh questions that ask students to sort of self-reflect on their own ability to think critically or their cultural awareness or things like that uh so that's part of this they um the the senior survey has its own dashboard you can see all the results but for things here that we felt were relevant to these post-secondary opportunities we wanted to pull out some of that information including this dashboard check and I meant to say this upfront I do want to stop for questions every couple Pages briefly just because I know I'm throwing a lot of data at you and if we save all our questions until the end I'm we might forget them all so

073if anybody has any questions about what we've talked about up until this point I'd be happy to take a few minutes yes uh yes I was wondering because you said that the the capabilities of the dashboard is pretty cool um but is there a way to overlap data like even more so among different groups um I guess I'm not sure particularly what you mean do you would an example be potentially filtering by like some of those demographic variables okay maybe that yeah that that answers my question so yes um I don't we haven't initialized that as a page level filter um but we do have every single page broken down um by each individual demographic I believe if we were to have every demographic group as a filter it might get a little bit ien

074if Ying um and it might get a little bit I I don't know how generalizable that data will be if we want to see on every single demographic group for each student does that answer your question um yes and I think I could play around with the filters too yes absolutely are there any other questions so far okay awesome um so we will be giving the senior survey right after spring break I believe um but this is last year's um results and we do want highlight the response rate um by school we generally have our response rate Threshold at 70% meaning that we can give you School level results um if you meet that response rate threshold um I'm just going to point out a random school that didn't meet it John Marshall that doesn't

075mean that John Marshall students won't be included in the titles of course we're going to rep we're going to report that data it's just that we can't give John Marshall their data alone it's just going to be represented in the whole District question yes who who am I looking at I was just curious use your microphone they won't be able to hear you on live stream thank you thank you so much I was just curious in getting this data see that Douglas is overperform not they performed well Star Spencer have has performed well is this in the principal's uh duties or does he get graded off of having these surveys filled out um no generally we coordinate with counselors um counselors are typically going to meet with seniors one-on-one or at least they try to

076um and that's when we want we give the opportunity for counselors to say before you leave this meeting please fill out this survey and I know some schools last year even did a diploma pickup scan this QR code before you leave complete the survey but I don't believe Mal do you have any information on that no I don't believe anything to do with principl it's been required um generally the surveys that we offer like we have one that just closed on Friday the student staff and family experience surveys um they're very strongly encouraged um but they are not required okay um so like Malo said this um we ask about students High School experience and their post-secondary plans relating to the 3E is the um enrollment employment and enlistment so last year of those who

077responded 81% of seniors said that they plan to continue their education whether that be a 2-year 4-year University um trade school any number of those things um 14% said they plan to enter the workforce right out of high school 9% plan to enlist or maybe more accurately enter the military through a variety of Pathways and 5% says that they have no plan at all and again this is one of those um you can filter by school just going to pick a random school and you can see how your school compares to the district not too far off as far as Northwest class I'm pretty on par and again you can see those Broken Out by school um for your post-graduation plans Tech trade Art School two-year we even have a two-year then foure for students

078planning on transferring and I'm not going to go over every one of these questions but we do ask things like what is the highest degree you expect to get oh don't want to get too far ahead because it's time to go back to our game all right what was the most commonly selected area of specialty for students entering a technical trade or art school what do y all think good time today oh my God interesting and this is really interesting to me because Health Professions was number one selected by those going to a four-year institution um for our Tech trade and art school students it was actually Automotive construction and maintenance that they were most interested in going [Music] into and here we can see we asked very specifically about what kind of Major Field

079they want to go into um so first these are our um college and university students you can see it broken out by either two or foure Institution for every one of these majors and here's the Health Professions and related programming programs being the number one most common I'll also highlight undecided being pretty high but that's okay and then here on the right we have our areas of specialty for Tech trade and art school students here's that Automotive construction and [Music] maintenance and we also also ask about if you're going straight into the work Force what are you going to be doing number one was construction manufacturing and repair with most of those students indicating that they're going to be working [Music] full-time and then lastly we have these different Pathways into the military for those

0809% that did indicate they want to enter into the military are there any questions on this one before I go to our last postsecondary opportunity page okay where am I going all righty and this um page focuses on data reported from the Oklahoma state regions for higher higher education they report remediation rate which refers to firsttime freshmen entering um a college or university that have to take remedial courses which are defined as no credit courses um if your state test scores indicate not state test scores excuse me if your college entrance exam test scores indicate that you might need a little bit of help in certain um areas they're going to put you in remedial courses before you can even begin to start taking courses for credit for your major and so here we have

081remediation rates across okcps and surrounding districts for the past couple years well up until 2022 [Music] remediation rates are important because they do tell us how well our students who are going to college are prepared for it because coming into college and then finding out that you can't take courses that count um and yet you have to pay for remedial cour work is very difficult for students so these data are really helpful for us to track and see where our students are and we can see that broken out by school as well and we also want to highlight what subject they are most taking those remedial courses in um so we have it broken down by reading English and math and I want to point out um excuse me all schools are the highest percentages

082of remediation rates across all the schools are in math except Star Spencer their highest is in English I just thought that was an interesting variation just do a quick scroll through here intentional all righty and that does it for our postsecondary opportunities any questions before I move on to our graduation Pages yeah oh yes the batteries okay so just for clarification post high school plans this is remediation is that whether they went in twoyear or four year correct yes that is any um first time freshman entering a two or four year um college or university um that we can track um if they go outside the state this does not include that um but yes and you may not know the answer to this you probably do but what do we do with the students

083that may have a fifth year that stay in Finish High School are they just included on the next year of freshman students they're in different cohorts so so you have your graduating class but you could take five or six years but you stay within your cohort you stay within your cohort and I don't believe I that's actually a great question that I can double check with Maryann about um but I don't believe these results are broken out by cohort so it's just whatever year that that firsttime freshman entered entered college or university and it's only looking at those those who enter immediately in the fall after graduation not those who who maybe wait a year to start college okay they just track it based on those who enter immediately following graduation all righty so we're

084going to go back to our game or education is killing it come on oh wait no no no no all right it's okay if we don't get to this one in time I thought I would have more time um we got last year we got an F on our graduation indicator um on the state report card and that was with a 72% 4-year graduation rate this is a similar question with post-secondary opportunities what do you think our 4-year graduation rate would have had to have been in order to move from an F to a d which is up one grade [Music] level oh my God would have had to have been 83.1% which is significantly higher I would say and that kids you a d on the report card come on so it's interesting to

085see just how different and perhaps manageable the increases were from a letter grade between post-secondary opportunities which we could probably easily get from a c to a b were things to say the same from last year versus what we would have had to do for a graduation rate just to get it up to a d you here we go come on so our first page here just focuses on official graduation rates um reported and here we can see the district total and by school for the past few school years that are available and again we break these down by a number of different demographic groups so I have a question do they differentiate I mean so putam Heights or we looked at Emerson is there any differentiation and I'm the question I'm trying to ask

086is so like if a kid has an IEP and they have to miss school to go to a therapy appointment there's a wer you can fill out is there anything that we do in the graduation in alternative schools that will allow that to look differently no just literally curious same standard all right and that actually reminds me I do want to point out that this is set to cohort graduation year 2020 3 not on this I'm going to scroll down a little bit on the ones that aren't by year this one for example is one year um it's set to cohort graduation year 2023 for the fouryear graduation rate you can um change that to four five six year depending on what you're trying to do um and different cohort years as well and here

087I do want to point out you can see quite a few missing priority groups here that is because we are not able to download data from the state um when priority groups or any other demographic groups have less than 10 students um and I'm not sure what everybody's familiarity is with priority groups but our number one priority group that or number one and two priority groups that most of the district um is absorbed into is special ed and econ dis or or E economically disadvantaged so that's why you see mostly those appearing here and may I share once you are identified in one of the groups you no longer move to the next group so if if you are identified in special ed that's where you stop uh if you then are identified um economically

088disadvantaged that's where you stop and so as you go through it's not and or that's the group you stop so when you see African-American or black students number four those are black students who are not elll not economically disadvantaged and not special a it cuz once you hit a group they're in order of count and that's it m so here in the dashboard those priority group number they're numbered for you there um and I believe in the glossery right that was provided to you this evening that is explained for anybody who isn't familiar with priority groups and how those work in the dashboard we provide the results by that but we also then provide them by um racial ethnic groups right each each group by itself special ed um and English Learners and and all

089of the other demographic categories so the rest of this page is just showing you by different demographic groups all right before we get to our next page time for another question true or false the high school course area that had the highest Pass rates last year was computer technology course is what do you think you too and that is false we actually had the lowest Pass rates in in our computer technology courses the highest was World language courses and that transitions me to the dashboard page showing core course Pass rates and course Pass rates aren't factored into our state report card calculations but if you want to get to the root of Are We graduating students you got to start with the course level so here are our core course Pass rates broken down by

090subject you can also select a different school and great band as well which I want to point out because middle school students do appear here for seventh and eighth grade students that are taking High School level courses um in math World languages and computer Technologies and you can also see it broken down by course type as well whether that be regular our honors preap and is which is um our preparing for our International baloria classes or our AP and IB courses and again our world languages was the highest last year and computer Technologies was the lowest and here you can see across the past few years available including last semester um of this school year which are going to be higher so far than every other previous year just because only one semester has happened

091so far um you can see Trends across years and you can also look at that by grade if you want to see what grades are excelling most in which subjects can also look at by school which Again by Middle School we're capturing our most high achieving middle schoolers who are taking those High School level courses which is why the Pass rates are so high across this 100% Mark as well as by high school and I know I'm going through it pretty fast um I'm going to go ahead skip demographic groups for now but I this is another one of those views that anybody at the district level accessing this can absolutely do a DAT a deep dive into whatever demographic group school grade that they want and now towards the bottom of the page we

092can see individual courses by the subject area which is very diving deep into the data might not be particularly useful if you're looking at the district as a whole but perhaps site level leaders principles counselors um even teachers would want to look at how does my course compare to different um schools for example so we have every course every core course at the high school level broken down um by Pass rates and it is set to default um school year 2024 but you can change that to any year you want to look at yeah and every course is by year as well and I also want to point out that we do include English language development courses which are for our elll students um these do not count towards English credit for graduation they count

093generally as electives but we want to get our elll students from these ELD classes onto the English level credit so I think it's important to look at how our elll students are doing in their classes and again we have by specific course I'm going to Breeze through this a little bit I'm just going to give you a brief overview of all the course um level views that we have um but here all our math courses quite a bit including some that might not necessarily count for mathematics credit towards graduation for example Intermediate Algebra um for our college prep work ready students which is the main pathway that students are going on towards graduation um this counts as an elective as well as math enhancement which is kind of like one of those remedial courses um

094that you take before you go on to one of the Core Mathematics courses and again you can see by course type and by year and it's like that for every subject I'm going to focus on science just a little bit here um because it's a little bit of a different view our Sciences are broken up between life science physical science and Earth space science courses and this is 2024 pass rate so for example life science courses the pass rate for 2024 was 80% let's say I want to see how that compares or how 2023 compares to 2024 so I'm going to select 2023 and you can see these figures at the bottom it was 9% higher pass rate in 2023 as compared to 2024 for our life science courses so these Widgets or these data

095points are specifically meant for comparison between years all righty I think it goes like that all the way through social studies um computer technology and World languages for the sake of time I'm going to hello okay sorry um I'm going to skip it unless anybody wants to see something particular um does anybody have any questions or particular data points they want to look on do you want to ask her to look no okay okay all righty so back to our game little preface for this next question as well um part of what we was so difficult about crafting a graduation um dashboard was determining what do we want and how are we going to Define um what status a student is on towards graduation so we had conversations with um department leaders lots of workshopping

096and we came up with different statuses um on track in danger and off track um and there are a lot of that goes into those statuses but a brief definition I'll go over real quick before we get to the next question here we go so our onrack students are those students that have taken the required courses and assessments by the necessary grade level such as taking English one in nth grade and are enrolled in in semester 1 or to be enrolled in for semester 2 the courses that they need to be enrolled in to continue being on track in the next grade level we want to enter students in the next grade level as on track as possible and ultimately graduate in four years according to the requirements of a student spe specified pathway um

097and for those that aren't familiar with Pathways um the alternate pathway is for our um how intellectually disabled students that have been specified as alternate pathway students everybody else is typically on the college prep work ready track um their graduation requirements are a little bit different both requiring 23 units required to graduate um our end danger students not necessarily off track we don't want to flag it with the big red off track but they're in danger of falling behind if they don't complete a certain course by a certain grade level for example if an 11th grade student hasn't completed a physical activity course yet they still have time in the 12th grade to take that course but we want to flag that student as in danger so the council potentially knows we need to get

098you enrolled in a physical activity course and then off track big red caps letters um not having taken the required courses or assessments by the necessary grade level or not being enrolled or planned to be enrolled in what you need to be in order to enter the next grade level is on track and without intervention um these students will not graduate in four years so with those definitions of those statuses in mind going ask some next question what percent of okcps high schoolers Grade 9 through 12 do you think are currently on track for graduation it is 63% and I know that seems scary I don't mean it to be scary there's so many things that go into determining what a student is on track for graduation um and many of those students could either

099be in danger not necessarily off track if a student is currently failing a course they would be marked as off track and this is updated weekly we get them back passing the course we get them back on track for graduation this is more so as a warning system rather than a negative label on a student so these statuses can change weekly this dashboard that she's showing you um is a district and school level dashboard we also are doing the exact same thing with the six kpis for a student level dashboard that will just be accessible to principals teachers counselors they'll be able to look up the exact student see all of this information about that student in one place so that they can catch those kinds of things earlier we don't want students to fall

100through the cracks and find out when they're in 12th grade they're missing several things um and so they'll be able to see that and I think you're going to show them a little bit but we're getting close I know we have a hard stop so yep you need us to stop at 7:25 I need you to get to the good part so they can ask questions and we can adjourn at 7:30 all righty well then I know exactly what to show you here we have some stats at a glance just indicating um some areas of interest um 16% of OKC PS high school students have failed one or more core courses and they haven't made it up and they aren't planned to be making it up um the average student is in danger off track

101in one of the six subject area course requirements this is filterable at the school level some schools you can see the average student is off track in zero some you can see three or four um and there are other requirements for graduation a lot of acronyms being thrown out which are available on the glossery sheet online um 86% of seniors haven't completed one or more of the other requirements for graduation and I think I'm going to skip some of these overview statistics because they'll be available on the student level dashboard that I'll show you in just a second I'm going to skip down to our view of the other requirements where we can see if it loads as a whole what our district and what students at what grade level have completed the assessments that

102they need to be taken um so here we have our CPR training um at what grade level that's getting done typically by senior year our personal financial literacy training which is a component of our civics class that students are are required to take for graduation um and our naturalization assessment um our ccra assessments which include our English and math act tests as well as an additional Science and History test and IAP which is individual career and academic planning um it's just a series of online assessments and um goal planning workshops that students take online and they're expected to do one each year to continue developing their goals so we can see throughout the years how students are doing on that as well as our FAFSA um our federal student aid forms that students are required

103to complete so this is especially useful at the counselor level and I'm going to go ahead and switch over to a really really brief pre preview of our student level dashboard um which is what our counselors and principes will be able to see if they want to really narrow in on a specific um group of students whether that be I'm going to filter for off trck students and print a list of every off trck student and go one by one and get them back on track or if I'm individually counseling a single student I can filter by their student ID um so here's again those statuses we have on track plus and minus at the student level um it's just differentiating between on track plus is those students who take the ideal path way meaning

104they do everything at the earliest possible opportunity um our counselors they expressed interest in wanting to know yeah we're doing it but we don't want to be doing it at the last minute we want to have our students in an English math social studies and um science course every single year at the earliest possible opportunity so what a counselor will be able to see potentially we will give them access to their school so this is a district level overview but um you will have access to your school you able be able to see um your graduation statuses at the school level their Pathways as well as their core course failure rates and we can see that by subject so you can see who's on track in English math science um as well as life skills

105and career Readiness which is for those alternate pathway kids um they are required to take two life skills and two career Readiness courses and you can see they are the most off trck group just because it seems like those students aren't taking their life skills and career Readiness courses and one of the last parts of this demonstration these are fake students who I named after my favorite clue characters Clue the board game um but here I have an on trck student an endanger student and an off track student so just very briefly I'm going to go through those students and why they're on track or off track this will take me about 2 minutes so I'm a counselor I see that Colonel Mustard is off track why is Colonel Mustard off track I'm going to

106go ahead and input the colonel student ID and you can also see what um other requirements he's taken and this is an 11th grade student so they don't necessarily need to have all these other requirements completed yet but this is very useful for me as a counselor a hypothetical counselor I am not a counselor but um so we can see every single one of the courses the student is in we can see their on track in English because they have English 1 through three here they're on track excuse me they are on track in math because they have three um math courses one of which they are currently enrolled in they're on track in science because they've taken a biology and they're currently enrolled in a physical science oh big red they are off track

107in social studies why they did not pass Civics which is you need to have basically social studies every year because you need four social studies courses and you can see they failed US history so um I did anonymize the student data but there would be a warning popping up here saying this student has failed a course and they are not enrolled to make it up referring to the civics class um so each student is going to have warnings pop up here I apologize for not popping up right now um but that is just an example of what a counselor would be able to see and there's also a way that they can print every single one of that students warnings so I want to see student ID number three what is every area that they're

108on and off track in I'll export that and I'll have a list so you can just go through and check off by subject level one by one so currently our counselors are keeping track of this using paper pencil um and so we've had a lot of positive feedback from them we are training them this Thursday afternoon on using that student level dashboard okay and that concludes my presentation does anybody have any questions yes oh I think it's working now yeah um just making sure that this will also be able to keep track of citizenship test and and what other test they what is it called it was yeah it was up there I think okay if you scroll down to other requirements we'll be able to see exactly what assessments and so Finance would be

109that too okay this is finance and I can that's actually a good suggestion perhaps I should put the full name instead of the acronym here I thought of that yes you did full credit and Dr pulk actually actually suggested last week that we also upload on the icat portal students input their career interests and what skills they might already have that can contribute towards a career that's going to be input as well so when a counselor is meeting one-on-one with a student and they see what courses they may or may not be failing I see you're interested in law and criminal justice let's see how I can tailor your schedule towards that and get you to success that way I want to say a special thank you to the pr team Dr Smith's leadership Emily

110designed this herself and So within this short amount of time please note this is our beginning uh but I am floored in regards of the data at the fingertips not only of our principles but our counselors but also our students in order for them to make correct decisions in regards of class schedules with that I'm going to say a very special thank you to um former board member vs uh for being in the room I would be remissed if I did not say a very special thank you in regards of dashboards she probably said those words or that uh compound word every board meeting and was very serious in regards of please note um your work has not gone in vain and with that board Lewis do we got a thumbs up on the dashboards

111all right there we go okay all right um it is pretty close to time is there anything pressing that anybody has a question to ask yes yes um so just noting that correlation is not causation so we have all this District data what are we going to do with it okay I thought we're going to graduate kids all right okay anyone else okay I will make a motion to adjourn is there a second second okay call for the vote please all in favor say I I any oppos say n hearing none the motion carries the board is adjurned thank you everyone great job te