Because my district is REALLY struggling financially and I'm the newest of only four school counselors, I figured it would be wise for me to have information on hand to show how much of my job involves crisis intervention or dealing with the unscheduled and unexpected. Before the start of the school year I made a Google Doc form for that purpose. I've been spending maybe 5-10 minutes after school entering the name and general presenting issue of whoever has shown up at my door that day. That version has been okay, but it doesn't quite capture everything I want to track. So I created a new form to collect data on the number of unscheduled kids I see, how those kids get to me, how much time I'm spending with them, and (super important from a CYA standpoint) whether these sessions with kids in crisis are forcing to miss any of my kids on IEPs or 504s. Much of the information will go on my end-of-year report next year. Some is just to satisfy my own curiosity. Some is to have on hand in case anyone (besides one 4th grade wiseguy) believes that I choose to avoid them by sitting in my office with the door shut "reading romance novels." As if!
I prefer thrillers or historical fiction. Anyway, I liked what I came up with, especially since entering data on "drop-ins" is already part of my daily routine. I imagined plenty of other people might like to collect similar data. The problem was that I could not for the life of me figure out how to share a GDoc form so that all of you could have it and change it to suit your needs without messing up my original. Enter my new hero, Jeff Ream from The Counseling Geek. I watched a couple of his Google Docs tutorials and decided to e-mail him and ask for help. He not only figured out a clever way to share forms, he even made another video tutorial about it! If you'd like to check out my data-collection form and use it as a basis for your own, give it a try. The crucial thing to remember is that you have to make a copy of mine (rename it so you don't get confused), then make any changes you'd like on the copy. That way you'll have yours and I'll have mine. To set up the spreadsheet for your responses, open your copy, click on "Choose Response Destination" in the top bar, then "New Spreadsheet." Done! If Google Docs is an enigma to you, check out Jeff's tutorials. Let me know how you fare. Good luck!
13 Comments
Melodi Howard
6/24/2014 12:27:26 am
Hi Ms. Mendoza!
Reply
Laurie Mendoza
6/24/2014 09:54:47 am
That's great news, Melodi---I'm so glad you think it will help. You'll find that Google Docs is going to help you do a lot of great stuff, and the more you use it, the easier it gets. E-mail me if you have any trouble though. Good luck!
Reply
Lana Liggett
8/29/2014 07:01:24 am
I love your website!! I created my first Google doc today using your minute meeting form. However I tried to copy the above mentioned form on data collection and there was not an option to make a copy. It wasn't highlighted. Do you have any suggestions?
Reply
8/29/2014 08:37:45 am
Hi Lana,
Reply
Carol Huck
9/20/2014 11:32:08 am
Hi Laurie,
Reply
9/20/2014 10:26:46 pm
Thanks, Carol! I'm very glad you found my site, and I'm hoping that you'll find other helpful things here as well. Don't be a stranger--come back again soon! :-)
Reply
Ashley Harrell
9/15/2015 12:27:36 pm
I am just starting to use google docs and ran across the one you created above for Data Collection! I am wondering how I input the information? I've saved it to my drive; however, every time I open it, it is to edit. I do not want to edit! Any advice? Thanks so much! Loving this gem of a blog!
Reply
Laurie Mendoza
9/15/2015 03:05:27 pm
Hi Ashley,
Reply
Amanda
1/7/2019 12:20:17 pm
Hi, I came across your post while looking for better ways to track my time. When I click on the link above to your google form, it takes me to a form called Facts and Myths of Bullying....do you still have the original form you created for tracking your time?
Reply
Laurie Mendoza
1/10/2019 04:26:07 am
Hi Amanda,
Reply
Carla
1/31/2019 01:05:52 pm
Data collection form! Have you had a chance to correct the link yet. I got the Bullying form when I checked it!
Amanda
1/31/2019 02:23:54 pm
Frustrating! Thank you for your time!
Rachel
3/18/2019 09:20:12 am
Hi. Can you upload the data collection file? I see a bullying myth questionnaire. Thx!
Reply
Leave a Reply. |
Author
|