1 / 49

Using the IEA IDB Analyzer Percentages & Means

Using the IEA IDB Analyzer Percentages & Means. Table of content. Preparations How to Start the Analysis Module Overview of Analysis Methods Percentages Settings for the Analysis Running the Analysis Compare SPSS Output and International Report Output in MS Excel Percentages and Means

jadyn
Download Presentation

Using the IEA IDB Analyzer Percentages & Means

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Using the IEA IDB Analyzer Percentages & Means

  2. Table of content • Preparations • How to Start the Analysis Module • Overview of Analysis Methods • Percentages • Settings for the Analysis • Running the Analysis • Compare SPSS Output and International Report • Output in MS Excel • Percentages and Means • Settings for the Analysis • Running the Analysis • Compare SPSS Output and International Report • Output in MS Excel • Hands-On Training

  3. Table of content • Preparations • How to Start the Analysis Module • Overview of Analysis Methods • Percentages • Settings for the Analysis • Running the Analysis • Compare SPSS Output and International Report • Output in MS Excel • Percentages and Means • Settings for the Analysis • Running the Analysis • Compare SPSS Output and International Report • Output in MS Excel • Hands-On Training

  4. How to Start the Analysis Module • To start the Analysis Module of the IDB Analyzer, select: Start > Programs > IEA > IDB Analyzer >Analysis Module

  5. How to Start the Analysis Module

  6. Analysis Methods • Percentages only • Percentages and means • Correlations • Regressions

  7. Table of content • Preparations • How to Start the Analysis Module • Overview of Analysis Methods • Percentages • Settings for the Analysis • Running the Analysis • Compare SPSS Output and International Report • Output in MS Excel • Percentages and Means • Settings for the Analysis • Running the Analysis • Compare SPSS Output and International Report • Output in MS Excel • Hands-On Training

  8. Table of content • Preparations • How to Start the Analysis Module • Overview of Analysis Methods • Percentages • Settings for the Analysis • Running the Analysis • Compare SPSS Output and International Report • Output in MS Excel • Percentages and Means • Settings for the Analysis • Running the Analysis • Compare SPSS Output and International Report • Output in MS Excel • Hands-On Training

  9. Calculating Percentages • Choose variable(s) to be analyzed • Load the SPSS Analysis File • Choose Percentages only as analysis type (some settings will be done automatically with respect to the datafile and the analysis method chosen) • Select Variables from the datafile to be analyzed as Grouping Variable • Define location and name of the Output Files • Start SPSS and run analysis

  10. Select Variable of Interest Student Questionnaire, Q20-A, p. 19 Variable of Interest: IS2P20A

  11. The Analysis File • The analysis file needs to be loaded from the respective directory • Countries in the example analysis file: • Austria • Belgium (Flemish) • Bulgaria • Denmark • England • Estonia • Finland

  12. Percentages Only - Preparation • Select Analysis File:C:\ICCS2009\Work\ICG_ISG_INTC2.sav • Select Analysis Type: Percentages only • Select Grouping Variables:IS2P20A (Table 4.01 from ICCS2009 International report, first column) [IDCNTRY] (Pre-selected if more than one country is in file)

  13. Percentages Only - Details Select Analysis FileC:\ICCS2009\Work\ICG_ISG_INTC2.sav

  14. Percentages Only - Details 1) Select Percentages only 2) Check Exclude Missing from Analysis

  15. Percentages Only - Details IDCNTRY TOTWGTS JKZONES

  16. Percentages Only - Details Search for IS2P20A

  17. Percentages Only - Details Search results will be displayed

  18. Percentages Only - Details Highlight variable Use arrow key to add variable to analysis

  19. Percentages Only - Details Define path and filename for output:“C:\ICCS2009\Work\Table_4_01.*” Change number of decimals to “1”

  20. Percentages Only - Details • The IDB Analyzer creates SPSS Syntax and starts SPSS • In SPSS Syntax Editor Choose: Run > All

  21. Percentages Only - Outcome • As a result the IDB Analyzer creates the following in the working directory (C:\ICCS2009\Work\): • SPSS Syntax file – contains the syntax with the commands (*.sps) • SPSS Data file – contains statistics from the analysis (*.sav) • MS Excel Output file – contains statistics from the analysis (*.xls)

  22. Percentages Only - SPSS Output

  23. Percentages Only - Excel Output Variable name and Value Labels Number of studentsin each group List of countries

  24. Percentages Only - Excel Output Weighted percentage of students for the groups defined by the grouping variables (IDCNTRY, IS2P20A) Total student weight – population estimate of the groups defined by the grouping variables(IDCNTRY, IS2P20A)

  25. Percentages Only - Excel Output Standard error of percentages

  26. Percentages Only - Excel Output

  27. Table of content • Preparations • How to Start the Analysis Module • Overview of Analysis Methods • Percentages • Settings for the Analysis • Running the Analysis • Compare SPSS Output and International Report • Output in MS Excel • Percentages and Means • Settings for the Analysis • Running the Analysis • Compare SPSS Output and International Report • Output in MS Excel • Hands-On Training

  28. Table of content • Preparations • How to Start the Analysis Module • Overview of Analysis Methods • Percentages • Settings for the Analysis • Running the Analysis • Compare SPSS Output and International Report • Output in MS Excel • Percentages and Means • Settings for the Analysis • Running the Analysis • Compare SPSS Output and International Report • Output in MS Excel • Hands-On Training

  29. Calculating Percentages and Means • Without Achievement Scores • Computes the percentages of students within specified subgroups, their mean and standard deviation on the continuous variable selected with their JRR standard errors • With Achievement Scores • Computes percentages and mean achievement scores based on plausible values with their JRR standard errors

  30. Calculating Percentages and Means • Choose variable(s) to be analyzed • Load the SPSS Analysis File • Choose Percentages and Means as analysis type (some settings will be done automatically) • Select Variables from the datafile to be analyzed as Analysis Variable OR Select the plausible values as Achievement Scores • Define location and name of the Output Files • Start SPSS and run analysis

  31. Civic and citizenship knowledge(represented with the 5 plausible values)PVCIV01-05 Variable of Interest

  32. The Analysis File • The analysis file needs to be loaded from the respective directory • Countries in the example analysis file: • Austria • Belgium (Flemish) • Bulgaria • Denmark • England • Estonia • Finland

  33. Percentages & Means - Preparation • Select Analysis File:C:\ICCS2009\Work\ICG_ISG_INTC2.sav • Select Analysis Type: Percentages and Means • Select Achievement Scores: PVCIV01-05 (Table 3.4 from ICCS2009 International Report, column right of graph)

  34. Percentages & Means - Details Select Analysis FileC:\ICCS2009\Work\ICG_ISG_INTC2.sav

  35. Percentages & Means - Details 1) Select Percentages and Means 2) Check Exclude Missing from Analysis 3) Check With Achievement Scores

  36. Percentages & Means - Details IDCNTRY TOTWGTS JKZONES

  37. Percentages & Means - Details

  38. Percentages & Means - Details Highlight variable Use arrow key to add variable to analysis

  39. Percentages & Means - Details C:\ICCS2009\Work\Table_3_4.* Change the number of decimals to one

  40. Percentages & Means - Details • The IDB Analyzer creates SPSS Syntax and starts SPSS • In SPSS Syntax Editor Choose: Run > All

  41. Percentages & Means – SPSS Output

  42. Percentages & Means – Excel Output Number of students in the sample Total student weight – population estimate of the group defined by the grouping variable(IDCNTRY) Achievement scores(PVCIV01-05) List of countries

  43. Percentages & Means – Excel Output Weighted percentage of students for the groups defined by the grouping variable (IDCNTRY) Standard error of percentage

  44. Percentages & Means – Excel Output Standard error of the mean of the analysis variable Standard deviation of the analysis variable Mean of the analysis variable Standard error of the standard deviation

  45. Percentages & Means – SPSS Output

  46. Thank you for your attention! Any Questions?

  47. Table of content • Preparations • How to Start the Analysis Module • Overview of Analysis Methods • Percentages • Settings for the Analysis • Running the Analysis • Compare SPSS Output and International Report • Output in MS Excel • Percentages and Means • Settings for the Analysis • Running the Analysis • Compare SPSS Output and International Report • Output in MS Excel • Hands-On Training

  48. Table of content • Preparations • How to Start the Analysis Module • Overview of Analysis Methods • Percentages • Settings for the Analysis • Running the Analysis • Compare SPSS Output and International Report • Output in MS Excel • Percentages and Means • Settings for the Analysis • Running the Analysis • Compare SPSS Output and International Report • Output in MS Excel • Hands-On Training

  49. Hands-On Training • Re-produce the presented example using your country data- Percentage of students’ agreement to the right of expressing opinions freely (IS2P20A) and/or • Re-produce the presented example using your country data- Mean civic and citizenship achievement of students (PVCIV01-05) and/or • Practice with own selected variables following these analysis steps

More Related