Hon Chemistry 9-21-20 Graphing Exercise 1

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

Here are the instructions for Monday – (You are going to be dreaming about graphs!!)

IMPORTANT: A rough draft of your first graph is due tomorrow by class time. The entire assignment must be submitted by this coming Friday, September 25, 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. 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! 🙂

     

  2. 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 Make a Best Fit (Scatter Plot) Line Graph in Excel 2010 – UPDATED to make sure you have all the parts of the graph covered.
  3.  

  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: ⁰¹²³⁴⁵⁶⁷⁸⁹₀₁₂₃₄₅₆₇₈₉

Now go forth and conquer graphs!!

Excel Graph Tutorial Below (older version of Excel)

Google Sheets Graph Tutorial Below

Print Friendly, PDF & Email

3 thoughts on “Hon Chemistry 9-21-20 Graphing Exercise 1

  1. This week I struggled with figuring out how to graph (specifically graph K from Graphing Exercise 1) on Google Sheets. I played around with Google Sheets for a couple hours, changing things within the graph and ultimately restarting three times. I eventually figured it our from persistent practice, and honestly had enough fun to where I’m going to be actively looking for ways to use the graph feature on Google Sheets.

  2. I struggled with creating the graphs in Google Excel, but I am practicing dilligently and asking the teacher and others for help when i necessary.

  3. I struggled with using all of my class time to work on assignments that were due. I will try to come to class more prepared to use all of the extra class time to help with assignments that are due so procrastination does not occur.

Leave a Reply

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