{"id":80,"date":"2019-10-02T16:48:32","date_gmt":"2019-10-02T20:48:32","guid":{"rendered":"https:\/\/iblog.dearbornschools.org\/iloveenvironmentalscience\/?p=80"},"modified":"2019-10-02T17:23:05","modified_gmt":"2019-10-02T21:23:05","slug":"data-and-graph-instructions","status":"publish","type":"post","link":"https:\/\/iblog.dearbornschools.org\/iloveenvironmentalscience\/2019\/10\/02\/data-and-graph-instructions\/","title":{"rendered":"Data and Graph instructions"},"content":{"rendered":"\n

You need the following by Monday October 7th.<\/p>\n\n\n\n

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

    Making Charts for individual data on Google Sheets<\/strong>
    <\/p>\n\n\n\n

    1. Open up Google Sheets<\/li>
    2. Name your document: Plant Data Environmental Science<\/li>
    3. In Column A, Row 1: Type \u201cFordson Vegetation Data\u201d<\/li>
    4. Enter your data below the header going down. 
      1. Write out grass, weeds, or bare spots ( do not use letters)<\/li><\/ol><\/li><\/ol>\n\n\n\n
        1. In Column B, Row 1: Type \u201c Hemlock Park Vegetation Data\u201d<\/li>
        2. Enter your data for Hemlock park below this going down
          1. Write out grass, weeds or bare spots (do not use letters)<\/li><\/ol><\/li><\/ol>\n\n\n\n

            Now you have your data in. Lets make some charts! <\/p>\n\n\n\n

            We are going to make bar charts and pie charts for each. You will have 4 charts total. 
            <\/p>\n\n\n\n

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

                    <\/p>\n\n\n

                    <\/p>\n\n\n\n

                    Making Class Data Charts
                    <\/p>\n\n\n\n

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


                      <\/p>\n\n\n

                      <\/p>\n\n\n

                      1. <\/li><\/ol>\n\n\n

                        <\/p>\n\n\n

                        <\/p>\n\n\n\n

                        You should have four charts in total!!!
                        <\/p>\n\n\n

                        <\/p>\n\n\n

                        1. <\/li><\/ol>\n","protected":false},"excerpt":{"rendered":"

                          You need the following by Monday October 7th. A bar and pie chart for your individual data from Fordson on Google sheets A bar and pie chart for your individual data from Hemlock Park on google sheets A pie chart for class data from Fordson A pie chart for class data from Hemlock park All 6 charts copied in neatly and colored on PAGE 10 of your note book. Making Charts for individual data on Google Sheets Open up Google Sheets Name your document: Plant Data Environmental Science In Column A, Row 1: Type \u201cFordson Vegetation Data\u201d Enter your data below the header going down.  Write out grass, weeds, or bare spots ( do not use letters) In Column B, Row 1: Type \u201c Hemlock Park Vegetation Data\u201d Enter your data for Hemlock park below this going down 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.  Highlight just Column A Click on Insert > Chart It should automatically make a pie chart for you. In the chart editor > click on customize Go to Chart and axis titles > Change Title to \u201c Fordson Vegetation Data\u201d  Pie chart > Slide label > percentage Play around in this customized section. Make a couple of changes to make this graph unique.  Move your pie chart out of the way Highlight Column Continue Reading →<\/a><\/p>\n","protected":false},"author":2051,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-80","post","type-post","status-publish","format-standard","hentry","category-blogs"],"_links":{"self":[{"href":"https:\/\/iblog.dearbornschools.org\/iloveenvironmentalscience\/wp-json\/wp\/v2\/posts\/80","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/iblog.dearbornschools.org\/iloveenvironmentalscience\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/iblog.dearbornschools.org\/iloveenvironmentalscience\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/iblog.dearbornschools.org\/iloveenvironmentalscience\/wp-json\/wp\/v2\/users\/2051"}],"replies":[{"embeddable":true,"href":"https:\/\/iblog.dearbornschools.org\/iloveenvironmentalscience\/wp-json\/wp\/v2\/comments?post=80"}],"version-history":[{"count":0,"href":"https:\/\/iblog.dearbornschools.org\/iloveenvironmentalscience\/wp-json\/wp\/v2\/posts\/80\/revisions"}],"wp:attachment":[{"href":"https:\/\/iblog.dearbornschools.org\/iloveenvironmentalscience\/wp-json\/wp\/v2\/media?parent=80"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/iblog.dearbornschools.org\/iloveenvironmentalscience\/wp-json\/wp\/v2\/categories?post=80"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/iblog.dearbornschools.org\/iloveenvironmentalscience\/wp-json\/wp\/v2\/tags?post=80"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}