data management seminar, 9-12th july 2007, hamburg 1 iccs 2009 data files and variables

24
Data Management Seminar, 9-12th July 2007, Hamburg 1 ICCS 2009 Data Files and Variables

Upload: clementine-stevens

Post on 18-Jan-2018

218 views

Category:

Documents


0 download

DESCRIPTION

Data Management Seminar, 9-12th July 2007, Hamburg 3 Content File Naming Convention Variable Naming Convention Question Location

TRANSCRIPT

Page 1: Data Management Seminar, 9-12th July 2007, Hamburg 1 ICCS 2009 Data Files and Variables

Data Management Seminar, 9-12th July 2007, Hamburg1

ICCS 2009Data Files and Variables

Page 2: Data Management Seminar, 9-12th July 2007, Hamburg 1 ICCS 2009 Data Files and Variables

Data Management Seminar, 9-12th July 2007, Hamburg2

Content

File Naming ConventionVariable Naming ConventionQuestion Location

Page 3: Data Management Seminar, 9-12th July 2007, Hamburg 1 ICCS 2009 Data Files and Variables

Data Management Seminar, 9-12th July 2007, Hamburg3

Content

File Naming ConventionVariable Naming ConventionQuestion Location

Page 4: Data Management Seminar, 9-12th July 2007, Hamburg 1 ICCS 2009 Data Files and Variables

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)

Page 5: Data Management Seminar, 9-12th July 2007, Hamburg 1 ICCS 2009 Data Files and Variables

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)

Page 6: Data Management Seminar, 9-12th July 2007, Hamburg 1 ICCS 2009 Data Files and Variables

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

Page 7: Data Management Seminar, 9-12th July 2007, Hamburg 1 ICCS 2009 Data Files and Variables

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

Page 8: Data Management Seminar, 9-12th July 2007, Hamburg 1 ICCS 2009 Data Files and Variables

Data Management Seminar, 9-12th July 2007, Hamburg8

Content

File Naming ConventionVariable Naming ConventionQuestion Location

Page 9: Data Management Seminar, 9-12th July 2007, Hamburg 1 ICCS 2009 Data Files and Variables

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

Page 10: Data Management Seminar, 9-12th July 2007, Hamburg 1 ICCS 2009 Data Files and Variables

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

Page 11: Data Management Seminar, 9-12th July 2007, Hamburg 1 ICCS 2009 Data Files and Variables

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

Page 12: Data Management Seminar, 9-12th July 2007, Hamburg 1 ICCS 2009 Data Files and Variables

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)

Page 13: Data Management Seminar, 9-12th July 2007, Hamburg 1 ICCS 2009 Data Files and Variables

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

Page 14: Data Management Seminar, 9-12th July 2007, Hamburg 1 ICCS 2009 Data Files and Variables

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

Page 15: Data Management Seminar, 9-12th July 2007, Hamburg 1 ICCS 2009 Data Files and Variables

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

Page 16: Data Management Seminar, 9-12th July 2007, Hamburg 1 ICCS 2009 Data Files and Variables

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

Page 17: Data Management Seminar, 9-12th July 2007, Hamburg 1 ICCS 2009 Data Files and Variables

Data Management Seminar, 9-12th July 2007, Hamburg17

Content

File Naming ConventionVariable Naming ConventionQuestion Location

Page 18: Data Management Seminar, 9-12th July 2007, Hamburg 1 ICCS 2009 Data Files and Variables

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

Page 19: Data Management Seminar, 9-12th July 2007, Hamburg 1 ICCS 2009 Data Files and Variables

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

Page 20: Data Management Seminar, 9-12th July 2007, Hamburg 1 ICCS 2009 Data Files and Variables

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

Page 21: Data Management Seminar, 9-12th July 2007, Hamburg 1 ICCS 2009 Data Files and Variables

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

Page 22: Data Management Seminar, 9-12th July 2007, Hamburg 1 ICCS 2009 Data Files and Variables

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

Page 23: Data Management Seminar, 9-12th July 2007, Hamburg 1 ICCS 2009 Data Files and Variables

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

Page 24: Data Management Seminar, 9-12th July 2007, Hamburg 1 ICCS 2009 Data Files and Variables

Data Management Seminar, 9-12th July 2007, Hamburg24

Thank you for your attention!