Graphing

**EXCEL & GRAPHING**
Which flavor do you prefer? Choose your flavor of Ben and Jerry's or Haagen-Dazs ice cream and go stand with others with the same choice.
 * Human Bar Graph**

Go to Ben and Jerry's Online and create your own flavor. @http://www.benjerry.com/activism/inside-the-pint/do-the-world-a-flavor/generator.cfm

Teachers and students can use Excel for a variety of tasks. Excel, a versatile tool, can increase teacher and student productivity for management and computation tasks. Teachers and students can collect and analyze data for making decisions, solving problems, drawing conclusions and making generalizations.
 * A "Starter" Excel Project - Ice Cream Sugar Count** (Jenny)

1. Predict how many sugar cubes each type of ice cream contains. 2. Look at the number of grams of sugar from the nutritional information on the container. Were you close? 3. Open Excel and record the ice cream names. (Tip: start on A2) 4. In column B title and record the number of grams of sugar. 5. In column C put the number 3 to represent the number of grams found in a cube of sugar. 6. In column D put the formula that will divide the number of grams in the ice cream by the number of grams found in a cube of sugar. The formula will look like this: =B2/C2 (change to B3/C3 on next row, B4/C4, B5/C5) 7. What does your information show? 8.Create a graph to easily analyze this information.
 * Can you believe there is all that sugar in your ice cream?
 * Which ice cream flavor had the most?
 * Which ice cream had the least?
 * What you predict for a 1/2 gallon? A gallon?
 * Do you think you will continue to eat ice cream?

**Excel Step by Step**

 * 1) Toolbars, Rows, Columns
 * 2) Entering Data
 * 3) Creating Graphs
 * 4) Pictographs - An "excel"lent way to create pictographs for younger students


 * 1) []

@http://office.microsoft.com/en-us/training/CR100479681033.aspx Davis School District Handouts []
 * Excel Resources **

Marbles!

Do you feel like you are losing your marbles? We sure do! Tonight we will learn about Microsoft Excel, graphs, and online resources through investigating [|marbles]. Beware....you may just have fun! > > >
 * 1) Work in teams of 3, take a scoop of marbles.
 * 2) Sort your marbles based on a classifying system you design.
 * 3) Once your marbles are sorted, compare your classification system with the [|types of marbles]  website. Can you find your specific marbles?
 * http://www.fs-usa.com/toy/subcats.aspx?cat1=125&cat2=190
 * http://www.landofmarbles.com/loose-playing-marbles.html
 * http://www.megaglass.com/c/toy-playing-marbles.html
 * http://www.landofmarbles.com/mm5/merchant.mvc?Screen=CTGY&Store_Code=lom&Category_Code=mega-marble-nets&offset=0
 * 1) Record your marble data.
 * 2) Play a [|game of marbles]. Be back ready to work in Microsoft Excel afterwards.
 * 1) Extensions
 * 2) Have students create a new game that could played with marbles.
 * 3) Interview parents or grandparents and find out their experiences with marbles or other similar games that they played when they were young.
 * 4) Research the origins of the sayings "Losing your marbles" or "He's holding all the marbles". Where and how did they originate?



Create a Graph

 * http://nces.ed.gov/nceskids/createagraph/
 * [|Virtual Manipulative 3-5 Data Analysis & Probablility]
 * [|Virtual Manipulative 6-8 Data Analysis & Probablility]

**Graphing Lesson Plans**

 * 1) http://www.teach-nology.com/teachers/lesson_plans/math/graphing/
 * 2) http://www.geocities.com/smilecdg/graphingles.html
 * 3) http://www.cyberbee.com/probability/graph3.html

**Additional Sites**

 * [|Medicine Hat School District]
 * [|Excel Tutorials]
 * [|NCTM]
 * [|Census]