Probability Spreadsheets
By - Eric Hood
Subject - Math, Computers
Grade Level - 6-High School

Software: Spreadsheet

Team Coin Toss or Dice Probability Spreadsheets

OVERVIEW:
Students pair up and toss coins to learn probability of coin tosses and then make a spreadsheet and graph to record the data.

PURPOSE:
To increase the knowledge of probability and how it affects a simple coin toss and then apply computer skills in using spreadsheets.

OBJECTIVES:
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.

RESOURCES/MATERIALS:
Computers, Microsoft Spreadsheet on the Works program or other spreadsheet 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 a spreadsheet 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.

Lesson found at http://www.lessonplanspage.com/CIJH.htm