WinDEM – Entering Data Part 2

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