Using Google Forms to Collect Classroom Data

Categories: Data

We aren’t just taking data because we love, it looks pretty, or our principals told us too. We are taking data so we can learn about our students’ skills, progress, and needs. Taking data and doing nothing with it is as useless as just not taking data at all. The whole point to taking data is to analyze and utilize it. It’s definitely easier said than done. By the time you get through the whole process of creating data sheets, training staff, organizing data systems, you have barely enough energy to drag your tired body to the bathroom or coffee pot much less review all that data you took. Don’t worry my friends – google forms can help do that for you.

You can use google forms to create SUPER easy to use systems to collecting and analyzing your data. You (or your paras) can input information onto the form and google will do the work of organizing and analyzing it. Setting up the forms are actually super simple and you will look like literally the most impressive teacher in the world when you pull out this bad boy at your next IEP.

So let’s start with the basics before we get fancy. I recommend having a folder for your classroom data in Google Drive with a Folder for each student. Once you have that setup, create a New Form in the student’s folder. I like to do one for each goal or major area you take data on.

Next you are going to create the form. Only you will see this part. When you or your paraprofessionals are input data – these are the questions they will answer. You can customize this section as much as you want. I recommend always starting out with the date as the first question. Google will timestamp the entry for you but we might not always be putting data in every day. I also recommend ending with a notes section so the adult can add any necessary notes (like the student was sick, there were a lot of distractions, etc.)

After you write out the name of the goal – write out a plain English (not IEP English) version of the goal below. The question after the date, should probably be what target set you are working on. When we take data on a skill, we want to be specific. Break down the skill you are working on into sets. If you are working on colors, the first set will be red, blue, and green; the second set will be yellow, brown, and purple, etc. Choice a Multiple Choice Question on google forms and write in each set. Make sure to click that the question is required!

After you create the form (see below for types of forms), click SEND to share with whoever will be input the data. If you have a classroom computer, you can book mark the links for each form to find it easily!

Frequency Goal

For many academic goals we work on, we are likely tracking the number correct and the number incorrect. Set up the form question as short answer, have one question for number correct and one question for number incorrect. Pro tip: Click on response validation in the lower right hand corner and then select number in between and select 0 and the highest amount of trials the student is doing. If the student is always doing 10 trials – choose 10. They should never be getting more than 10 correct or incorrect for this goal/

Prompting Level Goal

