Creating a Counselor Activity Log with Google Forms

Another new school year and I am renewing my vow to myself to use technology and give my best effort to going paperless. Again.  I truly LOVE Google Forms and have found lots of ways to use them.  All were successful but one, recording my daily activities.  And it wasn't the form, it was me. Last year, try as I might to make them work, I just wasn't able to keep up with it. When I sat down and analyzed what had happened I identified 3 problems.  One, my form was not on my desk top so it was not readily accessible and  I would spend too much time searching for it in my Google Drive. Second, I think I tried to collect too much information.   Rather just trying to click that I had performed a specific task for a specific amount of time I was trying to keep notes too. A bad idea for time and confidentiality sake.  Third once I got behind, psychologically, it just seemed like to much to do to catch up.

Google forms, round 2!
But now I am ready to try again.  I have redesigned my form a bit, adding a drop down menu of teachers, grade level, reasons students may want to see me, and who referred them.  Anything to make it click and go.  I still have my notes section in case there is something I did not think of or that needs to be part of my record. Another great thing about Google forms is you can continue to edit them even after you have started collecting data. Click the black "edit this form" button at the top of the page of the "color" form and you will get the gray "editable version."  Make your additions, deletions or corrections, close it up and continue collecting  data.  Need to edit a response?  Click on the "edit form" button on the color form, go to the gray form and click on the "View Responses" tab.  When it opens, scroll down to the entry you want to edit and make your needed changes.  I will still keep a file on each student I see with more specific notes and memory aides. This form will allow me to track my daily time  and whether it is spent on direct/indirect services and non-counselor related duties.

How's my progress?
Four weeks in and I am up-to-date on my daily entries!  Looking at my data, already I see I am spending more time with classes than individuals,  However, that is okay, as classroom lessons are a Tier 1 intervention where I lay the foundation of my program and skills training with ALL students. It is where I feel I get the biggest and best value for my time.  With all my classes plus the individuals I am seeing, it comes out to more than 80% of my daily time is being spent in direct services to students and what could be better than that!

Truly, creating a shortcut on my desk top to my form has made a huge difference.  It only takes a minute, literally, to click down the list of items on my form to record each activity.  If you are interested in using Google forms, here is a link to my form to help get you started. You are welcome to make a copy and make edits that fit for you and your counseling program. I love Google forms and find them easy to create and edit.  It is also easy to share data about your program and how your time is being spent (or encumbered!).  Google forms also creates beautiful graphs.  All you have to do is click on summary of responses to see its colorful creations.This is essential as we advocate for the best use of the School Counselor's time and also provides us with a valuable accountability piece.

Google forms step by step.
If you are new to Google forms, I am linking a PowerPoint presentation about some of their many uses and how to create your own forms.  You will find slides 30, 31 and 32 especially helpful for taking a copy of my form and making it your own.  Remember you must make a copy of my form before it will show up on your Google Drive.  Otherwise, your data will be stored on my form, in my drive and you will not be able  to access it.  Also, anyone else who decides to edit my form will also be editing your form. And, I wouldn't want your hard work to go to waste!

Please feel free to contact me with questions or more ideas for forms. Good Luck with your forms!  I think you're going to love them!