Course DescriptionUse intermediate Excel skills and the Internet to enhance instruction in the statistics classroom. Topics align with NCTM Principles and Standards and Common Core State Standards and include generating random numbers; sampling and creating number series; binomial, Poisson, and hypergeometric distributions; X2 and F-distributions and tests; one/two-sample hypothesis testing; multiple regression and correlation; two-way ANOVA; permutations, combinations, percentiles, quartiles, and rank; and summary statistics. Examine national technology standards and relevance of technology in teaching and learning mathematics and statistics. Engage in interesting real-world activities that motivate 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.