{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Data Entry","Score Sheet","Organization and Composition","Grammar and Structure","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 Writing Diagnostic Test - Form V"]
["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"]
["Organization and Composition"]
["Grammar and Structure"]
["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 - Writing - Form V"]
[{"$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"]
["Organization and Composition",{"$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'!D37:E39)","v":"Needs Improvement"},{"$f":"VLOOKUP(C7&D9,'Organization and Composition'!A:E,5,FALSE)","v":"Your performance on Organizing and Composing suggests that you need to improve significantly in this area. You need to work on basic sentence structure, including how to use nouns and verbs to form complete sentences, how to combine sentences to create a paragraph, identifying the main idea in a paragraph, recognizing and using supporting details. You also need to work on improving your vocabulary skills, capitalization, and punctuation skills."}]
["Grammar and Structure",{"$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'!D37:E39)","v":"Needs Improvement"},{"$f":"VLOOKUP(C7&D10,'Grammar and Structure'!A:E,5,FALSE)","v":"Your performance on Grammar and Structure suggests that you need to improve significantly in this area. You need to work on identifying nouns and verbs and how to use them to create a complete sentence. You need to expand your knowledge of basic sight words. You need to work on capitalization and how to use the various forms of punctuation, including the period and comma."}]

{"sheet":"Organization and Composition","index":2,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["Concatenate","Placement Score","Strand Category","Strand Category","Organization and Composition"]
[{"$f":"CONCATENATE(B2,D2)","v":"11"},1,"Needs Improvement",1,"Your performance on Organizing and Composing suggests that you need to improve significantly in this area. You need to work on basic sentence structure, including how to use nouns and verbs to form complete sentences, how to combine sentences to create a paragraph, identifying the main idea in a paragraph, recognizing and using supporting details. You also need to work on improving your vocabulary skills, capitalization, and punctuation skills."]
[{"$f":"CONCATENATE(B3,D3)","v":"12"},1,"Limited Proficiency",2,"Your performance on Organizing and Composing suggests that while you have some skills in this area, there is room for improvement. You sometimes have problems recognizing a basic sentence that has a noun and a verb. You need to work on word order, combining sentences differentiating between minor and major points within a paragraph, as well as filling out common forms."]
["13",1,"Proficient",3,"Your performance on Organizing and Composing suggests that you have well-developed skills in this area. You can identify a basic sentence that has a noun and a verb, but you need to work on knowing in what order to put words. You should work on writing complex and compound sentences, appropriate word choice, and organizing paragraphs with enough supporting detail."]
["21",2,"Needs Improvement",1,"Your performance on Organizing and Composing suggests that you need to improve significantly in this area. You need to work on basic sentence structure, including how to use nouns and verbs to form complete sentences, how to combine sentences to create a paragraph, identifying the main idea in a paragraph, recognizing and using supporting details. You also need to work on improving your vocabulary skills, capitalization, and punctuation skills."]
["22",2,"Limited Proficiency",2,"Your performance on Organizing and Composing suggests that while you have some skills in this area, there is room for improvement. You sometimes have problems recognizing a basic sentence that has a noun and a verb. You need to work on word order, combining sentences differentiating between minor and major points within a paragraph, as well as filling out common forms."]
["23",2,"Proficient",3,"Your performance on Organizing and Composing suggests that you have well-developed skills in this area. You can identify a basic sentence that has a noun and a verb, but you need to work on knowing in what order to put words. You should work on writing complex and compound sentences, appropriate word choice, and organizing paragraphs with enough supporting detail."]
["31",3,"Needs Improvement",1,"Your performance on Organizing and Composing suggests that you need to improve significantly in this area. You can occasionally find the main idea in a paragraph. You need to work on using transition words (e.g., however and therefore). You need to work on recognizing clear and concise writing. You need to work on developing your vocabulary to support the appropriate tone."]
["32",3,"Limited Proficiency",2,"Your performance on Organizing and Composing suggests that while you have some skills in this area, there is room for improvement. You can identify related ideas within a paragraph, but you need to work on determining which ideas best develop the main idea. You need to work on transitions and identifying the best words to reflect appropriate tone in relation to the audience and purpose."]
["33",3,"Proficient",3,"Your performance on Organizing and Composing suggests that you have well-developed skills in this area. You can identify different audiences, and you usually match the right tone with the target audience. You can use simple transition words but not always recognize the correct punctuation that goes with the transitions. You understand that a paragraph should have one main point, and you can usually identify the appropriate supporting evidence. You need to work on avoiding fragments and run-ons."]
["41",4,"Needs Improvement",1,"Your performance on Organizing and Composing suggests that you need to improve significantly in this area. You can occasionally find the main idea in a paragraph. You need to work on using transition words (e.g., however and therefore). You need to work on recognizing clear and concise writing. You need to work on developing your vocabulary to support the appropriate tone."]
["42",4,"Limited Proficiency",2,"Your performance on Organizing and Composing suggests that while you have some skills in this area, there is room for improvement. You can identify related ideas within a paragraph, but you need to work on determining which ideas best develop the main idea. You need to work on transitions and identifying the best words to reflect appropriate tone in relation to the audience and purpose."]
["43",4,"Proficient",3,"Your performance on Organizing and Composing suggests that you have well-developed skills in this area. You can identify different audiences, and you usually match the right tone with the target audience. You can use simple transition words but not always recognize the correct punctuation that goes with the transitions. You understand that a paragraph should have one main point, and you can usually identify the appropriate supporting evidence. You need to work on avoiding fragments and run-ons."]
["51",5,"Needs Improvement",1,"Your performance on Organizing and Composing suggests that you need to improve significantly in this area. You can usually recognize the main idea of an essay, but you have difficulty identifying topic sentences or supportive ideas that communicate the purpose of the paragraph to the audience. You can sometimes identify basic transitions, but you need to work on appropriate coordination and subordination techniques (e.g., but or since). You need to work on alter sentence structures for variety."]
["52",5,"Limited Proficiency",2,"Your performance on Organizing and Composing suggests that while you have some skills in this area, there is room for improvement. You usually recognize the audience and purpose of a piece of writing. You can usually identify the main point of a paragraph but need to work on identifying the best supporting evidence. You need to work on the use of transitions. You usually make good word choices including verb tense. You need to work on the use of various sentence structures."]
["53",5,"Proficient",3,"Your performance on Organizing and Composing suggests that you have well-developed skills in this area. You can identify purpose and audience in a piece of writing. You can recognize when a paragraph has only one main idea and sufficient evidence. You can recognize when basic transitions have been successfully used. You usually select the correct verb tense as well as other word choices. You can identify various sentence structures that make a piece of writing more interesting."]
["61",6,"Needs Improvement",1,"Your performance on Organizing and Composing suggests that you need to improve significantly in this area. You can usually recognize the main idea of an essay, but you have difficulty identifying topic sentences or supportive ideas that communicate the purpose of the paragraph to the audience. You can sometimes identify basic transitions, but you need to work on appropriate coordination and subordination techniques (e.g., but or since). You need to work on alter sentence structures for variety."]
["62",6,"Limited Proficiency",2,"Your performance on Organizing and Composing suggests that while you have some skills in this area, there is room for improvement. You usually recognize the audience and purpose of a piece of writing. You can usually identify the main point of a paragraph but need to work on identifying the best supporting evidence. You need to work on the use of transitions. You usually make good word choices including verb tense. You need to work on the use of various sentence structures."]
["63",6,"Proficient",3,"Your performance on Organizing and Composing suggests that you have well-developed skills in this area. You can identify purpose and audience in a piece of writing. You can recognize when a paragraph has only one main idea and sufficient evidence. You can recognize when basic transitions have been successfully used. You usually select the correct verb tense as well as other word choices. You can identify various sentence structures that make a piece of writing more interesting."]

{"sheet":"Grammar and Structure","index":3,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["Concatenate","Placement Score","Strand Category","Strand Category","Grammar and Structure"]
[{"$f":"CONCATENATE(B2,D2)","v":"11"},1,"Needs Improvement",1,"Your performance on Grammar and Structure suggests that you need to improve significantly in this area. You need to work on identifying nouns and verbs and how to use them to create a complete sentence. You need to expand your knowledge of basic sight words. You need to work on capitalization and how to use the various forms of punctuation, including the period and comma."]
[{"$f":"CONCATENATE(B3,D3)","v":"12"},1,"Limited Proficiency",2,"Your performance on Grammar and Structure suggests that while you have some skills in this area, there is room for improvement. Sometimes you can use the basic verb tenses (e.g., past and present). You need to work on your spelling of common sight words. You generally mix up words that sound alike (e.g., to/too/two or then/than). You know to put a period at the end of a sentence, but you need to work on using other forms of punctuation. You need to work on identifying a complete sentence."]
["13",1,"Proficient",3,"Your performance on Grammar and Structure suggests that you have well-developed skills in this area. Sometimes you can use the basic verb tenses (e.g., past, present, and future). You can spell some common sight words, but you also misspell many other words. You generally mix up words that sound alike (e.g., to/too/two or then/than). You know to put a period at the end of a sentence, but you need to work on how to use the other forms of punctuation. You need to work on how to identify a complete sentence."]
["21",2,"Needs Improvement",1,"Your performance on Grammar and Structure suggests that you need to improve significantly in this area. You need to work on identifying nouns and verbs and how to use them to create a complete sentence. You need to expand your knowledge of basic sight words. You need to work on capitalization and how to use the various forms of punctuation, including the period and comma."]
["22",2,"Limited Proficiency",2,"Your performance on Grammar and Structure suggests that while you have some skills in this area, there is room for improvement. Sometimes you can use the basic verb tenses (e.g., past and present). You need to work on your spelling of common sight words. You generally mix up words that sound alike (e.g., to/too/two or then/than). You know to put a period at the end of a sentence, but you need to work on using other forms of punctuation. You need to work on identifying a complete sentence."]
["23",2,"Proficient",3,"Your performance on Grammar and Structure suggests that you have well-developed skills in this area. Sometimes you can use the basic verb tenses (e.g., past, present, and future). You can spell some common sight words, but you also misspell many other words. You generally mix up words that sound alike (e.g., to/too/two or then/than). You know to put a period at the end of a sentence, but you need to work on how to use the other forms of punctuation. You need to work on how to identify a complete sentence."]
["31",3,"Needs Improvement",1,"Your performance on Grammar and Structure suggests that you need to improve significantly in this area. You have a difficult time identifying grammatically correct simple sentences. You need to work on your spelling of basic words. You need to work on selecting the correct word when the words sound the same (e.g., know/no). You need to work on when to use capitalization. You need to work on how to use transitions and prepositions correctly. You need to work on making single words plural."]
["32",3,"Limited Proficiency",2,"Your performance on Grammar and Structure suggests that while you have some skills in this area, there is room for improvement. You usually punctuate sentences with periods correctly, but you often misuse other punctuation marks. You have difficulty spelling, especially easily confused words (e.g., effect/affect). You need to work on making singular words plural. You need to work on the use of prepositions and transitions. You often fail to match your subject and verb for tense and number."]
["33",3,"Proficient",3,"Your performance on Grammar and Structure suggests that you have well-developed skills in this area. You need to work on plural endings besides /s/. You can recognize some easily confused words (e.g., two/to/too), but you have more difficulty with others (e.g., affect/effect). You usually use periods when needed, but when a sentence is complicated with dependent clauses, you find punctuation difficult. You usually recognize when a verb tense fails to match its subject."]
["41",4,"Needs Improvement",1,"Your performance on Grammar and Structure suggests that you need to improve significantly in this area. You have a difficult time identifying grammatically correct simple sentences. You need to work on your spelling of basic words. You need to work on selecting the correct word when the words sound the same (e.g., know/no). You need to work on when to use capitalization. You need to work on how to use transitions and prepositions correctly. You need to work on making single words plural."]
["42",4,"Limited Proficiency",2,"Your performance on Grammar and Structure suggests that while you have some skills in this area, there is room for improvement. You usually punctuate sentences with periods correctly, but you often misuse other punctuation marks. You have difficulty spelling, especially easily confused words (e.g., effect/affect). You need to work on making singular words plural. You need to work on the use of prepositions and transitions. You often fail to match your subject and verb for tense and number."]
["43",4,"Proficient",3,"Your performance on Grammar and Structure suggests that you have well-developed skills in this area. You need to work on plural endings besides /s/. You can recognize some easily confused words (e.g., two/to/too), but you have more difficulty with others (e.g., affect/effect). You usually use periods when needed, but when a sentence is complicated with dependent clauses, you find punctuation difficult. You usually recognize when a verb tense fails to match its subject."]
["51",5,"Needs Improvement",1,"Your performance on Grammar and Structure suggests that you need to improve significantly in this area. You can identify simple sentences, but you need to work on how to create complex or compound sentences, adding complexity to your word choices, and identifying words that sound alike (e.g., to/too/two). You can generally use periods correctly, but you need to work on the correct usage of other forms of punctuation. You need to select more effective prepositions and transitions."]
["52",5,"Limited Proficiency",2,"Your performance on Grammar and Structure suggests that while you have some skills in this area, there is room for improvement. You can usually correctly identify simple sentence structure and grammar, but you have difficulty with compound and complex sentences. You need to work on choosing the correct words to reflect a specific meaning, how to punctuate complex sentences, and identifying the correct usage of apostrophes, prepositions, and transitions."]
["53",5,"Proficient",3,"Your performance on Grammar and Structure suggests that you have well-developed skills in this area. You consistently recognize correct punctuation and pronouns and can usually recognize and correct run-on sentences or fragments. You know how to use verb tenses and match verbs to subjects (e.g., they were and he was). When words sound alike, you can usually pick the correct one (e.g., affect/effect or then/than). You usually select the correct preposition as well as appropriate transitions."]
["61",6,"Needs Improvement",1,"Your performance on Grammar and Structure suggests that you need to improve significantly in this area. You can identify simple sentences, but you need to work on how to create complex or compound sentences, adding complexity to your word choices, and identifying words that sound alike (e.g., to/too/two). You can generally use periods correctly, but you need to work on the correct usage of other forms of punctuation. You need to select more effective prepositions and transitions."]
["62",6,"Limited Proficiency",2,"Your performance on Grammar and Structure suggests that while you have some skills in this area, there is room for improvement. You can usually correctly identify simple sentence structure and grammar, but you have difficulty with compound and complex sentences. You need to work on choosing the correct words to reflect a specific meaning, how to punctuate complex sentences, and identifying the correct usage of apostrophes, prepositions, and transitions."]
["63",6,"Proficient",3,"Your performance on Grammar and Structure suggests that you have well-developed skills in this area. You consistently recognize correct punctuation and pronouns and can usually recognize and correct run-on sentences or fragments. You know how to use verb tenses and match verbs to subjects (e.g., they were and he was). When words sound alike, you can usually pick the correct one (e.g., affect/effect or then/than). You usually select the correct preposition as well as appropriate transitions."]

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