Simulations, Demonstrations, and
Interactive Dynamic Tutorial Movies
| The following links are provided to support an article written by Creighton and Glenn (July 2008) for the NCPEA Education Leadership Review: University teaching that improves school leadership: Basic techniques to help principals use data effectively. |
Loading Excel Toolpak
Excel Conditional Formatting
Creating a Pivot Tables with Excel
1. "What was the average score on each assessment?"
2. "Was there a difference in the assessment scores of boys and girls?"
3 & 4. "Did children who engage in more recreational reading perform better on the assessments and did the relationship between recreational reading and test score appear to be similar for boys and girls?"
5. "Was there a difference in the recreational reading habits of boys and girls?"
Use of Correlation with Excel
| The following interactive movies have been created to parallel the individual chapters of the second edition of Schools and Data: The Educator's Guide to Using Data to Improve Decision Making. They are free to all - especially students and principals using the book in their schools or graduate classes. Visit this site often, as tutorials will be added and updated regularly. I hope they are helpful to your understanding of Minitab, SPSS and Excel, and the statistical analysis of your data. Enjoy ! |
Chapter 1: The Role of Statistics in the Lives of Teachers and Principals
PowerPoint Presentation (Important Concepts)
Chapter 2: Getting Started
PowerPoint Chapter 2
Getting Started Excel
Getting Started SPSS
ITBS Example Excel
ITBS Example SPSS
Chapter 3: Collecting and Organizing Data
Powerpoint Chapter 3
Descriptive Statistics (Minitab)
Scatterplots (Excel)
Scatterplots (SPSS)
Creating Frequency Distributions
(SPSS)
Creating Frequency Distributions (Excel)
Measures of Central Tendency and Variablility (SPSS)
Measures of Central Tendency (Excel)
Measures of Variability (Excel)
Chapter 4: Correlation
Powerpoint Chapter 4
A Correlation Example-SPSS
A Correlation Example-Excel
Chapter 5: Introduction to Regression
Powerpoint Chapter 5
Simple Regression - Excel
Chapter 6: Formulation Research Questions
Powerpoint Chapter 6
Chapter 7: Independent Samples t Test
Powerpoint Chapter 7
One-Sample t Test (SPSS)
Independent-Sample t Test (Excel)
Chapter 8: Analysis of Variance (ANOVA)
Powerpoint Chapter 8
Class size ANOVA - SPSS
Class Size ANOVA - Excel
Chapter 9: ANOVA - Repeated Measures
Powerpoint Chapter 9
Analysis of DARE - Minitab
Chapter 10: The Two-Way ANOVA
Powerpoint Chapter 10
Excel Two-Anova
Chapter 11: The Chi-Square Test
Powerpoint Chapter 11
Chi Square - Excel
Chapter 12: The Other "Q"
Powerpoint Chapter 12
Chapter 13: Putting it All Together
Powerpoint Chapter 13