Embedded Files
April 14, 2020
Writing reports is my least favorite part about being a psychologist. I have templates of the tests that I administer, but having to Control+F and replace for the student’s name, changing the “he/she” or “his/her,” and putting in “(Standard Score = X), which falls in the AVERAGE range” is a hassle and can lead to many errors.
WHAT IF I TOLD YOU THAT YOU COULD SET UP YOUR TEMPLATES TO NOT ONLY COMPUTE TABLES BUT ALSO WRITE THE REPORT FOR YOU?
WHAT IF I TOLD YOU THAT YOU COULD SET UP YOUR TEMPLATES TO NOT ONLY COMPUTE TABLES BUT ALSO WRITE THE REPORT FOR YOU?
I stumbled upon Document Studio, a Google add-on. It cost me $29 for the year, but considering the number of reports I write, it was worth it for me.
It took some time to figure it out, but I got the hang of it and now have it for all my core batteries (WIAT, KTEA, TOWL, WISC, WRAML, NEPSY, DKEFS, etc.).
For the example provided, I used an outdated assessment with data taken from a sample report. You can see the report here. This is not real data.
HOW DOES IT WORK?
HOW DOES IT WORK?
You need to have your report template in a google document and your data in a google sheet. I keep both of these in the same folder.
In your Google Sheet, you put your “markers” in the first row. The data it pulls from is in the second row. Each marker is placed between {{brackets}}. When you run the add-on, it will pull the data from the first row and place it into the document based on what markers you have set up. Here are some examples of markers I have:
Name – {{NAME}}
he or she – {{heshe}}
His or Her – {{HisHer}}
The second row is where you input the data. In the video that I had linked, I have the data pulled from a table in another tab. I did this because I had created VLOOKUPs for all of my percentiles and descriptors. It’s super easy to create, and it saves me a step when creating my tables.
For the example shown, I have {{FSIQSS}} which is my FSIQ Standard Score. I have the second row pre-formatted. The formula I have is =’WISC-IV’!C4 or in other words =’tab name’!ColumnRow. This means that if I have a number in the tab WISC-IV, Column C, Row 4, it will automatically put that number in the cell in which I put the formula in.
I do this formatting for each score. Yes, this takes time to set up. But the time I put in to create it outweighs writing each report.
Now that you have your spreadsheet ready, you need to set up your report template. Notice how I have markers for {{NAME}}, {{heshe}}, etc.? I simply copy and paste those markers into my report where I would want that information to be put into.
Once you have your template ready, you go back to your Google Doc, select Add-Ons, Document Studio, and click Run. That’s it.
TIPS
TIPS
I also included my table from the Google Sheet in my template. That is one less thing that I will have to copy and paste! I just put the markers where I want the data to go.
I include sections under each paragraph that help me explain the scores. For example, what does it mean if Score A is higher than Score B? Or what does it mean if Score C is a normative weakness? That way, I can keep the interpretation that I need in my report and delete the rest.
Double, triple, and quadruple-check that each marker in your template is the correct information that you want in that spot.
UPDATE
UPDATE
I had many people reach out with additional questions so I hope this helps!
In the example above, these are my headings. H2:K2 is formatted to pull the data from the table. Here are my formulas to pull that data.
‘WISC-IV‘ = The sheet I want to pull the data from.
H2 = =‘WISC-IV’!C4 = In this example, it is 100
I2 = =‘WISC-IV’!D4 = In this example, it is 50
J2 = =‘WISC-IV’!E4 = In this example, it is 95-105
K2 = =‘WISC-IV’!F4 = In this example, it is Average
THE GOOGLE DOC TEMPLATE IN THIS EXAMPLE IS:
WECHSLER INTELLIGENCE SCALE FOR CHILDREN- FOURTH EDITION (WISC-IV)
{{NAME}} was administered fifteen subtests of the Wechsler Intelligence Scale for Children, Fourth Edition (WISC-IV) from which {{his*her}} composite scores are derived. The Full Scale IQ (FSIQ) is derived from a combination of ten subtest scores and is considered the most representative estimate of global intellectual functioning. {{NAME}}’s general cognitive ability is within the {{FSIQD}} range of intellectual functioning, as measured by the FSIQ. {{HisHer}} overall thinking and reasoning abilities exceed those of approximately {{FSIQ%}}% of children {{his*her}} age (FSIQ = {{FSIQSS}}; 95% confidence interval = {{FSIQR}}). {{HisHer}} ability to think with words is comparable to {{his*her}} ability to reason without the use of words.
THE SCORE TABLE IN THE GOOGLE DOC LOOKS LIKE THIS:
Page updated
Report abuse