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.
   • If you need a sample set of data to play around with, click here: Sample Data for Graphing Practice
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: 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!

• • How To Construct a Line Graph On Paper
  • Graphing Exercises 1 & 2

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

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!