{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Intro and Terms","Form A","Form B"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Intro and Terms","index":0,"n_rows":46,"n_cols":1,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["P. Tomlan and D. Border's"]
["Psycholinguistic Analysis of the WJIII Understanding Directions Test "]
["Forms A & B"]
["     The Understanding Directions test is perhaps the most complex test in the new WJIII battery.  Many practitioners have waited a long time for such a test.  It can safely be assumed that the multiple language, memory and problem-solving demands embedded there accurately represent many of the psycholinguistic demands of the typical regular education classroom, 3rd grade and beyond.  "]
["     The attached tables have been developed in an effort to assist examiners with item analysis/error analysis of student performance and to facilitate instructional/language intervention.  Not every psycholinguistic variable is accounted for;  those chosen are felt to be the most obvious and most easily addressed in an instructional setting.  The best use of these tables appears to be post-hoc analysis of examinee responses.  During testing, the examiner notes errors made on the test protocol itself, keeping the factors delineated on the chart in mind. "]
["     Following testing, the examiner uses these tables to glean insight into the psycholinguistic factors missed/misunderstood, looking for patterns/consistencies in performance.  With error patterns identified, either (a) those errors are of the frequency and severity to warrant referral for more formal, complete language evaluation, followed by language services/support where appropriate, or (b) those errors are addressed through direct instruction/’mini units’ within the context of the regular education or special education setting.  It is critical that errors be addressed/remediated;  the ability to follow oral directions accurately is critical to success in school, employment and adult adjustment.  "]
["    The attached tables (Tabs Form A and B at bottom) have been developed in an effort to assist examiners with item analysis/error analysis of student performance and to facilitate instructional/language intervention.  Not every psycholinguistic variable is accounted for;  those chosen are felt to be the most obvious and most easily addressed in an instructional setting. "]
["During testing, as per test instructions, the examiner marks correct and incorrect responses on the test protocol itself.  Using the appropriate Psycholinguistic Analysis table for Form A or Form B, the examiner locates the specific items administered.  Click on \"Items Missed\".  By deleting the number 1 from the \"Items Missed\" column for each item performed correctly, the examiner will be left with a printable psycholinquistic error analysis.  "]
[]
[]
["Definition of Psycholinguistic Categories:"]
["    Word Count"]
["Number of words in the direction."]
["Word Analysis…"]
["       Number"]
["Words that indicate number, including plurals:  two birds, one tree"]
["       Demonstrative Pronouns"]
["Words that indicate specificity and are used in place of a noun;  each, all, one"]
["       Inference"]
["Descriptions used rather than concrete nouns:  “the thing that flies”"]
["      Spatial Concepts"]
["Words that require spatial orientation within the context of the picture presented, including foreground and background concepts:  by, next to, near, far, above"]
["       Comparative/Superlative"]
["Words that indicate degrees of comparison:  taller, smallest"]
["Syntactical level…"]
["       Sequential Order"]
["The syntax of the direction to be followed is “clean”, presented in the order in which the direction is to be operationalized, i.e.  “first you do X, then you do Y…”"]
["      Out-of-Order Sequence"]
["The syntax of the direction requires that the testee reorganize the order of occurrence, i.e. “before you do X, do Y…”"]
["Meta-linquistic level…"]
["       Either/Or…"]
["The direction indicates that a choice must be made while factors are held in working memory."]
["      While"]
["The direction requires that two to three elements be held in working memory and operationalized simultaneously."]
["      If-then"]
["The direction indicates that an if…then/causative condition exists, this information held in working memory.  Also includes words that connote an if/then relationship…  “unless X, then Y”."]
["       Negation"]
["The direction indicates that something is not to be done."]
["Cognitive level…"]
["       Complex Reasoning Shift"]
["The direction requires that the listener shift from one mindset/expectation to another unexpectedly.  Having set up a particular scenario, the direction abruptly shifts its orientation, requiring more of a problem-solving approach."]
["      Inclusion/Exclusion/Coordination"]
["The direction requires that the listener (a) establish a set and add to or create an exception within that set, or (b) coordinate information across sets."]
["       Working Memory"]
["The direction requires that 3 or more concepts/”idea units” be kept in mind at the same time to complete all facets of the instruction."]
["© Tomlan, P. & Border, D. (2001)  "]

{"sheet":"Form A","index":1,"n_rows":71,"n_cols":28,"rows_kept":71,"cut":false,"hidden":false,"merged":[[4,21,5,21],[3,5,3,11],[4,8,5,8],[4,9,5,9],[4,10,5,10],[1,5,1,9],[3,14,3,15],[29,0,38,0],[4,14,5,14],[4,15,5,15],[4,11,5,11],[4,2,5,2],[4,5,5,5],[4,7,5,7],[40,18,40,21],[40,24,40,26],[4,24,5,24],[4,25,5,25],[4,26,5,26],[3,24,3,26],[4,18,5,18],[3,18,3,21],[4,19,5,19],[4,20,5,20],[41,2,42,2],[41,5,42,5],[41,7,42,7],[41,8,42,8],[40,5,40,11],[40,14,40,15],[41,15,42,15],[41,18,42,18],[41,19,42,19],[41,20,42,20],[41,9,42,9],[41,10,42,10],[41,11,42,11],[41,14,42,14],[43,0,52,0],[54,0,65,0],[67,0,70,0],[0,0,0,27],[6,0,15,0],[17,0,27,0],[41,21,42,21],[41,24,42,24],[41,25,42,25],[41,26,42,26]]}
["Analysis of Understanding Directions Subtest on the WJ III  Form A"]
[null,null,"Student Name",null,null,1]
[]
[null,null,null,null,null,"Word Analysis",null,null,null,null,null,null,null,null,"Syntactic Level",null,null,null,"Metacognitive Level",null,null,null,null,null,"Cognitive Level"]
[null,null,"Items missed",null,null,"Word Count",null,"Number","Demonstrative Pronouns","Inference","Spatial Concepts","Comparitive - Superlative",null,null,"Sequential Order","Out-of-order Sequence",null,null,"Either/Or Choice","While","If-Then Causitive","Negation",null,null,"Complex Reasoning Shift","Inclusion - Exclusion - Coordination","Working memory"]
[null,"#"]
["Pastoral Scene",1,1,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,2,1,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,3,1,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,4,1,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,5,1,null,null,5,null,null,null,{"$f":"IF(C11=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,6,1,null,null,8,null,null,null,null,null,null,null,null,{"$f":"IF(C12=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,7,1,null,null,8,null,null,null,null,{"$f":"IF(C13=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C13=\"\",\"\",\"X\")","v":"X"},7]
[null,8,1,null,null,8,null,null,null,null,null,null,null,null,{"$f":"IF(C14=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,9,1,null,null,7,null,null,null,null,{"$f":"IF(C15=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C15=\"\",\"\",\"X\")","v":"X"},9]
[null,10,1,null,null,12,null,null,null,null,{"$f":"IF(C16=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C16=\"\",\"\",\"X\")","v":"X"},null,null,{"$f":"IF(C16=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C16=\"\",\"\",\"X\")","v":"X"},10]
[]
["Jungle Scene",1,1,null,null,10,null,null,null,null,{"$f":"IF(C18=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C18=\"\",\"\",\"X\")","v":"X"},null,null,null,{"$f":"IF(C18=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C18=\"\",\"\",\"X\")","v":"X"},1]
[null,2,1,null,null,8,null,null,null,null,null,null,null,null,{"$f":"IF(C19=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,3,1,null,null,15,null,null,null,null,{"$f":"IF(C20=\"\",\"\",\"XX\")","v":"XX"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C20=\"\",\"\",\"X\")","v":"X"},null,null,null,{"$f":"IF(C20=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C20=\"\",\"\",\"X\")","v":"X"},3]
[null,4,1,null,null,10,null,null,null,null,null,{"$f":"IF(C21=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,5,1,null,null,10,null,null,null,null,null,{"$f":"IF(C22=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,6,1,null,null,9,null,null,null,null,null,null,null,null,{"$f":"IF(C23=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,7,1,null,null,10,null,null,null,null,{"$f":"IF(C24=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C24=\"\",\"\",\"X\")","v":"X"},null,null,null,{"$f":"IF(C24=\"\",\"\",\"X\")","v":"X"},null,7]
[null,8,1,null,null,14,null,null,null,null,{"$f":"IF(C25=\"\",\"\",\"X\")","v":"X"},null,null,null,{"$f":"IF(C25=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C25=\"\",\"\",\"X\")","v":"X"},8]
[null,9,1,null,null,17,null,null,null,null,{"$f":"IF(C26=\"\",\"\",\"XXXX\")","v":"XXXX"},null,null,null,{"$f":"IF(C26=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C26=\"\",\"\",\"X\")","v":"X"},9]
[null,10,1,null,null,11,null,null,null,null,null,null,null,null,{"$f":"IF(C27=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C27=\"\",\"\",\"X\")","v":"X"},10]
[null,11,1,null,null,8,null,null,{"$f":"IF(C28=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,{"$f":"IF(C28=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,8]
["Mountain Scene",1,1,null,null,8,null,null,null,null,null,null,null,null,{"$f":"IF(C30=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,2,1,null,null,12,null,null,null,null,{"$f":"IF(C31=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C31=\"\",\"\",\"X\")","v":"X"},null,null,"X",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C31=\"\",\"\",\"X\")","v":"X"},2]
[null,3,1,null,null,13,null,null,null,null,{"$f":"IF(C32=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C32=\"\",\"\",\"X\")","v":"X"},null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"X",3]
[null,4,1,null,null,12,null,null,null,null,{"$f":"IF(C33=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C33=\"\",\"\",\"X\")","v":"X"},null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"X",4]
[null,5,1,null,null,15,null,null,null,null,{"$f":"IF(C34=\"\",\"\",\"XX\")","v":"XX"},{"$f":"IF(C34=\"\",\"\",\"X\")","v":"X"},null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"X",5]
[null,6,1,null,null,14,null,{"$f":"IF(C35=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C35=\"\",\"\",\"X\")","v":"X"},null,{"$f":"IF(C35=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C35=\"\",\"\",\"XX\")","v":"XX"},null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"X",6]
[null,7,1,null,null,12,null,null,null,null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"X",7]
[null,8,1,null,null,14,null,{"$f":"IF(C37=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C37=\"\",\"\",\"X\")","v":"X"},null,{"$f":"IF(C37=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C37=\"\",\"\",\"X\")","v":"X"},null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"X",8]
[null,9,1,null,null,16,null,null,null,null,{"$f":"IF(C38=\"\",\"\",\"XX\")","v":"XX"},{"$f":"IF(C38=\"\",\"\",\"XX\")","v":"XX"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X",9]
[null,10,1,null,null,14,null,null,null,null,null,null,null,null,{"$f":"IF(C39=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,"X",10]
[]
[null,null,null,null,null,"Word Analysis",null,null,null,null,null,null,null,null,"Syntactic Level",null,null,null,"Metacognitive Level",null,null,null,null,null,"Cognitive Level"]
[null,null,"Items missed",null,null,"Word Count",null,"Number","Demonstrative Pronouns","Inference","Spatial Concepts","Comparitive - Superlative",null,null,"Sequential Order","Out-of-order Sequence",null,null,"Either/Or Choice","While","If-Then Causitive","Negation",null,null,"Complex Reasoning Shift","Inclusion - Exclusion - Coordination","Working memory"]
[null,"#"]
["City Park Scene",1,1,null,null,16,null,null,null,{"$f":"IF(C44=\"\",\"\",\"X\")","v":"X"},null,null,null,null,{"$f":"IF(C44=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,{"$f":"IF(C44=\"\",\"\",\"X\")","v":"X"},null,null,null,{"$f":"IF(C44=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C44=\"\",\"\",\"X\")","v":"X"},1]
[null,2,1,null,null,15,null,null,null,null,null,{"$f":"IF(C45=\"\",\"\",\"X\")","v":"X"},null,null,{"$f":"IF(C45=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C45=\"\",\"\",\"X\")","v":"X"},2]
[null,3,1,null,null,12,null,{"$f":"IF(C46=\"\",\"\",\"XX\")","v":"XX"},null,null,null,null,null,null,{"$f":"IF(C46=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,4,1,null,null,17,null,{"$f":"IF(C47=\"\",\"\",\"XX\")","v":"XX"},null,null,{"$f":"IF(C47=\"\",\"\",\"XX\")","v":"XX"},null,null,null,{"$f":"IF(C47=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C47=\"\",\"\",\"X\")","v":"X"},4]
[null,5,1,null,null,15,null,null,null,null,null,null,null,null,null,{"$f":"IF(C48=\"\",\"\",\"X\")","v":"X"},null,null,{"$f":"IF(C48=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,{"$f":"IF(C48=\"\",\"\",\"X\")","v":"X"},5]
[null,6,1,null,null,22,null,null,{"$f":"IF(C49=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,{"$f":"IF(C49=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,{"$f":"IF(C49=\"\",\"\",\"X\")","v":"X"},null,null,null,{"$f":"IF(C49=\"\",\"\",\"X\")","v":"X"},"X",6]
[null,7,1,null,null,26,null,{"$f":"IF(C50=\"\",\"\",\"X\")","v":"X"},null,null,{"$f":"IF(C50=\"\",\"\",\"XX\")","v":"XX"},{"$f":"IF(C50=\"\",\"\",\"X\")","v":"X"},null,null,{"$f":"IF(C50=\"\",\"\",\"X\")","v":"X"},null,null,null,{"$f":"IF(C50=\"\",\"\",\"X\")","v":"X"},null,{"$f":"IF(C50=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,"X",7]
[null,8,1,null,null,24,null,null,null,null,{"$f":"IF(C51=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C51=\"\",\"\",\"X\")","v":"X"},null,null,{"$f":"IF(C51=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,"X",8]
[null,9,1,null,null,25,null,null,null,null,{"$f":"IF(C52=\"\",\"\",\"X\")","v":"X"},null,null,null,{"$f":"IF(C52=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,"X",9]
[null,10,1,null,null,22,null,null,null,null,null,null,null,null,{"$f":"IF(C53=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,{"$f":"IF(C53=\"\",\"\",\"X\")","v":"X"},null,null,{"$f":"IF(C53=\"\",\"\",\"X\")","v":"X"},null,"X",10]
[]
["Living Room Scene",1,1,null,null,34,null,null,null,null,{"$f":"IF(C55=\"\",\"\",\"XXX\")","v":"XXX"},{"$f":"IF(C55=\"\",\"\",\"X\")","v":"X"},null,null,{"$f":"IF(C55=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,{"$f":"IF(C55=\"\",\"\",\"X\")","v":"X"},null,null,null,{"$f":"IF(C55=\"\",\"\",\"X\")","v":"X"},null,{"$f":"IF(C55=\"\",\"\",\"X\")","v":"X"},1]
[null,2,1,null,null,19,null,{"$f":"IF(C56=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C56=\"\",\"\",\"X\")","v":"X"},null,{"$f":"IF(C56=\"\",\"\",\"XXX\")","v":"XXX"},null,null,null,{"$f":"IF(C56=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C56=\"\",\"\",\"X\")","v":"X"},"X",2]
[null,3,1,null,null,26,null,null,null,null,{"$f":"IF(C57=\"\",\"\",\"XXX\")","v":"XXX"},{"$f":"IF(C57=\"\",\"\",\"X\")","v":"X"},null,null,{"$f":"IF(C57=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,{"$f":"IF(C57=\"\",\"\",\"X\")","v":"X"},null,null,null,null,"X",3]
[null,4,1,null,null,22,null,null,null,null,null,null,null,null,{"$f":"IF(C58=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,{"$f":"IF(C58=\"\",\"\",\"X\")","v":"X"},null,null,{"$f":"IF(C58=\"\",\"\",\"X\")","v":"X"},null,"X",4]
[null,5,1,null,null,25,null,null,null,null,{"$f":"IF(C59=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C59=\"\",\"\",\"X\")","v":"X"},null,null,null,{"$f":"IF(C59=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,"X",5]
[null,6,1,null,null,20,null,null,null,null,{"$f":"IF(C60=\"\",\"\",\"XX\")","v":"XX"},null,null,null,{"$f":"IF(C60=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,"X",6]
[null,7,1,null,null,21,null,null,null,null,{"$f":"IF(C61=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C61=\"\",\"\",\"X\")","v":"X"},null,null,null,{"$f":"IF(C61=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,"X",7]
[null,8,1,null,null,40,null,null,null,null,{"$f":"IF(C62=\"\",\"\",\"XXX\")","v":"XXX"},null,null,null,{"$f":"IF(C62=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C62=\"\",\"\",\"X\")","v":"X"},null,null,null,null,{"$f":"IF(C62=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C62=\"\",\"\",\"X\")","v":"X"},null,null,null,null,"X",8]
[null,9,1,null,null,25,null,null,null,null,{"$f":"IF(C63=\"\",\"\",\"XX\")","v":"XX"},{"$f":"IF(C63=\"\",\"\",\"X\")","v":"X"},null,null,{"$f":"IF(C63=\"\",\"\",\"X\")","v":"X"},null,null,null,{"$f":"IF(C63=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,"X",9]
[null,10,1,null,null,26,null,{"$f":"IF(C64=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C64=\"\",\"\",\"X\")","v":"X"},null,null,{"$f":"IF(C64=\"\",\"\",\"X\")","v":"X"},null,"X",10]
[null,11,1,null,null,23,null,null,null,null,{"$f":"IF(C65=\"\",\"\",\"XX\")","v":"XX"},null,null,null,{"$f":"IF(C65=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C65=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,"X",11]
[null,12,1,null,null,27,null,null,null,null,{"$f":"IF(C66=\"\",\"\",\"XXX\")","v":"XXX"},{"$f":"IF(C66=\"\",\"\",\"X\")","v":"X"},null,null,null,{"$f":"IF(C66=\"\",\"\",\"X\")","v":"X"},null,null,null,{"$f":"IF(C66=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,"X",12]
[]
["Desert Scene",1,1,null,null,20,null,{"$f":"IF(C68=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C68=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,{"$f":"IF(C68=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C68=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C68=\"\",\"\",\"X\")","v":"X"},1]
[null,2,1,null,null,23,null,null,null,null,{"$f":"IF(C69=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C69=\"\",\"\",\"X\")","v":"X"},null,null,{"$f":"IF(C69=\"\",\"\",\"X\")","v":"X"},null,null,null,{"$f":"IF(C69=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,{"$f":"IF(C69=\"\",\"\",\"X\")","v":"X"},2]
[null,3,1,null,null,22,null,null,null,null,{"$f":"IF(C70=\"\",\"\",\"X\")","v":"X"},null,null,null,null,{"$f":"IF(C70=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C70=\"\",\"\",\"X\")","v":"X"},3]
[null,4,1,null,null,42,null,null,null,null,{"$f":"IF(C71=\"\",\"\",\"XX\")","v":"XX"},{"$f":"IF(C71=\"\",\"\",\"XX\")","v":"XX"},null,null,{"$f":"IF(C71=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C71=\"\",\"\",\"X\")","v":"X"},null,null,null,null,{"$f":"IF(C71=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C71=\"\",\"\",\"X\")","v":"X"},null,null,null,null,{"$f":"IF(C71=\"\",\"\",\"X\")","v":"X"},4]

{"sheet":"Form B","index":2,"n_rows":76,"n_cols":28,"rows_kept":76,"cut":false,"hidden":false,"merged":[[27,0,36,0],[68,0,75,0],[41,0,51,0],[54,0,65,0],[39,2,40,2],[39,5,40,5],[39,7,40,7],[39,25,40,25],[39,26,40,26],[39,15,40,15],[39,18,40,18],[39,19,40,19],[1,5,1,9],[39,8,40,8],[38,5,38,11],[39,20,40,20],[39,9,40,9],[39,10,40,10],[39,11,40,11],[39,14,40,14],[0,0,0,27],[6,0,12,0],[15,0,24,0],[39,21,40,21],[39,24,40,24],[38,14,38,15],[38,18,38,21],[38,24,38,26],[4,24,5,24],[4,25,5,25],[4,26,5,26],[4,14,5,14],[4,15,5,15],[3,14,3,15],[4,18,5,18],[3,18,3,21],[3,24,3,26],[4,19,5,19],[4,20,5,20],[4,21,5,21],[4,2,5,2],[4,5,5,5],[4,7,5,7],[3,5,3,11],[4,8,5,8],[4,9,5,9],[4,10,5,10],[4,11,5,11]]}
["Analysis of Understanding Directions Subtest on the WJ III  Form B"]
[null,null,"Student Name",null,null,1]
[]
[null,null,null,null,null,"Word Analysis",null,null,null,null,null,null,null,null,"Syntactic Level",null,null,null,"Metacognitive Level",null,null,null,null,null,"Cognitive Level"]
[null,null,"Items missed",null,null,"Word Count",null,"Number","Demonstrative Pronouns","Inference","Spatial Concepts","Comparitive - Superlative",null,null,"Sequential Order","Out-of-order Sequence",null,null,"Either/Or Choice","While","If-Then Causitive","Negation",null,null,"Complex Reasoning Shift","Inclusion - Exclusion - Coordination","Working memory"]
[null,"#"]
["Beach Scene",1,1,null,null,4,null,{"$f":"IF(C7=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,2,1,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,3,1,null,null,4,null,{"$f":"IF(C9=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,4,1,null,null,8,null,{"$f":"IF(C10=\"\",\"\",\"XX\")","v":"XX"},null,null,null,null,null,null,{"$f":"IF(J10=\"\",\"\",\"X\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,5,1,null,null,8,null,null,null,null,null,null,null,null,{"$f":"IF(J11=\"\",\"\",\"X\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,6,1,null,null,11,null,null,null,null,{"$f":"IF(C12=\"\",\"\",\"X\")","v":"X"},null,null,null,{"$f":"IF(J12=\"\",\"\",\"X\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,7,1,null,null,7,null,null,null,null,{"$f":"IF(C13=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C13=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[]
[]
["Farm Scene",1,1,null,null,8,null,null,null,null,null,null,null,null,{"$f":"IF(C16=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,2,1,null,null,11,null,null,null,null,{"$f":"IF(C17=\"\",\"\",\"X\")","v":"X"},null,null,null,{"$f":"IF(C17=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,3,1,null,null,10,null,null,null,null,{"$f":"IF(C18=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C18=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,4,1,null,null,9,null,null,null,null,null,null,null,null,{"$f":"IF(C19=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,5,1,null,null,11,null,{"$f":"IF(C20=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C20=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C20=\"\",\"\",\"X\")","v":"X"},null,null,null,{"$f":"IF(C20=\"\",\"\",\"X\")","v":"X"},null,5]
[null,6,1,null,null,11,null,null,null,null,null,{"$f":"IF(C21=\"\",\"\",\"X\")","v":"X"},null,null,{"$f":"IF(C21=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,7,1,null,null,10,null,null,null,null,{"$f":"IF(C22=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,8,1,null,null,11,null,null,null,null,{"$f":"IF(C23=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C23=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,9,1,null,null,8,null,null,{"$f":"IF(C24=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,{"$f":"IF(C24=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,10,1,null,null,11,null,null,null,null,null,null,null,null,{"$f":"IF(C25=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,null,10]
[]
[]
["Swim Scene",1,1,null,null,11,null,null,null,null,{"$f":"IF(C28=\"\",\"\",\"X\")","v":"X"},null,null,null,{"$f":"IF(C28=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,2,1,null,null,12,null,null,null,null,{"$f":"IF(C29=\"\",\"\",\"X\")","v":"X"},null,null,null,{"$f":"IF(C29=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,3,1,null,null,13,null,null,null,null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,4,1,null,null,20,null,{"$f":"IF(C31=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C31=\"\",\"\",\"X\")","v":"X"},null,{"$f":"IF(C31=\"\",\"\",\"X\")","v":"X"},null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C31=\"\",\"\",\"X\")","v":"X"},4]
[null,5,1,null,null,14,null,null,null,null,{"$f":"IF(C32=\"\",\"\",\"X\")","v":"X"},null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C32=\"\",\"\",\"X\")","v":"X"},5]
[null,6,1,null,null,13,null,{"$f":"IF(C33=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C33=\"\",\"\",\"X\")","v":"X"},null,{"$f":"IF(C33=\"\",\"\",\"X\")","v":"X"},null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,7,1,null,null,14,null,null,null,null,{"$f":"IF(C34=\"\",\"\",\"X\")","v":"X"},null,null,null,"X",null,null,null,null,null,null,{"$f":"IF(C34=\"\",\"\",\"X\")","v":"X"},null,null,null,null,{"$f":"IF(C34=\"\",\"\",\"X\")","v":"X"},7]
[null,8,1,null,null,18,null,null,null,null,{"$f":"IF(C35=\"\",\"\",\"XX\")","v":"XX"},{"$f":"IF(C35=\"\",\"\",\"XX\")","v":"XX"},null,null,"X",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C35=\"\",\"\",\"X\")","v":"X"},8]
[null,9,1,null,null,16,null,null,null,null,{"$f":"IF(C36=\"\",\"\",\"XXX\")","v":"XXX"},{"$f":"IF(C36=\"\",\"\",\"X\")","v":"X"},null,null,"X",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C36=\"\",\"\",\"X\")","v":"X"},9]
[null,10,1,null,null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C37=\"\",\"\",\"X\")","v":"X"},10]
[]
[null,null,null,null,null,"Word Analysis",null,null,null,null,null,null,null,null,"Syntactic Level",null,null,null,"Metacognitive Level",null,null,null,null,null,"Cognitive Level"]
[null,null,"Items missed",null,null,"Word Count",null,"Number","Demonstrative Pronouns","Inference","Spatial Concepts","Comparitive - Superlative",null,null,"Sequential Order","Out-of-order Sequence",null,null,"Either/Or Choice","While","If-Then Causitive","Negation",null,null,"Complex Reasoning Shift","Inclusion - Exclusion - Coordination","Working memory"]
[null,"#"]
["School Scene",1,1,null,null,11,null,null,null,null,null,{"$f":"IF(C42=\"\",\"\",\"X\")","v":"X"},null,null,{"$f":"IF(C42=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C42=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C42=\"\",\"\",\"X\")","v":"X"},1]
[null,2,1,null,null,17,null,null,null,null,{"$f":"IF(C43=\"\",\"\",\"X\")","v":"X"},null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"X",2]
[null,3,1,null,null,15,null,{"$f":"IF(C44=\"\",\"\",\"X\")","v":"X"},null,null,{"$f":"IF(C44=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C44=\"\",\"\",\"X\")","v":"X"},null,null,"X",null,null,null,null,null,null,null,null,null,null,null,"X",3]
[null,4,1,null,null,19,null,null,null,null,null,{"$f":"IF(C45=\"\",\"\",\"X\")","v":"X"},null,null,"X",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C45=\"\",\"\",\"X\")","v":"X"},"X",4]
[null,5,1,null,null,19,null,null,null,null,{"$f":"IF(C46=\"\",\"\",\"XX\")","v":"XX"},null,null,null,"X",null,null,null,null,null,null,{"$f":"IF(C46=\"\",\"\",\"X\")","v":"X"},null,null,null,null,"X",5]
[null,6,1,null,null,19,null,null,null,null,{"$f":"IF(C47=\"\",\"\",\"X\")","v":"X"},null,null,null,"X",{"$f":"IF(C47=\"\",\"\",\"X\")","v":"X"},null,null,{"$f":"IF(C47=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,"X",6]
[null,7,1,null,null,26,null,null,null,null,{"$f":"IF(C48=\"\",\"\",\"X\")","v":"X"},null,null,null,"X",{"$f":"IF(C48=\"\",\"\",\"X\")","v":"X"},null,null,null,null,{"$f":"IF(DC48=\"\",\"\",\"X\")","v":""},{"$f":"IF(C48=\"\",\"\",\"X\")","v":"X"},null,null,{"$f":"IF(C48=\"\",\"\",\"X\")","v":"X"},null,"X",7]
[null,8,1,null,null,24,null,{"$f":"IF(C49=\"\",\"\",\"X\")","v":"X"},null,null,{"$f":"IF(C49=\"\",\"\",\"XX\")","v":"XX"},{"$f":"IF(C49=\"\",\"\",\"X\")","v":"X"},null,null,"X",null,null,null,{"$f":"IF(C49=\"\",\"\",\"X\")","v":"X"},null,{"$f":"IF(C49=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,"X",8]
[null,9,1,null,null,24,null,null,{"$f":"IF(C50=\"\",\"\",\"X\")","v":"X"},null,{"$f":"IF(C50=\"\",\"\",\"XX\")","v":"XX"},null,null,null,{"$f":"IF(C50=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,"X",9]
[null,10,1,null,null,20,null,{"$f":"IF(C51=\"\",\"\",\"X\")","v":"X"},null,null,{"$f":"IF(C51=\"\",\"\",\"XX\")","v":"XX"},null,null,null,{"$f":"IF(C51=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,"X",10]
[null,11,1,null,null,26,null,null,null,null,{"$f":"IF(C52=\"\",\"\",\"XXX\")","v":"XXX"},{"$f":"IF(C52=\"\",\"\",\"X\")","v":"X"},null,null,{"$f":"IF(C52=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C52=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C52=\"\",\"\",\"X\")","v":"X"},11]
[]
[]
["Coral Scene",1,1,null,null,12,null,{"$f":"IF(C55=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,{"$f":"IF(C55=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,{"$f":"IF(C55=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,1]
[null,2,1,null,null,17,null,{"$f":"IF(C56=\"\",\"\",\"X\")","v":"X"},null,null,{"$f":"IF(C56=\"\",\"\",\"X\")","v":"X"},null,null,null,{"$f":"IF(C56=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C56=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C56=\"\",\"\",\"X\")","v":"X"},2]
[null,3,1,null,null,20,null,{"$f":"IF(C57=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C57=\"\",\"\",\"X\")","v":"X"},null,null,{"$f":"IF(C57=\"\",\"\",\"X\")","v":"X"},null,null,null,{"$f":"IF(C57=\"\",\"\",\"X\")","v":"X"},null,3]
[null,4,1,null,null,18,null,null,null,null,{"$f":"IF(C58=\"\",\"\",\"XXXX\")","v":"XXXX"},null,null,null,{"$f":"IF(C58=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C58=\"\",\"\",\"X\")","v":"X"},4]
[null,5,1,null,null,13,null,null,null,null,{"$f":"IF(C59=\"\",\"\",\"X\")","v":"X"},null,null,null,null,{"$f":"IF(C59=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,5]
[null,6,1,null,null,16,null,null,null,null,{"$f":"IF(C60=\"\",\"\",\"XX\")","v":"XX"},null,null,null,null,{"$f":"IF(C60=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,6]
[null,7,1,null,null,17,null,null,null,null,{"$f":"IF(C61=\"\",\"\",\"X\")","v":"X"},null,null,null,{"$f":"IF(C61=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,8,1,null,null,15,null,null,null,null,{"$f":"IF(C62=\"\",\"\",\"XX\")","v":"XX"},null,null,null,{"$f":"IF(C62=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C62=\"\",\"\",\"X\")","v":"X"},null,8]
[null,9,1,null,null,8,null,{"$f":"IF(C63=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C63=\"\",\"\",\"X\")","v":"X"},null,9]
[null,10,1,null,null,18,null,null,null,null,{"$f":"IF(C64=\"\",\"\",\"XX\")","v":"XX"},null,null,null,{"$f":"IF(C64=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C64=\"\",\"\",\"X\")","v":"X"},10]
[null,11,1,null,null,16,null,{"$f":"IF(C65=\"\",\"\",\"X\")","v":"X"},null,null,{"$f":"IF(C65=\"\",\"\",\"XX\")","v":"XX"},null,null,null,null,{"$f":"IF(C65=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C65=\"\",\"\",\"X\")","v":"X"},11]
[null,12,1,null,null,19,null,null,null,null,{"$f":"IF(C66=\"\",\"\",\"XX\")","v":"XX"},{"$f":"IF(C66=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,{"$f":"IF(C66=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,12]
[]
[]
["Desert Scene",1,1,null,null,37,null,null,null,null,{"$f":"IF(C69=\"\",\"\",\"XXXX\")","v":"XXXX"},null,null,null,{"$f":"IF(C69=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C69=\"\",\"\",\"X\")","v":"X"},null,null,null,null,{"$f":"IF(C69=\"\",\"\",\"X\")","v":"X"},null,null,null,{"$f":"IF(C69=\"\",\"\",\"X\")","v":"X"},null,null,1]
[null,2,1,null,null,22,null,null,null,{"$f":"IF(C70=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C70=\"\",\"\",\"XXX\")","v":"XXX"},null,null,null,null,{"$f":"IF(C70=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C70=\"\",\"\",\"X\")","v":"X"},2]
[null,3,1,null,null,17,null,null,null,null,{"$f":"IF(C71=\"\",\"\",\"X\")","v":"X"},null,null,null,{"$f":"IF(C71=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,null,null,null,null,null,"X",3]
[null,4,1,null,null,23,null,{"$f":"IF(C72=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,"X",null,null,null,null,null,null,{"$f":"IF(C72=\"\",\"\",\"X\")","v":"X"},null,null,{"$f":"IF(C72=\"\",\"\",\"X\")","v":"X"},null,"X",4]
[null,5,1,null,null,26,null,null,null,null,{"$f":"IF(C73=\"\",\"\",\"XXX\")","v":"XXX"},{"$f":"IF(C73=\"\",\"\",\"X\")","v":"X"},null,null,"X",null,null,null,null,null,null,{"$f":"IF(C73=\"\",\"\",\"X\")","v":"X"},null,null,null,{"$f":"IF(C73=\"\",\"\",\"X\")","v":"X"},"X",5]
[null,6,1,null,null,24,null,null,null,null,{"$f":"IF(C74=\"\",\"\",\"X\")","v":"X"},null,null,null,"X",{"$f":"IF(C74=\"\",\"\",\"X\")","v":"X"},null,null,null,null,{"$f":"IF(C74=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C74=\"\",\"\",\"X\")","v":"X"},null,null,{"$f":"IF(C74=\"\",\"\",\"X\")","v":"X"},null,"X",6]
[null,7,1,null,null,28,null,null,null,{"$f":"IF(C75=\"\",\"\",\"X\")","v":"X"},{"$f":"IF(C75=\"\",\"\",\"XXX\")","v":"XXX"},{"$f":"IF(C75=\"\",\"\",\"X\")","v":"X"},null,null,"X",{"$f":"IF(C75=\"\",\"\",\"X\")","v":"X"},null,null,null,{"$f":"IF(C75=\"\",\"\",\"X\")","v":"X"},null,null,null,null,null,null,"X",7]
[null,8,1,null,null,20,null,null,null,null,{"$f":"IF(C76=\"\",\"\",\"X\")","v":"X"},null,null,null,"X",{"$f":"IF(C76=\"\",\"\",\"XX\")","v":"XX"},null,null,null,null,null,null,null,null,null,null,"X",8]