HON CHEMISTRY: Today you are going to learn (or review) how to make graphs using data analysis software like Google Sheets or Excel by watching the video below at your own pace.
Here are the instructions for Monday – (You are going to be dreaming about graphs!!)
IMPORTANT: A rough draft of your first graph is due tomorrow by class time. The entire assignment must be submitted by this coming Friday, September 25, 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.
- 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! 🙂
- 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 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
- 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: ⁰¹²³⁴⁵⁶⁷⁸⁹₀₁₂₃₄₅₆₇₈₉
Now go forth and conquer graphs!!
Excel Graph Tutorial Below (older version of Excel)
Google Sheets Graph Tutorial Below