Transcript Main title
Making the Most of Your Composite Computational Spreadsheet: Tools from California
Presenters
University of California at Berkeley Center for Social Services Research Barbara Needell, MSW, PhD Principal Investigator [email protected]
Daniel Webster, PhD Project Director [email protected]
William Dawson, MSW Project Manager [email protected]
California Department of Social Services Linda Hockman, Chief Outcomes & Accountability Bureau [email protected]
Debbie Williams, MSW, Chief Child Welfare Data Analysis Bureau [email protected]
Introduction
• Outcomes & Accountability System in California • Infrastructure • Tools from the Computational Spreadsheet • Case Study
California-Child and Family Services Review Outcomes & Accountability System
History
• AB636 • Shift from compliance to continuous quality improvement – outcome driven and partnering • Aligns with the federal CFSR • Four step process – Peer Quality Case Review (PQCR) – County Self Assessment (CSA) – System Improvement Plan (SIP) – Quarterly Data Reports
C-CFSR Process
Peer Quality Case Review PQCR System Improvement Plan Quarterly Data Reports County Self Assessment
Quarterly Contacts
• Continuous quality improvement • Co-joint analysis of county performance – tie data to practice • Review of quarterly data and SIP progress • Technical assistance
California’s Data System
• CWS/CMS: – Became operational in 1997 – Contains over 200 data tables – More than 400 data entry screens – Has about 19,500 users who turnover frequently – Archived 1,303,998 cases and 5,389,330 referrals – Currently Active: 116,585 cases and 33,721 referrals
Making Analysis Transparent
• Accessible to All – Uniform across state – Continuous feedback loop – Drill down to details – Easily accessible • Quality Improvement – Local staff must be able to question/challenge analysis, and get an explanation – Should be viewed as a learning process, not punitive – Continually test data.
– Communicate with users
Differentiated Roles
• Collaboration: – – California Department of Social Services Center for Social Services Research, UC Berkeley – – Children’s Research Center Statewide Data Committee • • CDSS & UC Berkeley share responsibility for child welfare reporting, analysis, and official publications – – http://cssr.berkeley.edu/ucb_childwelfare/ http://www.dss.cahwnet.gov/research/default.htm
State and UC Berkeley data reports – – – Public Aggregated data, providing drill down to county level Dynamic stratification