Mathematics of Data Management

Semester 1, 2017-18

Mr. Lieff

Carleton Place High School

New items are highlighted!


Links to Units
Unit 1 - Visual Representations
Unit 2 - Collecting Data
Unit 3 - Probability
Unit 4 - Counting and Probability Distributions
Unit 5/6 - Statistical Measures
Final Exam
Statistics Project

Grade Calculator
Cartogram - Roads in Canada.jpg

Heat Map - Roads in Canada

Textbook: Mathematics of Data Management (Nelson)

On the web: Nelson MDM4U Textbook
At school: X:\Documents\Lieff\MDM4U


COURSE SLIDES: are in Microsoft PowerPoint format. Students can install MS Office for free

PRINTING NOTE: It is recommended that you print 6 slides per page.
1. Click File | Print
2. Click Slides: Handouts | 6 Slides Horizontal

SMART Notebook v15 (90d free trial) (school version 11.4 and reg key at X:\documents\SMART)
Fathom2 Fathom Tutorials
GCFLearnFree - MS Office Tutorials


General Resources
Statistics Glossary Probability and Statistics eBook
Against All Odds - Inside Statistics Videos #1-21, 24 cover topics in this course
Statistics Online Computational Resource at UCLA
Statistics How-To
Statistical Symbols

Unit 1 - Visualizing Data (Ch1)

Class Notes
MSIP / Home Learning


1.1 Notes
1.1-1.2 Slides (20-Oct-16)
1.1 p. 11 #2, 3ab, 4, 7, 8
Statistics Glossary
Statistics Canada Graph Types
YT: Hans Rosling's 200 Countries, 200 Years, 4 Minutes
How to Make Data Look Sexy (CNN)
What apps are most used by Canadians?
What is the most common rhyme in the history of pop music?
Where in the USA is Carleton Place?
40 World Maps40 Awesome Maps
US Election Maps CNNNPR 270 To Win
Map: Advance voter turnout
Tulo Heat Maps
Canadians and the Pokemon craze, in four charts
Trump Slideshow Data
Fraser Institute - Compare Schools
33 Maps That Explain America
Graph Copycat Assignment

Sep 27
Sep 28
Infographics Assignment (3-Nov-16)
SMART Notebook Quick Reference
Due date: 11-Apr
World Map (use Paint to Colour)

Statistics Canada Infographics
San Jose Sharks Infographics Colorado Avalanche Infographics
Every Shot Kobe Took
Cool Infographics
Daily Infographic - a new infographic every day! Browse a few pages
50 Informative and Well-designed InfographicsLinks above each one jump to image
Pinterest Hockey InfographicsLook for ones with 3 graphs

Tools - some require a subscription
How to Create an Awesome Infographic Read this site
10 Awesome Free Tools To Make Infographics
How to Create an Infographic in an Hour or LessRequires creating graphs in Excel or Powerpoint
20+ Tools to Create Your Own InfographicsList of web sites
15 Tools to Make Amazing InfographicsList of web sites
How to create 5 fabulous Infographics (PPT)Requires good knowledge of PowerPoint

Kathy Schrock's Resources

Sick days

1.2 Read pp. 16–19
p. 20–24 #1, 4, 9, 11, 14
20 Insane Things That Correlate With Each Other

Chapter1.3to1.5.pptx (3-Nov-16)
MDM4U 1.3 Ex1.xlsx
1.3 p. 37 #2, 3, 6, 8Cereals and Drug Prices

Interpreting CorrelationsCorrelationPicture applets(use IE at school)
Correlating Data
youtube: Scatterplots and Correlation Coefficients in Fathom
video: Median-Median (3-Median) Line
Google Trends

1.4 p. 51 #1-2, 3-5 (use Fathom), 8
desmos - Linear Regression
Math Captain: Correlation

Cereal data
NHL Data Activity
NHL Teams by Height, Weight and Age
NHL Height Weight 1917-2015

Ch1 Summative (11-Apr-17)
Due: 21-Apr-17

1.5 (PPT)
Read pp. 57 – 60 Ex. 1-2
Complete p. 60 #1-6
video: Misleading Graphs

Comparing Apples to Oranges
Junk Charts
Misleading Graphs - WikipediaMisleading Graphs - Mr. McGrail
Misleading Graphs - Statistics How-To
Canadian teachers quitting in droves?
Canadians' math and literacy skills above par ...or are they?
2/3 of Quebecers want baseball back
Fathom Demo Chapter 1 - Fathom.ppt
StatCan Study: The financial impact of student loans

Unit 2 - Probability (4.1-4.5)
Class Notes
MSIP / Home Learning

YT: The Last banana
Chapter4.1to4.2.ppt (7-Feb-17)
4.1 pp. 209-212 #1, 5, 8-10, 12-13

