Course DescriptionLearn to effectively use Excel and the Internet to teach statistics topics. Methods align with NCTM Principles and Standards for School Mathematics and Common Core State Standards. Cover basic Excel skills and explore topics such as generating random numbers, simulations, frequency tables, summary statistics, graphs and charts, linear regression, correlation, binomial distribution, normal distribution, z-values and t-values, hypothesis testing, and ANOVA. Research instructional implications for use of technology in the classroom. Engage in interesting real-world activities that you can immediately use to teach all students.
Learner OutcomesUpon completion of this course, the student will be able to:
- Demonstrate proficiency in the use of EXCEL spreadsheet technology for teaching and learning Statistics.
- Create activities for the statistics classroom using the ideas, skills and strategies presented in this course.
- Create an instructional unit incorporating use of EXCEL spreadsheet technology.
- Design lesson plans that align with CCSS and NCTM Standards.