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

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

## Mathematics of Data Management

## Semester 1, 2017-18

## Mr. Lieff

Carleton Place High SchoolNew 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

Heat Map - Roads in CanadaTextbook: 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 freePRINTING NOTE:It is recommended that you print 6 slides per page.1. Click

File | Print2. Click

Slides: Handouts | 6 Slides HorizontalSOFTWARE DOWNLOADSSMART 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 ResourcesStatistics 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.htmlDateClass NotesMSIP / Home LearningResourcesSep11

1.1-1.2 Slides

(20-Oct-16)1.1 p. 11 #2, 3ab, 4, 7, 8

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

Sep26

Sep 28

(3-Nov-16)SMART Notebook Quick Reference

Due date: 11-Apr

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

p. 20–24 #1, 4, 9, 11, 14

(3-Nov-16)MDM4U 1.3 Ex1.xlsx

1.3 p. 37 #2, 3, 6, 8Cereals and Drug Prices

Correlating Data

youtube: Scatterplots and Correlation Coefficients in Fathom

video: Median-Median (3-Median) Line

Google Trends

Math Captain: Correlation

https://www.hashtags.org/

NHL Data Activity

NHL Teams by Height, Weight and Age

NHL Height Weight 1917-2015

Due: 21-Apr-17

Read pp. 57 – 60 Ex. 1-2

Complete p. 60 #1-6

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

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)DateClass NotesMSIP /Home LearningResources(7-Feb-17)4.1 pp. 209-212 #1, 5, 8-10, 12-13

MS Excel Random Number FormulasRandom 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

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.3 - 4.4 (PPT) 14-Feb-174.3 p. 228 #1, 2, 4, 7, 8, 10–14, 17

video: Venn Diagram Example

4.5 (PPT)14-Feb-174.5 pp. 245–249 #2, 3, 5, 7, 9, 12, 13a, 14

Intro - Games Fair (15-Feb-17)

Wizard of Odds

Oct20

Unit 1 Review (PPT) 14-Feb-17pp. 268-269 #3-4, 5abceg, 7, 9, 10a-d; p. 270 #1-2, 6

Practice Test

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 3 - Counting and Probability Distributions (4.6-4.7, 5.1-5.2)DateClass NotesMSIP / Home LearningExtra Resources(2-Mar-17)4.6 pp. 255-257 #1-7, 11, 13, 14, 16

Hearing Permutations

(7-Mar-17)Expected Value - Intro and examples (7:30 AppleCare)

Would you take this bet?

How to calculate Expected Value

(PPTX) (7-Mar-17)5.1 p. 277 #1-9, 12, 14

video: Creating a Probability Distribution (3 coins)

Two brothers win Powerball

Binomial Distributions - Math Is Fun (covers 5.1-5.3)

Colouring Pascal's Triangle Hearing Pascal's Triangle

Operators: Liam Carmen Jayme Zach Caelin Nancy Adam Hannah Derek JamesOperators: Owen Charles Kelly Leticia Tim Lucas Steven Carson Maria HaydenUnit 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

Path Counting Examples from Class

Practice Test

Games Fair due 2:20 PM

The Monty Hall ProblemVideo 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)DateClass SlidesMSIP / Home LearningResources(PPTX) (14-Nov-16)2.1 p. 81 #4, 8, 13

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

(PPTX) (14-Nov-16)p. 99 #1, 5, 6, 10, 11

For 6b, see Ex. 1 on p. 95

Basics of Survey and Question Design

Examples of Bad Questions and How to Fix Them

The Good, The Bad and the Ugly: Survey Examples

p. 105 #1-2, 4-5, 8-9, 12

(DOC)(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

Europeans’ Plan to do Uncontrolled Ebola Trial Draws Fire

Asthma Pill

Current Research Trials & Opportunities (UOttawa)

Ch1-2 Review (PPTX) 2-May-17Ch1 pp. 71-72 # 1, 3-10 (see slides for graphs)

Ch2 Review pp. 136-137 #1abd, 2, 4–8

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

DateClass SlidesMSIP / Home LearningResourcesChapter3.1to3.2 (PPTX) (3-May-17)3.1 p. 146 #1, 2, 4 , 9, 11 (data in Excel file on wiki),13

3.1_Q11.xlsx

Old Faithful Histogram

http://onlinestatbook.com/

http://davidmlane.com/hyperstat/A25329.html

Are Pop Lyrics Getting More Repetitive?

Statistics Calculator (Lots of stuff here!!!)(PPTX) 9-May-173.3 p. 168 #2b, 3b, 4, 6, 7, 10

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

Online English Vocabulary Test

InstructionsCh3 Summative (28-Nov-16)DataMDM4U heightdata.ftmDue date26-May-17Senior Privileges

(PPTX) 24-Apr-16Read examples on pp. 180-185

3.5 Complete p. 186 #2-5, 7, 8, 10

Z-Score Table

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

(PPTX) 6-Dec-165.3 p. 299 #1, 3, 7, 8 – 12

Roll 1-8 dice

Binomial Probability Calculator

https://www.youtube.com/watch?v=xNLQuuvE9ug

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

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

(PPT) 11-Dec-16p. 199 #6; p. 200 #3-7 (use a table for #6)

pp. 324 – 325 #7, 9-12

Rolls up to 100 dice and shows a histogram of the individual and cumulative resultshttp://archives.evergreen.edu/webpages/curricular/2003-2004/doingscience/flash/dice.htmlRoll 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.htmlSimple IQ Test http://www.begent.org/intelquiz.htm

IQ Test (e-mail required) http://www.iqtest.com/index.html

## Final Exam

List of TopicsPractice questions w answers

## CULMINATING PROJECT

MDM4U Final Project Handout.doc(12-May-16)Marking sheetStatistics Report (PPT)

Presentation (PPT)

What the p-value?What the p-value?

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

Due dates## PRESENTATION SCHEDULE

You are expected to attend all 4 days.

Textbook due back by (or at the exam).

Presentation Reminders

Sample presentation

## Project Links

Ottawa Board MDM4U siteBrockU - 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

SurveysGoogle 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

:password:cphs_surveysurveyFilling out a survey: username

:passwordcphs_data:dataLink 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 PageInfo Pleasep. 105 #1-2, 4-5, 8-9, 12