MDM4U

Mathematics of Data Management

Semester 1, 2017-18

Mr. Lieff

Carleton Place High School

New items are highlighted!


ANNOUNCEMENTS



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

FILES AND LINKS


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

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

COURSE NOTES


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)

Datasets http://paws.wcu.edu/emcnelis/StatsExamples.html
Date
Class Notes
MSIP / Home Learning
Resources
Sep5


Sep6-Sep9
Sep11


censusatschool.ca

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
http://www.informationisbeautiful.net/
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
https://www.graphiq.com/
Fraser Institute - Compare Schools
33 Maps That Explain America
Sep25
Sep26
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)

Examples
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

Piktochart
Infogram
Venngage
Kathy Schrock's Resources

Sick days
https://en.wikipedia.org/wiki/Arabs

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
https://www.hashtags.org/


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
Residuals http://www.math.csusb.edu/faculty/stanton/m262/regress/
StatCan Study: The financial impact of student loans http://www.statcan.gc.ca/daily-quotidien/100129/dq100129c-eng.htm

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


YT: The Last banana
Oct4
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)
=RANDBETWEEN(0,1)
Random H or T (coin toss)
=IF(RANDBETWEEN(0,1)=0,“H","T")
Random integer between 1 and n
=RANDBETWEEN(1,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
Oct10
4.2 pp. 218-219 # 4-7, 9, 10, 12
Gerolamo Cardano - wikipediaGerolamo Cardan Biography
Oct11
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
Oct16
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
Oct17
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
Oct19
Oct20
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
Oct23
Unit 1 Test - Probability (4.1-4.5)
Solution

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

Oct26
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
Oct30
4.7 pp. 262 – 265 # 1, 2, 3, 5, 7, 9, 18
Coke Freestyle: All The Flavours
Oct31
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
Nov6
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)
Nov7
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
Nov2
Games Fair Day 1
Operators: Liam Carmen Jayme Zach Caelin Nancy Adam Hannah Derek James
Nov3
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 http://www.youtube.com/watch?v=mhlc7peGlGg
Clips from NUMB3RS and '21' http://www.youtube.com/watch?v=OBpEFqjkPO8
Let's Make A Deal applet http://stayorswitch.com/

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

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?
Namespedia

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
Date
Class Slides
MSIP / Home Learning
Resources

Chapter3.1to3.2 (PPTX) (3-May-17)
3.1 p. 146 #1, 2, 4 , 9, 11 (data in Excel file on wiki),13
Quincunx
3.1_Q11.xlsx
Old Faithful Histogram
http://onlinestatbook.com/
http://davidmlane.com/hyperstat/A25329.html
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
https://www.youtube.com/watch?v=xNLQuuvE9ug

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

CPI-Ontario
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
http://archives.evergreen.edu/webpages/curricular/2003-2004/doingscience/flash/dice.html

Roll multiple dice and see the frequency and sum distributions; calculates average and standard deviation (misdirected as of 18-May-16)
http://archives.evergreen.edu/webpages/curricular/2003-2004/doingscience/flash/sumdice.html

Simple IQ Test http://www.begent.org/intelquiz.htm
IQ Test (e-mail required) http://www.iqtest.com/index.html

Final Exam

List of Topics
Practice questions w answers


CULMINATING PROJECT

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
Item
Date
Format
Thesis Question / Statement
TBA
verbal - recorded
Proposal
TBA
Word processed document as per project handout
Presentation
Schedule below
Presentation File or Presi
Written Report
16-Jun
Word processed document meeting all requirements in project handout

PRESENTATION SCHEDULE


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 http://www.amstat.org/sections/SIS/

APA format for sourcing information
http://www.liu.edu/CWIS/CWP/library/workshop/citapa.htm

Surveys

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 shortenershttp://tinyurl.com/ Allows aliaseshttps://bitly.com/

Data Sources (from Project Handout)
Statistics Canada: www.statcan.ca

Found Data (David Petro)
US Census at School Random Data
University of Michigan Library Statictics Search (US and CANADA)
Nation Master www.nationmaster.com
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