Google Form Example for School Counselors

I am blown away at the attention my last blog post has received about data received through google forms!!!! Thank you to everyone who has visited my blog and welcome to The Urban Educator!

Many of you have asked to see the google form that I use…so the easiest way for me to share it with you was to make one especially for you (instead of giving you the link to the one I use everyday). Check out my google form for student notes here – this is the version I use to document my student notes (the live form) *this is just an example – you need to create your own to input student information*

This is what it looks like when I am creating the google form:

Screen Shot 2014-11-04 at 7.31.03 PM

Screen Shot 2014-11-04 at 7.31.06 PM

Once you create your google form through your google drive, there will automatically be a (Responses) table created that will show your responses in your google drive. This table will show you all of your responses and you can sort by grade, type or student (it will automatically sort by date). Many of you also asked how to see the graph after you have documented your student notes. This is the EASIEST part of the data collection process.  See photo below…all you have to do is click on FORM – SHOW SUMMARY OF RESPONSES and google creates that pretty little color coded graphs with all of your data 🙂

Summary of Responses

Any suggestions are always welcome! Collecting data is important to prove to everyone that your job is important and I personally find this way super easy. Best of luck and continue to check back often 🙂




  1. diane5220 · November 5, 2014

    This is awesome!!! I was going to email you about this! Hope you love your new position! Diane

    Sent from my iPhone



    • nataliesweetpea · November 5, 2014

      Thanks Diane! I love my new job and will continue posting as much as I can 🙂 best of luck to you!!


  2. Chris o · November 5, 2014

    I created a form after seeing your post this morning. What I’m wondering is how to keep it open and editable rather than using the ‘send to’ link and submitting and x-ing out each time. Does that even make sense, I’m not sure you’ll be able to figure out what I’m asking… 🙂
    In other words, when you have your final form ready to use, where do you go from there in order to access a fresh copy each time.

    Thanks so much!


    • nataliesweetpea · November 5, 2014

      Chris – great question!! I “bookmark” my Student Notes live form to my web browser on to my bookmark bar so that a button actually appears at the top of my browser. I bookmark both the form and the responses so I have easy access. That works very well for me and I don’t have to go anywhere for a fresh copy besides clicking on it.
      Let me know if that works for you!!


  3. becca dravland · November 5, 2014

    I use/love GoogleDocs as well… I don’t use a form for each student BUT I created a Google Spreadsheet that I keep up in my browser all of the time. My spreadsheet looks similar to the responses spreadsheet you have. Love it!!


  4. Charity O · November 20, 2014

    Wow! This is so great! I haven’t done much with Google Forms, but I was able to easily create a form like yours. Thanks for the How To!


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s