using the iea idb analyzer to merge and analyze data
DESCRIPTION
Using the IEA IDB Analyzer to merge and analyze data. Table of content. Introduction to the IEA IDB Analyzer Installation process Selecting and merging data Hands-on training. Table of content. Introduction to the IEA IDB Analyzer Installation process Selecting and merging data - PowerPoint PPT PresentationTRANSCRIPT
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
Using the IEA IDB Analyzer to merge and analyze data
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
Table of contentIntroduction to the IEA IDB AnalyzerInstallation processSelecting and merging dataHands-on training
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
Table of contentIntroduction to the IEA IDB AnalyzerInstallation processSelecting and merging dataHands-on training
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
Introduction to IDB Analyzer
WHAT IT IS– A software program developed by the IEA
Data Processing and Research Center to analyze the data from ICCS and other IEA surveys
– Calculates correct standard errors when conducting analysis with ICCS
– Uses optimized algorithms for computing means, percentages and regressions
BONUS!– Easy creation of data sets for use in SPSS– Merging countries and/or data levels– Selection of analysis variables
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
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
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
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 sample design presentation)
– SPSS can not do variance estimation based on replicated weights
IDB Analyzer handles these issues and “adds” the missing features to SPSS!
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
Table of contentIntroduction to the IEA IDB AnalyzerInstallation processSelecting and merging dataHands-on training
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
Download IDB AnalyzerThe IDB Analyzer is available for download at the IEA website:
– www.iea.nl– Select the “IEA Studies Datasets and Data Analyzers”
subsection– Download the “IDBAnalyzer_Setup.exe” file from there
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
Installation processSPSS 11 or higher needs to be installed beforehandAdministrator rights are required for installation processIDB Analyzer has two modules– Merge – our starting point– Analyze
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
Installation processDouble click on the setup file (Seminar version: C:\ICCS2009\Software\IDB_Analyzer\IDBAnalyzer_Setup_v2.0.30.33.exe)
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
Installation process
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
Windows Vista…With Windows Vista an error may occur during the merge process:– "COM object with CLSID {...} is either not
valid or not registered"
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
Windows Vista…To solve this problem: – Go to the SPSS installation directory and
select the SPSS main program. – Right click on it and select properties. – Then select the Compatibility tab in the
properties window – Select the ‘Run as Administrator’
checkbox. – Then click ‘OK’ to close the window and
restart IDB Analyzer.
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
Table of contentIntroduction to the IEA IDB AnalyzerInstallation processSelecting and merging dataHands-on training
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
How to Open the IDB AnalyzerStart > Programs > IEA > IDB Analyzer > Merge
Module
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
What You Will See …
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
Merge Module
Select...Data
Source Director
y
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
StudyYear Grade
Merge ModuleSelect...Data
Source Director
y
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
Participants
Merge ModuleSelect...Data
Source Director
yStudyYear Grade
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
Participants
Merge ModuleSelect...Data
Source Director
yStudyYear Grade
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
Edit the country list to edit the country labels
Merge Module
Example: translate „Spain“ to „España”
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
Merge ModuleSave and confirm the change with „Yes“ and „Save“
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
Merge ModuleTo undo change go to „Edit Country List“ „Restore Defaults“ and confirm with „Yes“
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
Participants
Merge ModuleSelect...Data
Source Director
yStudyYear Grade
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
Participants
Merge ModuleSelect...Data
Source Director
yStudyYear Grade
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
Participants
Merge ModuleSelect...Data
Source Director
yStudyYear Grade
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
Participants
Merge ModuleSelect...Data
Source Director
yStudyYear Grade
Next>>
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
File Types
Merge ModuleSelect...
Variables
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
File Types
Merge ModuleSelect...
Variables
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
File Types
Merge ModuleSelect...
Variables
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
File Types
Merge ModuleSelect...
Variables
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
File Types
Merge ModuleSelect...
Variables
ID and Sampling Variables are selected automatically.
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
Supported File Type MergesAny 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.
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
Define File
Name and Save
Merge Module
File Types
Select...
Variables
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
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.
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
Merge Module
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
Merge Module
From the SPSS syntax editor choose:– Run > All– The 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
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
Merge Module
You can now start analyzing your data using the Analysis Module of
the IDB Analyzer.
More on this after lunch!
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
Thank you for your attention!
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
Table of contentIntroduction to the IEA IDB AnalyzerInstallation walkthroughSelecting and merging dataHands-on training
ICCS 2009 IDB Workshop, 18th February 2010, Madrid
Hands-on TrainingCopy files from the USB-stick to your C:\ driveCreate the following folder:
– C:\ICCS2009\WorkInstall IDB Analyzer from
– C:\ICCS2009\Software\IDB_AnalyzerOpen the IDB Analyzer Merge Module
– Define data source: C:\ICCS2009\Data– Select your country– Select all variables from the School Questionnaire file and
the Int. Student Questionnaire file– Define file name: C:\ICCS2009\Work\ICG_ISG_INTC2.sps– Start SPSS
Run all in the *.sps SPSS script to create *.sav SPSS data file