Fordson HS Environmental ScienceDearborn Public Schools

Oct 2nd Data and Graph instructions

You need the following by Monday October 7th.

1. A bar and pie chart for your individual data from Fordson on Google sheets
2. A bar and pie chart for your individual data from Hemlock Park on google sheets
3. A pie chart for class data from Fordson
4. A pie chart for class data from Hemlock park
5. All 6 charts copied in neatly and colored on PAGE 10 of your note book.

Making Charts for individual data on Google Sheets

1. Open up Google Sheets
2. Name your document: Plant Data Environmental Science
3. In Column A, Row 1: Type “Fordson Vegetation Data”
4. Enter your data below the header going down. 
   1. Write out grass, weeds, or bare spots ( do not use letters)

1. In Column B, Row 1: Type “ Hemlock Park Vegetation Data”
2. Enter your data for Hemlock park below this going down
   1. Write out grass, weeds or bare spots (do not use letters)

Now you have your data in. Lets make some charts! 

We are going to make bar charts and pie charts for each. You will have 4 charts total. 

1. Highlight just Column A
2. Click on Insert > Chart
3. It should automatically make a pie chart for you.
4. In the chart editor > click on customize
   1. Go to Chart and axis titles > Change Title to “ Fordson Vegetation Data” 
   2. Pie chart > Slide label > percentage
   3. Play around in this customized section. Make a couple of changes to make this graph unique. 
5. Move your pie chart out of the way
6. Highlight Column A again
7. Click on Insert > Chart
8. In the chart editor > click on setup
   1. Chart type > Bar Chart
   2. Change the Title to “Fordson Vegetation Data” 
   3. In the customize section
      1. Label your axes
      2. Y axis should say “ Number of plants” 
      3. Make a couple of other changes to make your graph unique
9.  Move your graph out of the way
10. Now do the same thing for your Hemlock Data. (Highlight Column B)
11. You should have four charts in total!!!

Making Class Data Charts

1. On ilearn . Open up your classes data
2. File > make a copy
3. Highlight just the totals and the headers for Fordson
4. Insert> Chart
5. In the Chart Editor, under set up, click on a pie chart
6. You may need to click on “switch rows/ columns” at the bottom in the chart editor undersettings
7. Do the same for the Hemlock Data
8. Cut and paste your charts on the page for your individual data so they are all in the same place

You should have four charts in total!!!

Posted in Blogs by Darren Mccormick with no comments yet.