Linking Data Video Tutorial #4

Foundations of Scoring Assistants

This goes over everything you need to know about copying scoring assistants into Microsoft Excel and then linking them to Word.  It also shows you how to link a table from Excel to Word and gives pointers to ensure that the data is always accurately transferred into your final report.  


Next: Basics of Excel

4 Comments on “Linking Data Video Tutorial #4

  1. On this video you are copying and pasting scoring assistant data from word documents into excel. In my experience most of the scoring assistants I work with save the score files as pdfs which, when you highlight to copy and paste, do very strange things. I tried to copy and paste from a BASC-2 score report into an excel document and when using the Text to Columns function (with spaces) the data became very disorganized because the spaces did not necessarily correlate to data that needed an individual cell (i.e. externalizing problems only needed one cell not two separate cells). I love the idea of making templates for report writing to help make the process more efficient but if I have to copy and paste from pdf files and manually fix the spaces every time, it becomes more cumbersome and less efficient. Any suggestions?

    1. Hi Lexi, great questions and I can pretty easily answer these questions because I use the BASC-2 all the time and it works perfectly efficiently. I agree that when it comes to PDF’s, it comes out disorganized. From my experience, the WISC, WIAT, and BRIEF come out neatly organized. The WJ-3 and BASC-2 do not. You are correct in using text to columns for the BASC-2, and from your commentary, it sounds like you did everything right! The words “Externalizing Problems” will always take up two cells and the data is expected to come out a little disorganized. The important thing is that it’s going to come out looking this exact way every time with the scores of each scale always falling in the exact same cell for any student you do this for. It may appear chaotic, but it’s consistent. Try it with three different students and you’ll see that the scores and percentiles fall into the same cell each time. Then, as seen in the next part of the video tutorial, you have to organize the data and then link it. Trust me, I’m absolutely confident that the BASC-2 works using this method. Let me know if this helps!

  2. How do you handle tests that have different numbers of subtests depending on the grade of the student, etc.? Do you create a different Excel template for each variation?

    1. Great question Melody. If that were the case, I would have to make different versions. For example, on the WIAT, I have a separate Excel Template for Kindergarteners.

Leave a Reply

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