Wednesday, March 15, 2017

Google Forms: Anecdotal Student Notes

I have tried all kinds of ways to take anecdotal notes.  Spiral notebooks, 3x5 cards, Evernote, Google Docs with table of contents, you name it, I’ve tried it.  Nothing was just what I was looking for.  I wanted something easily accessible, private while I’m taking notes, organized, and not something that someone can find lying around my desk.  Then it dawned on me - Google Forms!

I made a form that I use over and over again to take notes on students and it puts all the information into a sortable, searchable spreadsheet in my Drive.  I can sort by date, subject, or student.  Perfect!

I always mark the option to provide a link to submit another response, so after I submit, I’m ready for the next student.

What to ask?

  • Student Name - you can always enter your students in ahead of time so you just pick them from a drop down menu.  Saves time!
  • Date
  • Subject
  • Leave a field for comments
If you want to get fancy - you can use an add-on for Google Sheets called rowCall to make a separate tab in your spreadsheet for each child.  This means you will have every note for Tommy in one tab, every note for Suzie in another tab, etc.  Try it - it's amazing!

If you'd like to view a sample of my anecdotal notes Google Form - click here.  

If you'd like a copy of this form so you can make it your own - click here.


  1. Thank you very much for sharing the Google form that will be much helpful for me to collect different notes.

  2. Brilliant. I was getting overwhelmed with all the Evernote posts...I use Google Apps all the time. This is simple and easy to use. Thank you!


Thank you so much for taking the time to leave a comment!

Helping teachers incorporate technology, one tech tip at a time.