Daily Archives: September 25, 2017

Chemistry 9-25-17 Making Excel Graphs & Graphing Exercise 1 – 2

Posted on by

CHEMISTRY: Monday you are going to begin reviewing how to make your own hand drawn graphs, AND Wednesday you’ll learn how to make graphs on Excel by watching the video below at your own pace.

For Monday and the hand drawn graph, you’ll need to channel all that you learned in the 8th grade about drawing graphs. Might be a good idea to review this handout below, I’m just saying. The rough draft of the hand drawn graph is due tomorrow.

Next, here are the instructions for WEDNESDAY. (You are going to be dreaming about graphs before it’s all over!)

IMPORTANT: 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, you may need to modify the instructions to fit your device.

  1. Under the worksheet tab, open these three graphing handouts:
  2. Watch the vodcast below for further instructions on the assignment AND for a tutorial on how to make graphs in Excel.
    • When you get to the part of the video where I tell you that you can stop watching the tutorial, if you want to stop and work on your own, be sure and FIRST scroll to the end of the vodcast (at about minute 28:40) for hints on competing Exercise 2.
    • 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 2 assignment, pay very close attention to the instructions. (Watching the video will help.) 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.
  4. Now go forth and conquer graphs!!

CHEMISTRY 9-16-14 Making Excel Graphs & Graphing Exercises 1 – 2 from Tammy Skinner on Vimeo.