{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Information","D-SNAP Worksheet","True Peer Estimator","Domain Calculator"],"not_rendered":{"charts":1,"images":5,"macros":1,"external_links":0,"defined_names":14,"comments":0,"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":"Information","index":0,"n_rows":75,"n_cols":28,"rows_kept":75,"cut":false,"hidden":false,"merged":[[1,4,1,15],[6,4,6,15],[3,4,3,15],[66,23,66,24],[23,19,29,21],[14,5,14,8],[13,5,13,7],[66,5,66,6],[66,15,66,16],[48,4,50,15],[35,5,35,15],[38,6,38,15],[33,11,33,15],[11,3,13,3],[21,9,21,10],[39,6,39,15],[52,4,52,15],[51,4,51,15],[40,6,40,15],[42,5,43,15],[21,14,22,15]]}
[]
[null,null,null,null,"Diverse Student Normal Ability Performance"]
[]
[null,null,null,null,"© Larry J. Pristo, Ph.D and Samuel O. Ortiz, Ph.D."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V.02.22.24"]
[]
[null,null,null,null,"ENTER INFORMATION IN THE GREEN CELLS"]
[]
[null,null,null,null,"STEP 1","Enter Identifying Information"]
[]
[null,null,null,null,null,"Student Name"]
[null,null,null,"Optional",null,"ID Number"]
[null,null,null,null,null,"Date of Birth",null,null,{"$f":"DATEDIF($E$38,$E$39,\"y\")","v":0}]
[null,null,null,null,null,"Date of Cognitive Evaluation"]
[null,null,null,null,"Age =",{"$f":"DATEDIF($E$13,$E$14,\"y\")&\" years \"&DATEDIF($E$13,$E$14,\"ym\")&\" months \"&DATEDIF($E$1,$E$14,\"md\")&\" days\"","v":"0 years 0 months 0 days"},null,null,null,"(age is automatically computed)"]
[]
[null,null,null,null,"STEP 2","A.  Enter the seven broad factor scores (if available) and confidence intervals"]
[null,null,null,null,null,"B.  Indicate 68, 90, or 95 percent for the confidence interval"]
[null,null,null,null,null,"The WJ IV confidence intervals are available from the computerized scoring printout."]
[null,null,null,null,null,"The WISC-V (table D.2) and KABC-II (tables A.2-A.6) are available in the manuals."]
[]
[null,null,null,null,"Clusters",null,null,null,"% CI =",90,null,null,null,null,"Scaled to Standard Score Converter",null,null,null,"Predicted"]
[null,null,null,null,null,null,null,null,"SS","-1 CI","+1 CI"]
[null,null,null,null,"Comprehension - Knowledge (Gc)",null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(5*O24)+50","v":50},null,"Gc",{"$f":"IF(E39=0,0,IF(E39=1,D69,IF(E39=2,N69,IF(E39=3,V69,IF(E39=4,D70,IF(E39=5,N70,IF(E39=6,V70,IF(E39=7,D71,IF(E39=8,N71,IF(E39=9,V71))))))))))","v":0},"The predicted numbers populate from a formula using the number assigned to the level of difference."]
[null,null,null,null,"Fluid Reasoning (Gf)",null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(5*O25)+50","v":50},null,"Gf",{"$f":"IF(E39=0,0,IF(E39=1,E69,IF(E39=2,O69,IF(E39=3,W69,IF(E39=4,E70,IF(E39=5,O70,IF(E39=6,V70,IF(E39=7,E71,IF(E39=8,O71,IF(E39=9,W71))))))))))","v":0}]
[null,null,null,null,"Short-Term, Working Memory (Gwm)",null,null,null,null,null,null,null,null,null,0,50,null,"Gwm",{"$f":"IF(E39=0,0,IF(E39=1,F69,IF(E39=2,P69,IF(E39=3,X69,IF(E39=4,F70,IF(E39=5,P70,IF(E39=6,X70,IF(E39=7,F71,IF(E39=8,P71,IF(E39=9,X71))))))))))","v":0}]
[null,null,null,null,"Long-Term Retrieval (Glr)",null,null,null,null,null,null,null,null,null,0,50,null,"Glr",{"$f":"IF(E39=0,0,IF(E39=1,G69,IF(E39=2,Q69,IF(E39=3,Y69,IF(E39=4,G70,IF(E39=5,Q70,IF(E39=6,Y70,IF(E39=7,G71,IF(E39=8,Q71,IF(E39=9,Y71))))))))))","v":0}]
[null,null,null,null,"Visual Processing (Gv)",null,null,null,null,null,null,null,null,null,0,50,null,"Gv",{"$f":"IF(E39=0,0,IF(E39=1,H69,IF(E39=2,R69,IF(E39=3,Z69,IF(E39=4,H70,IF(E39=5,R70,IF(E39=6,Z70,IF(E39=7,H71,IF(E39=8,R71,IF(E39=9,Z71))))))))))","v":0}]
[null,null,null,null,"Auditory Processing (Ga)",null,null,null,null,null,null,null,null,null,0,50,null,"Ga",{"$f":"IF(E39=0,0,IF(E39=1,I69,IF(E39=2,S69,IF(E39=3,AA69,IF(E39=4,I70,IF(E39=5,S70,IF(E39=6,AA70,IF(E39=7,I71,IF(E39=8,S71,IF(E39=9,AA71))))))))))","v":0}]
[null,null,null,null,"Cognitive Processing Speed (Gs)",null,null,null,null,null,null,null,null,null,0,50,null,"Gs",{"$f":"IF(E39=0,,IF(E39=1,J69,IF(E39=2,T69,IF(E39=3,AB69,IF(E39=4,J70,IF(E39=5,T70,IF(E39=6,AB70,IF(E39=7,J71,IF(E39=8,T71,IF(E39=9,AB71))))))))))","v":0}]
[]
[null,null,null,null,"STEP 3","Determine the degree of \"Difference\" using the True Peer Estimator"]
[]
[null,null,null,null,"Based on your TPE ratings, you have indicated that the examinee is:",null,null,null,null,null,null,{"$f":"IF('True Peer Estimator'!M25=\"\",\"(TPE not completed)\",'True Peer Estimator'!M25)","v":"(TPE not completed)"}]
[]
[null,null,null,null,"STEP 4","Enter the value corresponding to the base assessment and the level of difference above the arrow"]
[]
[null,null,null,null,null,"Test by Level of Difference"]
[null,null,null,null,null,"WJ IV","1 = Slightly Different, 2 = Moderately Different, 3 = Markedly Different"]
[null,null,null,null,null,"WISC-V","4 = Slightly Different, 5 = Moderately Different, 6 = Markedly Different"]
[null,null,null,null,null,"KABC-II","7 = Slightly Different, 8 = Moderately Different, 9 = Markedly Different"]
[]
[null,null,null,null,"STEP 5","If you have an expected value for a broad factor not represented by one of the base tests, enter the value corresponding to the assessment and missing factor below."]
[]
[null,null,null,null,null,"WISC-V","Ga"]
[null,null,null,null,null,"KABC-II","Ga"]
[null,null,null,null,null,"KABC-II","Gs"]
[]
[null,null,null,null,"D-SNAP is © L. J. Pristo and S. O. Ortiz, 2024. This workbook and its contents are protected by copyright and other intellectual property rights. The contents and materials, except as referenced from other sources, are owned by the authors. The D-SNAP may not be reproduced, disseminated, or distrigbuted in printed or electronic form and may not be adapted, modified, reverse-engineered, or incorporated into other documents or programs without the expressed permission of the authors. However, permission to use, copy, and disseminate D-SNAP is granted for individual professional use, educational purposes, and other non-profit activities."]
[]
[]
[null,null,null,null,"The current verion of the D-SNAP can be downloaded freely at:"]
[null,null,null,null,"https://facpub.stjohns.edu/~ortizs/CLIM/"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"IF(J22<90,\"68% Confidence Interval\",IF(J22<95,\"90% Confidence Interval\",IF(J22>90,\"95% Confidence Interval\")))","v":"90% Confidence Interval"},null,null,"The formula to the left puts the condfidence internal on the graph."]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"IF(E39=0,0,IF(E39=1,D69,IF(E39=2,N69,IF(E39=3,V69,IF(E39=4,D70,IF(E39=5,N70,IF(E39=6,V70,IF(E39=7,D71,IF(E39=8,N71,IF(E39=9,V71))))))))))","v":0},"The forumla to the left can be used to pick up the predicted scores and put in the cell graph based on level of difference, cell D57"]
[]
[]
[null,null,null,null,null,"Slightly Different",null,null,null,null,null,null,null,null,null,"Moderately Different",null,null,null,null,null,null,null,"Markedly Different"]
[null,null,null,"Gc","Gf","Gwm","Glr","Gv","Ga","Gs",null,null,null,"Gc","Gf","Gwm","Glr","Gv","Ga","Gs",null,"Gc","Gf","Gwm","Glr","Gv","Ga","Gs"]
[null,null,"WJ IV",81,93,89,86,94,88,94,null,"WJ IV",null,72,90,85,79,92,83,92,"WJ IV",66,86,80,73,88,77,88]
[null,null,"WISC-V",81,93,92,90,94,{"$f":"IF(AND(E39=4,H45>0),H45,0)","v":0},93,null,"WISC-V",null,72,90,88,86,92,{"$f":"IF(AND(E39=5,H45>0),H45,0)","v":0},90,"WISC-V",66,86,83,80,88,{"$f":"IF(AND(E39=6,H45>0),H45,0)","v":0},86]
[null,null,"KABC-II",81,91,92,94,93,{"$f":"IF(AND(E39=7,H46>0),H46,0)","v":0},{"$f":"IF(AND(E39=7,H47>0),H47,0)","v":0},null,"KABC-II",null,72,87,88,92,89,{"$f":"IF(AND(E39=8,H46>0),H46,0)","v":0},{"$f":"IF(AND(E39=8,H47>0),H47,0)","v":0},"KABC-II",66,83,83,88,85,{"$f":"IF(AND(E39=9,H46>0),H46,0)","v":0},{"$f":"IF(AND(E39=9,H47>0),H47,0)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null," =IF(AND(E63=4,H69>0),H69,0)"]
[null,null,null,null,null,null,null,null," =IF(AND(Something is True, Something else is True), Value if True, Value if False)"]

{"sheet":"D-SNAP Worksheet","index":1,"n_rows":182,"n_cols":56,"rows_kept":182,"cut":false,"hidden":false,"merged":[[172,14,180,21],[2,53,2,55],[2,23,2,24],[2,36,2,39],[7,4,7,40],[6,4,6,40]]}
[]
[]
[null,null,null,null,null,null,null,"Name:",{"$f":"Information!E11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"DOB:",{"$f":"Information!E13","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,"DOE:",{"$f":"Information!E14","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ID:",{"$f":"Information!E12","v":0}]
[]
[]
[]
[null,null,null,null,{"$f":"IF(Information!E39=0,\"D-SNAP Obtained and Expected CHC Broad Abilities\",IF(Information!E39=1,\"WJ IV D-SNAP Slightly Different Obtained and Expected CHC Broad Abilities\",IF(Information!E39=2,\"WJ IV D-SNAP Moderately Different Obtained and Expected CHC Broad Abilities\",IF(Information!E39=3,\"WJ IV D-SNAP Markedly Different Obtained and Expected CHC Broad Abilities\",IF(Information!E39=4,\"WISC-V D-SNAP Slightly Different Obtained and Expected CHC Broad Abilities\",IF(Information!E39=5,\"WISC-V D-SNAP Moderately Different Obtained and Expected CHC Broad Abilities\",IF(Information!E39=6,\"WISC-V D-SNAP Markedly Different Obtained and Expected CHC Broad Abilities\",IF(Information!E39=7,\"KABC-II D-SNAP Slightly Different Obtained and Expected CHC Broad Abilities\",IF(Information!E39=8,\"KABC-II D-SNAP Moderately Different Obtained and Expected CHC Broad Abilities\",IF(Information!E39=9,\"KABC-II D-SNAP Markedly Different Obtained and Expected CHC Broad Abilities\",\"\"))))))))))","v":"D-SNAP Obtained and Expected CHC Broad Abilities"}]
[null,null,null,null,{"$f":"Information!E60","v":"90% Confidence Interval"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Slightly Different",null,null,null,null,null,null,null,null,null,null,null,null,"Markedly Different"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Comprehension - Knowledge (Gc)","Fluid Reasoning (Gf)","Short-Term Working Memory (Gwm)","Long-Term Storage & Retrieval (Glr)","Visual Processing (Gv)","Auditory Processing (Ga)","Cognitive Processing Speed (Gs)","Average",null,null,null,null,null,"Comprehension - Knowledge (Gc)","Fluid Reasoning (Gf)","Short-Term Working Memory (Gwm)","Long-Term Storage & Retrieval (Glr)","Visual Processing (Gv)","Auditory Processing (Ga)","Cognitive Processing Speed (Gs)","Average",null,null,null,null,null,"Comprehension - Knowledge (Gc)","Fluid Reasoning (Gf)","Short-Term Working Memory (Gwm)","Long-Term Storage & Retrieval (Glr)","Visual Processing (Gv)","Auditory Processing (Ga)","Cognitive Processing Speed (Gs)","Average"]
[]
[]
[]
[]
[]
[]
[null,null,null,"SET ZOOM AT 27%"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"obt",null,"obt",null,"obt",null,"obt",null,"obt",null,"obt",null,"obt"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Obtained","Expected","Obtained","Expected","Obtained","Expected","Obtained","Expected","Obtained","Expected","Obtained","Expected","Obtained","Expected","."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Comprehension Knowledge (Gc)","Comprehension Knowledge (Gc)","Fluid Reasoning (Gf)","Fluid Reasoning (Gf)","Short-Term Working Memory (Gwm)","Short-Term Working Memory (Gwm)","Long-Term Storage & Retrieval (Glr)","Long-Term Storage & Retrieval (Glr)","Visual Processing (Gv)","Visual Processing (Gv)","Auditory Processing (Ga)","Auditory Processing (Ga)","Cognitive Processing Speed (Gs)","Cognitive Processing Speed (Gs)","National Average Range"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CI upper limit",{"$f":"Information!K24","v":0},{"$f":"AK122-(Information!I24-Information!K24)","v":0},{"$f":"Information!K25","v":0},{"$f":"AM122-(Information!I25-Information!K25)","v":0},{"$f":"Information!K26","v":0},{"$f":"AO122-(Information!I26-Information!K26)","v":0},{"$f":"Information!K27","v":0},{"$f":"AQ122-(Information!I27-Information!K27)","v":0},{"$f":"Information!K28","v":0},{"$f":"AS122-(Information!I28-Information!K28)","v":0},{"$f":"Information!K29","v":0},{"$f":"AU122-(Information!I29-Information!K29)","v":0},{"$f":"Information!K30","v":0},{"$f":"AW122-(Information!I30-Information!K30)","v":0},115]
[null,null,null,null,null,null,null,null,null,{"$f":"AQ122-(Information!J30-Information!I30)","v":0},"Formula to bring in confidence intervals to Expected scores",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Factor Score",{"$f":"Information!I24","v":0},{"$f":"Information!S24","v":0},{"$f":"Information!I25","v":0},{"$f":"Information!S25","v":0},{"$f":"Information!I26","v":0},{"$f":"Information!S26","v":0},{"$f":"Information!I27","v":0},{"$f":"Information!S27","v":0},{"$f":"Information!I28","v":0},{"$f":"Information!S28","v":0},{"$f":"Information!I29","v":0},{"$f":"Information!S29","v":0},{"$f":"Information!I30","v":0},{"$f":"Information!S30","v":0},100]
[null,null,null,null,null,null,null,null,null,null,"Confidence intervals based for Expected from obtained scores",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CI lower limit",{"$f":"Information!J24","v":0},{"$f":"AK122-(Information!I24-Information!J24)","v":0},{"$f":"Information!J25","v":0},{"$f":"AM122-(Information!I25-Information!J25)","v":0},{"$f":"Information!J26","v":0},{"$f":"AO122-(Information!I26-Information!J26)","v":0},{"$f":"Information!J27","v":0},{"$f":"AQ122-(Information!I27-Information!J27)","v":0},{"$f":"Information!J28","v":0},{"$f":"AS122-(Information!I28-Information!J28)","v":0},{"$f":"Information!J29","v":0},{"$f":"AU122-(Information!I29-Information!J29)","v":0},{"$f":"Information!J30","v":0},{"$f":"AW122-(Information!I30-Information!J30)","v":0},85]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gc","pre","Gf","pre","Gwm","pre","Glr","pre","Gv","pre","Ga","pre","Gs",null,"Average"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,2,null,3,null,6,null,7,null,5,null,4]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Red on White are the Expected cores, Black on Yellow are the obtained scores"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"© L. Pristo and S. Ortiz, 2024.  This document / spreadsheet and its contents are protected by copyright and other intellectual property rights. The copyright of the contents and materials, except for any third party information available, is owned by the authors.  You may not reproduce, disseminate, adapt, modify or incorporate in printed or electronic form, any parts of the contents or materials available in this document / spreadsheet without the prior written permission of the authors."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The current workbook is licensed to the Washington Elementary School District, Phoenix, Arizona. 2020-2021."]

{"sheet":"True Peer Estimator","index":2,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":false,"merged":[[10,5,10,15],[24,10,24,11],[27,6,27,14],[19,5,19,14],[20,5,20,14],[21,5,21,14],[22,5,22,14],[24,12,24,15],[11,5,11,14],[12,5,12,14],[13,5,13,14],[14,5,14,14],[15,5,15,14],[16,5,16,14],[17,5,17,14],[18,5,18,14],[1,5,1,15],[2,5,3,15],[4,5,5,15],[6,5,7,15],[8,5,9,15]]}
[]
[null,null,null,null,null,"Diverse True Peer Group Estimator (TPE) © 2024 Samuel O. Ortiz, Ph.D."]
[null,null,null,null,null,"This worksheet provides a simple, systematic method for collecting data and information that may be used to qualitatively estimate the extent to which differences in developmental experiences are likely to affect expectations of development and growth. Note that a student’s degree of difference is dynamic and may change over time. Three categories are used:"]
[]
[null,null,null,null,null,"A) Slightly Different. This category is characterized by differences in culture, language, and experiences that although not fully representative of the U.S. mainstream, have nevertheless been supported by high family SES, well-educated parents, formal elementary education in the heritage language, bilingual parents, etc.) and where opportunity for developing English language proficiency constitutes at least ½ or more of a student’s life. "]
[]
[null,null,null,null,null,"B) Moderately Different. This category is characterized by differences in culture, language, and experiences that are not representative of the U.S. mainstream and where few supporting factors are present (e.g., low family SES, parental lack of education, no formal education in the heritage language, parents with limited English proficiency, etc.) or where opportunity for developing English proficiency constitutes less than ½ of a student’s life. "]
[]
[null,null,null,null,null,"C) Markedly Different. This category is characterized by differences in culture, language, and experiences that includes at least one additional factor that is atypical, and which creates an adverse influence on development (e.g., poverty/homelessness, exposure to war, trauma, violence, abuse, neglect, immigrant experience, refugee status, chronic illness, etc.) or where opportunity for developing English proficiency constitutes less than 10% of a student’s life."]
[]
[null,null,null,null,null,"To what extent has or does the student('s) or the student's family('s)…?"]
[null,null,null,null,null,"1 -------------------- 2 -------------------- 3 -------------------- 4 -------------------- 5",null,null,null,null,null,null,null,null,null,"Rating"]
[null,null,null,null,null,"1. ...heritage or home culture match middle-class, mainstream U.S. values, traditions, and beliefs in supporting acquisition of school-based acculturative knowledge? "]
[null,null,null,null,null,"2. ...socio-economic status match middle-class, mainstream families in the U.S. in supporting development of school-based learning and academic skills?"]
[null,null,null,null,null,"3. ...heritage or home language match middle-class, mainstream, monolingual English-speakers in supporting the acquisition of school-based English?"]
[null,null,null,null,null,"4. …attended school consistently and sufficiently to provide an adequate opportunity for age or grade expected academic learning?"]
[null,null,null,null,null,"5. ...avoided any unusual or atypical developmental life experiences (e.g., frequent moves, immigration or migrant worker experience, refugee status, exposure to war, trauma, violence, neglect, abuse, etc.)?"]
[null,null,null,null,null,"6. …received formal education in their heritage language either while attending school in the U.S. or prior to coming to the U.S.?"]
[null,null,null,null,null,"7. ...been exposed to high level language models in English over their lifetime as compared to middle-class, monolingual English-speakers of the same age?"]
[null,null,null,null,null,"8. ...English language development match same-age/grade, middle-class, monolingual, English-speaking peers (including reading/writing, vocabulary, and aspects of speech)?"]
[null,null,null,null,null,"9. ...reside in a community where English is the dominant language and where cultural values and attitudes primarily reflect middle-class, mainstream U.S. values? "]
[null,null,null,null,null,"10. ...received support for any aspects of social/emotional development that may have interfered with school-based learning (e.g., mental health, self-identity, gender identification, sexual orientation, self-esteem, etc.)?"]
[null,null,null,null,null,"TRUE PEER GROUP CLASSIFICATION GUIDELINES:                                                                                                         TOTAL:",null,null,null,null,null,null,null,null,null,{"$f":"SUM(P13:P22)","v":0}]
[null,null,null,null,null,null,"10 – 20 = SLIGHTLY DIFFERENT      "]
[null,null,null,null,null,null,"21 – 39 = MODERATELY DIFFERENT      ",null,null,null,"CLASSIFICATION:  ",null,{"$f":"IF(AND(COUNT(P13:P22)>=1,COUNT(P13:P22)<10),\"DATA MISSING\",IF(AND(P23>=1,P23<10),\"NO DIFFERENCE\",IF(AND(P23>=10,P23<21),\"SLIGHTLY DIFFERENT\",IF(AND(P23>=21,P23<40),\"MODERATELY DIFFERENT\",IF(AND(P23>=40,P23<51),\"MARKEDLY DIFFERENT\",\"\")))))","v":""}]
[null,null,null,null,null,null,"40 – 50 = MARKEDLY DIFFERENT"]
[]
[null,null,null,null,null,null,"The Diverse True Peer Group Estimator (TPE) is Copyright © 2024 by Samuel O. Ortiz, Ph.D. and permission to use, copy, and disseminate is granted for educational, non-profit activities only."]

{"sheet":"Domain Calculator","index":3,"n_rows":64,"n_cols":11,"rows_kept":64,"cut":false,"hidden":false,"merged":[[1,3,1,18],[2,4,7,17],[18,4,18,17],[27,4,27,17],[28,4,28,17],[25,4,25,17],[59,4,60,14],[47,9,47,10],[46,4,46,17],[37,4,37,17],[29,4,29,17],[40,4,40,17],[38,4,38,17],[43,4,43,17],[33,4,33,17],[32,4,32,17],[35,4,35,17],[36,4,36,17]]}
[]
[null,null,null,"Non-Standard Domain and Confidence Interval Calculations"]
[null,null,null,null,"The confidence intervals used in D-SNAP for composites/indexes/clusters are derived directly from the battery as reported in the tests publisher's tables or scoring system. The intervals used for inclusion in D-SNAP are based on cohesive (unitary) domains. Supplemental testing may be necessary when a domain is not cohesive or not measured by the battery prior to being able to calculate a confidence interval. In the case of a composite/cluster/index from a domain not on the main test battery or created via alternative procedures (e.g., Cross-battery Assessment; XBA) the expected, and possibly obtained, scores must first be calculated in the following manner."]
[]
[]
[]
[]
[]
[null,null,null,null,"Determine or Calculate:"]
[null,null,null,null,"(1) the examinee's level of difference using the True Peer Group Estimator (D-STPGE) tab"]
[null,null,null,null,"(2) each subtest's Culture-Language Test Classification (C-LTC)"]
[null,null,null,null,"(3) the impact and degree of attenuation expected for each subtest based on the values provided in the \"General Guidelines…\" table"]
[null,null,null,null,"(4) the resulting value for each individual subtest score based on the degree of attenuation expected"]
[null,null,null,null,"(5) the expected - and obtained, if necessary - composite scores by use of X-BASS or other composite calculator"]
[null,null,null,null,"(6) the confidence intervals using a median SEM of 5 points (see below)"]
[null,null,null,null,"Then enter obtained scores and CI in the top cells of the Information tab and expected composite score in the bottom cell of the tab"]
[]
[null,null,null,null,"Establishing a confidence interval:"]
[null,null,null,null,"When a publisher’s confidence interval is not available for a domain as in the case of combined subtests from different batteries, you may use an SEM consisting of 5 points (based on a review of SEM values for various composites/clusters/indexes: Flanagan et al., (2013) determined that the median SEM value was 5 points). Use of a five point value for the SEM naturally provides a 68% CI. To increase the probability that the true score resides within a certain confidence interval is accomplished by multiplying the SEM by 1.645 (for a 90% CI) or by 1.96 (for a 95% CI). Those values are indicated below for convenience to assist in creating the desired confidence interval for use with D-SNAP. The values are as follows:"]
[]
[]
[null,null,null,null,"For a 68% CI, use plus and minus 5 points (1.00 x 5 = 5.00)"]
[null,null,null,null,"For a 90% CI, use plus and minus 8 points (1.645 x 5 = 8.225, rounded to 8)"]
[null,null,null,null,"For a 95% CI, use plus and minus 10 points (1.96 x 5 = 9.800, rounded to 10)"]
[]
[null,null,null,null,"Obtained scores for any of the broad domains, regardless of how they were obtained, should be entered in the corresponding cells at the top of the Information tab where the seven broad ability domains are listed (clusters, step 2). Entering the desired confidence interval limits is also necessary as they may have been calculated using the guidance provided in the previous step. However, the graph will not provide a comparison for the expected level of performance unless you also enter a expected value at the bottom of the Information tab in the indicated cells (step 5). For example, if you adminster the WISC-V and want to include a measure of auditory processing, you will need to enter the obtained values in the upper cell under Ga, and then enter an expected value for Ga next to the WISC-V in the lower cell at the bottom of the tab. "]
[null,null,null,null,"Example:"]
[null,null,null,null,"A student was given a WISC-V. However, because neither the WISC (or KABC) measure auditory processing, adminstering additional tests is necessary to provide a measure of the domain. In this case, the subtests that form the Ga cluster from the WJ IV were used as a supplement. The subtests include WJ IV COG Phonoloogical Processing and WJ IV COG Nonword Repetition. Scoring the results according to the publisher's instructions reveals that the student obtained a SS=83 on the Phonological Processing subtest and a SS=85 on the Nonword Repetition subtest which generated an Auditory Processing (Ga) composite of SS=81. To obtain the expected composite score and the expected 90% confidence interval, the following steps were taken:"]
[]
[null,null,null,null,"1. Using the True Peer Estimator tab (yellow), the standalone D-STPGE, to determine the degree of difference the examinee obtained a score of 31 and was determined to be \"moderately different.\""]
[]
[]
[]
[null,null,null,null,"2. According to the C-LTC, the Phonological Processing subtest is in the \"High Language/Moderate Culture\" cell (cell #6), and Nonword Repetition is in the \"Moderate Language/Moderate Culture\" cell (cell #5)."]
[]
[]
[null,null,null,null,"3. According to the \"General Guidelines for Expected Patterns of Test Performance for Diverse Individuals,\" the degree or magnitude of impact on test performance for WJ IV Phonological Processing, as with all subtests classified as \"High Language/Moderate Culture,\" and for an examinee who is \"moderately different,\" is indicated as 15-20 points with a midpoint that is 17.5 points below the mean of 100. For WJ IV Nonword Repetition, a subtest classified as \"Moderate Language/Moderate Culture,\" the degree or magnitude of impact on test performance for an examinee who is \"moderately different\" is 10-15 points, midpoint which is 12.5 points below the mean of 100."]
[]
[]
[]
[null,null,null,null,"4. The expected value for each subtest is obtained by subtracting the degree of impact from the mean value for the test (i.e., SS=100). Thus, for the WJ IV Phonological Processing subtest, the expected value would be 100 - 17.5 = 82.5, rounded to 83. For the WJ IV Nonword Repetition subtest, the expected value would be 100 - 12.5 = 87.5, rounded to 88.\n\nTo create the expected composite score for the domain, the expected subtest values must be combined into a single score. This is accomplished via the XBA Analyzer in X-BASS or through some other composite calculato.  Tthe resulting value for this example using SS=83 and SS=88, is SS=83. \n\nNote: The WJ IV already provides a composite score based on the actual performance of the examinee on these two subtests noted at the beginning (e.g., SS=81). That value is entered in D-SNAP as the obtained composite score in the cell at the top of the Information tab. However, if the two subtests could not be combined after administration and scoring because they came from different batteries or there was no norm-referenced composite available from their respective publisher(s) of the subtests, the actual subtest values obtained via testing may be combined using the XBA Analyzer in X-BASS to create the necessary obtained composite score for entry into D-SNAP and the confidence interval for the obtained composite score can be calculated using Step 5 in the same way as it is used (automatically) for determining the confidence interval for the expected composite score."]
[]
[]
[null,null,null,null,"5. Because supplemental testing in the Auditory Processing (Ga) domain was accomplished with the WJ IV COG battery using the two subtests that are typically used to create the expected composite score, the upper and lower limits of the confidence interval are readily available in a table or the score report provided by the publisher. Thus, using the SEM value for Auditory Processing (Ga) from the test publisher's table which corresponds to a 90% band, we can now calculate the lower limit of the expected composite score as being 6 points less than the SS=83 (which was derived in Step 4) and the upper limit as being 7 points more than SS=83, or simply a range that spans from SS=77-90. Note, however, that in this case, it is not necessary to make the calculations for the CI as simply entering the expected composite score will result in D-SNAP automatically making the calculations and displaying the 90% CI accordingly.\n\nHowever, in cases where there are no norm-based composites available from the pubisher(s) of the subtests that were administered, it will mean that the SEM and CI are unknown. To remedy this situation, a CI can be determined by adding and subtracting a median SEM value to the expected composite score (and obtained composite score, as may be necessary) of 5 points. Whereas the actual CI for both the expected and obtained composistes were available in this case from the publisher of the WJ IV COG, this is not always true and sometimes both the obtained composite score and the corresponding CI must be calculated by hand. For example, using the XBA Analyzer in X-BASS, the subtest values of SS=83 and SS=85 as drawn from any other battery, would produce an obtained composite score of SS=81 as shown below. Next, a 90% CI can be established by adding and subtracting the median SEM value of 5 points to the value of the obtained composite score. This would result in a confidence band ranging from 81 - 5 = 76 to 81 + 5 = 86, or 76-86. Because the WJ IV COG already provides these values, however, they did not need to be calculated in this case. Nonetheless, these values compare favorably to the actual 90% CI reported in the WJ IV Table of Scores (i.e., 83 - 6 = 77 to 83 + 6 = 89, or 77-89)."]
[]
[]
[null,null,null,null,"6. Obtained composite scores for any of the broad domains, regardless of how they were established, should be entered in the corresponding cells at the top of the Information tab where the seven broad ability domains are listed. It is necessary to also enter the desired confidence interval limits for obtained composite scores, if calculated, using the guidance provided in the previous steps. However, the graph will not provide a comparison for the expected level of performance unless you also enter an expected composite score generated via the previous steps in the cell at the bottom of the Information tab. Because the student was given the WISC-V, her obtained composite score (SS=81) was entered into the top cells along with the 90% CI that was determined by the WJ IV Table of Scores (SS= 75-88). Next, her expected composite score (SS=83) was entered into the corresponding WISC-V Ga cell at the bottom of the tab. "]
[null,null,null,null,"Clusters",null,null,null,"% CI =",90]
[null,null,null,null,null,null,null,null,"SS","-1 CI","+1 CI"]
[null,null,null,null,"Comprehension - Knowledge (Gc)",null,null,null,76,70,83]
[null,null,null,null,"Fluid Reasoning (Gf)",null,null,null,80,74,86]
[null,null,null,null,"Short-Term, Working Memory (Gwm)",null,null,null,79,70,87]
[null,null,null,null,"Long-Term Retrieval (Glr)"]
[null,null,null,null,"Visual Processing (Gv)",null,null,null,89,80,99]
[null,null,null,null,"Auditory Processing (Ga)",null,null,null,81,75,88]
[null,null,null,null,"Cognitive Processing Speed (Gs)",null,null,null,99,91,107]
[]
[]
[]
[null,null,null,null,"If you have an expected value for a broad factor not represented by one of the base tests, enter the value corresponding to the assessment and missing factor below."]
[]
[null,null,null,null,"WISC-V","Ga",83]
[null,null,null,null,"KABC-II","Ga"]
[null,null,null,null,"KABC-II","Gs"]