MS Excel Random Number Formulas
Random 0 or 1 (coin toss, predict gender of a baby)
Random H or T (coin toss)
Random integer between 1 and n
To use:
Enter the formula
Fill down to generate a block of random numbers
Copy then Paste As Values
Human Sex RatioNumber of males vs. females worldwide
Plinko Customizable
UofT Day Statistics Applets Plinko, Dice, n(heads)
NLVM Coin Tossing
Paradise Simulator
Flipping coins One (historical results) Up to 10 Weighted
Experimental Probability spinners and dice
Belgian Lottery Numbers come up twice in a row
NHL Lottery Simulator
Wheel Decide
Probability Fair
Random Numbers in Excel
4.2 pp. 218-219 # 4-7, 9, 10, 12
Gerolamo Cardano - wikipediaGerolamo Cardan Biography
4.3 - 4.4 (PPT) 14-Feb-17
4.3 p. 228 #1, 2, 4, 7, 8, 10–14, 17
Venn Diagram Tool
video: Venn Diagram Example
4.4 pp. 235–238 #1, 2, 4, 6, 7, 9, 10, 19
Count Us In (Lets Make A Deal)

Probability Investigation - The Monty Hall Problem
Simple Monty Hall
4.5 (PPT) 14-Feb-17
4.5 pp. 245–249 #2, 3, 5, 7, 9, 12, 13a, 14
Intro - Games Fair (15-Feb-17)
Probability Trees
Wizard of Odds
Unit 1 Review (PPT) 14-Feb-17
pp. 268-269 #3-4, 5abceg, 7, 9, 10a-d; p. 270 #1-2, 6
Practice Test
MDM4U Probability and Counting Formulas (DOC)
Practice Test MC Answers
1.B 2.C 3.A 4.D 5.A
6.C 7.A 8.C 9.C 10.D
11.C 12.B 13.C 14.B 15.C
Unit 1 Test - Probability (4.1-4.5)

Unit 3 - Counting and Probability Distributions (4.6-4.7, 5.1-5.2)
Class Notes
MSIP / Home Learning
Extra Resources
Arranging Blocks Activity

4.6-4.7 (2-Mar-17)
4.6 pp. 255-257 #1-7, 11, 13, 14, 16
Ted Talk - Shuffling cards 52 Factorial Shuffling Cards Time Travel Card Trick
Hearing Permutations
4.7 pp. 262 – 265 # 1, 2, 3, 5, 7, 9, 18
Coke Freestyle: All The Flavours
5.1 Expected Value.ppt (7-Mar-17)
Expected Value video - patrickJMT
Expected Value - Intro and examples (7:30 AppleCare)
Would you take this bet?
How to calculate Expected Value
5.1 - 5.2 (PPTX) (7-Mar-17)
5.1 p. 277 #1-9, 12, 14
Creating a Probability Distribution in MS Excel
video: Creating a Probability Distribution (3 coins)
Two brothers win Powerball
Binomial Distributions - Math Is Fun (covers 5.1-5.3)
5.2 p. 289 #1, 2aceg, 6-8, 11-12
TED-Ed Pascal's Triangle
Colouring Pascal's Triangle Hearing Pascal's Triangle

Games Fair Planning Period
Games Fair Exemplar - Angry Birds
Games Fair Day 1
Operators: Liam Carmen Jayme Zach Caelin Nancy Adam Hannah Derek James
Games Fair Day 2
Operators: Owen Charles Kelly Leticia Tim Lucas Steven Carson Maria Hayden

Unit 2 Review (PPT) (11-Oct-16)
pp. 268-269 #1, 5df, 6, 8, 11; p. 270 #3-4, 7
pp. 324-325 #1-6; p. 326 #1, 6
MDM4U Probability and Counting Formulas (DOC)
Path Counting Examples from Class
Practice Test

Jazz Day
Games Fair due 2:20 PM

Unit 2 Test (4.6-4.7, 5.1-5.2)
U2 Test Solution
How to win Lotto 649

The Monty Hall Problem
Video by Ron Clarke
Clips from NUMB3RS and '21'
Let's Make A Deal applet

Unit 4 - Collecting Data (Ch2)
Class Slides
MSIP / Home Learning

2.1-2.2 (PPTX) (14-Nov-16)
2.1 p. 81 #4, 8, 13
Canadians Think Friday is the Best Day of the Week
Sample Size Calculator Margin of Error Calculator
Advanced Sample Size Calculator
Leafs are 0-4-1 when Kessel doesn't score
U.S. Netflix not for Canada
Which party is really in the lead?

2.2 pp. 89-90 #1-2, (3-4)adeh, (5-6)ab, 7acd

2.3 - 2.4 (PPTX) (14-Nov-16)
p. 99 #1, 5, 6, 10, 11
For 6b, see Ex. 1 on p. 95
Survey Questions 101: Do You Make any of These 7 Question Writing Mistakes?
Basics of Survey and Question Design
Examples of Bad Questions and How to Fix Them
The Good, The Bad and the Ugly: Survey Examples

LC Survey from Class
p. 105 #1-2, 4-5, 8-9, 12

Chapter 2 Problem - Statsville High School (DOC)

2.5 - 2.7 (PPTX 16-Nov-16)
Read p. 111 Ex 1 and 2
2.5 p. 113 # 1-7, 11
2.6 p. 123 # 7-9. 11
Backchecking - the Value of NHL draft picks
Europeans’ Plan to do Uncontrolled Ebola Trial Draws Fire
Asthma Pill
Current Research Trials & Opportunities (UOttawa)

