Skip to main content
Like
Create new Glog
previous
next
Email share
44 views | 0 likes | 0 reposts
Technical Skills for Data Analysis
EDUC 735 Review from October 21, 28 2010
Categorical x categorical analysis = crosstabulation with counts or % as values
Categorical x numeric analysis = table with average (or other non-count fuction) as values
Numeric x numeric analysis = correlation (scatterplot or r-statistic)
1. What is the relationship between course grades and performance on accountability assessments? 2. Are formative assessments helpful in predicting summative assessment scores? 3. Do my highest-need students have qualified teachers? 4. Is the gap in graduation rates between ethnic groups growing or declining? 5. Are my lowest attending students the ones with the lowest assessment scores? 6. Is my special education population representative of the school's student population, or are some groups over-represented?
In pairs, please discuss each of the questions in terms of a) what data are needed? b) what is the measurement scale of each variable? c) what type of analysis do you need to conduct to answer the question?
Some lessons to review fromour technical skills unit: 1. indicator variariables have values of 1 and 0 only. 2. Continuous variables can be any value, including fractions of a whole, discrete can be whole values only. 3. Learn from your data. Please please please! Should we be concerned that 100% of 5th graders were free/reduced lunch eligible, compared to lower numbers in other grades? Why or why not? 4. Pivot tables is an excel tool that allows you to make crosstabulations and other types of tables. Making a pivot table entails identifying data to go into that tool, not creating a crosstabulation. 6. The language of correlation 7. Variables as columns presenting data that describe cases, not analyses of data. 8. Is growth or change measured by Fall-Spring of Spring-Fall? 9. What is an NCE?
