280 likes | 394 Views
Solidifying the Impact of Your Data Culture: The Bricks and Mortar. Patience Oranika and Marcus Vandiver, Ed.D Alabama Department of Education Research & Development Section. What is R&D using to analyze/display data?. Statistical Analysis Procedures Displaying Data Software.
E N D
Solidifying the Impact of Your Data Culture:The Bricks and Mortar Patience Oranika and Marcus Vandiver, Ed.D Alabama Department of Education Research & Development Section
What is R&D using toanalyze/display data? • Statistical Analysis Procedures • Displaying Data • Software
Statistical Analysis Procedures • The Means Procedure • Correlations • Regression (Predictive Modeling)
Statistical Analysis Procedures:The Means Procedure The Means Procedure allows us to view, explore, and compare certain characteristics of continuous variables within certain categories.
Statistical Analysis Procedures:The Means Procedure • The Means Procedure was used to analyze the data from the Instructional Audit Tool. • Coded the Auditing Tool • Individual Analysis (if possible) • Group Analysis • Means were compared using identified categories from the auditing tool
Statistical Analysis Procedures:The Means Procedure Used The Means Procedures to analyze the data from the Instructional Audit Tool Descriptive Statistics: Minimum, maximum, mean of each individual item, and standard deviation This Means Comparison Report is categorized by Subject Other analyses that could be run in addition to the Means Procedure include ANOVA and Measures of Association
Statistical Analysis Procedures:Correlations Correlation is a statistical measurement of the relationship between two variables. Possible correlations range from -1 to +1.
Statistical Analysis Procedures:Correlations A correlation of –1 indicates a perfect negative correlation, meaning that as one variable goes up, the other goes down. A zero correlation indicates that there is no relationship between the variables. A correlation of +1 indicates a perfect positive correlation, meaning that both variables move in the same direction together.
Statistical Analysis Procedures:Correlations A correlation of –1 indicates a perfect negative correlation, meaning that as one variable goes up, the other goes down. A zero correlation indicates that there is no relationship between the variables. A correlation of +1 indicates a perfect positive correlation, meaning that both variables move in the same direction together.
Statistical Analysis Procedures:Correlations Examining the correlations between the identified ARMT percentages of proficiency at levels III, IV, and III and VI combined against ACT Explore average scores.
Statistical Analysis:Regression (Predictive Modeling) In simple linear regression, a criterion variable is predicted from one predictor variable. In multiple regression, the criterion is predicted by two or more variables.
Statistical Analysis:Regression (Predictive Modeling) For example, you might want to predict a student's university grade point average on the basis of their High-School GPA (HSGPA) and their total SAT score (verbal + math). The basic idea is to find a linear combination of HSGPA and SAT that best predicts University GPA (UGPA).
Displaying Data • Charts • Line Graphs • Bar Graphs • Scatterplots • Filled Maps
Displaying Data:Bar Graphs – Cohort Assessment Analysis ARMT Math, Level III vs Level IV
Displaying Data: ScatterplotsACT Explorer Mathematics and ARMT Mathematics Level III, 2011
Displaying Data: ScatterplotsACT Explorer Mathematics and ARMT Mathematics Level IV, 2011
Displaying Data: ScatterplotsACT Explorer Mathematics and ARMT Mathematics Levels III/IV, 2011
Displaying Data: Filled Maps – 2013 Graduation Rate Map DISCLAIMER: This is an inaccurate depiction of what the graduation rate could look like mapped in the state of Alabama by School District
Displaying Data:Filled Maps – 2013 ACT Average Scores DISCLAIMER: This is an inaccurate depiction of what the graduation rate could look like mapped in the state of Alabama by School District
Displaying Data: Filled Maps Graduation Rate Average ACT Scores Absentee Rate Truancy Rate DISCLAIMER: This is an inaccurate depiction of what the graduation rate could look like mapped in the state of Alabama by School District
Analytical Software Programs • SPSS • Complex analytics • Merging data • Excel • Basic analytics • Manipulating data (Pivot tables) • Merging data (VLookUp) • Cognos • Access to data • Building reports for analysis • Cross tabulation • Tableau • Interactive visualizations • Data and display deployment • Analytics