Hon Chemistry 9-19-19 Making Excel & Google Sheets Graphs AND Graphing Exercise 1

HON 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 Thursday – the last graph for Exercise 1. (Are you dreaming about graphs yet?!?)

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 Monday, September 23, 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 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.
  3. 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: ⁰¹²³⁴⁵⁶⁷⁸⁹₀₁₂₃₄₅₆₇₈₉
  4. Now go forth and conquer graphs!!

Excel Graph Tutorial Below (older version of Excel)

Google Sheets Graph Tutorial Below

Print Friendly, PDF & Email

12 thoughts on “Hon Chemistry 9-19-19 Making Excel & Google Sheets Graphs AND Graphing Exercise 1

  1. In my Science in the News assignment, I learned about the relationship between Alzheimer’s disease and lack of sleep. When you are deprived of lots of sleep, your brain has more of 2 harmful proteins that are also very present in people that have Alzheimer’s disease. This could be potentially threatening because these two proteins cause destruction in the brain of people with Alzheimer’s, so they could also cause destruction in our brains as well. So rest up (I say as I write this at midnight) !!

  2. In my Science in the News article this week I learned about the affects sleep deprivation can have on Alzheimer’s disease later in life. When you become sleep-deprived there is an increase in the building of 2 proteins that are found commonly in people with Alzheimer’s disease.

  3. This week in my science in the news article I learned that not getting enough sleep is very dangerous and can have long term effects that cause damage later on in life. When you don’t get enough sleep, you’re body releases to dangerous proteins, tau and A-beta, that can lead to Alzheimer’s disease. The less sleep you get the more likely it is for these proteins to be released which in turn increases the likelihood of Alzheimer’s disease. Long story short, most of this class will end up with Alzheimer’s because we do not get enough sleep.

  4. In my Science in the News article, I learned about the links between sleep deprivation and Alzheimers. When you sleep your brain washes out excess and harmful proteins, so when you don’t get enough sleep the brain does not have enough time to fully wash out the proteins. These two harmful proteins that build up when you don’t get enough sleep are closely linked to Alzheimers.

  5. While doing my science on the research assignment this week, I learned how sleep loss can affect you in you later life. Scientist have discovered that a well balanced sleep and wake cycle is most affective towards keeping your A-beta and tau levels in your brain regulated. Both of these proteins of not properly balanced can escalate your chances of Alzheimer’s disease. This is what I learned during my Science in the News project this week.

  6. When I was performing the action of writing down the answers to the inquiries that have been contained in the depths of my SitN assignment, I acquired a plethora of knowledge. Of these various jewels of information that hath been bestowed upon the complex machine that beith mine mind is the factual statement that the absence of sleep is strongly related to the horrible sickness that is commonly known as Alzheimers disease. The link between these two things is found in the proteins that flood the brain during alzheimer’s disease, as well as the brains of an adult human whilst they are without slumber.

  7. In my Science in the News assignment, I learned that sleep deprivation and Alzheimer’s disease are related by two proteins. When you do not get an adequate amount of rest, an abundance of two proteins, tau and beta, are released and can build up. These two proteins are prevalent in the brains of people who suffer from Alzheimer’s disease. Not getting the proper amount of sleep could be dangerous because these proteins wreak havoc among the brains of Alzheimer’s sufferers, so they could also be damaging yours!! So, be sure to get PLENTY of sleep because if not, later on in life you could be suffering from Alzheimer’s.

  8. This week I rate myself a 4/5. I had a great time doing the car lab today. It really made all the concepts we discussed in class seem real. I have never seen velocities cancel out in that manner before. Also, I was very pleased with my performance on our first test. I did not study very much for it and was honestly expecting a worse score, but I am not gonna complain. I will likely have to study more for our subsequent tests. Finally, I feel that I have a firm grasp of the notes we covered this week. Overall, I am pleased with this week and I hope that the rest of them will be of the same caliber.

    • correction:

      Alzheimer’s disease is related to two proteins. The tau levels in a person can increase if you are sleep deprived. Many people who have enough sleep don’t have as much tau and a beta as people who don’t. In the rats they tested the a beta was twice as high as ours when we have no sleep.

  9. In my Science in the News assignment, I learned about Alzheimer’s disease and how the risk of getting it increase when the amount of sleep you get decreases. When you don’t sleep as much as you need to, two proteins (Tau and A-beta) build up because of the fact that your brain is till working when it should be resting. So long story short: get enough sleep now to avoid diseases like Alzheimer’s later in your life. Preferably 8+ hours per night.

  10. In my science in the news I read that a lack of sleep can lead in an increased amount of two proteins in the brain that can cause Alzheimer’s disease later in life

Leave a Reply

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