ICCS 2009 IDB Seminar – Nov 24-26, 2010 – IEA DPC, Hamburg, Germany

Using the IEA IDB Analyzer to merge and analyze data

Table of content

Introduction to the IEA IDB AnalyzerInstallation processSelecting and merging dataHands-on training

Table of content

Introduction to the IEA IDB AnalyzerInstallation processSelecting and merging dataHands-on training

Introduction to IDB AnalyzerWHAT IT IS

A software program developed by the IEA Data Processing and Research Center to analyze the data from ICCS and other IEA surveysCalculates correct standard errors when conducting analysis with ICCSUses optimized algorithms for computing means, percentages and regressions

BONUS!Easy creation of data sets for use in SPSSMerging countries and/or data levelsSelection of analysis variables

What can it do?

For ICCS, compute percentages, means (and SD), correlations, and linear regressions – including their respective standard errorsAllows to analyze data calculating the correct standard errors using JRR (jackknife repeated replication)Enhanced SPSS and MS Excel output including adding titles to tables and column labels

Why Do We Need IDB Analyzer?

Very common question:“Why can’t I just do this in SPSS?”Answer:“Because of the data structure!”

Sampling is multi-stage, clustered, and stratified which can not be handled correctly by SPSS (remember the Weights and Variance Estimation presentation)SPSS can not do variance estimation based on replicated weights

IDB Analyzer handles these issues and “adds” the missing features to SPSS!

Table of content

Introduction to the IEA IDB AnalyzerInstallation processSelecting and merging dataHands-on training

Download IDB AnalyzerThe IDB Analyzer is available for download at the IEA website:

www.iea.nlSelect the “IEA Studies Datasets and Data Analyzers” subsectionDownload the “IDBAnalyzer_Setup.exe” file from there

Installation process

SPSS 11 or higher needs to be installed beforehandAdministrator rights are required for installation processIDB Analyzer has two modules

Merge – our starting pointAnalyze

Installation processDouble click on the setup file (Seminar version: C:\ICCS2009\Software\IDB_Analyzer\IDBAnalyzer_Setup_v2.0.0.37.exe)

Installation process

Table of content

Introduction to the IEA IDB AnalyzerInstallation processSelecting and merging dataHands-on training

How to Open the IDB Analyzer

Start > Programs > IEA > IDB Analyzer > Merge Module

What You Will See …

Merge Module

Select...Data

Source Director

y

StudyYear Grade

Merge Module

Select...Data

Source Director

y

Participants

Merge Module

Select...Data

Source Director

yStudyYear Grade

Participants

Merge Module

Select...Data

Source Director

yStudyYear Grade

Merge Module

Edit the country list to edit the country labels

Example: translate „Spain“ to „España”

Merge ModuleSave and confirm the change with „Yes“ and „Save“

Merge Module

To undo change go to „Edit Country List“ „Restore Defaults“ and confirm with „Yes“

Participants

Merge Module

Select...Data

Source Director

yStudyYear Grade

Participants

Merge Module

Select...Data

Source Director

yStudyYear Grade

Participants

Merge Module

Select...Data

Source Director

yStudyYear Grade

Participants

Merge Module

Select...Data

Source Director

yStudyYear Grade

Next>>

File Types

Merge Module

Select...

Variables

File Types

Merge Module

Select...

Variables

File Types

Merge Module

Select...

Variables

File Types

Merge Module

Select...

Variables

File Types

Merge Module

Select...

Variables

ID and Sampling Variables are selected automatically.

Supported File Type Merges

Any student files can be merged together.Any student files can be merged with the School Questionnaire file.Teacher Questionnaire file can be merged with the School Questionnaire file.Student files cannot be merged directly with the Teacher Questionnaire file.

Define File

Name and Save

Merge Module

File Types

Select...

Variables

Define File

Name and Save

Merge Module

File Types

Select...

Variables

Start SPSS

SPSS syntax file is stored in specified directory.

IDB Analyzer launches SPSS and opens the syntax file automatically.

Merge Module

Merge Module

From the SPSS syntax editor choose:Run > AllThe syntax is executed and the merged file is saved under the location you have chosen in the last step of the IDB Analyzer Merge Module

Merge Module

You can now start analyzing your data using the Analysis Module of

the IDB Analyzer.

More on this in the next presentation(s)!

Thank you for your attention!

Table of content

Introduction to the IEA IDB AnalyzerInstallation walkthroughSelecting and merging dataHands-on training

Hands-on Training

Copy files from the USB-stick to your C:\ driveInstall IDB Analyzer from

C:\ICCS2009\Software\IDB_AnalyzerOpen the IDB Analyzer Merge Module

Define data source: C:\ICCS2009\DataSelect all countriesSelect all variables from the School Questionnaire file and the Int. Student Questionnaire fileDefine file name: C:\ICCS2009\Work\ICG_ISG_INTC2.spsStart SPSS

Run all in the *.sps SPSS script to create *.sav SPSS data file