Sunday, January 4, 2015

Expert Help: Alice Keeler on Google Sheets: Creating a Line Graph

My class has done the Journey North Mystery Class Project for several years. It's a year long project that takes us through tracking daylight and observing changes to using geographical clues. We will be looking for 10 Mystery Classes located somewhere around the world.
So far, we've always graphed the data on paper and posted them in the classroom. We will still work on that, but I wanted a way the kids could see the data online so they could refer back to it, talk about what it means, and make predictions. I was stuck because I couldn't get the data into a line graph in Google Sheets or Excel.
One morning I posted the question to Alice Keeler (@AliceKeeler).

 Twitter Question
She asked a few more questions, I shared the Google Sheet file with her, and was able to watch as she moved things around and made it work! The amazing thing about Google Sheets, or any Google Doc, is the ability to share in real time! She commented right in the file and showed me where I went wrong and how to fix it. Not only do I have a line graph that I had been trying to figure out for several years, but I know how to do it myself the next time!

Click here for the explanation in Alice Keeler's blog.

Alice Keeler's Blog

No comments:

Post a Comment