Ch1-2 Review (PPTX) 2-May-17
Ch1 pp. 71-72 # 1, 3-10 (see slides for graphs)
Ch2 Review pp. 136-137 #1abd, 2, 4–8

Chapter 2 Twizz
Clinical Trials
Stand up Comedy - Spreadsheets Spreadsheet Converter
1940 census - How the US has changed in 72 years

Unit 5 - Normal Distribution and Binomial Probability (Ch3, 5.3-5.4)
Web page tying Ch1/2/4 in with 3.1-3.3
Class Slides
MSIP / Home Learning

Chapter3.1to3.2 (PPTX) (3-May-17)
3.1 p. 146 #1, 2, 4 , 9, 11 (data in Excel file on wiki),13
Old Faithful Histogram
Are Pop Lyrics Getting More Repetitive?

3.2 p. 159 #4, 5, 6, 8, 10-13
Statistics Calculator (Lots of stuff here!!!)

3.3 - 3.4 (PPTX) 9-May-17
3.3 p. 168 #2b, 3b, 4, 6, 7, 10
Standard Deviation and Variance
Standard Deviation Calculator
Online Stats Course
Quantile | Wikipedia
Box and Whisker Plots (patrickJMT)
Box and Whisker Plot Excel 2013 Excel 2016 Designer
How to Tell Someone’s Age When All You Know Is His/Her Name
Are women bad at math?
7 Species - The Data

3.4 p. 176 #1, 3b, 6, 8-10 (20-Jan-16)
Normal Distibution - Math is Fun
Online English Vocabulary Test

Ch3 Asgt
Instructions Ch3 Summative (28-Nov-16)
Data MDM4U heightdata.ftm
Due date 26-May-17
Census @ School Data Selector

Project Day
Senior Privileges

3.5 to 3.6 (PPTX) 24-Apr-16
Read examples on pp. 180-185
3.5 Complete p. 186 #2-5, 7, 8, 10
Z-Score Table
Normal Distribution Calculator (use IE) mu = mean, sigma = standard deviation
Cool School Range Tool - Use 0 as the lower bound to find the % below a data value
Calulating Percentile Rankings
Free IQ Test (Mr. Lieff = 135 Nov/13)
Memory Experiments

Graphing a Normal Distribution Curve in Excel

5.3 - 5.4 (PPTX) 6-Dec-16
5.3 p. 299 #1, 3, 7, 8 – 12
The Binomial Distribution (5.3-5.4)
Roll 1-8 dice
Binomial Probability Calculator

5.4 p. 311 # 4-10

3.6 Read pp. 189-192
Complete pp. 193-195 #1a (odd), 2-3 ac, 4 (alt: calculate SLG for 3 players on your favourite team for 2012), 8, 9, 11
BMI CalculatorBMI and Body Weight Comparison
Slugging Percentage - Hitting for the Cycle
TravelZoo Moving Average

NHL Fan Cost Index Graph Pro Sports Fan Cost Index Reports
Big Mac Index
Christmas Price Index

Fraser Institute - School Report Cards

Ch3-5 Review (PPT) 11-Dec-16
p. 199 #6; p. 200 #3-7 (use a table for #6)
pp. 324 – 325 #7, 9-12

Test 3.5/6, 5.3/4

Extra asgt Ch3-5 Problem

Rolls up to 100 dice and shows a histogram of the individual and cumulative results

Roll multiple dice and see the frequency and sum distributions; calculates average and standard deviation (misdirected as of 18-May-16)

Simple IQ Test
IQ Test (e-mail required)

Final Exam

List of Topics
Practice questions w answers


MDM4U Final Project Handout.doc (12-May-16) Marking sheet
Statistics Report (PPT)
Presentation (PPT)
What the p-value?What the p-value?

Report: Teachers' Pay in Canada (Summary and Infographic)

Due dates
Thesis Question / Statement
verbal - recorded
Word processed document as per project handout
Schedule below
Presentation File or Presi
Written Report
Word processed document meeting all requirements in project handout


You are expected to attend all 4 days.
Textbook due back by (or at the exam).
Presentation Reminders
Sample presentation

Attendance is part of your report mark.

Project Links

Ottawa Board MDM4U site
BrockU - 2003-2004 Sample Projects
Mr. Brotto's Sample Projects
Project Intro (PPT)

Statistics in Sports

APA format for sourcing information


Google Forms Very straightforward; integrated with google (requires google account)
Survey Monkey User friendly; 10 question limit on free version. (requires account)
Fathom Surveys

Creating a survey: username: cphs_survey password: survey
Filling out a survey: username: cphs_data password: data
Link shorteners Allows aliases

Data Sources (from Project Handout)
Statistics Canada:

Found Data (David Petro)
US Census at School Random Data
University of Michigan Library Statictics Search (US and CANADA)
Nation Master
Mr. Nephin's Resource Index Resource Index.doc

QELP (Quantitative Environmental Learning Project) Data Page
Info Please
p. 105 #1-2, 4-5, 8-9, 12