(12)  Probability and statistics. The student describes and predicts the results of a probability experiment. The student is expected to:

(A)  use fractions to describe the results of an experiment; and

(B)  use experimental results to make predictions.

(13)  Probability and statistics. The student solves problems by collecting, organizing, displaying, and interpreting sets of data. The student is expected to:

(A)  use tables of related number pairs to make line graphs;

(B)  describe characteristics of data presented in tables and graphs including the shape and spread of the data and the middle number; and

(C)  graph a given set of data using an appropriate graphical representation such as a picture or line.

• 1 cornman per student
• Computer(s) with Excel or equivalent Spreadsheet Program (Clarisworks)
• *Remember in Excel you MUST select the cell you want to work with prior to adding a formula or making a change.

1. Have students count the rows of corn.  They can compare the rows and columns of the cornman to that of the spreadsheet.
2. Have students type in the number that represents each color for each row. (Including the zeros).
3. As an enrichment students can color the cells, font, and border by going to "Format" and "Cells" in MS Excel.
4. Have students add the total number of each color, then add the total number in each row.  They should add using the "Formula" button.
5. Once complete, have students predict what rows 8 -20 would look like if there were more rows.  They should explain why they are making this prediction.
6. Students should also write fractions that represent the colors illustrated on each row.  (Example:  Row 1 = 3 Golds and 1 Yellow.  The answer is 3/4 of row 1 is Gold and/or 1/4 of row 1 is Yellow.)
7. After students calculate totals using the formula button, they can create a line graph to represent the number of overall colors.  One method is to highlight the row with the color names, hold down the "CTRL" key on the keyboard, and then highlighting the totals.  After letting go of the "CTRL" key, students can click on the chart/graph button and follow the wizard to generate a line, bar, column, or pie graph or chart.
8. Students can also determine the Mean, Median, and Mode of each row.