Spreadsheet - continued

Examples:

nose	5
eye	4
mouth	6
Above is an organized
spreadsheet table.
.	.
.	.
Below is a single column chart.			Above is a picture of unorganized information.
Below is a pie chart.

More Instructions for using Excel:
Pie	Finishing Touches (graph color, size)
Single Column          Multiple Column	Line Graph
Ordered Pairs Latitude and Longitude	Pictograph
Solve Word Problems (formula)	Functions - Statistical Landmarks (avg, min, max, count)  - Please read this review sheet.
Create a Timeline	Bubble Chart

      Return to top.

Exercises:

Now that you have worked through the above example you should be able to organize many types of information and create a chart to display it.  Here are several word problems that are different than the above examples.  Organize the information in a spreadsheet and create a graph that best displays the information.  

MULTIPLE COLUMN CHARTS
The picture below has pets of different sizes.  Set up a grid:  type of animal by size of animal.  Be sure to identify everything correctly and completely.  Create a chart that accurately displays the information.  When you are finished, your table and chart should look like the ones below.

Look around you for different objects.  Organize that information in a spreadsheet table and chart.  Think of other things you could organize in a spreadsheet - grades, allowance, CD's by type of music, books read, movies you've seen, and many more "graphable" topics.

Return to top.

LINE GRAPHS
These problems have an element of time - you will have to set up a grid in your spreadsheet properly and this time make a line graph.  Remember, labels need words; if you try to put only numbers (even a year) you will not have an accurate chart.

My family planted a tree on Arbor Day in 1997.  It was only 12 inches tall.  After one year it was 2 feet high; the next year it grew another 12 inches.  When we measured it on Arbor Day in 2000 it was 4.5 feet tall.  I can hardly wait until it is taller than I am.

    Did your final result look like this?  If not, keep working!

 Return to top.

My grandma planted a flowering tree that was 3 feet tall when I was born.  Three years later it was 8 feet tall.  When I was 5 it was 9 feet high.  On my eighth birthday my grandma and I measure the tree.  It was 12 feet high.  I’m ten now, and Grandma’s flowering tree is 15 feet tall.  I wonder how tall it will be when I turn 13? (You don't have to answer the question about when you're 13.)

In January grandfather was told he had a high cholesterol count.  It was 281.  The doctor told him to go on a diet with less fat.  In March his cholesterol had gone down to 249.  The doctor said it was still too high and Grandpa should exercise.  In June his cholesterol count was 225.  The doctor said he should keep eating well and get more exercise.  It is now September and Grandpa’s cholesterol is down to 197.  My family is very happy that Grandpa is doing so well.

How did you do?  Feel free to email me  (Mrs. Bradley) with questions or comments, or talk to me at school.  

Think of some word problems you could organize in a spreadsheet and graph - bring them to computer class for others to try to solve.

Return to Student Resource Pages

Last updated June 23, 2011 ~ Mrs. K. Bradley
kbradley@otsegoknights.org