Graphing Assignment
Who doesn’t like visuals!? When people gather any kind of data it is always nice to see a picture of the data, rather than read it in sentence form. A way to show the data you have gathered, you can create a graph to show your findings. For this assignment, you will need to choose two different categories and take surveys to gather numbers in order to create two different graphs. You can choose your own categories or you can choose one of the following categories: type of pets, number of siblings people have, pairs of shoes people own, favorite sport, or anything else that will give you a number. Based on the research you have done you will use the directions below and create the graphs by using Microsoft Excel. The goal is to get us familiar with the Excel program, as well as learn that we have different tools we can use to enhance our data.
How to Make a Graph for your Survey
using Microsoft Excel
1) Go to the Start Menu and left click.
2) Float your mouse over programs, and then move to the right and down to find Microsoft Excel, left click.
3) A new Microsoft Excel document will open up and will look like this.
4) Next, list all of your subject names in the left column. See the example below.
5) Next, type in the data collected for each subject.
6) Drag you mouse over all of the data you entered. Start by clicking in the upper left corner (A1) and then move down and to the right until you’ve selected everything you typed.
7) Now click on the chart symbol in the menu bar above. It looks like this:
8) When you get the screen that I’m am showing you to the right, click on the button that says Next twice.
9) Now, give your graph a title and a label on both the x and y axes.
10) Now click on the tab that says legend at the top of the chart. You need to “unclick” the Show Legend box. Make sure there is no check in that box.
11) Then click on the next button.
12) Lastly, select the button that says As New Sheet and press the Finish Button.
13) SHOW YOUR
TEACHER!!!!