Outschool
Open currency, time zone, and language settings
Log In

A.P. Statistics with Microsoft Excel (Module 1)

This 4-week session covers Module 1 of the Savannah Labs textbook, including an introduction to Statistics, Numerical Summaries, Graphical Methods, Z-scores and identifying outliers.
Dr. Deborah (Savannah Math Labs)
Average rating:
4.0
Number of reviews:
(1)
Class
Play

What's included

12 live meetings
11 in-class hours
Homework
2-4 hours per week. Students will be expected to read the Savannah Math Labs Module 1 text, complete the Lab Module 1 Microsoft Excel lab project, watch all assigned videos and complete additional practice A.P. Statistics problems associated with Module 1.

Class Experience

US Grade 9 - 12
In this four-week multi-class session, we will meet three times per week and cover Module One of the Savannah Math Labs Statistics content. This module encompasses Unit 1 of the A.P. Statistics curriculum (approximately 20% of the A.P. Statistics exam). Students enrolling in this session should have a solid grasp and understanding of Algebra.  

Students will receive the 25-page Module 1 Savannah Math Labs text document in addition to approximately 1 hour and 20 minutes of animated videos and Microsoft® Excel® tutorials. For weeks 1-3, we will adhere to the following schedule:

•	First meeting: Review the course content and topics for the week (Students should prepare by reading the relevant text and watching the relevant videos). 
•	Second meeting: Work as a group on an in-class exercise.  
•	Third meeting: Solve 3 - 4 AP Statistics problems related to the week’s content.  

An immersive-learning Microsoft® Excel® lab project is provided to students and solutions will be reviewed in Week 4.  In the fourth week, we will also discuss student questions and review additional A.P. Statistics problems.  

The following topics will be covered during each week of this four-week session: 
Week 1: Introduction to Statistics, Examples of Descriptive Statistics Versus Inferential Statistics. Categorical Versus Quantitative Data, Simple Random Samples, Definition of Statistical Bias, Types of Statistical Bias: Selection Bias, Response Bias.
Week 2: Numerical Summaries for Quantitative Data, Graphical Methods for Quantitative Data, Changing Units of Measurement, Cumulative Relative Frequency
Week 3: Box Plots, Normally Distributed Data, Z-Scores and Outliers.
Week 4: Wrap-Up Lab Module 1, Review Lab Module 1 Assignment, Additional Practice AP Module 1 questions.

Following this Module 1 session, a 2-week session covering Probability (Module 2) will be available starting in late September which covers The Classical Method of Computing Probabilities, The Law of Large Numbers and The Combinations Rule. Subsequent modules will cover the AP Statistics course content in its entirety to prepare students for the May 2024 A.P. Statistics exam!
Learning Goals
Learning objectives for Module 1 are as follows:
1. Differentiate between categorical and quantitative data sets.
2. Graphically depict a categorical data set with a pie graph, bar graph and Pareto graph.
3. Explain the additional value a Pareto graph provides over a traditional bar graph.
4. Characterize a quantitative data set with key summary statistics.
5. Change the measurement units of a quantitative variable (x) based on a linear transformation (y = ax +b) and compute the new sample mean and sample variance of y.
6. Visualize the distribution of a quantitative data set with a histogram, dot plot, stem and leaf plot, cumulative relative frequency graph and a box plot.
7. Compute a Z-score distribution and assess whether data is consistent with the empirical rule for normally distributed data.
learning goal

Other Details

Supply List
All Savannah Math Labs material (videos and text) will be provided in the Outschool course.  Additional homework problems will be assigned for the following manual:

AP Statistics Premium, 2023-2024: 9 Practice Tests + Comprehensive Review + Online Practice (Barron’s AP) Twelfth Edition.
 5 files available upon enrollment
External Resources
Learners will not need to use any apps or websites beyond the standard Outschool tools.
Sources
Some homework and self-assessments will be assigned in the following manual: AP Statistics Premium, 2023-2024: 9 Practice Tests + Comprehensive Review + Online Practice (Barron’s AP) Twelfth Edition.
Joined May, 2023
4.0
1reviews
Profile
Teacher expertise and credentials
Doctoral Degree in Mathematics from Rice University
I have a PhD in Statistics from Rice University and extensive teaching experience at the college level.  More details can be found in my teacher bio!

Reviews

Live Group Class
Share

$380

for 12 classes
3x per week, 4 weeks
55 min

Completed by 2 learners
Live video meetings
Ages: 14-18
10-15 learners per class

This class is no longer offered
About
Support
SafetyPrivacyCA PrivacyLearner PrivacyManage Data PreferencesTerms
Financial Assistance
Get The App
Download on the App StoreGet it on Google Play
© 2024 Outschool