data management seminar, 9-12th july 2007, hamburg 1 iccs 2009 data files and variables
DESCRIPTION
Data Management Seminar, 9-12th July 2007, Hamburg 3 Content File Naming Convention Variable Naming Convention Question LocationTRANSCRIPT
Data Management Seminar, 9-12th July 2007, Hamburg1
ICCS 2009Data Files and Variables
Data Management Seminar, 9-12th July 2007, Hamburg2
Content
File Naming ConventionVariable Naming ConventionQuestion Location
Data Management Seminar, 9-12th July 2007, Hamburg3
Content
File Naming ConventionVariable Naming ConventionQuestion Location
Data Management Seminar, 9-12th July 2007, Hamburg4
File Naming Convention
I S G ICS F 2 Target grade
Respondent Level Type of data
Placeholder for Country Code/
National Context Survey
Study Phase
Study Cycle
ISGICSF2 - International Student Questionnaire File(Field Trial)
Data Management Seminar, 9-12th July 2007, Hamburg5
File Naming Convention
Category Meaning1. Target Grade I = International target grade (usually 8th grade)
J = Additional grade (9th grade) 2. Respondent Level S = Student T = Teacher C = School N =
National 3. Type of Data A = Achievement G = General (Questionnaire)
E = European Module L = Latin American ModuleR = Reliability
4. Placeholder for Country Code/ National Context Survey
ICS = International AUT = Austria DEU = Germany …NC1 = National Contexts Survey Stage 1NC2 = National Contexts Survey Stage 2
5. Study Phase P = Pilot F = Field TrialC = Main Survey + National Contexts Survey Civic and Citizenship Education
6. Study Cycle 2 = Second Cycle (ICCS 2009)
Data Management Seminar, 9-12th July 2007, Hamburg6
File Naming Convention
Data File Target Grade
Resp. Level Type
Student Achievement I S AStudent Questionnaire I S GStudent Reliability I S REuropean Module Student Questionnaire I S ELatin American Module Student Questionnaire
I S L
Teacher Questionnaire
I T G
School Questionnaire I C GNational Contexts Survey
I N G
Data Management Seminar, 9-12th July 2007, Hamburg7
File Naming Examples
ISAAUTF2 ICCS 2009 Student Achievement File - Austria - Field Trial (Target Grade)
JSGNORF2 ICCS 2009 Student Questionnaire File - Norway - Field Trial (Additional Grade)
ITGGTMC2 ICCS 2009 Teacher Questionnaire File -Guatemala - Main Survey
Data Management Seminar, 9-12th July 2007, Hamburg8
Content
File Naming ConventionVariable Naming ConventionQuestion Location
Data Management Seminar, 9-12th July 2007, Hamburg9
Digit forMulti Part Items
I S B A 02 B 1 Reference
Level
Respondent Level
Form /Cycle of Study
Block Question Number in Block
Digit forMulti Part Question
ISBA02B1 = International Student Questionnaire, ‘About You’ block, 2nd Question of Block, Dimension B (second Item), Part 1
Variables in Questionnaires
Data Management Seminar, 9-12th July 2007, Hamburg10
Category Meaning1. Reference level I = Internationally administered
E = European ModuleL = Latin American ModuleX = National ContextN = Nationally administered
2. Respondent Level / National Context Survey
S = Student T = Teacher C = SchoolA = Phase 1 B = Phase 2
3. Form / Cycle of Study
Student QuestionnaireA = Form A B = Form B C = Form C
School/Teacher/Regional Module/Nat. Context & Main Survey2 = 2nd cycle (ICCS 2009)
Variables in Questionnaires
Data Management Seminar, 9-12th July 2007, Hamburg11
Category Meaning4. Block Student Questionnaire
A = About you B = Your home and your familyC = Your activities D = Your schoolE = Citizens and society F = You and societyG = Rights and responsibilities H = Institutions and societyI = Participating in society J = You and religion
School/Teacher/Regional Module/Nat. Context & Main SurveyG = Background P = Perception T = Test (RM only)
5. Question Number in Block
01, 02, 03...
6. Digit for Multi Part Items A, B, C …7. Digit for Multi Part Items 1, 2, 3 ... or A, B, C ...
Variables in Questionnaires
Data Management Seminar, 9-12th July 2007, Hamburg12
Questionnaire Variable Examples
ISAD01A - ICCS 2009 Student Questionnaire- Block D ‘Your School’- Question 1 in Block- Part A
LS2T05C - ICCS 2009 Latin American Module Student Questionnaire
- Test Block- Question 5 in Block- Part C (3rd Item)
Data Management Seminar, 9-12th July 2007, Hamburg13
Questionnaire Variable Examples
NT2G13A2 - National Variable in Teacher Questionnaire File
- Question 13- Part 2 (2nd Item)
ISBG01A2 - Student Questionnaire- Form B- Block G “Rights and responsibilities”- Question 1- Item A- Format 2 without “don’t know”
option
Data Management Seminar, 9-12th July 2007, Hamburg14
C E 2 03 M 1 General Study
Content
Test Booklet/Final Codebooks for
International DatabaseCycle of Study when Item was
first administered
Unique ItemUnit Identifier
Item Numberwithin Unit
Item Type
CE203M1 = International Student Achievement Booklet E (Booklet 5), Unit “03”, Multiple-choice Item, Item 1 of Unit
Variables in Achievement Files
Data Management Seminar, 9-12th July 2007, Hamburg15
Variables in Achievement files Category Meaning
1. General Study Content
C = Civic and Citizenship Education
2. Test Booklet/
Final Codebook for International Database
A = 1 B = 2 C = 3 D = 4 E = 5 F = 6
I – International CoreE – European ModuleL – Latin American Module
3. Cycle of Study when item was first administered
1 = 1st cycle (CIVED 1999)2 = 2nd cycle (ICCS 2009)
4. Unique Item Unit Identifier
01, 02, 03 ...
5. Item Type M = Multiple-choice ItemC = Constructed ItemO = Open-ended Item
6. Item Number within Unit
1, 2, 3 ...
Data Management Seminar, 9-12th July 2007, Hamburg16
Questionnaire Variable Examples
CA214O2 - International Student Achievement Booklet A
(Booklet 1)- Unit 14- Open-ended Format- 2nd Item
CC105M2 - CivED 1999 Student Achievement Booklet C (Booklet 3)
- CivED 1999 Unit 05- Multiple-choice Format- 2nd Item
Data Management Seminar, 9-12th July 2007, Hamburg17
Content
File Naming ConventionVariable Naming ConventionQuestion Location
Data Management Seminar, 9-12th July 2007, Hamburg18
Variables in Achievement files:
Category Meaning1. Reference Level I = Internationally administered
E = European ModuleL = Latin American ModuleX = National Context
2. Dash -3. Test Booklet 1 = Booklet 1
2 = Booklet 24. Dash -5. Question Number in Instrument
01, 02, 03...
6. Digit for Multi Part Items
A, B, C ...
Question Location in Achievement Files
Data Management Seminar, 9-12th July 2007, Hamburg19
I-2-01B - Internationally administered- Test Booklet 2- Question 1 (in instrument)- Item B
Question Location in Achievement Files
Data Management Seminar, 9-12th July 2007, Hamburg20
Variables in Teacher, School and Regional Module Questionnaire (and NCQ):
Category Meaning1. Reference Level I = Internationally administered
E = European ModuleL = Latin American ModuleX = National Context
2. Dash -3. Questionnaire SQ = Student Questionnaire (Regional Module)
TQ = Teacher QuestionnaireCQ = School QuestionnaireNQ = National Context Questionnaire
4. Dash -5. Question Number in Instrument
01, 02, 03...
6. Digit for Multi Part Items
A, B, C ...
Question Location in Questionnaires
Data Management Seminar, 9-12th July 2007, Hamburg21
I-CQ-13C - Internationally administered- School Questionnaire- Question 13 (in instrument)- Item C
E-SQ-07 - European Module- Student Questionnaire- Question 7 (in instrument)- [no further level, e.g. different parts
in item]
Question Location in Questionnaires
Data Management Seminar, 9-12th July 2007, Hamburg22
Variables in International Student Questionnaire: Category Meaning
1. Reference Level I = Internationally administeredE = European ModuleL = Latin American ModuleX = National Context
2. Dash -3. Questionnaire SQ = Student Questionnaire4. Dash -5. Form A = Form A
B = Form BC = Form C
6. Dash -7. Question Number in Instrument
01, 02, 03...
8. Digit for Multi Part Items
A, B, C ...
Question Location in Questionnaires
Data Management Seminar, 9-12th July 2007, Hamburg23
I-SQ-B-13C - Internationally administered- Student Questionnaire- Form B- Question 13 (in instrument)- Item C
Question Location in Questionnaires
Data Management Seminar, 9-12th July 2007, Hamburg24
Thank you for your attention!