Outschool
Search

for 12 classes
Class
Play

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

Completed by 2 learners
Ages 14-18
Live Group Class
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.
Average rating:
4.0
Number of reviews:
(1 reviews)

Live video meetings
3x per week, 4 weeks
10-15 learners per class
55 min

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.

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.

Meet the teacher

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

Parents also liked
AP Calculus AB Test Prep & Review
Mr. Oaks
5.0
(78)
per class
Group Class
32 wks, 1/wk, 50 min
14-18
AP Biology Test Prep and 1:1 Tutor
Laura Smith
per session
1-on-1 Tutoring
On Demand
15-18
AP African American Studies Test Prep
Amber Johnson Logan
4.9
(92)
per class
Group Class
8 wks, 1/wk, 55 min
14-18
AP History Test Prep 1:1 Tutoring
Dr. Hopkins, Ed.D
4.8
(10)
per session
1-on-1 Tutoring
On Demand
15-18
AP Calculus AB Test Prep | Free Response Bootcamp
Twin Oaks Learning Collective
5.0
(11)
per class
Group Class
5 wks, 2/wk, 45 min
15-18
AP Calculus AB: Easy as Pi! (Weekly Test Prep Review)
Pablo M.S.ECE
5.0
(83)
per class
Group Class
18 wks, 1/wk, 55 min
13-18
AP US History Test Prep - Time Periods 1-5 / Apush Prep
Matt Hall
5.0
(3)
per class
Next session at 11 PM on Mon 4/21
Group Class
1 wk, 1/wk, 1.33 hr
12-17
AP US History Test Prep - Time Periods 6-9 / Apush Prep
Matt Hall
5.0
(3)
per class
Next session at 11 PM on Thu 5/1
Group Class
1 wk, 1/wk, 1.33 hr
12-17
1-on-1 AP Biology Test Preparation
Kayla Thibault - Strong Roots Learning LLC
per session
1-on-1 Tutoring
On Demand
14-18
AP Biology - Test Preparation & Review
Dr. Lee, PhD, Biology and Life Science
4.9
(287)
per class
Group Class
15 wks, 1/wk, 1 hr
13-18
AP Microeconomics Exam Prep
Dr. Hanen, PhD, economics
5.0
(1)
per class
Next session at 12 AM on Friday
Group Class
5 wks, 2/wk, 1.50 hr
16-18
AP Statistics Exam Prep
AI Code Academy
4.7
(1,779)
per class
Next session at 11:30 PM on Mon 4/14
Group Class
10 wks, 1/wk, 1 hr
14-18
AP Macroeconomics Exam Prep
Dr. Hanen, PhD, economics
5.0
(1)
per class
Next session at 11 PM on Sat 4/26
Group Class
10 wks, 1/wk, 1.50 hr
16-18
AP Computer Science a Exam Prep Course
AI Code Academy
4.7
(1,779)
per class
Next session at 11:30 PM on Mon 4/14
Group Class
10 wks, 1/wk, 1 hr
14-18
AP Pre-Calculus Exam Prep
Lhisha Bennett
4.9
(44)
per class
Next session at 5 PM on Sun 4/13
Group Class
4 wks, 2/wk, 1 hr
13-18
AP Calculus BC Exam Prep
Lhisha Bennett
4.9
(44)
per class
Next session at 11 PM on Mon 4/14
Group Class
4 wks, 2/wk, 1 hr
13-18
See More Classes
Home
Search
Give a Gift Card
Open currency, time zone, and language settings
Language & Region
Log In