ICCS2009 IDB Seminar P04 IDBAnalyzer Overview and Merge

Document Sample
ICCS2009 IDB Seminar P04 IDBAnalyzer Overview and Merge Powered By Docstoc
					    Using the IEA IDB Analyzer
    to merge and analyze data




ICCS 2009 IDB Seminar – Nov 24-26, 2010 – IEA DPC, Hamburg, Germany
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
 Hands-on training
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?
 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?
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 Analyzer
 Installation process
 Selecting and merging data
 Hands-on training
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

 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 process
  Double 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 Analyzer
 Installation process
 Selecting and merging data
 Hands-on training
How to Open the IDB Analyzer

  Start > Programs > IEA > IDB Analyzer > Merge Module
What You Will See …
  Merge Module

Select...
  Data
 Source
Directory
 Merge Module
 Select...
  Data
 Source
Directory
  Study
   Year
  Grade
   Merge Module
  Select...
  Data
 Source
Directory
  Study
   Year
  Grade
Participants
   Merge Module
  Select...
  Data
 Source
Directory
  Study
   Year
  Grade
Participants
Merge Module
 Edit the country list to edit the country labels




      Example: translate „Spain“ to „España”
Merge Module
 Save and confirm the change with „Yes“ and
 „Save“
Merge Module
 To undo change go to „Edit Country List“ 
 „Restore Defaults“ and confirm with „Yes“
   Merge Module
  Select...
  Data
 Source
Directory
  Study
   Year
  Grade
Participants
   Merge Module
  Select...
  Data
 Source
Directory
  Study
   Year
  Grade
Participants
   Merge Module
  Select...
  Data
 Source
Directory
  Study
   Year
  Grade
Participants
   Merge Module
  Select...
  Data
 Source
Directory
  Study
   Year
  Grade
Participants
 Next>>
   Merge Module
   Select...
File Types
Variables
   Merge Module
   Select...
File Types
Variables
   Merge Module
   Select...
File Types
Variables
   Merge Module
   Select...
File Types
Variables
   Merge Module
   Select...
File Types
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.
    Merge Module
   Select...
File Types
Variables
Define File
Name and
  Save
    Merge Module
   Select...
File Types
Variables
Define File
Name and
  Save
                SPSS syntax file is stored in specified
Start SPSS                   directory.
               IDB Analyzer launches SPSS and opens
                   the syntax file automatically.
Merge Module
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 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 Analyzer
 Installation walkthrough
 Selecting and merging data
 Hands-on training
Hands-on Training
 Copy files from the USB-stick to your C:\ drive
 Install IDB Analyzer from
     C:\ICCS2009\Software\IDB_Analyzer
 Open the IDB Analyzer Merge Module
     Define data source: C:\ICCS2009\Data
     Select all countries
     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

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:21
posted:9/11/2012
language:Unknown
pages:39