Michigan Questionnaire c ga Quest o a e Documentation System - - PowerPoint PPT Presentation

michigan questionnaire c ga quest o a e documentation
SMART_READER_LITE
LIVE PREVIEW

Michigan Questionnaire c ga Quest o a e Documentation System - - PowerPoint PPT Presentation

Michigan Questionnaire c ga Quest o a e Documentation System (MQDS): A U A Users Perspective P i Heidi Guyer, Gina-Qian Cheung The 11th International Blaise Conference Annapolis, Maryland September 2007 MQDS Background MQDS


slide-1
SLIDE 1

Michigan Questionnaire c ga Quest o a e Documentation System (MQDS): A U ’ P i A User’s Perspective

Heidi Guyer, Gina-Qian Cheung The 11th International Blaise Conference Annapolis, Maryland September 2007

slide-2
SLIDE 2

MQDS Background MQDS Background

  • Goal: Develop a system used to generate

Goal: Develop a system used to generate questionnaires & codebooks from a Blaise data model / data set

  • Developed by the University of Michigan’s

Survey Research Center Survey Research Center

  • Development Period: 2003 – 2007
  • International Consortium of Users: 2006-

present p

slide-3
SLIDE 3

Main features of MQDS Main features of MQDS

Core Tools

  • Questionnaire Documentation
  • Codebook Documentation (from Blaise BDB or

( SAS data set) Additional Tools

  • XML Merge
  • Reapply Stylesheet
  • Blaise to SAS
  • SAS to XML
slide-4
SLIDE 4

Review Method Review Method

  • “Testing to robustness”

Testing to robustness

  • Testing Team identified
  • Testing plan developed
  • Testing plan developed
  • Bug Log developed

D t d l i d

  • Data models assigned
  • Group & Individual testing sessions
  • Solicit comments from internal users
  • Solicit comments from Consortium users
slide-5
SLIDE 5

Overall Impressions p

  • Key Features

y

– Flexibility – Supports multiple languages – Updated interface p

  • Pros

– Easy to install – Sample project provided – Updated and complete documentation – Format of output

  • Cons

– Limitations with large or complex data models

slide-6
SLIDE 6

Program Interface Program Interface

slide-7
SLIDE 7

Questionnaire Documentation Q

  • Key Features

O t t i RTF HTML – Output in RTF or HTML – Include hyperlinks and external lookup files

  • Pros

– Flexibility in formatting – User selects items displayed – Supports multiple languages – Hyperlinks can be used to include other files

  • Cons

– Some of the screens are confusing (stylesheet selection) g ( y ) – Default color of hyperlinks and interviewer instructions is the same – Inability to display logic for large or complex data models

slide-8
SLIDE 8

Questionnaire Documentation Questionnaire Documentation

slide-9
SLIDE 9

Questionnaire Documentation Questionnaire Documentation

slide-10
SLIDE 10

Questionnaire Documentation Questionnaire Documentation

English Spanish Tagalog Tagalog

slide-11
SLIDE 11

Codebook

  • Key Features

– Output in RTF or HTML – Output in RTF or HTML – Ability to generate a codebook from Blaise or SAS data set

  • Pros

Pros

– Flexibility in formatting – User selects items displayed – Supports multiple languages Supports multiple languages – Frequencies and descriptive statistics are displayed

  • Cons

– Same usability issues as with the Questionnaire Documentation – Inability to process extremely large data sets – Tool needed to confirm that all variables are included in the

  • utput

– Codeframes will not match output for recoded or newly created SAS variables

slide-12
SLIDE 12

Codebook Documentation

slide-13
SLIDE 13

Demonstration Demonstration

slide-14
SLIDE 14

Additional Tools

  • XML Merge
  • XML Merge
  • Reapply Stylesheet
  • Blaise to SAS
  • SAS to XML

All useful time saving tools! All useful, time-saving tools!

slide-15
SLIDE 15

Additional uses of MQDS Additional uses of MQDS

  • Can be used throughout the project

Can be used throughout the project lifecycle:

Instrument development and testing – Instrument development and testing – Documentation IRB submission – IRB submission – Training D i d t ll ti – During data collection – Post-data collection

slide-16
SLIDE 16

Additional uses of MQDS Additional uses of MQDS

  • Can be used for comparison purposes:

– Across waves of a longitudinal study – Across the same study in multiple languages – Across similar studies

slide-17
SLIDE 17

CPES Project CPES Project

  • Collaborative Psychiatric Epidemiology
  • Collaborative Psychiatric Epidemiology

Surveys (CPES)

Th NIMH t l h lth – Three NIMH mental health surveys

  • National Comorbidity Survey – Replication
  • National Survey of Latinos and Asian Americans
  • National Survey of Latinos and Asian Americans
  • National Survey of American Life
slide-18
SLIDE 18

CPES Project CPES Project

  • Primary goals:
  • Primary goals:

– Harmonize and merge multiple datasets Di i t f bli – Disseminate for public use

slide-19
SLIDE 19

Harmonization and Disclosure Analysis

D l i t t lk

  • Develop survey instrument crosswalk

– Link sections and questions – Evaluate questions for comparability – Re-code questions and re-link if required for harmonization

  • Merge datasets
  • Perform disclosure analysis

– Re-code and drop variables – Restricted use dataset will be available [soon] [ ]

  • Generate XML question metadata files (MQDS)

– Question text, response options, missing data codes, frequencies etc frequencies, etc.

slide-20
SLIDE 20

CPES Home Page Overview g

www.icpsr.umich.edu/CPES

slide-21
SLIDE 21

Interactive Documentation Interactive Documentation

slide-22
SLIDE 22

Interactive Documentation: Frequencies / Summary Stats

slide-23
SLIDE 23

Future Directions Future Directions

  • Investigate incorporation of Data

Investigate incorporation of Data Dissemination Initiative (DDI) v.3 recommendations recommendations.

  • PDF output
slide-24
SLIDE 24

Summary Summary

  • Useful tool for creating questionnaire and

Useful tool for creating questionnaire and data documentation

  • Primary drawbacks encountered with
  • Primary drawbacks encountered with

large, complex data sets

slide-25
SLIDE 25

Acknowledgments Acknowledgments

ISR-SRC-SRO Tricia Blanchard, Karl Dinkelmann, Eduardo Galván, Hemant Kannan, Peter Sparks ISR-SRC Health & Retirement Study, Panel Study of Income Dynamics Dynamics MQDS Consortium Members Mathematica Policy Research National Centre for Social Mathematica Policy Research, National Centre for Social Research, Statistics Canada, UMich Survey Research Center