Making Graphs with Excel



Making Graphs with Excel 2007

THIS IS SO FUN AND EASY!

INTRODUCTION:

1. Open Excel.

2. Type data a column.

Please follow your teacher as this is done for “Average Rainfall in Center Grove.”

|15 |

|21 |

|28 |

|24 |

|16 |

|8 |

This is how it should look.

3. While in the top left square, left click on your mouse and drag down to highlight your data. (The first box will stay white.)

4. Click on the insert tab on the toolbar.

[pic]

5. Click on the type of graph you’re making (today pick a line graph). When you pick a graph, another tab will appear. This is the Chart Tools tab.

[pic]

6. Click on the “Layout” tab. Within the Labels section, you should be a description of your graph with a title. The category (x) axis describes what is being shown horizontally (THE INDEPENDENT VARIABLE-what is being tested). The category (y) axis describes what is being shown vertically (THE DEPENDENT VARIABLE-what is being measured).

In this example it should be “Average Rainfall in Center Grove.”

7. Check out the other sections. Under “Gridlines” you may wish to add major gridlines on the (x) axis. Under “Legend,” choose if you want to show a legend. Push “Next.”

Your teacher will show you ”Show Values” under “Data Labels” and the "Data Table” tab.

PRACTICE:

Sample #1: Column Graph

Let’s pretend that you are graphing the number of people in each of the science classes compared to the control (the average amount of students the school states should be in each class.) Make your Excel sheet look like below.

|# students per Class |

|Period 1 |21 |

|Period 2 |25 |

|Period 3 |23 |

|Period 4 |30 |

|Period 5 |21 |

|Control |25 |

1. Follow steps 3-5 from the front of this page. Choose “Column.”

2. Follow steps 6-8 from the front of this page.

3. Be sure to give the chart a title and label each of the axes properly. Each axis should have a label and units!

4. SHOW IT TO YOUR TEACHER BEFORE MOVING ON!

Sample #2: Pie Chart

Let’s pretend that you are graphing the percentage of people that came to school wearing a particular color. Make your Excel sheet look like below.

|Colors of Clothing |

|Yellow |20% |

|Blue |30% |

|Red |50% |

1. Follow steps 3-5 and this time choose “Pie.”

2. Title your graph.

3. Click on the design tab, and try different chart layouts and styles. Which do you think presents your data in the best format?

4. Now you have a pie chart! SHOW IT TO YOUR TEACHER BEFORE MOVING ON!

Sample #3: Multiple Line Graph

|Growth Rate in Mice in mg |

| |Mouse 1 |Mouse 2 |Mouse 3 |

|Week 1 |25 |20 |30 |

|Week 2 |115 |120 |140 |

|Week 3 |140 |125 |160 |

|Week 4 |210 |200 |220 |

|Week 5 |400 |250 |380 |

|Week 6 |720 |300 |680 |

1. Start typing in the dependent variable data in three separate columns for “Gain in Mass of Young Mice.” This data is started for you below.

2. Follow steps 3-5 from the front of this paper. Choose a line graph.

3. Follow steps 6-7 from the front of this paper.

4. SHOW IT TO YOUR TEACHER BEFORE MOVING ON!

ASSIGNMENT:

From the data you recorded during the candy lab, you need to CHOOSE one of the following three graphs to make.

This assignment is worth 10 points.

Paragraph:

Did you type a paragraph to go with the graph? 1 0

Does the paragraph thoroughly explain what the graph PROVES and

include at least five sentences? 2 1 0

Does the paragraph use data collected to support your hypothesis? 1 0

Graph:

Is the title specific and does it explain the graph? 1 0

Are the axes labeled OR is there a legend? 2 1 0

Are data labels present with values shown? 1 0

Is the size and shading of the graph appropriate so all numbers, labels, and

other graph parts are easily read? 1 0

Other:

Are there 0-3 spelling or grammar errors? 1 0

TOTAL: _______/10

Option 1: Make a “Column” graph showing the mass of each of your group member’s candy packages and comparing that to the control (what the mass was stated to be). (HINT: Look at Sample #1 from the Excel day.) Now look at the bold print below.

Option 2: Make a “Column” graph showing the amount of candy in each of your group member’s candy packages and comparing that to the control (the number of candies that should have been in each bag.) (HINT: Look at Sample #1 from the Excel day.) Now look at the bold print below.

Option 3: Make a “Pie” graph showing the percent your group had of each color of candy out of the average total for your group. (HINT: Look at Sample #2 from the Excel day.) Now look at the bold print below.

After making your graph, copy it (right click on its edge and choose “copy”). Then, open up a new document in Microsoft Word. Right click and click on “paste.” In a paragraph underneath your graph, type a conclusion telling me what exactly your graph proves. Does your data and graph support or not support your original hypotheses? Print it out when finished and put your name on it.

**IF you have extra time, try another of the three options! You may only play in EXCEL, though!**

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download