I've created this spreadsheet because I've found that scoring the Khan-Lewis Phonological Analysis-3 is really time consuming. This spreadsheet analyzes the errors for you and calculates your scores.
1. Administer the KLPA-3.
2. Type in or select the sound substitutions (IPA symbols) from the drop down menu.
3. Relax. This spreadsheet just calculated your raw score, number of occurrences per process, AND percent of occurrences.
4. Copy and paste into your report.
Video Tutorial Here!
Users will see the target word and target phoneme listed on the left side of the spreadsheet. Input your change into the "Change" column. Pay attention to highlighted vowels! These were added to easily calculate the presence of Syllable Reduction. Once complete, the spreadsheet will calculate the number of occurrences for each Core & Supplemental Phonological Process. The spreadsheet also calculates the Total Raw Score (based on the Core Phonological Processes only.) Users will have to input their own Standard Score, Percentile, and Age Equivalent from the User Manual. Copy and paste the KLPA-3 Score Summary and Percent of Occurrence for Core & Supplemental Phonological Processes grids into your report.
-This spreadsheet works on Macs & PCs.
-IPA symbols can be selected from the drop down menu in the "Change" column.
-Below the grids you'll see a list various IPA symbols- they were used to create the drop down menu, so just leave them be. :)
-It took me 6 months to make this spreadsheet! Enjoy!
Need to score the Goldman-Fristoe Test of Articulation-3? Check out this Auto-Analyzing Spreadsheet!
Please send me a message if you have any questions about this spreadsheet.