1 / 44

Third Group Training Course in Application of Information and

Third Group Training Course in Application of Information and Communications Technology to Production and Dissemination of Official Statistics (06 th May’07 – 12 Jul’07) Compare Various Types of Interviewing & Data Capturing Methods By Group - II Ms. Rashmi Sharma, India

linus
Download Presentation

Third Group Training Course in Application of Information and

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. Third Group Training Course in Application of Information and Communications Technology to Production and Dissemination of Official Statistics (06th May’07 – 12 Jul’07) Compare Various Types of Interviewing & Data Capturing Methods By Group - II Ms. Rashmi Sharma, India Mst. Maksuda Shilpi, Bangladesh Ms. Aminath Shirmeen, Maldives Mr. Amadou Tidiane Diallo, Senegal

  2. Presentation Overview • Introduction - Amadou • Project Activity Plan - Shiru • Questionnaire - Shiru • Software Used - Rashmi • Software Development - Rashmi • Data Collection - Shilpi • Tabulation - Shilpi • Data Analysis & Conclusions - Amadou • References - Amadou • Data Dissemination Including web – Rashmi • Action Plan - Shiru, Rashmi, Shilpi, Amadou • Q & A on project and A/P - All

  3. Introduction • Target group is TIC participants • Sample concerned with 54 individuals • Sample distribution:21 males and 33 females, drawn from all 5 regions • Response rate is 96 %

  4. Project Activity Plan and the QuestionnaireShiru

  5. Activity Plan • Activity plan • Meetings • Choosing the Topic • Design questionnaire • Develop Data entry programme • Data Collection and Data Entry • Data cleaning and Analysis • Finalize tables • Dissemination in different format

  6. Meetings • We had total 7 meetings. • We held our meetings in TIC lobby and one meeting during normal project class at SIAP. • We changed our survey topic 3 times. • 5th meeting – We finalized survey topic. • Meetings

  7. Data Collection • We used 4 methods of data collection: • PAPI • CAPI • CATI • Electronic – method using email

  8. Factors considered during questionnaire design • Flow of questions • Multiple answers • Skip questions

  9. Questionnaire • Design Questionnaire in excel format. • Total no. of Questions = 15 • No. of Multiple questions = 3 • No. of Skip questions = 2 • Questionnaire • PAPI and CATI (questionnaire1) • Electronic (questionnaire2)

  10. Software Development Rashmi

  11. Software Used • CSPro • STATA & SPSS • Microsoft Access • Microsoft Excel • Microsoft Word • Microsoft FrontPage • Xerver

  12. Data Entry Application Data entry app s/w developed in : CSPro, Access, Excel Data file specification • Number of Variables = 37 - Numeric variables =35 • Alphanumeric variables = 2 • Number of record type = 1

  13. Created Date Entry Application • Created Dictionary: All items in CSPro dictionary • Created Identification : Identification, Id, 2 • Identify Records and variable, sub items : (Person) • Identify variable label: Exact Question Text • Identify variable name: Q<question number> • Size of variable (according to question) • Type of variable (according to question) • Identify Values (according to question) • Fix number of occurrences (according default) Click here

  14. Data Dictionary

  15. Value Set

  16. CSPro Data Capture Screen

  17. Logic

  18. CAPIQuestion pop-up responses box

  19. MS Excel • Macro Recording • Data save in ASCII form • Align the data according to CSPro Data Dictionary format

  20. MS ACCESS

  21. Data Integration CSPro PAPI CSPro DATA File ACCESS CAPI Concatenation (CSPro) CSPro CAPI EXCEL EMAIL Output Data CSPro CATI Input Data

  22. Data Integration • Integration of the different data files format • The integrated file is handed over to all group members

  23. Data Collection and Tabulation Mst. Maksuda Shilpi

  24. Methods and Name of Collector • PAPI Methods by Shilpi • CAPI Methods by Rashmi • CATI Methods by Amadou • Electronic Methods by Shiru

  25. Methods and Number of Cases • 10 Cases by PAPI Methods • 8 Cases by Electronic Methods • 19 Cases by CAPI Methods • 17 Cases by CATI Methods • 2 Non-responses in Electronic Methods

  26. Data Integration • Using CSPro data entry application all these files are concatenated.

  27. Tabulation • We made tabulation by CSPro Tabulation Application. • No. of Table=9 • No. of Frequency Table=5 • No. of Cross Table=4 • Demonstration of tabulation application

  28. Table 1: Percentage Distribution of Method Used

  29. Table 2: Percentage Distribution of Time to fill Questionnaire

  30. Amadou

  31. Data Analysis & Conclusions • Analysis is done under STATA, SPSS & Excel • Interpretation of Results • Survey findings

  32. Tables converted from CSPro into SPSS and Stata • Converted data copied and pasted into Excel and data ploted

  33. 53.13 % of respondents completed the questionnaires through CAPI within 5 minutes • 21.88 % completed the questionnaire by PAPI within the same time interval.

  34. 15.63 % (third of CATI proportion) filled in the questionnaires within the first time interval • The proportion goes further down with CATI (9.38 %).

  35. 15.63 % (third of CATI proportion) filled in the questionnaire by Electronic within the first time interval • The proportion goes further down with CATI (9.38 %).

  36. 15.63 % (third of CATI proportion) filled in the questionnaire by Electronic within the first time interval • The proportion goes further down with CATI (9.38 %).

  37. 8 respondents in 10, whose first language is not English, completed the questionnaire between 5 and 11 minutes • 2 in 10, whose first language is English, completed the questionnaire within the same interval

  38. 63.6 % of female respondents completed the questionnaire within 5 minutes • 52.4 % of male respondents completed the questionnaire within the same time interval

  39. Descriptive statistics under Stata • Method used: • Mean = 2.42; Standard deviation:0.96; Minimum value=1 and Maximum value=4

  40. Regression analysis under STATA • About 20 % of the variation of Time used is explained by the model

  41. Survey Findings • CAPI is more effective than PAPI, CATI or E-mail in terms of time • Women did better than men in filling in the questionnaire • Non-English speaking respondents did better than English-speaking respondents • Familiarity with IT Tools is higher among Asian respondents than those from other regions • Time to fill in the questionnaire is longer with non-English speaking respondents through CATI

  42. References • 1. Demographic and Health Surveys-Phase II (1990), Institute for Resource Development. • 2. Designing Surveys, A Guide to Decisions and Procedures (1995), Ronald Czaja and Johny Blair. • 3. U.S. Bureau of the Census. (1992) 1990 Census of Population: General Population Characteristics—North Carolina. Washington, DC: U.S. Government Printing Office. (1990 CP-1-35). • 4. SIAP HANDOUTS, 2007 • 5. JICA-TIC Survey 2007 conducted by participants of the Fifth Group Training Course in Modules on Core Official Statistics

  43. Data Dissemination • CD • Web • Hard Copy

  44. THANK YOU

More Related