1 / 20

Michigan Questionnaire Documentation System (MQDS)

MQDS is a system designed to extract metadata from Blaise survey instruments and render it as an XML document using the DDI standard.

pstearns
Download Presentation

Michigan Questionnaire Documentation System (MQDS)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Michigan Questionnaire Documentation System (MQDS) Gina Cheung University of Michigan, Survey Research Center North American DDI Conference April 2-3, 2013

  2. Agenda • MQDS Background • MQDS current design • Demo

  3. Survey Lifecycle http://ccsg.isr.umich.edu/

  4. What is MQDS? • The Michigan Questionnaire Documentation System (MQDS) was designed to extract comprehensive metadata from Blaise survey instruments and render it as an eXtended Markup Language (XML) document using the Data Documentation Initiative (DDI) standard.

  5. MQDS Development Timeline

  6. MQDS V4: Import-Export-Transform (IET) Process Model SQL Server / SQL Server Express Relational DB XML (DDI 3) User specifies output files (location, Language/locale, XML output options, etc.) Blaise Datamodel (BMI) User specifies input files (location, file type, etc.) Blaise Database (BDB) Questionnaire Other File Types (e.g. SAS, SPSS, etc) Codebook Database connection settings User specifies stylesheet selection criteria, type of output desired (html, rtf, pdf), etc. DDI 3 elements not in *.bmi

  7. MQDS Main Menu

  8. 1. Import Relational DB SQL Server / SQL Server Express Blaise Datamodel (BMI) Blaise Database (BDB) Database connection settings Other File Types (e.g. SAS, SPSS, etc) User specifies Instrument Data & Metadata Match Blaise Language Settings to ISO Language/locale DDI 3 elements not in *.bmi via Profiles

  9. 2. Export Relational Db SQL Server / SQL Server Express User specifies DDI V3 Instance: output location, Fill names or resolved, formatted or unformatted, languages, etc. XML (DDI 3.1)

  10. 3. Transform XML (DDI 3) User specifies DDI file to transform: output location, stylesheet selection criteria, output desired html, rtf, or pdf, etc. Questionnaire Codebook

  11. Style-sheet Modification

  12. HTML output example

  13. Codebook Output Example

  14. MQDS Summary Three Process Three Products Relational DB SQL Server / SQL Server Express XML (DDI 3.1) Questionnaire Codebook

  15. MQDS usage • Free to all Blaise community users • Questionnaire design • Questionnaire documentation • Quick data transformation (BDB format to SAS, SPASS or SQL DB format) • Creating interviewers’ training materials • Codebook with universe info • (CPES)

  16. MQDS Limitations • Complex Blaise questionnaire roster structure • Blaise alien router (external program) • Paradata • Not a tool for Survey life circle documentation yet….

  17. Where we are going… and DDI for… Mixed Mode Project Management } Metadata Mixed Mode Survey Management } Paradata WEB CATI } Decentralized CATI Ancillary Data Survey data Admin Data MAIL CAPI

  18. By the way, here is the “hot” topic in my world……. Data Collection Possibilities with Mobile Technologies Phone GPS Location Check in Link to online survey Bar code scanner Self administered survey app Social Data Capture Audio Recording/Oral Instructions or Training App based data collection SMS / MMS Bluetooth Email Visual Data Capture Reminders to complete via phone, email or SMS Accelerometer

  19. Thank you!Contact info:qianyang@umich.edu

More Related