slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Using the IEA IDB Analyzer to merge and analyze data PowerPoint Presentation
Download Presentation
Using the IEA IDB Analyzer to merge and analyze data

Loading in 2 Seconds...

play fullscreen
1 / 41

Using the IEA IDB Analyzer to merge and analyze data - PowerPoint PPT Presentation


  • 262 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Using the IEA IDB Analyzer to merge and analyze data' - shanon


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1

Using the IEA IDB Analyzer

to merge and analyze data

table of content
Table of content
  • Introduction to the IEA IDB Analyzer
  • Installation process
  • Selecting and merging data
  • Hands-on training
table of content1
Table of content

Introduction to the IEA IDB Analyzer

Installation process

Selecting and merging data

Hands-on training

introduction to idb analyzer
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
what can it do
What can it do?
  • For ICCS, compute percentages, means (and SD), correlations, and linear regressions – including their respective standard errors
  • Allows 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
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!
table of content2
Table of content
  • Introduction to the IEA IDB Analyzer
  • Installation process
  • Selecting and merging data
  • Hands-on training
download idb analyzer
Download IDB Analyzer

The 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

installation process
Installation process
  • SPSS 11 or higher needs to be installed beforehand
  • Administrator rights are required for installation process
  • IDB Analyzer has two modules
    • Merge – our starting point
    • Analyze
installation process1
Installation process
  • Double click on the setup file

(Seminar version: C:\ICCS2009\Software\IDB_Analyzer\IDBAnalyzer_Setup_v2.0.30.33.exe)

windows vista
Windows Vista…
  • With Windows Vista an error may occur during the merge process:
    • "COM object with CLSID {...} is either not valid or not registered"
windows vista1
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.
table of content3
Table of content
  • Introduction to the IEA IDB Analyzer
  • Installation process
  • Selecting and merging data
  • Hands-on training
how to open the idb analyzer
How to Open the IDB Analyzer

Start > Programs > IEA > IDB Analyzer > Merge Module

merge module1
Merge Module

Select...

Data Source Directory

Study

Year

Grade

merge module2
Merge Module

Select...

Data Source Directory

Study

Year

Grade

Participants

merge module3
Merge Module

Select...

Data Source Directory

Study

Year

Grade

Participants

merge module4
Merge Module
  • Edit the country list to edit the country labels

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

merge module5
Merge Module
  • Save and confirm the change with „Yes“ and „Save“
merge module6
Merge Module
  • To undo change go to „Edit Country List“  „Restore Defaults“ and confirm with „Yes“
merge module7
Merge Module

Select...

Data Source Directory

Study

Year

Grade

Participants

merge module8
Merge Module

Select...

Data Source Directory

Study

Year

Grade

Participants

merge module9
Merge Module

Select...

Data Source Directory

Study

Year

Grade

Participants

merge module10
Merge Module

Select...

Data Source Directory

Study

Year

Grade

Participants

Next>>

merge module11
Merge Module

Select...

File Types

Variables

merge module12
Merge Module

Select...

File Types

Variables

merge module13
Merge Module

Select...

File Types

Variables

merge module14
Merge Module

Select...

File Types

Variables

merge module15
Merge Module

Select...

File Types

Variables

ID and Sampling Variables are selected automatically.

supported file type merges
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.

merge module16
Merge Module

Select...

File Types

Variables

Define File Name and Save

merge module17
Merge Module

Select...

File Types

Variables

Define File Name and Save

SPSS syntax file is stored in specified directory.

IDB Analyzer launches SPSS and opens the syntax file automatically.

Start SPSS

merge module19
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
merge module20
Merge Module

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

IDB Analyzer.

 More on this after lunch!

table of content4
Table of content

Introduction to the IEA IDB Analyzer

Installation walkthrough

Selecting and merging data

Hands-on training

hands on training
Hands-on Training

Copy files from the USB-stick to your C:\ drive

Create the following folder:

C:\ICCS2009\Work

Install IDB Analyzer from

C:\ICCS2009\Software\IDB_Analyzer

Open 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