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. (You are going to be dreaming about graphs before it’s all over!)
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. Rough drafts of both are due Friday in class. 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 Tuesday, 8:00 A.M. Graphing Exercise 2 is a separate online practice of reading and interpreting graphs that is due this Monday.
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, you may need to modify the instructions to fit your device.
- Under the worksheet tab, open these three graphing handouts:
- Watch the vodcast below for further instructions on the assignment AND for a tutorial on how to make graphs in Excel.
- 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. (Watching the video will help with the Excel graph.) 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.
- 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!!