Chemistry 10-7-19 Making Excel & Google Sheets Graphs AND Graphing Exercise 1 – 2

CHEMISTRY: Today you are going to learn (or review) how to make graphs on Excel or Google Sheets (or other data analysis software) by watching the video below at your own pace.

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

IMPORTANT: Don’t let the assignment confuse you! Check the project sheets for the exact order of how you turn in everything!! 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 Wednesday, October 7, 8:00 A.M. Again, check the Project sheets for the exact order of how you turn in everything!!

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. Under the worksheet tab, open these three graphing handouts – note, there is no handout for Google Sheets:
  2. 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! πŸ™‚
  3. 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.
  4. 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: β°ΒΉΒ²Β³β΄β΅βΆβ·βΈβΉβ‚€β‚β‚‚β‚ƒβ‚„β‚…β‚†β‚‡β‚ˆβ‚‰
  5. Now go forth and conquer graphs!!

Excel Graph Tutorial Below

Google Sheets Graph Tutorial Below

Physics 10-3-19 2D Motion Problems Review & Help Session

PHYSICS: Wow! You have grown so much in understanding these problems! Here’s yesterday’s discussion of one of the relative motion problems (#44) and the torpedo problem – #7 from the 2D worksheet. Add #37 from the end of the chapter review to your homework for this weekend.

Below the vodcast from today’s class is the help session from this morning – #5 and #6 from the 2D worksheet – a stone is thrown and a bird in the wind.

Have a great homecoming tomorrow!!


Photo by Andrew Palmer on Unsplash

Help Session from Thursday morning:

Photo by Brina Blum on Unsplash

Chemistry 10-2-19 A Look at Hand Drawn Graphs (& Due Dates)

CHEMISTRY: Were you happy with your hand drawn graph? Here’s the very short review today of good and some examples of not so good graphs.

HOMEWORK INFO: Monday – Hand drawn graph (J) and Exercise 2 are due.
Tuesday – Excel/Google Sheets graph (K) is due. (We’ll start these graphs in class on Tuesday.)
WEDNESDAY- The whole graphing project is due – all three pages turned in as one PDF.

Speaking of the first graph – be careful with your hand drawn graph! 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!!


flick photo by Caleb Roenigk

Physics 10-1-19 Kid on a Slide with a Water Gun & a Rocket

PHYSICS: From Monday, here’s our work on the kid on a slide with a Water Gun and an almost to the end look at the accelerating rocket.

So it wasn’t very pretty today, BUT I think you made tons of progress in how you think. Can you go back now and polish them up and make them beautiful?

Need some extra practice? Help session Thursday morning, 7:20ish A.M.


Photo by Markus Spiske on Unsplash

Chemistry 10-1-19 Fundamental Science Skills Graphing Activity

Quick – list 10 things you remember from the 8th grade about interpreting and reading graphs! Not to worry – today you’re going to begin reviewing those important concepts and techniques. Here is your assignment for today, Tuesday:

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 today.
  5. When you finish, next go to the Worksheet Tab and begin Graph J on Graphing Exercises 1 & 2.

Holler if you have any questions!