Extracting "proper" questionnaires from CAPI surveys
Locked
Extracting "proper" questionnaires from CAPI surveys
 
|
Most major survey series these days use CAPI. This makes it daunting to produce the equivalent of a traditional questionnaire for use alongside the corresponding SPSS saved file, which itself is most likely generated automatically. Does anyone have any experience of extracting a traditional printed questionnaire from questionnaires in CAPI format? Of course this can be done tediously by copy/pasting CAPI questions and then editing down to a traditional format, but it’s possible that someone somewhere has had a shot at automating the process. For instance, here’s an example from the 2008 NORC General Social Survey, in which questionnaires are invariably constructed directly in CAPI format: (See: http://www3.norc.org/NR/rdonlyres/21403184-C064-4E20-944F-0CFCABC9BB5E/1306/BALLOT1XSECEnglish.pdf page 86) HAPPY: Categorical (Single) Taken all together, how would you say things are these days--would you say that you are very happy, {response to happytxt1}, or not too happy? Categories: {very_happy} Very happy {pretty_happy} {response to happytxt2} {not_too_happy} Not too happy {dontknow} DON'T KNOW {refused} REFUSED HEALTH: Categorical (Single) Would you say your own health, in general, is excellent, good, fair, or poor? Categories: {excellent} Excellent {good} Good {fair} Fair {poor} Poor {dontknow} DON'T KNOW {refused} REFUSED For tutorial purposes, it would be easier if there were a version which looked like this (in which the variable names are used in lieu of non-existent question numbers): [HAPPY] Taken all together, how would you say things are these days--would you say that you are very happy, pretty happy or not too happy? Very happy 1 Pretty happy 2 Not too happy 3 DON'T KNOW 8 REFUSED 9 [HEALTH] Would you say your own health, in general, is excellent, good, fair, or poor? Excellent 1 Good 2 Fair 3 Poor 4 DON'T KNOW 8 REFUSED 9 It would be even easier if variables in the SPSS file were in the same order as in the questionnaire, but they are in alphabetical order. Creating documents that tally with the SPSS file or modifying the SPSS file to tally with the questionnaire is yet another headache, but that’s another story. At least Jon Peck’s Python code to change the labels, all in UPPER CASE, to Mixed case makes the file easier on the eye and the output more suitable for reporting.. (see: http://surveyresearch.weebly.com/uploads/2/9/9/8/2998485/notes_on_full_gss_2008.pdf John F Hall (Mr) [Retired academic survey researcher] Email: [hidden email] Website: www.surveyresearch.weebly.com SPSS start page: : : www.surveyresearch.weebly.com/1-survey-analysis-workshop |
Re: Extracting "proper" questionnaires from CAPI surveys
|
John, We take the opposite approach. We believe in surveys written directly into a survey tool typically aren't well enough constructed without a document that is signed off first. After the Microsoft Word document has been approved, we move it into the survey tool. Some tools allow a direct import, if the document is formatted appropriately, but so far we haven't found this to be perfect usually needing quite a bit of extra manipulation. So we first copy into Excel, where we do some of the formatting (some look and feel, and some response codes in, plus instructions to the programmer). Then it's a fairly simple matter of editing questions in the survey tool. As the import capabilities of the survey tools improve, will probably look at increasing the automation with more macros, so that we can both reduce effort and improve quality control. Mike _________________________________________________________________________ From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of John F Hall Most major survey series these days use CAPI. This makes it daunting to produce the equivalent of a traditional questionnaire for use alongside the corresponding SPSS saved file, which itself is most likely generated automatically. Does anyone have any experience of extracting a traditional printed questionnaire from questionnaires in CAPI format? Of course this can be done tediously by copy/pasting CAPI questions and then editing down to a traditional format, but it’s possible that someone somewhere has had a shot at automating the process. For instance, here’s an example from the 2008 NORC General Social Survey, in which questionnaires are invariably constructed directly in CAPI format: (See: http://www3.norc.org/NR/rdonlyres/21403184-C064-4E20-944F-0CFCABC9BB5E/1306/BALLOT1XSECEnglish.pdf page 86) HAPPY: Categorical (Single) Taken all together, how would you say things are these days--would you say that you are very happy, {response to happytxt1}, or not too happy? Categories: {very_happy} Very happy {pretty_happy} {response to happytxt2} {not_too_happy} Not too happy {dontknow} DON'T KNOW {refused} REFUSED HEALTH: Categorical (Single) Would you say your own health, in general, is excellent, good, fair, or poor? Categories: {excellent} Excellent {good} Good {fair} Fair {poor} Poor {dontknow} DON'T KNOW {refused} REFUSED For tutorial purposes, it would be easier if there were a version which looked like this (in which the variable names are used in lieu of non-existent question numbers): [HAPPY] Taken all together, how would you say things are these days--would you say that you are very happy, pretty happy or not too happy? Very happy 1 Pretty happy 2 Not too happy 3 DON'T KNOW 8 REFUSED 9 [HEALTH] Would you say your own health, in general, is excellent, good, fair, or poor? Excellent 1 Good 2 Fair 3 Poor 4 DON'T KNOW 8 REFUSED 9 It would be even easier if variables in the SPSS file were in the same order as in the questionnaire, but they are in alphabetical order. Creating documents that tally with the SPSS file or modifying the SPSS file to tally with the questionnaire is yet another headache, but that’s another story. At least Jon Peck’s Python code to change the labels, all in UPPER CASE, to Mixed case makes the file easier on the eye and the output more suitable for reporting.. (see: http://surveyresearch.weebly.com/uploads/2/9/9/8/2998485/notes_on_full_gss_2008.pdf John F Hall (Mr) [Retired academic survey researcher] Email: [hidden email] Website: www.surveyresearch.weebly.com SPSS start page: : : www.surveyresearch.weebly.com/1-survey-analysis-workshop |
| Free forum by Nabble | Edit this page |