Auto-calculations for Digital Forms

Hey everyone!

I made a Google Sheet with some formulas to auto-calculate the results from the digital CELF-5 Pragmatics Profile and CELF P2 Descriptive Pragmatics Profile and uploaded a presentation with videos about how to use them into the SLP Google Drive.  You will not need to type in formulas yourself but will need to follow the directions and copy the formulas/table set into a form response Google Sheet.  Please watch the videos before trying to use this document!

You can find the video and the auto-calculator google sheet in the Digital Form Auto-Calculators folder (in the Digital Forms folder).

In the presentation videos, there is also a helpful tip about using the "Transpose" function to reorganize form response data into 2 columns instead of the rows that are generated when you put the data in a Google Sheet (if you aren't already doing this!).

Contact me if you have any difficulty with it or have questions! 

 -Janie Life

Comments

Post a Comment

Popular posts from this blog

Informed SLP Grammar Guide

Hey everyone!  The Informed SLP just released a free resource on their blog to help SLPs with targeting grammar forms in the therapy.  They've compiled a spreadsheet called "Grammatical Concepts of English: Suggested Order of Intervention." I've copied the link for the blog post below, and you can find the spreadsheet here . The Informed SLP Blog post:  https://www.theinformedslp.com/how-to/grammar-chart They do explain in the blog post that there are " no systematic studies have yet been completed that show which order of intervention is most effective." Even though this is the case, they've used the research that is available to try to describe logical sequences for targets. They  describe  how the information in the spreadsheet is organized  in the bl og post .  It looked like it could be helpful, so I thought it was worth sharing! -Janie
Read more

Picture Books for 4-6

Hi all! I am trying to use books more in therapy and I would like to find some picture books (instead of chapter books) that are appropriate for 4th - 6th grade.  Does anyone have any recommendations? Thanks! Hailey
Read more

MSB Goals

Hey everyone! As I have been progress monitoring my students' goals, I noticed that sometimes the goals in MSB do not match the goals on their progress reports in esped. I was under the impression that MSB updated every day and would pull in esped goals. I'm not sure where some of the goals I've been submitting data for came from, because according to esped, my students don't have those things as goals. I hope that makes sense. Has this happened to anyone else?  Help! Lori
Read more