Data Project
Data Project The Douglas County Cares Collaborative Data Project
Consider
Culture
Compute
Collaborate
Capacity
Collect
Culture ONE person approach to care • We serve the same person • The person owns their data • The person owns their outcome • The funding we receive is for the person
Culture
Capacity Context Right data, in the Right form, at the Right time, to the Right people
Capacity
Resources
Processes, Structure & Software
People Organizational Culture—beliefs and assumptions
Collect Ask It Once Principle • Knowledge Requirement: need to know how the information gets from whoever asks it to all the other places and people it needs to be. • • • • •
Collect
Who gathers what info? What information is gathered? When? Where does it go? How does it get to everyone who needs it?
Collect Ask It Once Principle • Other Requirements • A database and software system that is flexible enough to support your processes • Clear procedures (what is expected, when and by whom) • Training and Support for staff/volunteers • Data Monitoring
Collect
Collaborate
Means of matching
Fundamentals when consolidating data across systems
• • • •
Mary
m
Kesha
Mary
Mary
Mary
John
PPI info
=
Match
Deduplication… Collaborate
First name Last name SSN (at least last 4) Date of Birth
Consolidate
• Other HH members • Zipcode* • Internal IDs shared or entered
Collaborate Working with multiple partners
• Contract and MOUs • Release of Information • • • •
Who How long For what purpose Revocation
• Data Retention • Data Sharing
Collaborate
Compute Different data for different people…putting the system to work • Client • Presumptive Eligibility • Printing “Applications”
• Frontline Staff • Dashboard of what’s been done • Ease Access Case Notes
Compute
Compute Different data for different people…putting the system to work • Managers • Data Quality • Service Counts
• Directors/Senior Leadership • Outcome Summary • Self sufficiency matrix/scale improvements over time
• Funders • Reports for compliance (variety of formats and data); e.g. New CSBG Annual Report
Compute
Compute: Model to do Reporting Clients & HH Communities benefits
outcomes
service
Compute
Any Local System Producing data in the CSBG Data Standard
income
Module 3: Community Project Summary Module 4: Section C (demographics)
Module 3: Community Outcomes Module 4: Section A NPIs Module 4: Section B Service Counts
Case Study
Catholic Charities of Central Colorado Castle Rock Regional Office Consider
Culture
Compute
Collaborate
Capacity
Collect
Changing the Culture
Culture
Culture
Culture
Building Capacity
Capacity
Capacity
PROGRAM NAME SERVICE NAME AMOUNTS / UNIT SERVICE GROUP
SERVICE ITEM OUTCOME Capacity
Program Name ESL Intro ESL Level 1 ESL Level 2 ESL Level 3 ESL Level 4 Child Care
Capacity
Service Name
Units
ESL Classes
# Student Classroom Hours
Child Care # Child Care Sessions Session Hours
Service Group
Service Item
Outcome
Education – English Adult Language Class Services
Improved English Proficiency
Education – Child Services
Early Childhood Development
Improved Child Development
Risk Management!
Capacity
Data Collection
Collect
Collect
Client Benefits • One and done intake • Case manager intel • Smoother referrals
Collect
The Power of Collaboration
Collaborate
Computing the Benefits
Compute
“In God we trust, all others must bring data.” - W. Edwards Deming
Consider the Opportunities
Consider
Consider
Questions? Consider
Compute
Collabor ate
Culture
Capacity
Collect
Rand Clark Community of Care Navigator Douglas County 303-660-7460 [email protected]
Consider
Culture
Compute
Collaborate
Capacity
Collect
Culture ONE person approach to care • We serve the same person • The person owns their data • The person owns their outcome • The funding we receive is for the person
Culture
Capacity Context Right data, in the Right form, at the Right time, to the Right people
Capacity
Resources
Processes, Structure & Software
People Organizational Culture—beliefs and assumptions
Collect Ask It Once Principle • Knowledge Requirement: need to know how the information gets from whoever asks it to all the other places and people it needs to be. • • • • •
Collect
Who gathers what info? What information is gathered? When? Where does it go? How does it get to everyone who needs it?
Collect Ask It Once Principle • Other Requirements • A database and software system that is flexible enough to support your processes • Clear procedures (what is expected, when and by whom) • Training and Support for staff/volunteers • Data Monitoring
Collect
Collaborate
Means of matching
Fundamentals when consolidating data across systems
• • • •
Mary
m
Kesha
Mary
Mary
Mary
John
PPI info
=
Match
Deduplication… Collaborate
First name Last name SSN (at least last 4) Date of Birth
Consolidate
• Other HH members • Zipcode* • Internal IDs shared or entered
Collaborate Working with multiple partners
• Contract and MOUs • Release of Information • • • •
Who How long For what purpose Revocation
• Data Retention • Data Sharing
Collaborate
Compute Different data for different people…putting the system to work • Client • Presumptive Eligibility • Printing “Applications”
• Frontline Staff • Dashboard of what’s been done • Ease Access Case Notes
Compute
Compute Different data for different people…putting the system to work • Managers • Data Quality • Service Counts
• Directors/Senior Leadership • Outcome Summary • Self sufficiency matrix/scale improvements over time
• Funders • Reports for compliance (variety of formats and data); e.g. New CSBG Annual Report
Compute
Compute: Model to do Reporting Clients & HH Communities benefits
outcomes
service
Compute
Any Local System Producing data in the CSBG Data Standard
income
Module 3: Community Project Summary Module 4: Section C (demographics)
Module 3: Community Outcomes Module 4: Section A NPIs Module 4: Section B Service Counts
Case Study
Catholic Charities of Central Colorado Castle Rock Regional Office Consider
Culture
Compute
Collaborate
Capacity
Collect
Changing the Culture
Culture
Culture
Culture
Building Capacity
Capacity
Capacity
PROGRAM NAME SERVICE NAME AMOUNTS / UNIT SERVICE GROUP
SERVICE ITEM OUTCOME Capacity
Program Name ESL Intro ESL Level 1 ESL Level 2 ESL Level 3 ESL Level 4 Child Care
Capacity
Service Name
Units
ESL Classes
# Student Classroom Hours
Child Care # Child Care Sessions Session Hours
Service Group
Service Item
Outcome
Education – English Adult Language Class Services
Improved English Proficiency
Education – Child Services
Early Childhood Development
Improved Child Development
Risk Management!
Capacity
Data Collection
Collect
Collect
Client Benefits • One and done intake • Case manager intel • Smoother referrals
Collect
The Power of Collaboration
Collaborate
Computing the Benefits
Compute
“In God we trust, all others must bring data.” - W. Edwards Deming
Consider the Opportunities
Consider
Consider
Questions? Consider
Compute
Collabor ate
Culture
Capacity
Collect
Rand Clark Community of Care Navigator Douglas County 303-660-7460 [email protected]
