Follow this simple tutorial to convert Google Forms responses into Google docs templates for quick and magically easy report writing!
Looking for an easy, digital system for your data collection notes? Learn all about how you can use Google Forms for your data collection!
Data collection isn't the most fun topic. Before iPads, my folders for kids were full of sticky notes, therapy data forms, attendance forms, and other assorted loose items. At progress report time, I would try to study my hand-written data for trends, and come up with some percentages to show growth, or lack of growth. For children with multiple goals, or those with collaborative goals, consistent data collection was even more challenging! I have recently updated this to reflect the changes that Google has made in making forms (6/15/13). Enter Google Forms and Spreadsheets!!! This blog is a brief tutorial on how to create a Google form for your data collection, which then saves your information into a spreadsheet. Once I create my form, I can save the form icon to the iPad screen making recordkeeping easier than using pencils and graph paper! Step 1---go to Google Drive (you must have a Gmail account). Under 'create new', select 'form'. It will take you to a new form which you will name in the next step. Step 2 In the top line, give your form a title. If you are collecting data for an IEP, you can name it after the IEP. If it's some other purpose, call it something else!! Then pick a theme (for IEP stuff, I usually go with the plain form. It's up to you, though.) Then click OK. Step 3 Now you are ready for the fun part. You get to create questions for your form. These questions, in my case, are taken directly from specific IEPs or treatment plans. You will be creating one form per client Some questions lend themselves to different types of responses. If you need the date of a session, or the number of minutes seen recorded, this might work with a 'text' response. If you are recording whether a child met or didn't meet an objective, multiple choice (yes/no), might work better. If you want to record an anecdotal response, select 'paragraph text'. For my first question---I'm recording attendance. I want to make sure I record if the student was present, and if there was no speech that day, why. I'm using the 'multiple choice' question type since there is only one answer that will work. Once finished with the question and answer possibilities, I click 'done'. After clicking 'done' this is what question one looks like on the form: Step 4: You are now ready for making Question 2. You can add a question by clicking button below your first question, or edit an existing question by clicking the pencil to the right of your question. You can see that I already added a second question using the 'checkboxes' type of question which can allow more than one response. add second question click pencil to edit; click add item to add more questions You can add as many questions as you want. One SLP I know collaborates with a teacher and puts the entire repertoire of the objectives from a child's IEP on the form. It makes for a long form, so if you want a shorter one, limit yourself to one section (e.g. communication objectives). Step 5 Once the form is complete, send it to yourself and anyone else who will be completing it (e.g. teacher). Your information collected by this form will go into a spreadsheet in Google drive. This is what a sample spreadsheet looks like. With one click, a summary of all of your information over time can be generated with graphs and lists. Here is a sample. My next tutorial will be to teach how to send your form to the iPad so that you have easy access to it. Google forms and documents have really helped my record keeping for my kids. Here is a blog I posted about using Forms and Docs to take attendance. I hope Google forms help you too, and you can use it in your work!
As most of you know, I work with preschool aged students in a public elementary school. All of the students on my caseload are in our full-day program. The full-day preschool classes are comprised of students with autism, sensory disorders, and other developmental or medical disorders. I absolutely love this populat
Great ideas from an librarian, SLP, and PK teacher!
From discussions with my SLP friends and what I have read on several other blogs, we are all always trying to refine our data collection. I know for myself, I love to see what other people are doing...so of course I thought I would share my own system, which continues to be changed a little every year. I am a fan of paper and pen...I know with the explosion of iPads in therapy, a lot of therapists are using digital data collection. I happen to think this is fabulous; however, I do not currently use it. What am I waiting for? Someone to buy me an iPad :)
Follow this simple tutorial to convert Google Forms responses into Google docs templates for quick and magically easy report writing!
Data collection isn't the most fun topic. Before iPads, my folders for kids were full of sticky notes, therapy data forms, attendance forms, and other assorted loose items. At progress report time, I would try to study my hand-written data for trends, and come up with some percentages to show growth, or lack of growth. For children with multiple goals, or those with collaborative goals, consistent data collection was even more challenging! I have recently updated this to reflect the changes that Google has made in making forms (6/15/13). Enter Google Forms and Spreadsheets!!! This blog is a brief tutorial on how to create a Google form for your data collection, which then saves your information into a spreadsheet. Once I create my form, I can save the form icon to the iPad screen making recordkeeping easier than using pencils and graph paper! Step 1---go to Google Drive (you must have a Gmail account). Under 'create new', select 'form'. It will take you to a new form which you will name in the next step. Step 2 In the top line, give your form a title. If you are collecting data for an IEP, you can name it after the IEP. If it's some other purpose, call it something else!! Then pick a theme (for IEP stuff, I usually go with the plain form. It's up to you, though.) Then click OK. Step 3 Now you are ready for the fun part. You get to create questions for your form. These questions, in my case, are taken directly from specific IEPs or treatment plans. You will be creating one form per client Some questions lend themselves to different types of responses. If you need the date of a session, or the number of minutes seen recorded, this might work with a 'text' response. If you are recording whether a child met or didn't meet an objective, multiple choice (yes/no), might work better. If you want to record an anecdotal response, select 'paragraph text'. For my first question---I'm recording attendance. I want to make sure I record if the student was present, and if there was no speech that day, why. I'm using the 'multiple choice' question type since there is only one answer that will work. Once finished with the question and answer possibilities, I click 'done'. After clicking 'done' this is what question one looks like on the form: Step 4: You are now ready for making Question 2. You can add a question by clicking button below your first question, or edit an existing question by clicking the pencil to the right of your question. You can see that I already added a second question using the 'checkboxes' type of question which can allow more than one response. add second question click pencil to edit; click add item to add more questions You can add as many questions as you want. One SLP I know collaborates with a teacher and puts the entire repertoire of the objectives from a child's IEP on the form. It makes for a long form, so if you want a shorter one, limit yourself to one section (e.g. communication objectives). Step 5 Once the form is complete, send it to yourself and anyone else who will be completing it (e.g. teacher). Your information collected by this form will go into a spreadsheet in Google drive. This is what a sample spreadsheet looks like. With one click, a summary of all of your information over time can be generated with graphs and lists. Here is a sample. My next tutorial will be to teach how to send your form to the iPad so that you have easy access to it. Google forms and documents have really helped my record keeping for my kids. Here is a blog I posted about using Forms and Docs to take attendance. I hope Google forms help you too, and you can use it in your work!
From discussions with my SLP friends and what I have read on several other blogs, we are all always trying to refine our data collection. I know for myself, I love to see what other people are doing...so of course I thought I would share my own system, which continues to be changed a little every year. I am a fan of paper and pen...I know with the explosion of iPads in therapy, a lot of therapists are using digital data collection. I happen to think this is fabulous; however, I do not currently use it. What am I waiting for? Someone to buy me an iPad :)
This is an easy form for collecting speech data during your speech therapy sessions. Each day has an opportunity for 30 trials, which are numbered, making it easier to know the total number of trials completed at a glance (instead of counting, and counting...). Print the form front and back, for a...
Want to know one thing that makes my teacher heart happy? Feeling organized with all the DATA! DATA…DATA…DATA! Data tracking is something that we will never be able to escape in education, especially in special education. So, might as well get on board with it and find an organizational system that fits you! Data collection ... Read More about Your Lifeline for IEP Goal Tracking
I’ve wrapped up my year–sessions and paperwork–and am now focused on my daughter’s high school graduation (gulp!) I will be seeing a handful of students this summer and, while I’m still in school-mode, I’ve started session plans and pulling together materials. It makes it sooooo much easier if I can just grab and go. I […]
I hope you've been enjoying this week's organizing posts! It's always fun to exchange ideas and be able to take a few things back to your s...
This year will be my fifth year as an SLP. I would like to say at this time that I have data tracking mastered. However, I can't seem to fi...
A few days ago, I wrote about creating customized therapy note paper forms for each client (or kid, in my setting). Once I do that, I have the information I need to create a Google form and spreadsheet for collecting data. It's up-front, labor intensive work (for a day), but once I have the perfect form, I can fill it out rather quickly on a computer or an iPad after I see a child (or after you see an adult--depending on your circumstance). I wrote a previous tutorial about creating Google forms. You can check out that tutorial here! Now, I would like to highlight what information I collect for my Google forms. I already have a diagnosis code on the paper form; the child's birthdate, and the IEP dates are on the paper form; and my signature and ASHA credentials will be on the paper form for each session. The data I collect for the session on the Google form includes: date of session (use the 'text' option when creating the form) session characteristics---was it individual, group of 2, group of 3, in the speech therapy room, in the classroom, in a resource room? (use the 'checkboxes' option) if no speech, why?---was the student absent, was the therapist absent, was there a meeting during speech time, was the student suspended....... (use the 'multiple choice' option) minutes of the session---how long does this last? (use the 'text' option) Now comes the meat of your session. Different types of data require different types of Google questions. A common goal for language therapy is requiring the child to answer wh-questions. I prefer to use a 'grid' for this. Another common question type is to state a percentage. You will need to take actual data on a piece of paper. The results of this will go into the Google therapy note as a percentage. You will need to use a multiple choice option for this. Something I always include is a 'description of the session'. This will be a "paragraph text" when you are looking at the form item choices. That's when I really sit at my computer and write the abbreviated schedule of activities of the session. I type faster and clearer than I handwrite, so when people read my notes, they will see exactly what happened, in a more narrative form. I now ask in the form, 'what skilled interventions were used during therapy?'. This was originally created for Medicaid documentation but actually makes me think and justify therapy for all kids. You can do what you want with this---list intervention techniques in a 'paragraph text' form, or use a 'checkbox' format. The underlying principle here is that you have to say why a speech therapist is needed to work with a client. What skills do you bring with you that another person who is not an SLP can't do? After a session was completed, a required question to answer is "Was adequate progress made?" This is a 'multiple choice format'----see below. Here is an example of a real form for an unnamed student. This was based on an IEP that I inherited. I feel that by using this form, I've recorded adequate data to report on his progress. SAMPLE FORM. CLICK HERE The bottom line is that the IEP goals drive what I do, and how I create a Google form. Up front, it's labor intensive, but using these forms helps to drive my data collection and therapy note reporting. Ultimately, I'm a better therapist, and can use my detailed notes to report on student progress. Episode 3 will be on using this format to write progress reports, and how to collect all of this into 'working student folders'.
Great ideas from an librarian, SLP, and PK teacher!
I made this product because I was looking for a way to better keep track of the data for the goals of the student's IEP. This form allows you to see the goal and take data on the same sheet.
Although I really don't want to think about progress reports for a few more months, I was completely inspired by this list of Report Card comments. I typically write a few sentences of objective data ("Johnny is producing /s, z/ in initial position with 75% accuracy and medial position with 50% accuracy), and then I
Today I'm joining up with Jenn over at Crazy Speech World for a Data Linky Party! I wanted to show you the data sheet I've been using for a few years. It works for
A recent study indicated that providing students with daily report cards on their progress was beneficial. Sixty three elementary students, mostly white male with ADHD, received daily reports and a control group did not receive daily reports. Significant improvements where seen in productivity and following the classroom rules in the group that received the daily reports. Check out our newly published School and Home Communication Forms to get a simple daily form (plus 20 more forms) that you can even edit if necessary. Reference: Shah, Nirva. Study: 'Daily Report Cards' Improve Behavior of Students With ADHD. Retrieved from Education Week on 7/9/2012 at http://blogs.edweek.org/edweek/speced/2012/06/study_daily_report_cards_impro.html
One of the challenging things about teaching graduate student SLPs to do AAC assessments is that there is no single, comprehensive protocol to cover the needs of all types of clients. We’ve started…
Ok, so I have decided I will probably never be done, tinkering with my Excel file named Caseload Data Tools, but I have decided to release what I have so far to the public. I first started using Excel to record the data of my students’ sessions over a year ago and this file has seen a lot of improvements since. This file includes macros (programs written inside Excel to automate tasks). With macros, I have hopefully simplified charting of student data and making individual worksheets for each student. For more information about macros with Excel, check out my post here. There are lots of cells with red spots in the upper right corners. When you scroll over these, they display comments to help explain what to do and where to do it. Here is some (ok a lot) of the information. All the names and information in the pictures are fictitious, and were fabricated to illustrate how the file functions. Any resemblance to real persons, living or dead, is purely coincidental. You will need to enable macros in Excel to use most the the file's functions. The file starts with four sheets. The most important sheet in the file is ‘Caseload’. Data entered into this sheet is copied into other worksheets. Goals, minutes etc. can be changed at any time here, and the information will automatically be changed in the other worksheets. At the bare minimum student first names need to be entered. After students’ names are entered click “Click to here to make new client sheets”. Data can be entered into the client sheets (in Date, Target Area, and Percent and charted by clicking "Click here to make a Chart". A macro creates a pivot chart. Data can be filtered by selected by selecting "Target Area" or "Date". If one "Target Area" is selected, the chart can be changed to line graph by right clicking on the chart, selecting "Change Chart Type", then selecting "Line with Markers". Line charts usually do not work, when there is more than one target area, because days when only one target area is tracked the other area is tracked as zero. "Cluster Column" works best with multiple target areas. After you enter dates into the 'Attendance' sheet, minutes from the student sheets are automatically transferred into this sheet. Goals from the 'Caseload' sheet are also in the 'Goals' sheet for easy printing. The workbook also has a 'Schedule' sheet. Without using macros only the 'Caseload', 'Schedule', 'Goals', and 'Attendance' will work. I should probably include a disclaimer, so I don't get sued or anything. Macros contained in this Excel file are not intended to cause harm, but use at your own risk. Hopefully you will find this file as useful as I do!
This is the perfect way to individually track the progress during each session for each student all on one data collection form! Track a group of students who are working on the same or different goals using these group data strips. I have included an editable blank form within the zip file. Every sound in every position, plus blends! Phonemes include: P B T D M N Y G K F V TH SH CH J S R L Z TH is further broken down into voiced and voiceless R is further broken down into: AR ER OR (IRE, EAR, AIR) Mixed blends and separated blends include: S, R, L blends in combination and broken down and placed into phrases and sentences. Blends are further broken down and placed with vowels, in phrases, and in sentences. The blends included are: BR/DR/FR/GR/KR/PR/TR, SK/SL/SM/SN/SP/ST/SW and BL/FL/GL/KL/PL/SL. Phonemes are in the following positions: *Isolation *Phoneme with vowels *Initial/Medial/Final position of words *A mixed position list for each phoneme *Phrases with mixed positions of each phoneme & *Sentences with mixed positions of all phonemes Print the Speech Group Data form onto card stock, then print out the goal sheets that you need for your students and hole punch them using the guide. Hole punch your Speech Group Data form, using the guide, and then place your goal sheets for each student onto the group data form using brads. You can easily update goals. Place the next target behind the top goal to keep you on track! Once a goal is mastered remove the slip and place it in the student’s folder for your documentation. Each strip will document 10 therapy sessions. Each data form will hold up to 4 students. Use the blank data form that is included for your language students. You will have a sheet for each student and if you group your students, it will be very easy to tally results at the end of the therapy session. You can use the tally sheet to show parents and teachers progress. Once the child has finished one sound and position, move on to another! Take a look at my other data collection products: Individual Tracking Data for J for FREE! Individual Tracking Data for p b t d m n y Individual Tracking Data for s r l z and blends Individual Tracking Data for g k f v th sh ch RTI for J Articulation Progress Data PHRASES BUNDLE Articulation Progress Data SENTENCE BUNDLE
Here are some really simple data collection sheets to help organize your sessions. The first page features a 3-goal chart, the second page features a more target intensive chart, and the last page is a progress monitor sheet that you can use to see 10 sessions at a glance. I've included some of the ...
Progress charts are an amazing visual tool to use in your therapy. It helps the child understand and see their progress and gives them motivation for improvement. I am a HUGE believer in homework and daily drill with my speech clients. Usually the weeks where my students have a lower score than the previous week it is because they have not practiced their homework. Using a progress chart helps my clients feel more accountable for their improvement. We always celebrate any improvements and discuss all the possible reasons for regression. It is important that you let the client try to figure out why they didn't improve instead of pointing your finger at them and making them feel terrible. When they realize for themselves that they are in control of their improvements they always work harder and have a better attitude. I have made a number of different progress charts over the years. Last year I used this one. It is good, but it was hard for some of my clients to understand why we were charting the different positions (initial, medial, and final) on the same chart. So I decided to make a new one to help them better visualize which positions were easier and harder for them. Here it is. I am having a lot of success with it this term but I'm sure I'll be tweaking things like I always do. You can get a copy of this progress chart by going to my Teachers Pay Teachers website (seller name annieSLP) or copy and paste this link into your URL for the direct link to the artic progress chart: http://www.teacherspayteachers.com/Product/Articulation-Progress-Chart
Orlanda and I were comparing notes one day earlier this year about the seemingly bazillions of data documentation sheets that we had tried over the years and how none of them ever quite fit the bill. I showed her the one that I was currently using at the time and a few days later she tweaked the format using another data sheet she had tweaked from a colleague, and together we came up with a GREAT sheet. It has been really handy that we are both using the same format so when we are co-teaching, whichever one of us isn't direct teaching can pick up each other's data sheets and document data easily. Most of my (Kelley's) sheets are 2 sided to allow for frequency data to be collected on one side (behavioral or academic)... ...and anecdotal data on the other side. Obviously, I just make a note of the goal to remind me what I'm tracking. When I calculate the data I correlate it to the criterion. If kids have a lot of goals, they have a whole sheet to themselves. Students who are only working on a few goals or if I only see them in a group instead of working one on one or in the inclusion setting, are put on a "group" sheet. That way I can pull one sheet out for a group and track data on many students at the same time. I color code the sheets as well, so I can quickly retrieve the one I want and make notes. Using the same data documentation sheets allows us to easily share data across sessions for those students that we share as teacher and speech/language pathologist. This has helped our data reports be even more thorough. It has also helped us to evaluate behaviors and skills across settings. The Group data sheets that we are using can be found here: We have toyed with a variety of ways to calculate and measure our data, and currently we have stuck with "Percentage of trials correct". We have considered changing to a "rubric" system, but in the meantime, we have found this method to be the most useful and we just make sure we take GREAT notes when any "unknown" factors affect our therapy outcomes! You will see in the data Key that we use a (+) for a correct response, a (-) for an incorrect response, and (O) means we circle the type of response when it was cued. So essentially, we have four types of responses that we document: correct, incorrect, cued correct, and cued incorrect. The "notes" are an important place to document the "type" of cue needed, particularly if it was an extremely explicit cue (such as "hand over hand"). In speech therapy, I (Orlanda) use the above data sheet for group language sessions and even in fluency therapy. I have also tweaked the same type of data sheet specifically for articulation therapy with the only change being to the data key and an added "level". Find this data sheet here: On this form, the "level" refers to one of the following: isolation, syllable, word, phrase, sentence, connected speech, etc. Also, I have switched from the (+) method to using tally marks (/) because they are much faster for me to count and calculate AND I can fit more into a box (considering my goal is always 50+ trials per session). Then I use the "independence" slot to document the estimated amount/type of cues needed for each student. I have another data sheet that is similar but is meant for an individual therapy session. Grab it here: We would love to take a look at your data systems. What system do you use? Email us and we'd love to share your ideas with others. ~Kelley and Orlanda
As a rule, SLPs are pretty good about collecting data in their clinical work. Here are some of our prAACtical thoughts about data collection. 1. Don’t bite off more than you can chew. We’ve visited…
How to create a data collection system for speech therapy that is efficient and saves you time and allow you to quickly update student progress.
School-based speech-language pathologists often get swamped with treatment sessions, IEPs, meetings, progress reports, evaluations and more. We are tempted to cut corners with paperwork and tasks. One corner we can’t cut involves how we conduct speech-language evaluations.
This is a simple data collection form, designed to be used to track articulation. It allows for 100 trials per day and includes spaces to track the cues given, the sounds practiced, their position in words, and the level being addressed. This is a 2 page document designed to be printed double-side...
Attached are 3 different pragmatic language goal ideas and corresponding data sheets. Enjoy!
Trying to decide how to set up your student data in your speech therapy room? Click for an overview of different data taking systems outlined just for SLPs!
Form for collecting basic data for students on your caseload...
My FAVORITE resource. Write, track, and organize all of your caseload students' goals in the same spreadsheet. Easily write quarterly progress reports, keep track of data collection links and resources, and track student progress towards their goals all year!If you're looking for other caseload reso...
This document was created to help organize the SLP. I print these sheets front and back and use a label with the objectives printed on them to help make my data collection easier, visually organized and short and sweet. ...
I have created an Excel file which provides a visual of standard and scale scores for evaluations. I have a lot of parents who find all the scores from tests confusing, so I made this to help them understand. All you have to do is enter the student information and then enter the test name and standard or scale score and Excel will graph the score beside it. The student's age will be automatically calculated from the date of birth and report. You can download this file DxGraph.xlsx from ge.tt here. Comment if you have any suggestions.
Although I really don't want to think about progress reports for a few more months, I was completely inspired by this list of Report Card comments. I typically write a few sentences of objective data ("Johnny is producing /s, z/ in initial position with 75% accuracy and medial position with 50% accuracy), and then I
Between the million referrals, IEP folders, data collection sheets, homework sheets, lesson plans and behavior charts floating around my roo...
