Unit Links

Click on the picture
to access the unit.

Course Outline course outline 1...2...3...4...5...6 excel

Calendar

(Entire calendar is at the bottom)
Jan 22 - Business
- AS COVID small business
- HN Stock Market
- LP Business
- MR COVID small business
- PV Cell Phone Use
- RA AI Impact on Business
- SM COVID small business

Unit 4 Review
Jan 23 - Review

Unit 5 Review
ZScore Review
Jan 24 - Review

Oscars Presentation.
Review!!
Day 1 Exam Review
Day 2 Exam Review
Jan 25 - Exams - P1 Jan 26 - Exams - P2
Jan 29 - Exams - P3 - That's us.
8:30 - 10:00
Worth 20% of final grade
See resources below.
Doctor's note is required if you miss the exam.
Jan 30 - Exams - P4 Jan 31 - Exams - Emergency Make Up, if needed.
Will be scheduled by board.
Feb 1 - Turnaround Day Feb 2 - Semester 2 - First Day of Class, Come to school

 

 

Exam Information & Resources

Exam Details
Things NOT on the Exam Blank Sample Tests Sample Test Solutions Test Review Questions
Monday Jan 29
Room 102
8:30 - 10:00
- 5 Question Pages
- One page per unit
- 132 Marks total (28 marks for each unit; except #3, which has 20)
- Worth 20% of final grade
- Formula Sheet (provided on exam).
- Excel is not on the exam
- On Tests, in the start of communication, there is a chart where you fill in terms. There is no chart like that on the exam. However, you still need to know the terms to answer questions.
- You do not need to memorize the % of data that falls in each section of the Normal distribution.
Unit 1 - Probabiliy
Unit 2 - Counting
Unit 3 - Statistics Studies
Unit 4 - One-variable
Unit 5 - Distributions
Unit 1 - Probabiliy
Unit 2 - Counting
Unit 3 - Statistics Studies
Unit 4 - One-variable
Unit 5 - Distributions
Unit 1 - Probabiliy
Unit 2 - Counting
Unit 3 - Statistics Studies
Unit 4 - One-variable
Unit 5 - Distributions


1

Unit 1: Probablityup

Questions Powerpoints/Notes Test Preparation Excel - Level 1 & 2 Excel - Level 3 & 4
1.1 Sample Space
1.2 Trees
1.2a Venn - Two Bubble
1.3 Venn Diagrams
1.4 More Trees
1.5 Formulas
1.6 Indep Mututally Exclusive
1.7 Conditional


1. Probability (sample space, trees), Examples
2. Venn Diagrams
3. More Trees, 1.2 solutions: 6, 9, 10
4. Law of Large Numbers
5. Additive Property
6. Conditional Probability

Final Project
Sample Test Solution

Review Knowledge Short Answer
Review Communication & Thinking

Videos:
7. Tree without Replacement
12. Three Bubble Venn
13. Conditional Prob and Tree
A1. Formulas
A2. Fill Down
A3. And, Or, Not
B1. Cell Formatting, XL Sheet
B2. Pivot Tables, XL Sheet

2

Unit 2: Counting up

Questions Powerpoints/Notes Test Review Excel - Level 1 & 2 Excel - Level 3 & 4
2.1 Factorial
2.2 Permutations
2.3 Combinations

Counting Test Review, answers
1. Factorial
2. Counting
3. Permutations
4. Permutations with Restrictions
5. Circular Permutations
6. Perms with Repeats
7. Combinations
Sample Test Solution

Counting Test Review, answers
A1. Infographics A
A2. Infographics B
A3. Perms Combs
B1. Excel as Calculator
B2. Birthdays
B3. Historial Riddle
B4. Code Breaking

3

Unit 3: Experimental Design (Two Variable)up

Questions Powerpoints/Notes Excel - Level 1 & 2 Excel - Level 3 & 4
3.1 PPDAC
3.3 Causation
3.4 Correlation Coefficient
3.9 Multiple Choice
3.9 Survey

Example PPDAC Quiz
Answer Guide
PPDAC Quiz #1
0. PPDAC, Gladwell
1. PPDAC
2. Sampling
3. Causation
4. Correlation Co-efficient
5. Feltron.com
6. Error and Bias
7. Data Mining

New Math Definitions
A1 - Line of Best Fit, video
A2 - Felton Report
A3 - One Variable Excel
A4 - Computer Prices
B1 - Google Correlate
B2 - Google Trends
B3 - Formulas
B4 - Dialog Boxes

 

4
Unit 4: One Variable Analysisup

Questions Powerpoints/Notes Excel - Level 1 & 2 Excel - Level 3 & 4
4.1 Distrubtions
4.2 Standard Dev
4.5 ZScores, table
4.6 ZScores
4.7 ZScores
1. Central Tendency
2. Standard Deviation
3. IQR Box & Whisker
4. Normal Distribution
5. Z-Scores
6. More ZScores
7. ZScores Quiz, more Zscores
A1. SpreadAnalysis, video: One Var, Histograms
B1. Reading Scores

 

5

Unit 5: Distributions up

Questions Powerpoints/Notes Excel - Level 1 & 2 Excel - Level 3 & 4
5.3 Variables
5.4 Prob Dist
5.5 Binomial
5.6 Binomial Eqns
1. Pascal's Triangle
2. Pascal's Method
3. Expected Value
4. Expected Value applications
5. Binomial Distribution
6. More Binomial
7. Geometric
8. Hypergeometric
9. Confidence Intervals
All formulas
A1. Pascal's Triangle
A2. Expected Value
A3. Binomial
A4. Geometric
A5. Hypergeometric
B1. Venn Diagram Review
B2. Histogram Review
B3. Line of Best Fit Review
B4. Pie Charts Review
B5. IQR

 

6

Final Project up

Problem Plan Data Analysis Conclusion Presentation
Assignment
Problem Example
Plan B
Sea of Numbers
Problem Rubric
Examples:
On-line Source
Survey
Google Trends
Self Tracking
Secondary

Plan Rubric
Data Example
Data Rubric
Analysis Rubric

Analysis Examples - look at old spreadsheets!

A simulation: Mortgage
Peel School Board Survey
Line of Best Fit: video
Histogram: video
Conc Example
Conc Rubric

Typography
Pres Example
Pres Rubric

1. Save sound from BenSound
2. Add sound (Insert > Audio > Audio on my PC). Click on it. Go to Playback > Play in Background.
3. Record Timings (SlideShow > Record Slide Show)
4. Save as MPEG-4 video


 

 

Complete Calendar up

Sept 4 - Labour Day
Sept 5 - Gr 9s only Sept 6 - First Day of class
Reflection Story
Get To Know You
Math Profile
Sept 7
Studying
Events & Trees (old powerpoint)
Worked Tree Example

Questions 1.1: do 1ab, 2, 5, 7. You can sub in 10 or 11 for any of them.
Sept 8
Excel Introduction

Sept 11
List of Excel Formulas
Excel 1: Formulas
Venn Diagrams, And, Or, Not

Homework:
Venn Questions #1, 3, 5, 7.

Sept 12
Venn Diagrams (3 Bubble)
Excel 2: Fill Down
Sheet 1.2

Answers:
1.1 Trees, 1.2a Two Bubble Venn

Extra Optional Excel
B1. Cell Formatting, XL Sheet
B2. Pivot Tables, XL Sheet

Homework:
3 Bubble Venn #2, 4, 6, 8
Sept 13
Probablity Formulas
Mutually Exclusive
Sheet 1.3

Homework:
1.6 Indep Mututally Exclusive - # 1, 2, 3


Sept 14
Formula Practice
SAT probability of perfect
Probability Formula Quiz tomorrow!


Homework:
1.5 Formulas - #2, 3, 4, 5, 6
** Special Note: Ms. Gorski won't check Homework on Sept 15 because of the quiz.

Sept 15
Conditional Probablity
Random Sneeze

Probablity Formula Quiz
Probablity Quiz Solutions

Homework:
1.7 Conditional Prob #2, 5, 8
Sept 18
Probability Formula Quiz Re-write (optional)

Probability Formulas Practice
Trees Without Replacement

Homework:
Trees without Replacement #2, 3, 6


Sept 19 - Photo Day
Probability Formula Quiz (optional)
And Or Not Lesson (powerpoint)

Excel And, Or, Not

Homework: Formula Practice and Review #1, 2, 3
Sept 20 - Photo Day
Sample Test 1 (super open book)
- You may use your flash cards, sheets, or notes
- No phones, no computers
- You may work with a group
- You may ask questions
Sept 21
Probability Formula Quiz (Optional)

Excel Finish up
Correct Sample Test Solution
Test Review Cards
Sept 22 - Terry Fox
Factorial (unit 2)

Review Knowledge Short Answer
Review Communication & Thinking

Homework: 2.1 Factorial - #1, 3, 5abc, 6abc, 7ab
Sept 25
Unit 1 Test Review
Review Knowledge Short Answer
Review Communication & Thinking
Videos:
7. Tree without Replacement
12. Three Bubble Venn
13. Conditional Prob and Tree
Sept 26
Permutations

Homework: Unit 1 Test tomorrow!

Sept 27
Unit 1 Test
- closed book, no friends.
- must have a math department approved calculator
- for studying: Sample Test Solution, see other resources in Unit 1 below.
Sept 28
Permutations with Restrictions

Homework:
- Finish sheet: "Why Couldn't the School Keep a Secret?"
- Permutations #3, 4, 9

Sept 29 - Orange Shirt Day
A. Complete and Hand in Factorial & Permutations Review Sheet:
- Code Line Hint
- On the Button Hints

B. Log on and complete in Excel:
1. Excel as a Calculator [video]
2. Birthdays
3. Historical Riddle

Yesterday's Homework (Perms with Restrictions Sheet & Permutations #3, 4, 9) will be checked on Monday.
Oct 2
- Homework Check (Perms with Restrictions Sheet & Permutations #3, 4, 9)
- Back of Perms Sheet from Thursday
- Circle Permutations

Homework:
- Permutations #18-22
Oct 3
Permutations with Repeats

How's Excel Going?
1. Excel as a Calculator [video]
2. Birthdays
3. Historical Riddle
4. Perms Combs

Homework:
- Permutations #7, 25, 26, 27, 28
Oct 4
- Combinations
- Cards for Perms with Repeats, Circles, Combinations
- 2 sheets

Homework:
- Combinations #1, 3a, 4, 6
Oct 5
- Probability with perms and combs
- Cards for Problem Solving Types, Excel

How's Excel Going? For real this time.
1. Excel as a Calculator [video]
2. Birthdays
3. Historical Riddle
4. Perms Combs

Homework:
- Combinations #8, 10, 11, 14, 18, 19
Oct 6 - PL Day
Oct 9 - Thanksgiving Oct 10 - P3 Fire Drill
Sample Test #2

An Excel Reminder (again):
1. Excel as a Calculator [video]
2. Birthdays
3. Historical Riddle
4. Perms Combs
Oct 11
- Homework check from Friday: Combinations #8, 10, 11, 14, 18, 19
- Check Sample Test Solution
- Counting Test Review, answers
- PPDAC Intro

Oct 12
- Review for test
- PPDAC in more depth
Oct 13
Unit 2 Test - Counting

For studying purposes: sample test solution
Oct 16 [2:00 Dismissal JSC]
Sampling
Sheet 3.3
Oct 17
Moose Sampling
Hand in Sheet 3.1, 3.2, 3.3, 3.4.
A1 - Excel Scatterplots

Excel Line of Best Fit video
Google Sheets Line of Best Fit video
Google Sheets 2Variable Formulas
Oct 18
Movie Choice
R, R^2
Oct 19 [Buyout Football]
Causation vs. Correlation

Homework: #1-3 Causation vs. Correlation Questions.
Notice the quiz tomorrow.
Oct 20
PPDAC Quiz 1, Answer Guide

Modern Applications - Data mining
Sheet 3.6

More Excel:
A2 - Felton Report
Oct 23 -
1 variable statistics
Take Up Quiz 1
Cards

Excel:
A1 - Line of Best Fit
A2 - Feltron Report
A3 - One Variable

Bonus:
B1 - Formulas
B2 - Dialog Boxes
Oct 24 - Early Progress Due
Error and Bias
PPDAC Quiz 2, Answer Guide

Sheet Solutions:
3.1 PPDAC
3.2 Causal vs Descriptive
3.3 Sampling

Excel:
A3 - One Variable
Oct 25
Survey Questions

Homework:
3.9 Survey
Oct 26
Sample Test 3
Oct 27 - Early Release @ 11:00, Progress Reports Out
Central Tendency - Unit 3
Martians

Homework:
Measures of Central Tendency, #1, 2bc, 5. Investigation 1, 2, 3.
Oct 30 [Project Complete]
- Excel Finish Up:
A1 - Line of Best Fit
A2 - Feltron Report
A3 - One Variable
- Excel Bonus:
B1 - Formulas
B2 - Dialog Boxes

- Complete Homework from Friday: Measures of Central Tendency, #1, 2bc, 5. Investigation 1, 2, 3.

- Correct sample test.
- Correct sheets: 1 ppdac, 2 casual, 3 sample, 5 movie, 6 privacy, 7 bias.
Oct 31 [Halloween]
- Homework Check: Measure of Central Tendency (Friday)
- PPDAC Quiz (the fourth one)
- Histograms, Frequency Calculations
- Standard Deviation
- Begin Work on sheet 4.1
- PPDAC Review



Nov 1 [Chang @ Drones]
- IQR & Box and Whisker
- Begin Work on sheet 4.2
- PPDAC Review
- Box & Whisker Lesson
Nov 2 [Gorski @ Drones]
- Complete and submit sheet 4.1 and 4.2.
- If you are missing the sheets, the supply teacher has extras
- Hand sheets into the grey hand in bin
- Powerpoints:
(a) Distributions (end) - 4.1
(b) Standard Deviation - 4.1
(c) IQR & Box and Whisker - 4.2
- If done early, review for your test
Nov 3
Unit 3 - Test - PPDAC

For studying purposes:
- sample test.
- 1 ppdac, 2 casual, 3 sample, 5 movie, 6 privacy, 7 bias.

Nov 6
Normal Distribution

Homework: #3, 4, 6, 8, 9

Excel: A1. SpreadAnalysis, video: One Var, Histograms
Nov 7
Z-scores Table
Normal Distribution & Z Scores Lesson
Quiz

Homework: #1, 2

Nov 8
More ZScores
Even More ZScores



Nov 9
Excel Histograms
- Watch the video: One Var, Histograms
- Work on A1. SpreadAnalysis
- Complete Z-Scores Practice Homework: #5, 6, 7, 8, 9
Nov 10 - [10:30 Remembrance, Midterms Due]
- Z-Scores Tricky Questions
- Histograms in Excel
- Complete: A1. SpreadAnalysis
- Work on: B2. Histogram Review

Optional Homework 4.7 ZScores: #1, 2, 3, 4
Nov 13
Sample Test 4

Nov 14
Pascal's Triangle. Pascal's Method
Sheet 5.1
Nov 15
Probability Distributions
Homework:
- Variables #1, 2, 3
- Prob Distributions #1, 2, 3
Nov 16
Review Unit 4
Expected Value & Lotteries
Nov 17
Excel:
A1. Pascal's Triangle
A2. Expected Value
A3. Binomial

Sample Test Solution
Nov 20
The Distributions
Binomial Distribution
Test Review
Nov 21
Unit 4 Test - One Variable
Sample Test Solution
Test Review
Nov 22
Geometric Distributions
Old TextBook Link
Complete and submit 5.3 Binomial Distribtion + 5.4 Geometric Distribution
Nov 23
Hypergeometric
Nov 24 - PL Day
Nov 27
Practice Distribution Types
Sheet 5.6 Uniform Distribution
Review of Formulas & Types
- The Distributions

Nov 28
Sheet 5.7 Bug Random Walk
- Program in code.org
- Applications
Complete & Submit Sheet 5.6
Excel:
- A3. Binomial
- A4. Geometric
- A5. Hypergeometric
Nov 29
Project Introduction
- Video Project Example
- Art Project Example

Overall Assignment
Research Question Ideas
To Do on Project:
- Choose topic
- Find some graphs
- Find some data
- Be ready for Monday

Excel
New Cards
Nov 30
- Hand in Sheet 5.6 or 5.7 if missing
- Start project research
(a) Find some data
(b) Find some graphs
Record URLs as you go **

- Excel:
A1. Pascal's Triangle
A2. Expected Value
A3. Binomial
A4. Geometric
A5. Hypergeometric
Dec 1
Sample Test - Distributions
Formula Sheet
Dec 4 - [Research]
Research
Making a survey powerpoint.

Old Posts:
Research Question Ideas
Find some data

Examples:
- Video Project Example
- Art Project Example
Dec 5 - [Research]
Due start of class: Page 1 (intro) + Page 2 (cluster 1)

Work on Page 3.
Create bibliography, survey.


"Early Checkmarks"
Survey Example

*The earlier I get a draft of your survey, the earlier you can get data.
**Make your spreadsheet columns now. Start building it as you think about it.
Dec 6 [Gorski Away]
Due start of class: Page 3 (cluster 2) (Ms. Gorski will collect when she arrives)

Due tomorrow: Page 4 (cluster 3).

*Draft survey
*Draft spreadsheet
*Find more research and graphs that relate to your topic... histograms, time-series data, scatterplots, box and whister.
*Review sample test solution (I will give these back when I arrive at the end of the day; if the second half of class is cancelled, I will go to the cafeteria to hand them out).
Dec 7 - Review for unit 5
Due start of class: All of Research (all 4 pages)

Data Phase: Work on
(a) spreadsheet,
(b) bibliography,
(c) research (charts, data from internet),
(d) survey.

*Aim to submit survey by Monday
Dec 8
Data Phase:
Work on
(a) spreadsheet,
(b) bibliography,
(c) research (charts, data from internet),
(d) survey.

*Aim to submit survey by Monday

Test preparation.
Dec 11
Unit Test 5 - Distributions
Review Questions
Formula Sheet

Sample Test Solution
Blank Sample Test

Dec 12 - Data
Work on:
(a) spreadsheet,
(b) bibliography,
(c) research (charts, data from internet),
(d) survey.

*If doing a survey, submit today.
Dec 13 - Data
Due start of class: 1 of 3 Research papers.
Also show the associated:
(a) spreadsheet,
(b) bibliography,
(c) research (charts, data from internet),
(d) survey.

Work on source information for research OR collecting survey data.
Dec 14 - Data
Due start of class: 2 of 3 Research papers.
Also show the associated:
(a) spreadsheet,
(b) bibliography,
(c) research (charts, data from internet),
(d) survey.

Enter survey data into
Powerpoint discussion/demonstration.
Make and save Powerpoint file.
Dec 15 - Early Release @ 11:00
All Data is due today. I won't check it until Monday.
Begin work on analysis.

Make one Powerpoint slide (style template)
- choose font size (big, 44+)
- choose font
- choose heading colour
- choose font colour
- choose image style
- choose background colour
Dec 18 - Analysis
Due at start of class: Powerpoint Style Template
Slide Count for Powerpoint recorded.

1: Probability | Pie Chart | Bar Graph | Pictograph
2: Venn Diagrams: XL Venn Calcs | PP Venn Diagram | Video Bubble Calcs | Conditional Prob
3: Counting Calcs | Diagrams
4: 2 Var Video XL Line of Best Fit video | Video GS Line of Best Fit | Video GS 2Var Formulas
5: 1 Var Mean: Video One Var Calcs | Video Histograms | Normal Dist
6: 1 Var Median: Box and Whisker | Video GS
7: Simulation
Dec 19 - Analysis
Due start of class: One cluster done - both in Excel and in Powerpoint.
Slide Count for Powerpoint recorded.

Dec 20 - Analysis
Due start of class: Two clusters done - both in Excel and in Powerpoint.
Slide Count for Powerpoint recorded.

Adding analysis to each graph.
Second Order Questions.
Why is it important?

Dec 21 - Analysis
Due start of class: Three clusters done - both in Excel and in Powerpoint.
Slide Count for Powerpoint recorded.

Start building and organizing arguments.
Put in a title slide for each argument.
Add definitions, data, graphs from the internet.

Submit:
- Draft Spreadsheet
- Draft Powerpoint

Dec 22 - Analysis
Slide Count for Powerpoint.

Re-Submit: (if desired)
- Draft Spreadsheet
- Draft Powerpoint



Dec 25 - Break Dec 26 - Break Dec 27 - Break Dec 28 - Break Dec 29 - Break
Jan 1 - Break Jan 2 - Break Jan 3 - Break Jan 4 - Break Jan 5 - Break
Jan 8 - Conclusions
Reminder of overall project outline
Powerpoint details:
- Structure & Formatting
- Brainstorming Example
- Final Version Example (one research question)
Jan 9 - Conclusions
Second Order Questions
2nd Order Examples
More 2nd Order
2nd Order Thesis
Jan 10 - Conclusions [Wellness Day]
Aim to have Powerpoint Complete.
Are My Slides Done?
ONW - Omit Needless Words
(another version)
Jan 11 - Conclusions
Peer Review Day
Editing
Alpha Testing - Excel
Alpha Testing - Descriptions
Alpha Testing - Graph
Jan 12 - Final Project Draft Due
Submit:
- Final Spreadsheet
- Draft of Powerpoint

Jan 15 - Final Powerpoint Due
Pres Example
Submit: Final Powerpoint
Adding Sound, Recording video.
Reminder of overall project outline
Powerpoint details:
- Structure & Formatting
- Brainstorming Example
- Final Version Example (one research question)
Jan 16 - Videos Due
Submit: Final mp4 video, 5 minutes max.
Adding Sound, Recording video.
Jan 17 - Social Issues, Technology, Brains
- AK RSA
- HK Quantum Computers
- MS Rubix Cube
- MS Ebooks
- RL Personality Test
- SA Memory

Unit 1 Review
Jan 18 - Environment & Governance
- AS Turtles
- KM Deep Sea
- LL Water
- SZ GDP
- SS Fast Fashion
- SJ Pando

Unit 2 Review
Jan 19 - Sports & Entertainment
- AG NBA
- BP Soccer
- CP VAR Soccer
- DD Hockey
- JD Pokemon
- SR Wrestling
- ZK Movies

Unit 3 Review
Jan 22 - Seven Presentations
Business
- AS COVID small business
- HN Stock Market
- LP Business
- MR COVID small business
- PV Cell Phone Use
- RA AI Impact on Business
- SM COVID small business

Unit 4 Review
Jan 23 - Review

Unit 5 Review
Other Unit Review
Jan 24 - Review

Oscars Presentation.
Jan 25 - Exams - P1 Jan 26 - Exams - P2
Jan 29 - Exams - P3 - That's us.
8:30 - 10:00
Worth 20% of final grade
See resources below.
Jan 30 - Exams - P4 Jan 31 - Exams - Snow Day Make Up, if needed Feb 1 - Turnaround Day Feb 2 - Semester 2 - First Day of Class, Come to school