Chemistry 9-26-18 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 other data analysis software) by watching the video below at your own pace.

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

IMPORTANT: Don’t let the assignment confuse you! 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 Tuesday, October 2, 8:00 A.M.

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

56 thoughts on “Chemistry 9-26-18 Making Excel & Google Sheets Graphs AND Graphing Exercise 1 – 2

  1. I rate myself a 4/5 this week. I understood the graph and everything we did pretty well. I have used all the technology before and it wasn’t as hard for me as it was for others.

  2. I would rate myself a 4/5 this week. I believe i took a lot from the lessens but i did not understand them at first but after a couple of question i felt like i got on the right track to what I was doing.

Leave a Reply to J Lozier C1 Cancel reply

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