Using Administrative Data in Analyzing Program Outcomes

National Association for Welfare Research and Statistics (NAWRS)

2013 Workshop – Chicago, Illinois

Don Winstead – Don Winstead Consulting, LLC

Email:

Website: WinsteadConsulting.com

Electronic copy of this document, the NAWRS Power Point and a “How To” guide to making your own Excel Spinner Reports is available at WinsteadConsulting.com/ documents

Links to Examples Used in Workshop and Other Resources

Examples of Excel “Spinner” Reports

Workforce Reports:

Link: http://www.floridajobs.org/workforce-board-resources/program-monitoring-and-reports/state-program-reports/welfare-transition-program-reports

Suggested Reports / Content
Weekly Report / A weekly report on engagement with activity summaries by Workforce Region.
Welfare Transition Participation Rate / An annual report of TANF Work Participation Rate by Workforce Region.

Link: http://www.floridajobs.org/workforce-board-resources/program-monitoring-and-reports/state-program-reports

Suggested Report / Content
Monthly Management Report / A monthly compilation of 34 WIA, TANF and Wagner-Peyser performance measures by Workforce Region

Economic Self-Sufficiency Trend Reports

Link: http://www.dcf.state.fl.us/programs/access/StandardDataReports.asp

Suggested Reports / Content
Caseload / A monthly report of caseload and benefit issuance trends with data available from January 1993.
Flash Points / A report of TANF caseload trends and characteristics with data available from July 2000.

Child Welfare Performance Reports

Link: http://centerforchildwelfare.fmhi.usf.edu/DataReports/TrendReports.shtml

Suggested Reports / Content
Child Welfare Performance Measures Trend Report / A quarterly report with Child Welfare CFSR measures by Region, Circuit, County and CBC Area
Child Welfare Services Trend Report / A monthly report of child welfare caseload data on removals, adoptions, out-of-home care data by Region, Circuit, County and CBC Area.
Child Protective Investigation Trend Report / A monthly report of information on child protective investigations by Region, Circuit, County and CBC Area.

How to Learn to Make Spinner Charts

Link: http://www.winsteadconsulting.com/documents.html

Suggested File / Content
NAWRS 2013 Spinner How To Example / An excel spreadsheet with a simple spinner example and “how to:” instructions.

Example of Scorecard

http://www.myflfamilies.com/about-us/planning-performance-measures/cbc-scorecard

Other suggested resources and links

Anyone interested in displaying statistical data should watch videos by Hans Rosling. His website is gapminder.org

Videos are available there and also on Ted.com

Start with the 2005 video, “The best stats you've ever seen” and the 2006 video, “New insights on poverty”.

Make your own Motion Charts

You can make “Motion Charts” in Google Docs. Select “Create Spreadsheet.” Put geographic entity in first column, date in second column and numeric data in third and fourth columns. Select “Insert Chart/ Motion Chart”.