1 / 53

WinDEM – Entering Data Part 1

WinDEM – Entering Data Part 1. Table of Content. 1 Introduction 2 Sequence of Variables 3 WinDEM Data Entry Editor 4 Entering Data 5 Material Needed for Data Entry 6 Example: Entering Student Regional Module Data 7 Hands-On Training: Entering Data. 2. Instrument Preparation.

liliha
Download Presentation

WinDEM – Entering Data Part 1

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. WinDEM – Entering Data Part 1

  2. Table of Content 1 Introduction 2 Sequence of Variables 3 WinDEM Data Entry Editor 4 Entering Data 5 Material Needed for Data Entry 6 Example: Entering Student Regional Module Data 7 Hands-On Training: Entering Data 2

  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 3

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

  5. Questionnaire Data Files • Contain responses to questionnaires • Principal Responses  School Questionnaire Data File • Teacher Responses  Teacher Questionnaire Data File • Student Responses (1)  Regional Module Questionnaire Data File • Student Responses (2)  Student Questionnaire Data File • Should contain one record for each COMPLETED questionnaire Will be covered in Entering Data Part 2 5

  6. Table of Content 1 Introduction 2 Sequence of Variables 3 WinDEM Data Entry Editor 4 Entering Data 5 Material Needed for Data Entry 6 Example: Entering Student Regional Module Data 7 Hands-On Training: Entering Data 6

  7. Identification Variables – I • Identification variables In all files: IDPUNCH – 3 digits, identifies the key puncher 333 111 444 222 7

  8. Identification Variables – II • Identification variables In all files: Unique ID – depending on file type IDSCHOOL – 4 digits, school questionnaire data file IDTEACH – 6 digits, teacher questionnaire data file IDSTUD – 8 digits, all student data files IDCHECK – 3 digits, in combination with unique ID Facilitates linkage between WinW3S and WinDEM with CheckSum Procedure 8

  9. Linkage between WinW3S & WinDEM Within-School Sampling Data Entry Tracking Form Information Instrument Information WinW3S WinDEM ICGxxxM2.DBF Will be merged later at the IEA DPC ITGxxxM2.DBF ISGxxxM2.DBF ISAxxxM2.DBF ISRxxxM2.DBF ISExxxM2.DBF MICSxxx2.mdb ISLxxxM2.DBF ISSxxxM2.DBF ISOxxxM2.MDB 9

  10. Linkage between WinW3S & WinDEM • Advantages: • Tracking form information is only entered in WinW3S • Instrument information is entered only in WinDEM • No double entry of hierarchical identification codes is necessary • No empty instruments need to be entered in WinDEM • ... is ensured by introducing the • CheckSum procedure • (WinW3S Linkcheck) Reduces mispunches, time, and costs 10

  11. CheckSum Procedure • CheckSum is created for each unique identification code (ID) • CheckSum is printed on all labels and tracking forms produced by WinW3S • WinDEM accepts unique IDs only in combination with corresponding CheckSum 11

  12. CheckSum Procedure Data Entry Within-School Sampling Student ID: 10010101 CheckSum: 270 WinDEM WinW3S Correct Student ID: 10010102 CheckSum: 270 Student ID: 10020101 CheckSum: 271 Mispunched 13

  13. Indicator Variables – I • Identification variables • Indicator variables In all files: CHECK01, CHECK02,…, CHECKn – 1 digit, avoid column shifts – Only entering blank space is allowed – Appear - When transition is made between ID variables and TOKEN01 variables - At the end of every odd numbered page and at the end of the questionnaire 14

  14. Indicator Variables – II • Identification variables • Indicator variables In all files: 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 – Appear after CHECK01 variable and before survey instrument variables 15

  15. Survey Instrument Variables • Identification variables • Indicator variables • Survey instrument variables 16

  16. Sequence in Questionnaire Files 10010101 270 Example: Student Regional Module 111 10010101 270 3 Student Regional Module 17

  17. Table of Content 1 Introduction 2 Sequence of Variables 3 WinDEM Data Entry Editor 4 Entering Data 5 Material Needed for Data Entry 6 Example: Entering Student Regional Module Data 7 Hands-On Training: Entering Data 18

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

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

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

  21. WinDEM – Open Data File 22

  22. WinDEM – Open Data File Extension *.dbf 23

  23. Data Entry Editor – Main Entry ID Block 24

  24. Data Entry Editor – Main Entry Entered Values Variable Labels Question Location Variable Names 25

  25. Data Entry Editor – Main Entry Current Value Labels Current Question Location Current Entered Value 26

  26. Data Entry Editor – Table Entry 27

  27. Data Entry Editor – Table Entry 28

  28. Table of Content 1 Introduction 2 Sequence of Variables 3 WinDEM Data Entry Editor 4 Entering Data 5 Material Needed for Data Entry 6 Example: Entering Student Regional Module Data 7 Hands-On Training: Entering Data 29

  29. Coding Categorical Questions Enter 1 Enter 2 Enter 3 • 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 • … ... 30

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

  31. Coding Non-Categorical Questions • Key punchers shall be able to enter the data the easiest way possible: • For non-categorical questions – enter response value 24 Enter 24 12 Enter 12 32

  32. 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 33

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

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

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

  36. Invalid Codes Enter 97 Enter 97 • Invalid response (7,97,997,…) • Invalid response 37

  37. Not Administered Codes • Not administered (8,98,998,…) • Question (or page) was misprinted (or missing) in the questionnaire Enter 98 38

  38. Table of Content 1 Introduction 2 Sequence of Variables 3 WinDEM Data Entry Editor 4 Entering Data 5 Material Needed for Data Entry 6 Example: Entering Student Regional Module Data 7 Hands-On Training: Entering Data 39

  39. Required Information • Required information on school level • School Tracking Form (column O) or  WinW3S Report • School Questionnaire • Required information on teacher level Teacher Tracking Form (column 5) • Teacher Questionnaire • Required information on student level  Student Tracking Form (columns 8 - 13) • Student Booklets and Questionnaires 40

  40. Records to be Entered in WinDEM • All WinDEM data files should contain one record for each COMPLETED questionnaire and booklet. • Questionnaires and booklets that have been left blank should NOT be entered in WinDEM. 41

  41. Availability of Student Data No Record to be created in WinDEM Tom participated but was excluded Student Name Exclusion Booklet Participation Status Test Quest RM Tom 2 3 E E E 42

  42. Availability of Student Data No Record to be created in WinDEM Tina had no parental permission Student Name Exclusion Booklet Participation Status Test Quest RM Tina 4 R P P P 43

  43. Availability of Student Data No Record to be created in WinDEM Jeff was absent in sessions Student Name Exclusion Booklet Participation Status Test Quest RM Jeff 5 A A A 44

  44. Availability of Student Data No Record to be created in WinDEM Mark left school permanently Student Name Exclusion Booklet Participation Status Test Quest RM Mark 6 NA NA NA 45

  45. Availability of Student Data Enter in WinDEM Maria participated in sessions Student Name Exclusion Booklet Participation Status Test Quest RM Maria 2 R C C C 46

  46. Table of Content 1 Introduction 2 Sequence of Variables 3 WinDEM Data Entry Editor 4 Entering Data 5 Material Needed for Data Entry 6 Example: Entering Student Regional Module Data 7 Hands-On Training: Entering Data 47

  47. Show WinDEM Example – I • Start WinDEM • Create European Module Questionnaire data file from codebook file ISEDEUM2.sdb D:\Seminar Examples\4_Work_WinDem\ISEDEUM2.sdb 48

  48. Show WinDEM Example – II • Enter... 1. Student label information 2. Student EU Module data 49

  49. Table of Content 1 Introduction 2 Sequence of Variables 3 WinDEM Data Entry Editor 4 Entering Data 5 Material Needed for Data Entry 6 Example: Entering Student Regional Module Data 7 Hands-On Training: Entering Data 50

  50. 60 min Hands-On Training • What you will need:  Survey Tracking Forms • European Module Questionnaire (Tab10) • School Questionnaires (Tab8) • Teacher Questionnaire (Tab9) • Codebooks in • What you will have to do: • Start WinDEM (Start  Programs  IEA  WinDEM_ICCS09_MS WinDEM_ICCS09_MS) • Create data files from corresponding codebooks (WinDEM menu FILE  NEW DATA FILE) • Enter data of questionnaire labels and questionnaires D:\Seminar Examples\4_Work_WinDem Login: user / bird 51

More Related