Chemistry 10-7-19 Making Excel & Google Sheets Graphs AND Graphing Exercise 1 – 2

CHEMISTRY: Today you are going to learn (or review) how to make graphs on Excel or Google Sheets (or other data analysis software) by watching the video below at your own pace.

Here are the instructions for Monday. (You are going to be dreaming about graphs before it’s all over!)

IMPORTANT: Don’t let the assignment confuse you! Check the project sheets for the exact order of how you turn in everything!! What it basically means is that you will make two graphs – one hand drawn and one Excel. And then, you will answer some questions about the graphs and turn in the whole assignment as a PDF – it must be submitted by this coming Wednesday, October 7, 8:00 A.M. Again, check the Project sheets for the exact order of how you turn in everything!!

You can do this assignment at school or at home with your own computer. If you use any device other than a PC or any graphing tool other than Excel or Google Sheets, you may need to modify the instructions to fit your device.

  1. Under the worksheet tab, open these three graphing handouts – note, there is no handout for Google Sheets:
  2. Watch one of the vodcasts below for a tutorial on how to make graphs in Excel or Google Sheets.
    • My advice is to use a split screen view on the laptop with the video on one side and Excel open on the other side of your laptop screen. Watch the video and at the same time pause it as you follow along with the steps in Excel. Holler if you need me to show you how to do a split screen view. Or Google it! 🙂
  3. When you begin working on the Graphing Exercise 1 assignment, pay very close attention to the instructions. Also, pay close attention to the sheet on How to Construct a Line Graph, and How to Make a Best Fit (Scatter Plot) Line Graph in Excel 2010 – UPDATED to make sure you have all the parts of the graph covered.
  4. Google Sheets only: If you ever need to add subscript or superscripts to the axis labels in Google sheets, try copying and pasting whatever number you need from this set in to the axis title in Google sheets: ⁰¹²³⁴⁵⁶⁷⁸⁹₀₁₂₃₄₅₆₇₈₉
  5. Now go forth and conquer graphs!!

Excel Graph Tutorial Below

Google Sheets Graph Tutorial Below

Print Friendly, PDF & Email

8 thoughts on “Chemistry 10-7-19 Making Excel & Google Sheets Graphs AND Graphing Exercise 1 – 2

  1. This week I rate myself a 3 out of 5. I think I did very well in following the instructions for the graphs and on successfully making the graphs. I also think that learning the elements is hard, but I worked on it a lot.

  2. I would rate myself this week as a 3 and a half out of 5 stars. I think that I have done pretty good on the graphs we did, both written and digital, but not so much on studying for the periodic table.

  3. This week I would rate myself 3 out of 5 stars. I did well on all the graphing activities we did in class but forgot to print it out for Mrs. Skinner to check.

  4. I would rate my self 3 out of 5 this week. I understood all the graphing exercise pretty well. I’m not rating myself 5 out of 5 because im having trouble on studying the periodic table.

  5. I would rate myself a 3 out of 5 stars. I think I could’ve done better on the graphs that I presented and followed the Instructions better.

  6. This week I rate myself a 4 out of 5 stars. I did very well on graphing exercise 1, and I’ve also been studying and memorizing elements and symbols for the quiz since last week.

  7. I would rate myself 4 out of 5 stars on the graphing exercises. This is because the directions were clear and I stumbled only once.

  8. I rate myself 4/5. I think I did good on the graph activities we did in class, but I didn’t do as well with the periodic table quiz.

Leave a Reply

Your email address will not be published. Required fields are marked *