Course DescriptionLearn to effectively use spreadsheet functions and data analysis tools of Microsoft Excel to analyze, summarize, and interpret quantitative and qualitative business data. Develop skills to put information and data to work to make informed business decisions. Methods align with ISTE National Educational Technology Standards. Engage in hands-on activities you can immediately use to teach all students. The following topics are covered: Spreadsheet basics; graphs, charts, and plots; frequency tables; descriptive and summary statistics; percentiles, quartiles, and ranking; combinations, permutations, and binomial probabilities.
Learner OutcomesUpon completion of this course, the student will be able to:
- Demonstrate proficiency in the use of EXCEL spreadsheet technology.
- 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 ISTE National Educational Technology Standards.