Chemistry 9-28-17 Making Excel Graphs

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

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

IMPORTANT: The video you will watch has the assignments backwards – Ex 1 is now Ex 2, and Ex 2 is now Ex 1. What this basically means is that you will make the graphs first – the printed rough draft of the Excel graph is due Monday in class. You’ve already finished the hand graph and the questions! The entire assignment – all three pages of it, are due by Tuesday, Oct. 4, by 8:00 A.M – submitted  as PDF 2X (this means to Google Drive & Turnitin.com).

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 two graphing handouts:
  2. Watch the vodcast below for further instructions on the assignment AND for a tutorial on how to make graphs in Excel. Start the vodcast at 6:00 minutes.
    • 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

43 thoughts on “Chemistry 9-28-17 Making Excel Graphs

  1. I rate myself a 4/5 this week in chemistry because I understood most of the graphing stuff, but I did not understand some of the questions from exercise 1.

  2. This week i rate myself a 3/5. I feel l did better than i thought on the chemistry test but i need to use a different way to study. The homework thus week was a little bit of a challenge for me this week.

  3. This week i rate myself a 3/5. I need to do better on preparing myself for the test. This weeks homework was a challenge for me.

  4. I’d rate myself a 4/5 for this week. I understand graphing and I am improving on drawing the lines. Also I feel like I did well on the test.

  5. I would rate myself a 4.5/5 this week i got all my hw done on time and i understoof the graphing very well. Should be easy to get that done this weekend.

  6. This week was a great week! I understood all the graphing and got everything turned in on time. I didn’t score as high as i would’ve liked on the test, but it just means i have more room for improvement. I’m hoping next week is just as great and i continue to absorb all the information and not forget it in a day.

  7. This week i would rate myself a 4/5. i did well with graphs and homework, but i feel like i struggled with some of the exercises we did.

  8. I would rate myself a 4/5 this week, because I got all homework done on time, understood the graphs and did pretty good on the test but there’s always room for improvement!

  9. I rate myself 4.5/5 this week. I struggled with some of the problems.I also struggled finding the controlled variables and the dependent and independent variables.

  10. I rate this week a 4/5. My test grade was not the worst grade in the world, but I’ll be sure to work more efficiently next test. It was quite a stressful week, especially with the graphing and Excel graphing, but I’m determined to make it through!

  11. I rate myself a 4/5 this week. I did very well on my test, and the graphing exercises were not as bad I thought they would be! I did struggle with procrastination, and had a hard time focusing when the amount of time it took to do some of the homework increased.

  12. This week I would rate myself a 4/5 I didn’t do as well on the test as I would have wanted to but graphing went well and I got all of my assignments turned in on time.

  13. I would rate this week a 3 out of 5. Mainly because of the graphing hand drawings was a struggle for me, I didn’t know where to start and the example that was on How To Construct a Line Graph On Paper made me more confusing about the Lab. Graphing isn’t difficult for me.

  14. Today I rate myself 3/5. I didn’t catch on quickly to the graphing, but when I did, it became very easy to complete and construct.

  15. Today I rate myself 3/5. I didn’t catch on quickly to the graphing, but when I did, it became very easy to complete and construct. I had to repost this because I did the wrong heading, so maybe a 2.5/5.

  16. Today I rate myself 3/5. I didn’t catch on quickly to the graphing, but when I did, it became very easy to complete and construct. I had to repost this because I did the wrong heading, so maybe a 2.5/5.

  17. I rate myself a 3/5. I understood the graphing exercise well and I found it rather easy to complete. I did not do as well as I hoped I would on the Chemistry test. I will have to alter my study habits if I want to do better.

  18. This week I rate myself a 3/5. My test grade disappointed me because I know I can do better….it wasn’t terrible but I know it wasn’t my best. The graphing excercise stressed me out….I got them done but I definitely could’ve managed my time better. Next week I’m gonna work on my time management and hopefully keep my average the way it is.

  19. I rate myself a 3/5 this week because I did not do well on the test and had to redo the graph but I think I have the hang of graphing now and I will do better on the next test.

  20. This week I rate myself a 4/5. I did better than I was expecting on my test and I’ve been able to keep up in class. I feel like i made a really good graph. I’m looking forward to another good week of chemistry

  21. This week I would rate myself a 4/5 because I caught back up after missing Monday. I learned how to graph correctly, and I feel confiednt for the rest of this lesson.

  22. This week I would rate myself a 3/5 because I would have liked to make a better grade on the test but I understand I need to study a different way. Also I understood the graphing stuff quickly.

  23. I struggled with the excel graph this week because I didn’t understand what to do so during the weekend I’m going to listen carefully to the video to ensure that I finish the excel graph.

  24. I rate myself a 5/5 for the week I think I did good on the graphs and did good on the test we got back the only problem I’m having is setting up the excel graph x and y axis’s

  25. I would rate myself a 3/5 this week. I the first time I draw up the line graph it was wrong but i soon realized my mistake and it was a pretty easy fix. The video was a huge reminder on how to do a excel graph.

  26. I would rate my self a 4/5 this week because I worked well with the computers. I am learning how to graph on excel and paper.

  27. This week I rate myself 4/5. The graphing was somewhat difficult, but I pushed on! I turned everything in on time and tried my best at what I did.

  28. I would rate myself a 2/5 this week! I didn’t do well on my test. I really didn’t understand the graphs this week, it might’ve been cause I can in late on Monday and missed it. I had trouble with the homework for this weekend

  29. I rate myself a 4/5 this week. I learned how to make graphs on the computer in class. Also I learned from my mistakes on my test.

  30. I rate myself a 4/5 this week. That is because I understood everything with the graphs on paper and on the computer. Also, I got a better grade on my test than I thought I would.

  31. I learned so much about how to create a graph for data this week in chemistry. I rate myself a 3/5 for this week, much room for improvement.

  32. I would rate myself a 3/5 because while I eventually figured out how to make a graph I had trouble at first. Also I feel like I could have worked faster

  33. i would rate myself a 3/5 this week. i was a little stressed with all the graphs this week and wish i would have done better on my test. next week i hope to do better!

  34. I would rate myself 2/5 this week. The graphs and the scanning were all very foreign and challenging to me, but I think I’ll get the hang of it.

  35. I rate this week a 4/5! It was very laid back in class and i really understood what we went over in class. Going over the test was very stressful and i didnt do as good as i would have hoped.

Leave a Reply

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