570 likes | 587 Views
WinDEM – Entering Data Part 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. Instrument Preparation.
E N D
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
Instrument Preparation Codebook Adaptation Data Entry and Verification Data Entry and Verification Test Administration Data Submission Receiving Material Sampling and Preparing Test Administration Scoring
Data Entry and Verification Complete Student Information Enter Questionnaire Data Enter Achievement and Reliability Data
Student Questionnaire Data File • Contain responses to questionnaire • Student Responses (2) Student Questionnaire Data File • Should contain one record for each COMPLETED questionnaire
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
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
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
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
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
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
Survey Instrument Variables • Identification variables • Indicator variables • Survey instrument variables
Sequence in Questionnaire Files 10010101 270 Example: Student Questionnaire 111 10010101 270 3 Student Questionnaire
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
WinDEM – New Data File Create new data file (for the first time) from a codebook!
WinDEM – New Data File Codebook (*.sdb) Data File (*.dbf) Extension *.sdb
WinDEM – New Data File Now the new data file is ready for data entry!
WinDEM – Open Data File Extension *.dbf
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
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
Entering Categorical Questions • Note: In the Main Survey questionnaires you will find codes printed next to the checkboxes. • Example:
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
Entering Occupation Data Car Dealer Sells Mercedes Benz
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
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
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
Entering Occupation Data - Puncher Press Enter
Entering Occupation Data - Puncher Coding Module Entry Form pops up
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
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
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
Entering Occupation Data - Coder Sort records Expand/collapse fields
Entering Occupation Data - Coder Filled automatically Non-editable fields Navigate by TAB key
Entering Occupation Data - Coder Student ID Mother/Father Job Title Job Description ISCO-88 Code ISCO-88 Description
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
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
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
Missing Codes Omitted 9, 99, 999, ... Not Administered 8, 98, 998, ... Invalid 7,97,997,... Default 6, 96, 996, ...
Omitted Codes – I • Omitted response (9,99,999,…) • Non-response Enter 9
Omitted Codes – II • Omitted response (9,99,999,…) • Non-response • Questionnaire not completed at all Do not enter record in WinDEM.
Omitted Codes – III • Omitted response (9,99,999,…) • Non-response • Questionnaire not completed • Question not applicable for filter-dependent questions
Filter-Dependent Questions Do you support any political party? => Filter question Enter 2 If yes, how strong? => Dependent question Enter 9
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
Required Information • Required information on student level Student Tracking Form (columns 9 - 14) • Student Questionnaire