Chemistry 9-20-16 Making Excel Graphs & Graphing Exercise 1 – 2

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

Here are the instructions for Tuesday. (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.

Print Friendly, PDF & Email

6 thoughts on “Chemistry 9-20-16 Making Excel Graphs & Graphing Exercise 1 – 2

  1. My struggle this week was trying to format the graphs correctly. In the beginning of the week, it was very hard to understand, but when Mrs. Skinner checked my graphs I learned what I did wrong and corrected it.

  2. This week I would rate myself 4/5 stars I did a great job reading and understanding graphs this week and the practice in class and the video really helped with reminding me the proper way to use excel.

  3. This week in chemistry I learned how to make a graph in excel. This week I struggled with starting the graph in excel but I figured it out quickly. My triumph was getting almost everything correct on both of my graphs. I applied what I had learned from the video to my graphs. I would rate myself a 4/5 stars this week because I had more triumphs than struggles.

  4. This week I would rate myself a 3/5. I need to do a better job reading at everything on my sheet before starting. I did good with the dancing raisins lab and with the hand drawn graph.

  5. This week during chemistry I would rate myself a 3/5. I need to do a better job reading at everything on my sheet before starting. I did good with the dancing raisins lab and with the hand drawn graph.

  6. This week was discouraging for me as I got my test back and didn’t get what I had hoped. I had trouble with the graphs at first but then caught on. I feel like I did well on the raisins lab today, however. I think I would give myself a 3.5 / 5.

Leave a Reply

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