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

Hon Chemistry 9-18-19 Hand Drawn Graphs & Graphing Exercise 1

HON CHEMISTRY: Today you began reviewing how to make your own hand drawn graphs using Graphing Exercise 1. Did you remember what you learned from a long time ago? Any questions about Graphing Exercises 1 & 2? (You are going to be dreaming about graphs before it’s all over!)

Under the worksheet tab, open these three graphing handouts. Use these handouts to make sure you are doing the hand drawn graph correctly!

Need a refresher? Watch this vodcast for good and bad examples. Carefully review the instructions on how to draw them. Common mistakes – switching independent and dependent variables, the scale on an axis not consistent along the axis, graph too small, line not a best fit, forgetting to label the axis, etc.

And finally – NEATNESS is very important!! Rough draft of all your graphs are due Friday – but I’ll be glad to check them early!


flick photo by Caleb Roenigk

Science In the News Assignment for Tuesday

Here is the Science In the News assignment for Tuesday:

How can chemistry, physics – or any other type of science, technology, engineering, and mathematics (STEM) be important to your everyday life? TONS of ways, and this year we’ll be using Science In the News to research just that!

IMPORTANT guidelines for the assignment:

  • For today, you will have two articles to choose from. After today, you will find your article on websites like sciencenewsforstudents.org or https://www.sciencenews.org/
  • Make sure you pick an article you find interesting and that you understand!!
  • Make sure you pick an article that you can use to answer the questions on the Science In the News sheet. If there are questions you cannot answer with the type of article you have – pick another article!!!
  • The SItN assignment must be handwritten on notebook paper – you may write on the back

IMPORTANT #2: When you are finished today, put your laptop up in the correct slot and plug it in!!

Hon Chemistry 9-16-19 Fundamental Science Skills Graphing Activity

Welcome to Graphing 101 – or what I like to call, “A Quick Review of Everything You Learned About Graphing in the 8th Grade.” Here is your assignment for Monday.

IMPORTANT: Today’s assignment is one that you will have to complete at school. The program is on the school laptops and on the computers in the computer lab.

  1. Find the “Fundamental Science Skills” program on your computer.
  2. In the Graphing Skills section, click on “Graphing Data Points.” Read through and practice in each section VERY CAREFULLY!
  3. After you have completed each review section, go to the exam and complete it.
    • You must enter your name in the exact format you do when you title a lab – including the title of the activity.
    • Click on “Check Your Answers.” When you have 100% accuracy, bring your lap top to me to check your Check Answers Results Sheet. If you are doing the assignment outside of our class period, print off your exam results sheet and bring it to me to check.
    • IMPORTANT: Your answers and the format of it all must match exactly to receive credit. (Sometimes being exactly correct is extremely important!)
  4. The Graphing Data Points assignment is due by the end of the class period.
  5. Next, go to the Ring Challenge and complete it. You will need headphones or earbuds. If you don’t finish in class, bring the completed sheet to me to check off. It is due by the end of the school day on Friday.

Holler if you have any questions!

Physics 9-11-19 Chapter 2 Concepts, Rockets & Splash

PHYSICS: Test tomorrow! You can do this!! First here’s the conceptual review we did today, bumblebees, etc. Hope Joy, at the end I put a quick overview of the test for you because I forgot to start recording at the beginning.

Below today’s lesson is an old vodcast of one of the rocket problems. I didn’t have the mic on for the help session today, but I found an old one that might be helpful. It also has a complete look at #47, the mountain climber and the single splash (very key part to that problem!).

Are you becoming more comfortable with working problems? When selecting formulas, it’s always a good idea to ask yourself “Why?”. Why can you use this formula? Why is it legit? Why is it the best one? Is there a better route to the solution? And then, continue to practice them over and over til it starts to become second nature!

God bless you as you prepare for the test! I’m praying for you!!!


Photo by Nicolas Häns on Unsplash

PHYSICS 9-15-14 Free Fall Problems from Tammy Skinner on Vimeo.

Chemistry 9-6-19 Relationships Among Data & Homework Problems Review

CHEMISTRY – Can you believe it? We’ve finished the chapter! Here’s the lecture from today on direct and inverse proportions AND a look at the density and conversion factor problems from last night’s worksheet.

Homework UPDATE: The thLAB: Building a Balance due date is moved to Tuesday. The Chapter 2 Review Worksheet is due Monday. Be sure and read the instructions carefully for both!

Speaking of tests, have you gone to the TEST Info tab yet? You might find something that will help a lot as you study!!!

Also, don’t forget to check out the Interactive Review Games with your online text and also the review at sciencegeek.net. Great practice with both memorization, concepts and problem solving!

God bless you as you study this week! I’m be praying for you!!


Photo by Ryan Quintal on Unsplash