LCAP REPORTING JOURNEY MICHAEL HART E COORDINA TO

LCAP REPORTING JOURNEY MICHAEL HART E COORDINA TO R, SI S MURRIETA VAL LE Y US D MAY 16 , 20 17

Topics WHAT LCAP ? YE AR 0 – 20 14/15 YE AR 1 – 2 0 15/16 RE EXA MINATION YE AR 2 – 20 16/17 YE AR 3 – 2017/18 YE AR 4 – 20 18/19

What LCAP? • LCAP (Local Control Accountability Plan) is a three-year, district level plan which addresses State priorities and local priorities. • The plan describes the school district’s key goals for students as well as the specific actions (with expenditures) the district will take to achieve the goals and the means (metrics) used to measure progress. • It is a critical component of the LCFF which must be updated annually.

Year 0 – 2014/15 • First year gathering data for the LCAP • Several personnel changes in key areas of Ed Services and Technology • What are the metrics and where can we find the data? • 47 Metrics

Year 0 – 2014/15, Lessons • This is a LOT of work • We need to create a solid plan for gathering and reporting this information • This may require additional resources

Year 1 – 2015/16 • Aggressive reporting schedule • Each month reports were prepared for BOE • Throughout the year there were 108 reports presented on 47 different metrics at 10 Board meetings • Worked with existing vendors to improve their reporting capabilities • SIS • Assessment • Created detailed instructions for school sites to pull data from both the SIS and Assessment systems • Contracted with two additional vendors to provide reports and analysis

Poll

Year 1 – 2015/16, Lessons • Data sets are complex • In particular, breaking information out into Student Groups is challenging • Results varied depending on who pulled the data and what system was used • Access to information was not readily available (ex. NSLP) • Training vendors on systems and data was time consuming • Vendor progress towards updating LCAP reporting capabilities was less than desired

Reexamination Questions • What are we doing? • Why are we doing it? • How can we do better?

Year 2 – 2016/17, Lessons Successful implementation of a BI/A solution will require: Accurate • Steadfast upper management support • Good data quality • A solid implementation plan developed by both Ed Services and IT personnel Accessible Reproducible

Year 2 – 2016/17 • Temporarily reduced BOE reporting • Removed one vendor, reduced responsibilities of another • Abandoned efforts to increase SIS and Assessment vendors LCAP reporting abilities • Hired new SIS Tech to support report building / auditing • Doubled data entry training efforts • Provided training and extended NSLP access to Administrative teams • Embarked upon long term BI/A (Business Intelligence and Analytics) strategy • Program implementation (6 months) • Built District Admin LCAP reports • Assembled Site Administration Focus Group

Year 2 – 2016/17, Program Enrollment Report

Year 2 – 2016/17, 4 Year Cohort Report

Year 2 – 2016/17, Projected Growth by School

Year 2 – 2016/17, 4 Year Projections

Year 2 – 2016/17, CA Dashboard 5 x 5’s at Scale

Year 3 – 2017/18 • Build and deploy Site Administration reports • Assemble Focus Group for Teacher level reports • Train key personnel at DSC on self service report building utilizing existing data sources

Year 4 – 2018/19 • Build and deploy Teacher level reports • Train Site Administration innovators on self service report building utilizing existing data sources • Reassess and determine future needs for District Admin LCAP reporting

In Conclusion Numbers have an important story to tell. They rely on you to give them a clear and convincing voice. - Stephen Few The art and practice of visualizing data is becoming ever more important in bridging the human-computer gap to mediate analytical insight in a meaningful way. - Edd Dumbill