{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["e-SSW Instructions","e-Strand Scoring Worksheet ","Performance Level Ratings","Class Record"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"e-SSW Instructions","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"e-Strand Scoring Worksheet ","index":1,"n_rows":71,"n_cols":4,"rows_kept":71,"cut":false,"hidden":false,"merged":[[46,0,46,3],[47,3,48,3],[11,1,16,2],[11,3,16,3],[28,1,28,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[38,0,38,3],[7,1,7,3],[9,1,9,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[6,1,6,3]]}
["GDO-R E-Strand Scoring Worksheet (E-SSW)"]
[]
["Student Summary Scores"]
["Student's Name","Blake"]
["Student's Chronological Age Band","<Enter>"]
["Strand B Scaled Score",{"$f":"D29","v":0}]
["Strand C Scaled Score ",{"$f":"D35","v":0}]
["Strand D Scaled Score ",{"$f":"D43","v":0}]
[]
[null,"RAW SCORE",null,"SCALED SCORE"]
["STRAND A  Developmental"]
["Cubes","See Chapter 4 in Examiner’s Manual for  scoring Developmental Age in Task Chapters "]
["Copy Forms"]
["Incomplete Person"]
["Fine Motor"]
["Gross Motor"]
["Overt Behavior"]
["STRAND B  Letters/Numbers"]
["Writing Name  (out of 3) \n0=no letters\n1=just letters\n2=first name\n3=first and last name",0,{"$f":"\"/ 3 X 100 =\"","v":"/ 3 X 100 ="},{"$f":"IF(ISBLANK(B19),\"\",IF(B19>3,$B$59,B19/3*100))","v":0}]
["Writing Numbers (max 20)\nNote: Must have 2 numbers written to evaluate a sequence\nTotal # written ",0,{"$f":"\"/ 20 X 100 =\"","v":"/ 20 X 100 ="},{"$f":"IF(ISBLANK(B20),\"\",IF(B20>20,$B$59,B20/20*100))","v":0}]
["Total # written in sequence ",0,"/ 20 X 100 =",0]
["Digit Repetition  (out of 12)\n1 pt for each digit set correctly repeated",0,{"$f":"\"/ 12 X 100 =\"","v":"/ 12 X 100 ="},{"$f":"IF(ISBLANK(B22),\"\",IF(B22>12,$B$59,B22/12*100))","v":0}]
["Identifying Letters (out of 26)\n1 pt for each number correctly identified  ",0,{"$f":"\"/ 26 X 100 =\"","v":"/ 26 X 100 ="},{"$f":"IF(ISBLANK(B23),\"\",IF(B23>26,$B$59,B23/26*100))","v":0}]
["Identifying Numbers   (out of 12)\n1 pt for each number correctly identified",0,{"$f":"\"/ 12 X 100 =\"","v":"/ 12 X 100 ="},{"$f":"IF(ISBLANK(B24),\"\",IF(B24>12,$B$59,B24/12*100))","v":0}]
["Counting (out of 40)\nHow high did the child count? ",0,{"$f":"\"/ 40 X 100 =\"","v":"/ 40 X 100 ="},{"$f":"IF(ISBLANK(B25),\"\",IF(B25>40,$B$59,B25/40*100))","v":0}]
["One-to-One Correspondence and Conservation (out of 8)\n1 pt for each One-to-One (how many?) item correct\n1 pt for each Conservation (altogether?) item correct",0,{"$f":"\"/ 8 X 100 =\"","v":"/ 8 X 100 ="},{"$f":"IF(ISBLANK(B26),\"\",IF(B26>8,$B$59,B26/8*100))","v":0}]
["Calculations (out of 14)\n2 pts for each item correct without pennies\n1 pt for each item correct with pennies ",0,{"$f":"\"/ 14 X 100 =\"","v":"/ 14 X 100 ="},{"$f":"IF(ISBLANK(B27),\"\",IF(B27>14,$B$59,B27/14*100))","v":0}]
[]
[null,"STRAND B Scaled Score:",null,{"$f":"IF(C55>0,$B$59,IF(B55=9,IFERROR(AVERAGE(D19:D27),\"\"),$B$58))","v":0}]
["STRAND C  Language/Comprehension"]
["Naming Animals  (out of 60) \n1 pt for each animal named",0,{"$f":"\"/ 60 X 100 =\"","v":"/ 60 X 100 ="},{"$f":"IF(ISBLANK(B31),\"\",IF(B31>60,$B$59,B31/60*100))","v":0}]
["Prepositions  (out of 5)\n1 pt for each item correct",0,{"$f":"\"/ 5 X 100 =\"","v":"/ 5 X 100 ="},{"$f":"IF(ISBLANK(B32),\"\",IF(B32>5,$B$59,B32/5*100))","v":0}]
["Comprehension Questions  (out of 5)\n1 pt for each item correct",0,"/ 5 X 100 =",0]
["Action Agents  (out of 20)\n1 pt for each item correct",0,{"$f":"\"/ 20 X 100 =\"","v":"/ 20 X 100 ="},{"$f":"IF(ISBLANK(B34),\"\",IF(B34>20,$B$59,B34/20*100))","v":0}]
[null,"STRAND C Scaled Score:",null,{"$f":"IF(C56>0,$B$59,IF(B56=4,IFERROR(AVERAGE(D31:D34),\"\"),$B$58))","v":0}]
["Interview/Language","See Language Rubric"]
["Interests","See Language Rubric"]
[]
["STRAND D  Visual/Spatial Discrimination"]
["Visual I  (out of 12) \n1 pt for each item correct\nDO NOT include item #1 (teaching item in the score)  \nDO include the \"Skip\" as an item on the task",0,{"$f":"\"/ 12 X 100 =\"","v":"/ 12 X 100 ="},{"$f":"IF(ISBLANK(B40),\"\",IF(B40>12,$B$59,B40/12*100))","v":0}]
["Color Forms  (out of 5) \n1 pt for each shape correctly matched",0,{"$f":"\"/ 5 X 100 =\"","v":"/ 5 X 100 ="},{"$f":"IF(ISBLANK(B41),\"\",IF(B41>5,$B$59,B41/5*100))","v":0}]
["Three-Hole Form Board  (out of 8) \n2 pts for each presentation correctly completed\n1 pt for each presentation correctly complete with\n       TRIAL and ERROR method",0,{"$f":"\"/ 8 X 100 =\"","v":"/ 8 X 100 ="},{"$f":"IF(ISBLANK(B42),\"\",IF(B42>8,$B$59,B42/8*100))","v":0}]
[null,"STRAND D Scaled Score:",null,{"$f":"IF(C57>0,$B$59,IF(B57=3,IFERROR(AVERAGE(D40:D42),\"\"),$B$58))","v":0}]
["Right/Left","See Right/Left Scoring Rubric"]
["Visual III","See Visual III Scoring Rubric"]
[]
["STRAND E  Social-Emotional/Adaptive "]
["Social/Emotional Development","PQ Total SE: ","TQ Total SE: ","See Strand E Interpretation Notes in Social-Emotional-Adaptive Task Chapter"]
["Adaptive Skills","PQ Total A: ","TQ Total A: "]
[]
[]
[]
[]
["Hidden formula for Average Calculation"]
["Strand B",{"$f":"COUNT(B19:B27)","v":9},{"$f":"COUNTIF(D19:D27,B59)","v":0}]
["Strand C",{"$f":"COUNT(B31:B34)","v":4},{"$f":"COUNTIF(D31:D34,B59)","v":0}]
["Strand D",{"$f":"COUNT(B40:B42)","v":3},{"$f":"COUNTIF(D40:D42,B59)","v":0}]
["Text for incomplete error ","Error - Enter scores for all tasks"]
["Text for range error","Error - score is out of range"]
[]
["For Age Band Drop Down Menu"]
["<Enter>"]
["2 years 9 months and 0 days – 3 years 2 months and 29 days","Age 3"]
["3 years 3 months and 0 days – 3 years 8 months and 29 days","Age 36"]
["3 years 9 months and 0 days – 4 years 2 months and 29 days","Age 4"]
["4 years 3 months and 0 days – 4 years 8 months and 29 days","Age 46"]
["4 years 9 months and 0 days – 5 years 2 months and 29 days","Age 5"]
["5 years 3 months and 0 days – 5 years 8 months and 29 days","Age 56"]
["5 years 9 months and 0 days – 6 years 2 months and 29 days","Age 6"]
["Result"]
[{"$f":"B5","v":"<Enter>"},{"$f":"VLOOKUP(A71,'e-Strand Scoring Worksheet '!A63:B69,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Performance Level Ratings","index":2,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[21,1,21,4],[22,1,22,4],[22,5,22,7],[18,1,18,4],[18,5,18,7],[19,1,19,4],[19,5,19,7],[20,1,20,4],[20,5,20,7],[21,5,21,7]]}
["GDO-R Strand Performance Level Ratings"]
[null,"Student's Chronological Age Band from SSW"]
[]
["STRAND B","Age 3","Age 36","Age 4","Age 46","Age 5","Age 56","Age 6"]
["Concern","0-2","0-4","0-7","0-18","0-38","0-48","0-64"]
["Emerging","3-8","5-10","8-22","19-40","39-63","49-74","65-85"]
["Age\nAppropriate","9-100","11-100","23-100","41-100","64-100","75-100","86-100"]
[]
["STRAND C","Age 3","Age 36","Age 4","Age 46","Age 5","Age 56","Age 6"]
["Concern","0-9","0-16","0-23","0-32","0-46","0-56","0-61"]
["Emerging","10-19","17-36","24-47","33-63","47-66","57-69","62-73"]
["Age\nAppropriate","20-100","37-100","48-100","64-100","67-100","70-100","74-100"]
[]
["STRAND D","Age 3","Age 36","Age 4","Age 46","Age 5","Age 56","Age 6"]
["Concern","0-56","0-61","0-64","0-67","0-76","0-81","0-83"]
["Emerging","54-74","62-74","65-75","68-82","77-90","82-92","84-93"]
["Age\nAppropriate","75-100","75-100","76-100","83-100","91-100","93-100","94-100"]
[]
["PQ and TQ Scores for STRAND E","Interpretation",null,null,null,"Performance Level Score"]
["0-1","Child is below expectations",null,null,null,"Child is below expectations"]
["1-2","Child is progressing toward expectations",null,null,null,"Emerging"]
["2-3","Child is meeting expectations",null,null,null,"Age Appropriate"]
["4-5","Child is consistently exceeding expectations",null,null,null,"Age Appropriate"]

{"sheet":"Class Record","index":3,"n_rows":83,"n_cols":21,"rows_kept":83,"cut":false,"hidden":false,"merged":[]}
["Last Name of Student","First Name of Student","Chronological Age (CA)","GDO Age Band","Strand A Dev. Age","Strand A Perf. Level","Strand B score","Strand B Perf. Level","Strand C score","Strand C Perf. Level","Strand D score","Strand D Perf. Level","TQ SE Score","TQ SE Perf. Level","TQ Adaptive Score","TQ Adaptive Perf. Level","PQ SE Score","PQ SE Perf. Level","PQ Adaptive Score","PQ Adaptive Perf. Level","GDO-R Overall Perf. Level Rating"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Child Age Band","Strand A Dev. Age","Strand A Performance Level"]
["Enter Age Band",3,"Age Appropriate","Enter Age Band"]
["2 years 9 months and 0 days – 3 years 2 months and 29 days",3.5,"Emerging","2 years 9 months and 0 days – 3 years 2 months and 29 days"]
["3 years 3 months and 0 days – 3 years 8 months and 29 days",4,"Concern","3 years 3 months and 0 days – 3 years 8 months and 29 days"]
["3 years 9 months and 0 days – 4 years 2 months and 29 days",4.5,null,"3 years 9 months and 0 days – 4 years 2 months and 29 days"]
["4 years 3 months and 0 days – 4 years 8 months and 29 days",5,null,"4 years 3 months and 0 days – 4 years 8 months and 29 days"]
["4 years 9 months and 0 days – 5 years 2 months and 29 days",5.5,null,"4 years 9 months and 0 days – 5 years 2 months and 29 days"]
["5 years 3 months and 0 days – 5 years 8 months and 29 days",6,null,"5 years 3 months and 0 days – 5 years 8 months and 29 days"]
["5 years 9 months and 0 days – 6 years 2 months and 29 days",null,null,"5 years 9 months and 0 days – 6 years 2 months and 29 days"]
["Strand B Per. Level","Strand C Perf. Level","Strand D Perf. Level"]
["Age Appropriate","Age Appropriate","Age Appropriate"]
["Emerging","Emerging","Emerging"]
["Concern","Concern","Concern"]
[]
["TQ Social score","TQ Emotional score","TQ Adaptive Score"]
[1,1,1]
[2,2,2]
[3,3,3]
[4,4,4]
[5,5,5]
[]
["TQ Social Perf. Level","TQ Emotional Perf. Level","TQ Adaptive Perf. Level"]
["Age Appropriate","Age Appropriate","Age Appropriate"]
["Emerging","Emerging","Emerging"]
["Concern","Concern","Concern"]