view a plan
This one involves Computer Spreadsheets and Probability
Computers & Internet, Math
6, 7, 8, 9, 10, 11, 12
Title – Probability Spreadsheets
By – Eric Hood
Subject – Math, Computers
Grade Level – 6-12
Team Coin Toss or Dice Probability Spreadsheets
Students pair up and toss coins to learn probability of coin tosses and then make a spreadsheet and graph to record the data.
To increase the knowledge of probability and how it affects a simple coin toss and then apply computer skills in using spreadsheets.
Students will be able to: Team up and (1) create probability outcomes,(2) record data and(3) create a spreadsheet using the probability data and then a (4) graph for visual reference.
Computers, Microsoft Spreadsheet on the Works program, work sheet, coins, dice, cards or other devices to devise a probability ratio, printer, and web editor if placing on the Internet.
ACTIVITIES AND PROCEDURES:
Students are paired off, one recorder and one does the probability experiment.
Student rolls dice or flips coins (50 times using the worksheet provided as the guide), the other student records the data.
Students add up the results and using the MS Works program show their results in a digital format.
Activity may be placed in a booklet for all and/or published on the web site.
Note: Could easily use the scientific method before attempting the experiment.
TYING IT ALL TOGETHER:
To show students how the probability system works and show how the computer can enhance a difficult task of teaching.
Students see how they apply skills with the computer to everyday events, sheet will have all data posted as on the worksheet.
E-Mail Eric !