Using the IEA IDB Analyzer II

1

Using the IEA IDB Analyzer II

Andrés Sandoval-Hernández – IEA DPC

Workshop on using PISA, PIAAC, TIMSS & PIRLS, TALIS datasets

Ispra, Italy-

2

•

1 part patience

•

1 part know-how

…and the IEA IDB Analyzer!

3

Table of contents

•

Percentages and means with PISA

•

Without PV’s

•

With PV’s

4

Immigration status and wealth

What is the percentage of native, first generation, and

second generation immigrant students and the mean of the

wealth index associated to each category?

IMMIG WEALTH

Variables of interest Native

First Generation Second Generation

5

What Do we Need to Do?

Analysis for IMMIG

•

Start the IDB Analyzer Analysis module using PISA_Merged.sav

under C:\EU_Workshop\Work

•

Countries in the merged data file:

–

Austria

–

Denmark

–

Netherlands

–

Slovak Republic

–

Spain

6

Analysis: Percentages and Means (PISA)

•

Analysis File:

C:\EU_Workshop\Work\PISA_Merged.sav

•

Analysis Type:

PISA age 15 (Using Student Weights)

•

Statistic Type: Percentages and Means

•

Plausible Value Option: None used

•

Grouping Variable CNT, IMMIG

•

Analysis Variable: WEALTH

7

IDB Analyzer: Percentages and Means

WEALTH W_FSTUWT Percentages and Means

Exclude Missing from Analysis

C:\EU_Workshop\Work\PISA_Merged.sav

C:\EU_Workshop\Work\Immig.*

CNT IMMIG PISA age 15 (Using Student Weights)

8

9

Outcome

•

As a result IDB Analyzer creates the following in the working

directory (C:\EU_Workshop\Work):

–

SPSS Syntax file – contains the syntax with the commands

–

SPSS Data file – contains statistics from the analysis

10

11

SPSS: Excel Output

Final student weight – contains estimates in

the population that belong to the groups

defined by the

classification variables (CNT, IMMIG)

12

SPSS: Excel Output

Weighted percentage of students for the groups defined by the

classification variables (CNT, IMMIG)

Standard error of the percentages

13 Standard deviation of the analysis variable

SPSS: Excel Output

14

SPSS: Excel Output

Standard error of the standard deviation

Percent of cases

within the group with missing values for the analysis variable

15

Table of contents

•

Percentages and means with PISA

•

Without PV’s

•

With PV’s

16

Immigration status and math achievement

What is the percentage of native, first generation, and

second generation immigrant students and the mean

achievement in math associated to each category?

IMMIG

PV1MATH01-05

Variables of interest

17

What Do we Need to Do?

Analysis for IMMIG

•

Start the IDB Analyzer Analysis module using PISA_Merged.sav

under C:\EU_Workshop\Work

•

Countries in the merged data file:

–

Austria

–

Denmark

–

Netherlands

–

Slovak Republic

–

Spain

18

Analysis: Percentages and Means with PV’s (PISA)

•

Analysis File:

C:\EU_Workshop\Work\PISA_Merged.sav

•

Analysis Type:

PISA age 15 (Using Student Weights)

•

Statistic Type: Percentages and Means

•

Plausible Value Option: Use PVs

•

Grouping Variable CNT, IMMIG

•

Plausible Value: PV1MATH01-05

•

Weighting variable: W_FSTUWT

19

IDB Analyzer: Percentages and Means with PV’s

PVMATH01-05 W_FSTUWT Percentages and Means

Use PV‘s

Exclude Missing from Analysis

C:\EU_Workshop\Work\PISA_Merged.sav

C:\EU_Workshop\Work\Immig_math.*

CNT IMMIG PISA age 15 (Using Student Weights)

20

21

Outcome

•

As a result IDB Analyzer creates the following in the working

directory (C:\EU_Workshop\Work):

–

SPSS Syntax file – contains the syntax with the commands

–

SPSS Data file – contains statistics from the analysis

22

23

SPSS: Excel Output

Final student weight – contains estimates in

the population that belong to the groups

defined by the

classification variables (CNT, IMMIG)

24

SPSS: Excel Output

Weighted percentage of students for the groups defined by the

classification variables (CNT, IMMIG)

Standard error of the percentages

25 Standard deviation of the analysis variable

SPSS: Excel Output

26

Table of contents

•

Percentages and means with PISA

•

Without PV’s

•

With PV’s

27

Standards in evaluations for assessing student

progress

How frequently do teachers work together with other

teachers at the same school to ensure common standards

in evaluations for assessing student progress?

TT2G33F

Teacher Questionnaire, Q33-F, p. 19 Variable of

28

What Do we Need to Do?

Analysis for TT2G33F

•

Start the IDB Analyzer Analysis module using TALIS_Merged

under C:\EU_Workshop\Work

•

Countries in the merged data file:

–

Denmark

–

Netherlands

–

Italy

–

Slovak Republic

–

Spain

29

Analysis: Percentages only (TALIS)

•

Analysis File:

C:\EU_Workshop\Work\TALIS_Merged.sav

•

Analysis Type: TALIS 2013 Single Level Population (Using Teacher

Weights)

TALIS 2013 Single Level/Population (Using Teacher Weights)

•

Statistic Type: Percentages only

30

IDB Analyzer: Percentages only

IDCNTRY TT2G33F TCHWGT Percentages only

Exclude Missing from Analysis

C:\EU_Workshop\Work\TALIS_Merged.sav

C:\EU_Workshop\Work\A1WorksWithTeachers.*

31

SPSS: Run the analysis

•

As a result IDB Analyzer creates SPSS Syntax and starts SPSS

•

In SPSS Syntax, highlight all and click on the Run button

32

Outcome

•

As a result IDB Analyzer creates the following in the working

directory (C:\EU_Workshop\Work):

–

SPSS Syntax file – contains the syntax with the commands

–

SPSS Data file – contains statistics from the analysis

33

34

SPSS: Excel Output

35

SPSS: Excel Output

Total teacher weight – contains estimates in the population that belong to the group defined by the classification variables

(IDCNTRY, TT2G33F)

Weighted percentage of teachers for the groups defined by the

classification variables (IDCNTRY, TT2G33F)

36

SPSS: Excel Output

error of

37

Any Questions?