Using Google to Chart Progress


I hope you all had a happy Valentine's Day! C and I declared our love to each other by stuffing ourselves full of sushi - my favorite! It was so nice to have a night out to have fun and relax after what has been the craziest month of all time. I have been running around non-stop since #Snowzilla2016 trying to catch up with IEPs, meetings, and evaluations. And, in the middle of it all, I had my mid-year evaluation. Despite the crazy, I got my behind in gear and nailed my evaluation. My savior? Google sheets.

Did you know you can create awesome spreadsheets and progress charts in a matter of minutes with Google sheets? It is super easy! And my administrators LOVE charts. I think it helps us to speak the same lingo. Here' how it works.

1) Open up a new Google sheet (which you can open from your google apps or go here).

2) Enter in your data. In my district, we have to make a  SMART goal.  My goal this year is for narrative retell. I used the Test of Narrative Retell to get a baseline and measure progress (you can read more about my goal here), but you can use whatever data you have! Here's an example:  

3) After you enter your data, you are ready to make your chart! Highlight your data and then select the little "graph" icon on the top right side of the page. It looks like this:

4) There are lots of options when you click that button! You can change the style of the graph, the colors, and the names of the axes.  When you are happy with the way it looks, click "insert" and voila! You are done. You can even share the data right from google by giving access to your administrators - just click the "share" button in the top right hand corner.

Having these handy charts made it easy for me and my administrators to see my students' growth and discuss how my students have been doing so far this year. My evaluation was smooth sailing.

Have you used Google to help you with you data? What do you think? I would love to hear more from you! Comment below to share!



1 comment

  1. I love the step by step instructions! Thanks for the great tutorial 😀