For some goals, we are tracking the level of prompting. Google Forms is perfect for this. Click on dropdown or multiple choice question, type in the task, and put the prompting levels as the options. Be sure to specify what you mean by minimal, moderate, and maximum prompts with a range (i.e. minimal prompts (1-2 prompts). You could also put the options as the type of prompt with verbal, gestural, partial physical, and full physical. For this example, I have 4 hygiene tasks and the data collector will select the prompt level for each task.

ABC Data

When looking at analyzing the function (or purpose) of behavior, we often take ABC (antecedent, behavior, consequence) data to try to figure out what is causing this behavior to occur. Again – we aren’t doing this for our health. The entire point of this data is to utilize it so we can determine a successful intervention. Google Forms REALLY shines here because you can include a lot of different information and it will break it all down for you. Include information like the date, time, total time of incident, location (use a dropdown menu for choices), antecedents (use a checklist and check all that apply to each incident), behaviors (checklist again), and consequences (checklist).

Fluency Data

You know I love a good fluency center in any classroom. You can gather so much data – quickly and easily! Set up a coordinating Google Form for all of your fluency programs. I love keeping this in one form for easy access. Create a short answer question for each program and put total correct per minute (or timing length).

Analyzing that Data!

After you and your staff have started using the form and submitting data, comes the fun part! On the same google form you created, click responses (the right tab). Everything is broken down so you can easily see the data you have taken in a variety of ways. You can see how often behavior is occurring in each location. You can see which prompting levels are most common.

You can also open up the data in Spreadsheets by clicking on the green button in the upper right hand corner. For frequency correct and incorrect goals, I like to open in the spreadsheet and create a line graph to show progress over time.

If you are brand new to Google Forms (or google even) – I PROMISE you it’s not as tricky as it looks. This intimidated me (and my assistants) when we first started with it but it is honestly so user friendly! Give it a try! 🙂

37 Comments

  1. Are you inputting the data into the google form as you are working with the student or are you collecting data (paper/pencil) and then inputting after the session?

    Reply
  2. I use my iPad to do this as the student is performing the task. I also have students track their own data as well.

    Reply
  3. I’ve had a problem caused by putting multiple objectives on one form when not all objectives are addressed daily. So, if I input data on a couple of objectives addressed that day while another one was not addressed, Google won’t allow me to submit any of the entries as the form is rendered “incomplete” (and if you enter something that indicates “not addressed” for one so that the other data are entered, it’ll mess up your graphs). I haven’t come up with a good solution for this.

    Reply
  4. I typically do paper/pencil while working with a student. I know some people input as they go but I’ve usually found that to be too hard to multi-task and distracting to the student.

    Reply
  5. Love that!

    Reply
  6. Can you click on the “required” option so not all objectives are required each day?

    Reply
  7. Where is the link to these forms?

    Reply
  8. These are created for specific students but can be recreated and customized following these steps! 🙂

    Reply
  9. can you help me with the data set up in google, I am confused on how to do the complete set up with questions and answers.

    Reply
  10. Hi Jaimie! Follow the steps in this post. I’d start with something simple like a frequency goal as mentioned above! 🙂

    Reply
  11. This article was very helpful! Thank you! My question is: if you make a mistake and submit the form, how do you correct it? My form says it is not editable.

    Reply
  12. If you go into Settings on the Google Form (the cog at top right):
    Settings -> General -> Respondents can – check the “Edit after submit” button.

    Reply
  13. Thanks so much, love Google Forms for ABC data, starting to use for IEP data. If you are setting up a different form for each goal, for each student, 15 kids x 6 or 7 goals each = a lot of Google Forms 🙂 any tips on accessing the specific form needed quickly?
    🙂

    Reply
  14. Try creating a QR code and either put it on your PECS ring or create a sheet for each student with all the QR codes listed and laminate it and keep it in an accessible location. Then you can scan the code and it will open the form for submissions.

    Reply
  15. I would do one per kid and only input the data on the goals you did that day or that session. Does that make sense? So have all of the goals for each kid on one form.

    Reply
  16. Great suggestion!

    Reply
  17. I want to use Google Forms to track student letter name and letter sound goals. For example, the student will state the letter sound for 26 out of 26 letters. I like to keep track of what sounds they get correct and incorrect. How would I do this using forms? I would also like it to graph total correct so students can see progress.

    Reply
  18. When using this to enter DTT data, how would you suggest having spots for % Independence and % Accuracy? Would it have to be two separate questions? Suggestions on how to set this up?

    Reply
  19. You could do a percentage or do a linear scale and pick the total amount of trials you’ll do each day and then when you submit data select how many correct. Hope this helps!

    Reply
  20. What is a “QR Code”? Question/Response? Please give a couple of examples.

    Reply
  21. If I have students in one co-teach setting, and they have similar curriculum goals, is there an efficient way to create a “copy” of a previously created form for a particular student, and then ‘edit’ by either adding or subtracting individual goals, benchmarks or other related points? Can I just ‘copy’ and then ‘rename’?
    Eileen

    Reply
  22. It’s something you can scan that goes to a specific URL. You can make your own QR codes and link them to the google forms and then you or staff can scan it to go to the link!

    Reply
  23. Yes! Copy and rename!

    Reply
  24. THANK YOU so much for this information! Exactly what I was looking for… now implementing thanks to you!

    Reply
  25. If I am taking data on the percent accuracy of addition problems and the student does not complete the same amount of problems each session, how should I set up the question in google forms? Not sure the best way to track percentage. Thank you for your help!

    Reply
  26. I would do a short answer and then click response validation to require a number between 0 – 100 and then you can turn the data into an excel document and graph across time! 🙂

    Reply
  27. Hello,
    I love your google form recording sheets. I teach mainstream kindergarten but am actually using this for my own twin daughters. I made an ABC type form. I love it, it’s easy. I just started working with some ABA therapists and they wondered if I could tweak it so that you could see the whole incident (ABC) with the date. Right now, I have it break down the time it happened, the person they were with, the behaviors that we saw etc…but it is all separate. So, you can see that most things happen at 3pm ish. Most things happen with me…yay me! and most things happen when they are denied a request or tangible. …but I don’t see that on this particular date, at this particular time, with this antecedent, this result happened….
    I can see this on the paper form of course but wondering if you know how to make it happen digitally too?!
    I probably missed it in one of your articles and I will keep researching but if you can direct me to it, I would really appreciate it! Thank you so much for sharing your knowledge with the rest of us! 🙂

    Reply
  28. Hmmm how would you do frequency data?

    Reply
  29. Add a short answer and add response validation for a number between 0 – (whatever max you want)

    Reply
  30. I am needing to be able to mark a behavior that occurs several times in a single day, how should I set up my form to be able to do that… like a tally sheet in a way…

    For example: Behavior: Child threw toy.

    If the child does this 6 times in one day I need to be able to click it like a button and it record that behavior for me then be able to tell me it happened six times on 08/15/19 in a spreadsheet or responses page…

    Reply
  31. Not sure of a tally or checklist type verion for this but you could do short answer and input the number each day.

    Reply
  32. My data did not show up charted just the responses. I dont know what I did or didnt do lol

    Reply
  33. As a school psychologist I would like to be able to create ABC data sheets for my teachers. Am I able to complete a form on Google docs to share with them to use?

    Reply
  34. Yep!

    Reply
  35. Hi! I am trying to set up Google Forms to do this exact goal. Would you mind sharing how you set this goal up?

    Reply
  36. Is there a way to enter collect accuracy/independence data within the same question?
    For example… Using visual supports as needed, Bob will compare two characters in a story or drama with 80% accuracy and independence. Any help would be greatly appreciated!

    Reply
  37. For that I would simply track correct and incorrect using the number field and put the response range between 0 and how many total trials you will be doing (ie if you are doing ten trials have that number be ten). So input total correct and input total incorrect out of the ten trials and then you can make a graph with each.

    Reply

Submit a Comment

Your email address will not be published. Required fields are marked *