Loading...

Course Description

Use 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 Outcomes

Upon 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.
Loading...

Enroll Now - Select a section to enroll in

Section Title
Statistics with Microsoft Excel, Part II
Delivery Options
Online  
Course Fee(s)
Tuition credit (3 units) $460.00
Available for Credit
3 Quarter Credits
Reading List / Textbook
Knowlton, E. (2016). EXCEL® 2010/2013/2016: Essentials for Statistics
and Data Management.
Fernandina Beach, FL: Adventures In Education, Inc.
Section Notes

This course is offered in collaboration with Adventures in Education


Course is self-paced. Completion time: up to one year from date of enrollment.


Refund Policy: Withdrawals submitted online through SPU within 7 days of enrollment will receive a 95% refund. Withdrawals received after that point will not receive a refund and no withdrawals will be accepted after the completion deadline for the course. Instructions on how to withdraw are located on our website under Students/Withdrawal and Refund Policies.

Required fields are indicated by .