windem entering data part 2 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
WinDEM – Entering Data Part 2 PowerPoint Presentation
Download Presentation
WinDEM – Entering Data Part 2

Loading in 2 Seconds...

play fullscreen
1 / 57
adolph

WinDEM – Entering Data Part 2 - PowerPoint PPT Presentation

0 Views
Download Presentation
WinDEM – Entering Data Part 2
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. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. WinDEM – Entering Data Part 2

  2. Table of Content 1 Introduction 2 Sequence of variables 3 Questionnaire Data Files 4 Entering data 5 Materials needed for data entry 6 Example of entering Student Questionnaire Data 7 Hands-on Training – Student Questionnaire Data

  3. Instrument Preparation Codebook Adaptation Data Entry and Verification Data Entry and Verification Test Administration Data Submission Receiving Material Sampling and Preparing Test Administration Scoring

  4. Data Entry and Verification Complete Student Information Enter Questionnaire Data Enter Achievement and Reliability Data

  5. Student Questionnaire Data File • Contain responses to questionnaire • Student Responses (2)  Student Questionnaire Data File • Should contain one record for each COMPLETED questionnaire

  6. Table of Content 1 Introduction 2 Sequence of variables 3 Questionnaire Data Files 4 Entering data 5 Materials needed for data entry 6 Example of entering Student Questionnaire Data 7 Hands-on Training – Student Questionnaire Data

  7. Identification Variables – I • Identification variables IDPUNCH – 3 digits, identifies the key puncher Identification Variables – II • Identification variables Unique ID – depending on file type IDSTUD – 8 digits, all student data files IDCHECK – 3 digits, in combination with unique ID

  8. Indicator Variables – I • Identification variables • Indicator variables CHECK01, CHECK02,…, CHECKn – 1 digit, avoid column shifts Indicator Variables – II TOKEN01 – 1 digit, indicates availability of data – 3 codes possible 1 – Instrument available, but empty 2 – Instrument not available or lost 3 – Instrument available with responses

  9. Indicator Variables – III • Identification variables • Occupational Variables Type 1 Student Questionnaire Puncher Coder Enters text data using CodingModule Entry Form in WinDEM Enters ISCO-88 code into Coding Module Database

  10. Indicator Variables – III • Identification variables • Occupational Variables Type 2 Student Questionnaire Coder Puncher In the presentation and in seminar examples only entering Occupational Variables Type 1 will be considered Writes down ISCO-88 code in the Student Questionnaire Enters ISCO-88 code directly in WinDEM

  11. Indicator Variables – III • Identification variables • Occupational Variables Type 1 or 2 • Type 1 – shown in the international codebook • Type 2 – hidden in the international codebook Each country decides which type to use unhiding it in the codebook and hiding the other one In this presentation and in seminar examples only entering Occupational Variables Type 1 will be considered

  12. Survey Instrument Variables • Identification variables • Indicator variables • Survey instrument variables

  13. Sequence in Questionnaire Files 10010101 270 Example: Student Questionnaire 111 10010101 270 3 Student Questionnaire

  14. Table of Content 1 Introduction 2 Sequence of variables 3 Questionnaire Data Files 4 Entering data 5 Materials needed for data entry 6 Example of entering Student Questionnaire Data 7 Hands-on Training – Student Questionnaire Data

  15. WinDEM – New Data File Create new data file (for the first time) from a codebook!

  16. WinDEM – New Data File Codebook (*.sdb) Data File (*.dbf) Extension *.sdb

  17. WinDEM – New Data File Now the new data file is ready for data entry!

  18. WinDEM – Open Data File

  19. WinDEM – Open Data File Extension *.dbf

  20. Table of Content 1 Introduction 2 Sequence of variables 3 Questionnaire Data Files 4 Entering data 5 Materials needed for data entry 6 Example of entering Student Questionnaire Data 7 Hands-on Training – Student Questionnaire Data

  21. Entering Categorical Questions • Key punchers shall be able to enter the data the easiest way possible: • For categorical questions – enter checked category • First option  Enter 1 • Second option  Enter 2 • … Enter 1 Enter 2

  22. Entering Categorical Questions • Note: In the Main Survey questionnaires you will find codes printed next to the checkboxes. • Example:

  23. Entering Non-Categorical Questions • Key punchers shall be able to enter the data the easiest way possible: • For non-categorical questions – enter response value 93 Enter 93

  24. Entering Occupation Data Car Dealer Sells Mercedes Benz

  25. Entering Occupation Data • Puncher • Uses Coding Module Entry Form in WinDEM • Enters • Job Title • Job Description • Coder • Using Coding Module Database • Enters ISCO-88 code

  26. Data goes in Entering Occupation Data • Prerequisites • Codebook, Data File and Occupational Module Database must be in the same folder Puncher Enters text data through WinDEM Data Entry Module ISOxxxM2.mdb Coder Enters ISCO-88 code

  27. Data goes in Data goes in Entering Occupation Data - Puncher Puncher Puncher Enters text data through WinDEM Data Entry Module Enters text data through WinDEM Data Entry Module ISOxxxM2.mdb ISOxxxM2.mdb Coder Enters ISCO-88 code

  28. Entering Occupation Data - Puncher Press Enter

  29. Entering Occupation Data - Puncher Coding Module Entry Form pops up

  30. Enter the Job Title Enter the Job Description Entering Occupation Data - Puncher Car Dealer Press Enter to go to the next field Sells Mercedez Benz

  31. Entering Occupation Data - Puncher Car Dealer Press Enter to exit Coding Module Entry Form Press Enter to go to the next field Sells Mercedez Benz

  32. Data goes in Data goes in Entering Occupation Data - Coder Puncher Puncher Enters text data through WinDEM Data Entry Module Enters text data through WinDEM Data Entry Module ISOxxxM2.mdb ISOxxxM2.mdb Coder Coder Enters ISCO-88 code Enters ISCO-88 code

  33. Entering Occupation Data - Coder Sort records Expand/collapse fields

  34. Entering Occupation Data - Coder

  35. Entering Occupation Data - Coder

  36. Entering Occupation Data - Coder Filled automatically Non-editable fields Navigate by TAB key

  37. Entering Occupation Data - Coder Student ID Mother/Father Job Title Job Description ISCO-88 Code ISCO-88 Description

  38. Entering Occupation Data - Coder

  39. Entering Occupation Data - Coder

  40. Entering Occupation Data - Coder

  41. Entering Occupation Data - Coder 4100 OFFICE CLERKS [Incl. Clerk nfs, Government Office Clerk nfs] Fill the ISCO-88 code ISCO-88 description is filled authomatically

  42. Entering Occupation Data - Coder 4100 OFFICE CLERKS [Incl. Clerk nfs, Government Office Clerk nfs] Hit TAB key to go to ISCO-88 field for the next student

  43. Default Codes • Data entry staff has to distinguish between “Missing Values” or “Valid Values” codes Default 6, 96, 996, ... • Defined in WinDEM codebooks • Default codes have to be replaced during data entry

  44. Missing Codes Omitted 9, 99, 999, ... Not Administered 8, 98, 998, ... Invalid 7,97,997,... Default 6, 96, 996, ...

  45. Omitted Codes – I • Omitted response (9,99,999,…) • Non-response Enter 9

  46. Omitted Codes – II • Omitted response (9,99,999,…) • Non-response • Questionnaire not completed at all Do not enter record in WinDEM.

  47. Omitted Codes – III • Omitted response (9,99,999,…) • Non-response • Questionnaire not completed • Question not applicable for filter-dependent questions

  48. Filter-Dependent Questions Do you support any political party? => Filter question Enter 2 If yes, how strong? => Dependent question Enter 9

  49. Table of Content 1 Introduction 2 Sequence of variables 3 Questionnaire Data Files 4 Entering data 5 Materials needed for data entry 6 Example of entering Student Questionnaire Data 7 Hands-on Training – Student Questionnaire Data

  50. Required Information • Required information on student level  Student Tracking Form (columns 9 - 14) • Student Questionnaire