{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Data Entry","Score Sheet","Vocabulary and Meaning","Reading Comprehension","Look Up tables"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Data Entry","index":0,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["ABE Reading Diagnostic Test - Form T"]
["Student's Name"]
["Student's ID"]
["Date of Birth"]
["Date Tested"]
["Site ID"]
["Proctor"]
["Enter below the Raw Score for each of the strands ","Raw Scores"]
["Vocabulary and Meaning"]
["Reading Comprehension"]
["Total Raw Score (will calculate automatically)",{"$f":"SUM(B9:B10)","v":0}]

{"sheet":"Score Sheet","index":1,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,1,1,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[1,4,1,5],[3,4,3,5],[2,4,2,5],[4,4,4,5]]}
["ABE Diagnostic Score Report - Reading - Form T"]
[{"$f":"'Data Entry'!A2","v":"Student's Name"},"Date of Birth",null,null,"Site ID"]
[{"$f":"'Data Entry'!B2","v":0},{"$f":"'Data Entry'!B4","v":"00:00:00"},null,null,{"$f":"'Data Entry'!B6","v":0}]
[{"$f":"'Data Entry'!A3","v":"Student's ID"},"Date Tested",null,null,"Proctor"]
[{"$f":"'Data Entry'!B3","v":0},{"$f":"'Data Entry'!B5","v":"00:00:00"},null,null,{"$f":"'Data Entry'!B7","v":0}]
[null,"Raw Score","Scaled Score"]
["Placement Score",{"$f":"'Data Entry'!B11","v":0},{"$f":"LOOKUP(B7,'Look Up tables'!A3:B63)","v":1}]
["Strands","Raw Score","Scaled            Score","Category                Score","Category Description","Proficiency Statements"]
["Vocabulary and Meaning",{"$f":"'Data Entry'!B9","v":0},{"$f":"LOOKUP(B9,'Look Up tables'!D4:E27)","v":1},{"$f":"LOOKUP(C9,'Look Up tables'!G4:H18)","v":1},{"$f":"LOOKUP(D9,'Look Up tables'!D32:E34)","v":"Needs Improvement"},{"$f":"VLOOKUP(C7&D9,'Vocabulary and Meaning'!A:E,5,FALSE)","v":"Your performance in the Vocabulary and Meaning area suggests that you need to improve significantly in this area. This area tests your knowledge and application of vocabulary, up to and including college-level. You need to work extensively on increasing basic sight vocabulary and recognizing basic signs, symbols, letters, numbers, and common abbreviations."}]
["Reading Comprehension",{"$f":"'Data Entry'!B10","v":0},{"$f":"LOOKUP(B10,'Look Up tables'!J4:K27)","v":1},{"$f":"LOOKUP(C10,'Look Up tables'!M4:N18)","v":1},{"$f":"LOOKUP(D10,'Look Up tables'!D32:E34)","v":"Needs Improvement"},{"$f":"VLOOKUP(C7&D10,'Reading Comprehension'!A:E,5,FALSE)","v":"Your performance in the Comprehension area suggests that you need to improve significantly in this area. This area tests your ability to understand text. You need to work extensively on identifying the topic and locating clearly stated data in simple text, and decoding basic visual information."}]

