140 likes | 287 Views
Living “Single” in a “Multi” Data Collection World. March 2010 Presentation to the FedCASIC Conference Steve Lehrfeld. Overview. Defining "multiple" terms Diagram a real example Mathematica’s “simple” solution to a complex problem. The Good Ol ’ Days. Simple Multi-mode. Survey.
E N D
Living “Single” in a “Multi” Data Collection World March 2010 Presentation to the FedCASIC Conference Steve Lehrfeld
Overview • Defining "multiple" terms • Diagram a real example • Mathematica’s “simple” solution to a complex problem
The Good Ol’ Days Simple Multi-mode Survey Sample list: Case #1 Survey Case #2 Survey Survey Survey Case #n Survey
Multi-Instrument Survey A Sample list: Case #1 Survey B Case #2 Survey A Survey B Survey A Case #n Survey B
Multi-Respondent Sample list: Survey Case #1 Respondent 1 Respondent 2 Survey Case #2 Respondent 1 Respondent 2 Survey Survey Survey Case #n Respondent 1 Respondent 2 Survey
Multi-Entity Sample list: Survey A Case #1 Survey B Case #1 Case #2 Survey A Survey B Case #2 Survey A Case #n
An “educational” example Principal Int Multi-Instrument School Principal Admin Admin Records Multi-Entity Classroom Observation Classroom #n Teacher Classroom #1 Teacher Teacher Interview Parent Interview Student #1 Parent Child Student #2 Parent Child Student #3 Parent Child Student #n Parent Child Multi-Mode Child Assess-ment Multi-Respondent
How we do it: Sample Management Another example: “Core” tables: Project “add-on” tables: Districts Cases States Schools Case Members Firms Classrooms/Teachers Addresses/ Phones/etc Instruments Employees Families
How we do it: Connected Systems Sample Management System: CATI CAWI Get Respondent User Login Finalize Data Finalize Transmit Scan Barcode ID CAPI Finalize & Transmit PAPI
How we do it: More Detail Sample Management: CATI COM / SQL Stored Proc Cases Get Next Case Get Latest Info User Logs In Get Latest Info CAWI Case Members Replication Finalize Case Finalize Case Finalize Case Interviewer Transmits Instruments Status Rules Update Status Finalize Case CAPI Finalize Case Addresses/ Phones/etc. Address Review Finalize Case Finalize Update Contact Info Receipting PAPI POET Scan Barcode ID
Example Report Multi-Instrument Multi-Respondent Multi-Mode
For More Information • Please contact: • slehrfeld@mathematica-mpr.com