(Click here to return to the lesson plan.

Standards for the lesson plan
Data Analysis and Probability: Graphing Candy with Excel

These standards and benchmarks are from McREL's online database, Content Knowledge: A Compendium of Standards and Benchmarks for K-12 education (4th edition, 2004) (http://www.mcrel.org/standards-benchmarks/.) The mathematics portion of the database was developed using National Council of Teachers of Mathematics (NCTM) standards in addition to other nationally recognized standards documents.

Standard 1: Uses a variety of strategies in the problem-solving process
Grades 5-8

Benchmark 5: Knows the difference between pertinent and irrelevant information when solving problems

Benchmark 6: Understands the basic language of logic in mathematical situations (for example, "and," "or," "not")

Benchmark 7: Uses explanations of the methods and reasoning behind the problem solution to determine reasonableness of and to verify results with respect to the original problem

Standard 2: Understands and applies basic and advanced properties of the concepts of numbers

Benchmark 7: Understands the concepts of ratio, proportion, and percent and the relationships among them

Standard 3:  Uses basic and advanced procedures while performing the processes of computation

Benchmark 4: Selects and uses appropriate computational methods (for example, mental, paper and pencil, calculator, computer) for a given situation

Benchmark 6: Uses proportional reasoning to solve mathematical and real-world problems (for example, involving equivalent fractions, equal ratios, constant rate of change, proportions, percents)

Standard 6: Understands and applies basic and advanced concepts of statistics and data analysis

Benchmark 5: Uses data and statistical measures for a variety of purposes (for example, formulating hypotheses, making predictions, testing conjectures)

Benchmark 6: Organizes and displays data using tables, graphs (for example, line, circle, bar), frequency distributions, and plots (for example, stem-and-leaf, box-and-whiskers, scatter)

Standard 7: Understands and applies basic and advanced concepts of probability

Benchmark 2: Determines probability using simulations or experiments

Benchmark 5: Understands the relationship between the numerical expression of a probability (for example, fraction, percentage, odds) and the events that produce these numbers