{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Data Entry","Score Sheet","Sentence Structure","Agreement","Sentence Logic","Essay Revision","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":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["TSI 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"]
["Sentence Structure"]
["Agreement"]
["Sentence Logic"]
["Essay Revision"]

{"sheet":"Score Sheet","index":1,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,3],[3,1,3,3],[4,1,4,3],[0,0,0,5],[1,4,1,5],[2,4,2,5],[3,4,3,5],[4,4,4,5],[1,1,1,3]]}
["TSI 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}]
["Strands","Raw Score","Scaled          Scored","Category             Score","Category Description","Proficiency Statements"]
["Sentence Structure",{"$f":"'Data Entry'!B9","v":0},{"$f":"LOOKUP(B7,'Look Up tables'!A2:B24)","v":1},{"$f":"LOOKUP(C7,'Look Up tables'!D4:E18)","v":1},{"$f":"LOOKUP(D7,'Look Up tables'!A28:B30)","v":"Needs Improvement"},{"$f":"LOOKUP(C7,'Sentence Structure'!B2:C4)","v":"Your performance on Sentence Structure suggests that you need to improve significantly in this area. While you can recognize basic sentence structure with a noun and a verb, sometimes you mistake longer phrases for complete sentences and overlook needed punctuation when two sentences run together. You know that punctuation is needed at the end of a sentence, but you need to learn how to use commas or semicolons within a sentence. You need to learn how to use parallel constructions correctly."}]
["Agreement",{"$f":"'Data Entry'!B10","v":0},{"$f":"LOOKUP(B8,'Look Up tables'!G2:H24)","v":1},{"$f":"LOOKUP(C8,'Look Up tables'!J4:K18)","v":1},{"$f":"LOOKUP(D8,'Look Up tables'!A28:B30)","v":"Needs Improvement"},{"$f":"LOOKUP(C8,Agreement!B2:C4)","v":"Your performance on Agreement suggests that you need to improve significantly in this area. You can match the subject and verb in a simple sentence, but you have difficulty if the word order changes or the sentence has a clause. You can rarely match pronouns to nouns (i.e., both singular or plural). You must learn how to use correct verb tense (i.e., past, present, or future); you must learn how to use helping verbs (e.g., be or have). You need to learn what parallelism is and how to use it."}]
["Sentence Logic",{"$f":"'Data Entry'!B11","v":0},{"$f":"LOOKUP(B9,'Look Up tables'!M2:N24)","v":1},{"$f":"LOOKUP(C9,'Look Up tables'!P4:Q18)","v":1},{"$f":"LOOKUP(D9,'Look Up tables'!A28:B30)","v":"Needs Improvement"},{"$f":"LOOKUP(C9,'Sentence Logic'!B2:C4)","v":"Your performance on Sentence Logic suggests that you need to improve significantly in this area. You can pick out the main subject and verb in a simple sentence, but you may have difficulty with complex sentences that use subordinate clauses. You can recognize simple modifiers, but you often fail to use them correctly. You need to learn what parallel structures are. You also need to learn transitions and how to use them. You need to learn how to show logical relationships among ideas. "}]
["Essay Revision",{"$f":"'Data Entry'!B12","v":0},{"$f":"LOOKUP(B10,'Look Up tables'!S2:T24)","v":1},{"$f":"LOOKUP(C10,'Look Up tables'!V4:W18)","v":1},{"$f":"LOOKUP(D10,'Look Up tables'!A28:B30)","v":"Needs Improvement"},{"$f":"LOOKUP(C10,'Essay Revision'!B2:C4)","v":"Your performance on Essay Revision suggests that you need to improve significantly in this area. You have trouble recognizing how paragraph organization supports the communication of ideas. You can identify a main point in a paragraph, but sometimes you do not recognize when some information is unimportant. You must learn how to identify supporting evidence in each paragraph. You must learn about transitions and how to use them. You must work on identifying the best words to convey your ideas."}]

{"sheet":"Sentence Structure","index":2,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[null,null,"Sentence Structure"]
["Needs Improvement",1,"Your performance on Sentence Structure suggests that you need to improve significantly in this area. While you can recognize basic sentence structure with a noun and a verb, sometimes you mistake longer phrases for complete sentences and overlook needed punctuation when two sentences run together. You know that punctuation is needed at the end of a sentence, but you need to learn how to use commas or semicolons within a sentence. You need to learn how to use parallel constructions correctly."]
["Limited Proficiency",2,"Your performance on Sentence Structure suggests that while you have some skills in this area there is room for improvement. You occasionally overlook sentence fragments or run-on sentences. You can usually recognize correct punctuation used at the end of sentences, but you need to learn how to use commas and semicolons in complex sentences. You usually recognize when correct parallelism is used, but you need to work on noun/verb agreement within complex sentence structures."]
["Proficienct",3,"Your performance on Sentence Structure suggests that you have well-developed skills in this area. You consistently recognize correct grammar and punctuation. You understand how subordinate clauses and coordinating strategies are used to write more complex sentences. You can identify run-on sentences and sentence fragments. You understand how relationships of ideas are constructed in sentences and how parallelism is used. "]

{"sheet":"Agreement","index":3,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[null,null,"Agreement"]
["Needs Improvement",1,"Your performance on Agreement suggests that you need to improve significantly in this area. You can match the subject and verb in a simple sentence, but you have difficulty if the word order changes or the sentence has a clause. You can rarely match pronouns to nouns (i.e., both singular or plural). You must learn how to use correct verb tense (i.e., past, present, or future); you must learn how to use helping verbs (e.g., be or have). You need to learn what parallelism is and how to use it."]
["Limited Proficiency",2,"Your performance on Agreement suggests that while you have some skills in this area there is room for improvement. You usually recognize when a subject agrees with its verb but not if there is a clause or phrase in the middle. You can usually match a simple pronoun to the correct noun (i.e., both singular), but you must learn how to manage indefinite pronouns (e.g., each or many). You need to learn proper usage of helping verbs and how to use the correct tense. You need to work on parallelism. "]
["Proficient",3,"Your performance on Agreement suggests that you have well-developed skills in this area. You recognize correct subject-verb agreement (e.g., “he was” and “they were”) and correct verb tense, even when there are subordinate clauses in the sentence. You recognize when pronouns must match their nouns (i.e., both singular, both masculine) even with indefinite pronouns like “each,” “many,” or “every.” You know that parallel items agree in number, case, and tense. "]

{"sheet":"Sentence Logic","index":4,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[null,null,"Sentence Logic"]
["Needs Improvement",1,"Your performance on Sentence Logic suggests that you need to improve significantly in this area. You can pick out the main subject and verb in a simple sentence, but you may have difficulty with complex sentences that use subordinate clauses. You can recognize simple modifiers, but you often fail to use them correctly. You need to learn what parallel structures are. You also need to learn transitions and how to use them. You need to learn how to show logical relationships among ideas. "]
["Limited Proficiency",2,"Your performance on Sentence Logic suggests that while you have some skills in this area there is room for improvement. You can usually recognize the main subject and verb in a sentence. You can usually identify modifier, but you occasionally use them incorrectly. You need to work on identifying appropriate parallel structures. You can sometimes identify logical relationships, but you need to learn the correct transition words to reflect those relationships."]
["Proficient",3,"Your performance on Sentence Logic suggests that you have well-developed skills in this area. You recognize logical sentences that illustrate relationships. You can successfully use transitions. You can usually identify correct parallel structures. You can identify the main subject and verb as well as the subordinate clauses. You understand how compound and complex sentences are built by joining sentences together and punctuating correctly. You understand how to use modifiers and appositives. "]

{"sheet":"Essay Revision","index":5,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[null,null,"Essay Revision"]
["Needs Improvement",1,"Your performance on Essay Revision suggests that you need to improve significantly in this area. You have trouble recognizing how paragraph organization supports the communication of ideas. You can identify a main point in a paragraph, but sometimes you do not recognize when some information is unimportant. You must learn how to identify supporting evidence in each paragraph. You must learn about transitions and how to use them. You must work on identifying the best words to convey your ideas."]
["Limited Proficiency",2,"Your performance on Essay Revision suggests that while you have some skills in this area there is room for improvement. You understand how to order sentences in a paragraph, but you may have difficulty identifying the main idea of a paragraph as separate from the supporting evidence. You must learn to support the progression of ideas between sections using transitions. You must work on identifying the purpose and audience for a piece of writing. You need to use more concise language. "]
["Proficient",3,"Your performance on Essay Revision suggests that you have well-developed skills in this area. You can recognize a main idea within a paragraph. You can identify evidence used to support a thesis and how transitions are used to improve the flow of ideas within and between paragraphs. You recognize that writing must be clear and concise and focused on a purpose and audience. You can recognize when writing can be improved by changing the order of ideas and by making changes to the style and voice."]

{"sheet":"Look Up tables","index":6,"n_rows":30,"n_cols":23,"rows_kept":30,"cut":false,"hidden":true,"merged":[[25,0,25,1],[1,0,1,1],[1,6,1,7],[1,21,1,22],[0,0,0,4],[0,6,0,10],[0,12,0,16],[1,3,1,4],[1,15,1,16],[0,18,0,22],[1,12,1,13],[1,18,1,19],[1,9,1,10]]}
["Sentence Structure",null,null,null,null,null,"Agreement",null,null,null,null,null,"Sentence Logic",null,null,null,null,null,"Essay Revision"]
["Form V",null,null,"Form V",null,null,"Form V",null,null,"Form V",null,null,"Form V",null,null,"Form V",null,null,"Form V",null,null,"Form V"]
["Raw Score","Category Score ",null,null,null,null,"Raw Score","Category Score ",null,null,null,null,"Raw Score","Category Score ",null,null,null,null,"Raw Score","Category Score "]
[0,1,null,1,1,null,0,1,null,1,1,null,0,1,null,1,1,null,0,1,null,1,1]
[1,1,null,2,1,null,1,1,null,2,1,null,1,1,null,2,1,null,1,1,null,2,1]
[2,1,null,3,1,null,2,1,null,3,1,null,2,1,null,3,1,null,2,1,null,3,1]
[3,1,null,4,1,null,3,1,null,4,1,null,3,1,null,4,1,null,3,1,null,4,1]
[4,1,null,5,2,null,4,1,null,5,2,null,4,1,null,5,2,null,4,1,null,5,2]
[5,1,null,6,2,null,5,1,null,6,2,null,5,1,null,6,2,null,5,1,null,6,2]
[6,2,null,7,2,null,6,1,null,7,2,null,6,2,null,7,2,null,6,2,null,7,2]
[7,3,null,8,2,null,7,2,null,8,2,null,7,3,null,8,2,null,7,3,null,8,2]
[8,3,null,9,2,null,8,3,null,9,2,null,8,4,null,9,2,null,8,3,null,9,2]
[9,4,null,10,3,null,9,3,null,10,3,null,9,4,null,10,3,null,9,4,null,10,3]
[10,5,null,11,3,null,10,4,null,11,3,null,10,4,null,11,3,null,10,4,null,11,3]
[11,6,null,12,3,null,11,4,null,12,3,null,11,5,null,12,3,null,11,4,null,12,3]
[12,7,null,13,3,null,12,4,null,13,3,null,12,6,null,13,3,null,12,4,null,13,3]
[13,8,null,14,3,null,13,5,null,14,3,null,13,7,null,14,3,null,13,5,null,14,3]
[14,10,null,15,3,null,14,5,null,15,3,null,14,8,null,15,3,null,14,7,null,15,3]
[15,10,null,null,null,null,15,6,null,null,null,null,15,10,null,null,null,null,15,9]
[16,10,null,null,null,null,16,7,null,null,null,null,16,10,null,null,null,null,16,10]
[17,11,null,null,null,null,17,8,null,null,null,null,17,10,null,null,null,null,17,10]
[18,12,null,null,null,null,18,10,null,null,null,null,18,11,null,null,null,null,18,11]
[19,13,null,null,null,null,19,11,null,null,null,null,19,12,null,null,null,null,19,13]
[20,15,null,null,null,null,20,15,null,null,null,null,20,15,null,null,null,null,20,15]
[]
["Form V"]
["Raw Score","Category Score"]
[1,"Needs Improvement"]
[2,"Limited Proficiency"]
[3,"Proficient"]