{"sheet":"Vocabulary and Meaning","index":2,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["Concatenate","Placement Score","Strand Category","Strand Category","Vocabulary and Meaning"]
[{"$f":"CONCATENATE(B2,D2)","v":"11"},1,"Needs Improvement",1,"Your performance in the Vocabulary and Meaning area suggests that you need to improve significantly in this area. This area tests your knowledge and application of vocabulary, up to and including college-level. You need to work extensively on increasing basic sight vocabulary and recognizing basic signs, symbols, letters, numbers, and common abbreviations."]
[{"$f":"CONCATENATE(B3,D3)","v":"12"},1,"Limited Proficiency",2,"Your performance in the Vocabulary and Meaning area suggests that while you have some skill in this area, there is room for improvement. This area tests your knowledge and application of vocabulary, up to and including college-level. You need to focus on increasing basic sight vocabulary and recognizing basic signs, symbols, letters, numbers, and common abbreviations."]
["13",1,"Proficient",3,"Your performance in the Vocabulary and Meaning area suggests that you have well-developed skills. This area tests your knowledge and application of vocabulary, up to and including college-level.  Your performance demonstrates the ability to use basic sight vocabulary and recognize basic signs, symbols, letters, numbers, and common abbreviations."]
["21",2,"Needs Improvement",1,"Your performance in the Vocabulary and Meaning area suggests that you need to improve significantly in this area. This area tests your knowledge and application of vocabulary, up to and including college-level. You need to work extensively on increasing basic sight vocabulary and recognizing basic signs, symbols, letters, numbers, and common abbreviations."]
["22",2,"Limited Proficiency",2,"Your performance in the Vocabulary and Meaning area suggests that while you have some skill in this area, there is room for improvement. This area tests your knowledge and application of vocabulary, up to and including college-level. You need to focus on increasing basic sight vocabulary and recognizing basic signs, symbols, letters, numbers, and common abbreviations."]
["23",2,"Proficient",3,"Your performance in the Vocabulary and Meaning area suggests that you have well-developed skills. This area tests your knowledge and application of vocabulary, up to and including college-level.  Your performance demonstrates the ability to use basic sight vocabulary and recognize basic signs, symbols, letters, numbers, and common abbreviations."]
["31",3,"Needs Improvement",1,"Your performance in the Vocabulary and Meaning area suggests that you need to improve significantly in this area. This area tests your knowledge and application of vocabulary, up to and including college-level. You need to work extensively on finding meaning from unfamiliar words using context clues or prefixes/suffixes, recognizing and identifying word relationships, basic abbreviations, symbols, and contractions in context, and using basic sight vocabulary."]
["32",3,"Limited Proficiency",2,"Your performance in the Vocabulary and Meaning area suggests that while you have some skill in this area, there is room for improvement. This area tests your knowledge and application of vocabulary, up to and including college-level. You need to focus on finding meaning from unfamiliar words using context clues or prefixes/suffixes, recognizing and identifying word relationships, basic abbreviations, symbols, and contractions in context, and using basic sight vocabulary."]
["33",3,"Proficient",3,"Your performance in the Vocabulary and Meaning area suggests that you have well-developed skills. This area tests your knowledge and application of vocabulary, up to and including college-level. Your performance demonstrates the ability to find meaning from some unfamiliar words using context clues or prefixes/suffixes; to recognize and identify some word relationships, basic abbreviations, symbols, and contractions in context; and to use basic sight vocabulary."]
["41",4,"Needs Improvement",1,"Your performance in the Vocabulary and Meaning area suggests that you need to improve significantly in this area. This area tests your knowledge and application of vocabulary, up to and including college-level. You need to work extensively on finding meaning from unfamiliar words using context clues or prefixes/suffixes, recognizing and identifying word relationships, basic abbreviations, symbols, and contractions in context, and using basic sight vocabulary."]
["42",4,"Limited Proficiency",2,"Your performance in the Vocabulary and Meaning area suggests that while you have some skill in this area, there is room for improvement. This area tests your knowledge and application of vocabulary, up to and including college-level. You need to focus on finding meaning from unfamiliar words using context clues or prefixes/suffixes, recognizing and identifying word relationships, basic abbreviations, symbols, and contractions in context, and using basic sight vocabulary."]
["43",4,"Proficient",3,"Your performance in the Vocabulary and Meaning area suggests that you have well-developed skills. This area tests your knowledge and application of vocabulary, up to and including college-level. Your performance demonstrates the ability to find meaning from some unfamiliar words using context clues or prefixes/suffixes; to recognize and identify some word relationships, basic abbreviations, symbols, and contractions in context; and to use basic sight vocabulary."]
["51",5,"Needs Improvement",1,"Your performance in the Vocabulary and Meaning area suggests that you need to improve significantly in this area. This area tests your knowledge and application of vocabulary, up to and including college-level. You need to work on expanding and understanding vocabulary and your ability to determine meaning based on context clues and/or use of prefixes and suffixes, as well as recognition of abbreviations, contractions, and symbols. "]
["52",5,"Limited Proficiency",2,"Your performance in the Vocabulary and Meaning area suggests that while you have some skill in this area, there is room for improvement. This area tests your knowledge and application of vocabulary, up to and including college-level. You need to work on further expansion and understanding of vocabulary and your ability to determine meaning based on context clues and/or use of prefixes and suffixes, as well as recognition of abbreviations, contractions, and symbols."]
["53",5,"Proficient",3,"Your performance in the Vocabulary and Meaning area suggests that you have well-developed skills. This area tests your knowledge and application of vocabulary, up to and including college-level. The questions in this area also test your ability to determine meaning based on context clues and/or use of prefixes and suffixes, as well as recognition of abbreviations, contractions, and symbols."]
["61",6,"Needs Improvement",1,"Your performance in the Vocabulary and Meaning area suggests that you need to improve significantly in this area. This area tests your knowledge and application of vocabulary, up to and including college-level. You need to work on expanding and understanding vocabulary and your ability to determine meaning based on context clues and/or use of prefixes and suffixes, as well as recognition of abbreviations, contractions, and symbols. "]
["62",6,"Limited Proficiency",2,"Your performance in the Vocabulary and Meaning area suggests that while you have some skill in this area, there is room for improvement. This area tests your knowledge and application of vocabulary, up to and including college-level. You need to work on further expansion and understanding of vocabulary and your ability to determine meaning based on context clues and/or use of prefixes and suffixes, as well as recognition of abbreviations, contractions, and symbols."]
["63",6,"Proficient",3,"Your performance in the Vocabulary and Meaning area suggests that you have well-developed skills. This area tests your knowledge and application of vocabulary, up to and including college-level. The questions in this area also test your ability to determine meaning based on context clues and/or use of prefixes and suffixes, as well as recognition of abbreviations, contractions, and symbols."]

{"sheet":"Reading Comprehension","index":3,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["Concatenate","Placement Score","Strand Category","Strand Category","Reading Comprehension"]
[{"$f":"CONCATENATE(B2,D2)","v":"11"},1,"Needs Improvement",1,"Your performance in the Comprehension area suggests that you need to improve significantly in this area. This area tests your ability to understand text. You need to work extensively on identifying the topic and locating clearly stated data in simple text, and decoding basic visual information."]
[{"$f":"CONCATENATE(B3,D3)","v":"12"},1,"Limited Proficiency",2,"Your performance in the Comprehension area suggests that while you have some skill in this area, there is room for improvement. This area tests your ability to understand text. You need to focus on identifying the topic and locating clearly stated data in simple text, and decoding basic visual information."]
["13",1,"Proficient",3,"Your performance in the Comprehension area suggests that you have well-developed skills. This area tests your ability to understand text. Your performance demonstrates the ability to identify the topic and locate clearly stated data in simple text, and decode basic visual information."]
["21",2,"Needs Improvement",1,"Your performance in the Comprehension area suggests that you need to improve significantly in this area. This area tests your ability to understand text. You need to work extensively on identifying the topic and locating clearly stated data in simple text, and decoding basic visual information."]
["22",2,"Limited Proficiency",2,"Your performance in the Comprehension area suggests that while you have some skill in this area, there is room for improvement. This area tests your ability to understand text. You need to focus on identifying the topic and locating clearly stated data in simple text, and decoding basic visual information."]
["23",2,"Proficient",3,"Your performance in the Comprehension area suggests that you have well-developed skills. This area tests your ability to understand text. Your performance demonstrates the ability to identify the topic and locate clearly stated data in simple text, and decode basic visual information."]
["31",3,"Needs Improvement",1,"Your performance in the Comprehension area suggests that you need to improve significantly in this area. This area tests your ability to understand text. You need to work extensively on identifying stated main ideas and some supporting details, and determining author’s purpose; locating and interpreting data in simple visual information; making basic inferences and drawing basic conclusions; and recognizing organizational patterns and figurative language."]
["32",3,"Limited Proficiency",2,"Your performance in the Comprehension area suggests that while you have some skill in this area, there is room for improvement. This area tests your ability to understand text. You need to focus on identifying stated main ideas and supporting details, and determining author’s purpose; locating and interpreting data in simple visual information; making basic inferences and drawing basic conclusions; and recognizing organizational patterns and figurative language."]
["33",3,"Proficient",3,"Your performance in the Comprehension area suggests that you have well-developed skills. This area tests your ability to understand text by identifying stated main ideas and some supporting details, and occasionally determine author’s purpose; to locate and interpret data in simple text, graph, charts, and tables; to make basic inferences and draw basic conclusions; and to recognize some organizational patterns and some figurative language."]
["41",4,"Needs Improvement",1,"Your performance in the Comprehension area suggests that you need to improve significantly in this area. This area tests your ability to understand text. You need to work extensively on identifying stated main ideas and some supporting details, and determining author’s purpose; locating and interpreting data in simple visual information; making basic inferences and drawing basic conclusions; and recognizing organizational patterns and figurative language."]
["42",4,"Limited Proficiency",2,"Your performance in the Comprehension area suggests that while you have some skill in this area, there is room for improvement. This area tests your ability to understand text. You need to focus on identifying stated main ideas and supporting details, and determining author’s purpose; locating and interpreting data in simple visual information; making basic inferences and drawing basic conclusions; and recognizing organizational patterns and figurative language."]
["43",4,"Proficient",3,"Your performance in the Comprehension area suggests that you have well-developed skills. This area tests your ability to understand text by identifying stated main ideas and some supporting details, and occasionally determine author’s purpose; to locate and interpret data in simple text, graph, charts, and tables; to make basic inferences and draw basic conclusions; and to recognize some organizational patterns and some figurative language."]
["51",5,"Needs Improvement",1,"Your performance in the Comprehension area suggests that you need to improve significantly in this area. This area tests your ability to understand text. You need to work extensively on identifying stated and implied main ideas, supporting details, and identifying author’s purpose and tone. You should also focus on analyzing text using graphs, charts, and tables, as well as making inferences and drawing conclusions, identifying organizational patterns, and interpreting figurative language."]
["52",5,"Limited Proficiency",2,"Your performance in the Comprehension area suggests that while you have some skill in this area, there is room for improvement. This area tests your ability to understand text. You need to focus on identifying stated and implied main ideas, supporting details, and identifying author’s purpose and tone. You should also focus on analyzing visual elements, as well as making inferences and drawing conclusions, identifying organizational patterns, and interpreting figurative language."]
["53",5,"Proficient",3,"Your performance in the Comprehension area suggests that you have well-developed skills. This area tests your ability to understand text by identifying stated and implied main ideas, supporting details, and author’s purpose and tone. The questions in this area also test your ability to analyze text using graphs, charts, and tables, as well as make inferences and draw conclusions, identify organizational patterns, and interpret figurative language."]
["61",6,"Needs Improvement",1,"Your performance in the Comprehension area suggests that you need to improve significantly in this area. This area tests your ability to understand text. You need to work extensively on identifying stated and implied main ideas, supporting details, and identifying author’s purpose and tone. You should also focus on analyzing text using graphs, charts, and tables, as well as making inferences and drawing conclusions, identifying organizational patterns, and interpreting figurative language."]
["62",6,"Limited Proficiency",2,"Your performance in the Comprehension area suggests that while you have some skill in this area, there is room for improvement. This area tests your ability to understand text. You need to focus on identifying stated and implied main ideas, supporting details, and identifying author’s purpose and tone. You should also focus on analyzing visual elements, as well as making inferences and drawing conclusions, identifying organizational patterns, and interpreting figurative language."]
["63",6,"Proficient",3,"Your performance in the Comprehension area suggests that you have well-developed skills. This area tests your ability to understand text by identifying stated and implied main ideas, supporting details, and author’s purpose and tone. The questions in this area also test your ability to analyze text using graphs, charts, and tables, as well as make inferences and draw conclusions, identify organizational patterns, and interpret figurative language."]

{"sheet":"Look Up tables","index":4,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":true,"merged":[[29,3,29,4],[1,3,1,4],[0,0,0,1],[1,12,1,13],[0,3,0,7],[0,9,0,10],[1,6,1,7],[1,9,1,10]]}
["Form T Placement Scores",null,null,"Vocabulary and Meaning",null,null,null,null,null,"Reading Comprehension"]
["Raw Score","Scale Score",null,"Form T",null,null,"Form T",null,null,"Form T",null,null,"Form T"]
[0,1,null,"Raw Score","Category Score",null,null,null,null,"Raw Score","Category Score"]
[1,1,null,0,1,null,1,1,null,0,1,null,1,1]
[2,1,null,1,1,null,2,1,null,1,1,null,2,1]
[3,1,null,2,1,null,3,1,null,2,1,null,3,1]
[4,1,null,3,1,null,4,1,null,3,1,null,4,1]
[5,1,null,4,1,null,5,2,null,4,1,null,5,2]
[6,1,null,5,1,null,6,2,null,5,1,null,6,2]
[7,1,null,6,1,null,7,2,null,6,1,null,7,2]
[8,1,null,7,1,null,8,2,null,7,2,null,8,2]
[9,1,null,8,1,null,9,2,null,8,3,null,9,2]
[10,1,null,9,3,null,10,3,null,9,3,null,10,3]
[11,1,null,10,4,null,11,3,null,10,4,null,11,3]
[12,2,null,11,4,null,12,3,null,11,4,null,12,3]
[13,2,null,12,5,null,13,3,null,12,5,null,13,3]
[14,2,null,13,5,null,14,3,null,13,5,null,14,3]
[15,2,null,14,6,null,15,3,null,14,5,null,15,3]
[16,2,null,15,6,null,null,null,null,15,6]
[17,2,null,16,7,null,null,null,null,16,6]
[18,2,null,17,7,null,null,null,null,17,7]
[19,2,null,18,8,null,null,null,null,18,8]
[20,2,null,19,8,null,null,null,null,19,9]
[21,2,null,20,9,null,null,null,null,20,10]
[22,2,null,21,10,null,null,null,null,21,11]
[23,2,null,22,11,null,null,null,null,22,13]
[24,3,null,23,14,null,null,null,null,23,15]
[25,3]
[26,3]
[27,3,null,"Form T"]
[28,4,null,"Raw Score","Category Score"]
[29,4,null,1,"Needs Improvement"]
[30,4,null,2,"Limited Proficiency"]
[31,4,null,3,"Proficient"]
[32,4]
[33,4]
[34,4]
[35,4]
[36,4]
[37,4]
[38,4]
[39,5]
[40,5]
[41,5]
[42,5]
[43,5]
[44,6]
[45,6]
[46,6]