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