{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Data Entry","Score Sheet","Elementary Algebra","Intermediate Algebra","Geometry and Measurement","Data Analysis, Statistics ...","Look Up tables","Sheet1"],"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 Mathematics 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"]
["Elementary Algebra and Functions "]
["Intermediate Algebra and Functions  "]
["Geometry and Measurement"]
["Data Analysis, Statistics and Probability"]

{"sheet":"Score Sheet","index":1,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[4,4,4,5],[3,4,3,5],[0,0,0,5],[1,1,1,3],[2,1,2,3],[1,4,1,5],[2,4,2,5],[3,1,3,3],[4,1,4,3]]}
["TSI Diagnostice Score Report - Mathematics - 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          Score","Category      Score","Category Description","Proficiency Statements"]
["Elementary Algebra and Functions ",{"$f":"'Data Entry'!B9","v":0},{"$f":"LOOKUP(B7,'Look Up tables'!A4:B25)","v":1},{"$f":"LOOKUP(C7,'Look Up tables'!D4:E18)","v":1},{"$f":"LOOKUP(D7,'Look Up tables'!A30:B32)","v":"Needs Improvement"},{"$f":"LOOKUP(D7,'Elementary Algebra'!B2:C4)","v":"The results suggest that you have the ability to perform operations with whole numbers; add and subtract fractions with the same denominators; use less than and greater than to order integers and fractions; convert among fractions, percentages, and decimals; understand basic math terminology and symbols.  Recommended study: perform operations with integers and decimals; translate statements into algebraic expressions; solve ratio and proportion problems; plot points on a graph. "}]
["Intermediate Algebra and Functions  ",{"$f":"'Data Entry'!B10","v":0},{"$f":"LOOKUP(B8,'Look Up tables'!G4:H25)","v":1},{"$f":"LOOKUP(C8,'Look Up tables'!J4:K18)","v":1},{"$f":"LOOKUP(D8,'Look Up tables'!A30:B32)","v":"Needs Improvement"},{"$f":"LOOKUP(D8,'Intermediate Algebra'!B2:C4)","v":"The results suggest that you have the ability to take square roots; add, subtract, multiply and divide polynomials; work exponents using whole numbers; know the distance formula and use it in word problems; factor polynomials using GCF.  Recommended study: Factoring polynomial expressions; simplifying square roots; solving simple equations with radicals and fractions."}]
["Geometry and Measurement",{"$f":"'Data Entry'!B11","v":0},{"$f":"LOOKUP(B9,'Look Up tables'!M4:N25)","v":1},{"$f":"LOOKUP(C9,'Look Up tables'!P4:Q18)","v":1},{"$f":"LOOKUP(D9,'Look Up tables'!A30:B32)","v":"Needs Improvement"},{"$f":"LOOKUP(D9,'Geometry and Measurement'!B2:C11)","v":"The results suggest that you have the ability to calculate perimeter, area, and volume, compute unit conversions, distinguish between geometric shapes as well as use properties of similar figures given labeled illustrations.  Recommended study:  Solving Equations involving geometric shapes, Pythagorean Theorem, and ratio and proportion."}]
["Data Analysis, Statistics and Probability",{"$f":"'Data Entry'!B12","v":0},{"$f":"LOOKUP(B10,'Look Up tables'!S4:T25)","v":1},{"$f":"LOOKUP(C10,'Look Up tables'!S4:T18)","v":1},{"$f":"LOOKUP(D10,'Look Up tables'!A30:B32)","v":"Needs Improvement"},{"$f":"LOOKUP(D10,'Data Analysis, Statistics ...'!B2:C4)","v":"The results suggest that you have the ability to calculate the mean, median, mode, and range for a set of whole number values; calculate the probability of a simple event; read and interpret charts and graphs; apply fundamental counting principles using diagrams.  Recommended study:  calculate probabilities, percentages, measures of center and variability."}]

{"sheet":"Elementary Algebra","index":2,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[null,null,"Elementary Algebra and Functions"]
["Needs Improvement",1,"The results suggest that you have the ability to perform operations with whole numbers; add and subtract fractions with the same denominators; use less than and greater than to order integers and fractions; convert among fractions, percentages, and decimals; understand basic math terminology and symbols.  Recommended study: perform operations with integers and decimals; translate statements into algebraic expressions; solve ratio and proportion problems; plot points on a graph. "]
["Limited Proficiency",2,"These results suggest you have the ability to perform operations with integers and decimals; translate statements into algebraic expressions and evaluate using substitution; solve basic ratio and proportion problems; plot points on a graph; interpret inequalities.  Recommended study: perform operations with real numbers using correct order of operations; translate and solve linear equations, inequalities, systems, and variation problems; plot functions on a graph; solve word problems."]
["Proficiency",3,"These results suggest that you have the ability to perform operations with real numbers and algebraic expressions using correct order of operations; solve linear equations, inequalities, systems and variation problems; graph linear functions; solve word problems."]

{"sheet":"Intermediate Algebra","index":3,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[null,null,"Intermediate Algebra and Functions"]
["Needs Improvement",1,"The results suggest that you have the ability to take square roots; add, subtract, multiply and divide polynomials; work exponents using whole numbers; know the distance formula and use it in word problems; factor polynomials using GCF.  Recommended study: Factoring polynomial expressions; simplifying square roots; solving simple equations with radicals and fractions."]
["Limited Proficiency",8,"The results suggest that you have the ability to factor polynomial expressions with GCF, grouping, and difference of squares, and factor trinomials with leading coefficient of 1; simplify simple expressions with fractions; find solutions to quadratic equations by substituting and factoring (leading coefficient of 1); apply some rules of exponents with integer exponents; evaluate linear functions. Recommended study: factor trinomials; solve quadratic equations; simplify square roots."]
["Proficient",9,"The results suggest that you have the ability to factor polynomial expressions by GCF, grouping, difference of squares, trinomials; solve quadratic equations by factoring and using quadratic formula; simplify square roots with numerical values; and solve simple equations with radicals and fractions; can apply unit conversion in word problems; formulate algebraic expressions and equations to solve word problems; apply rules of exponents.  "]

{"sheet":"Geometry and Measurement","index":4,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[null,null,"Geometry and Measurement"]
["Needs Improvement",1,"The results suggest that you have the ability to calculate perimeter, area, and volume, compute unit conversions, distinguish between geometric shapes as well as use properties of similar figures given labeled illustrations.  Recommended study:  Solving Equations involving geometric shapes, Pythagorean Theorem, and ratio and proportion."]
["Limited Proficiency",2,"The results suggest that you have the ability to identify & solve simple 2-D and 3-D perimeter, area and volume problems. Use ratio, proportion and Pythagorean Theorem to solve algebraic expressions and 2-step geometric problems.  Can locate and identify points in the coordinate system to solve problems with distance.  Recognize positive and negative slopes. Recommended study:  Multi-step geometrical problems focusing on Polynomials and Factoring quadratics."]
["Proficient",3,"The results suggest that you have the ability to identify and analyze geometric shapes to calculate perimeter, area and volume.  Analyze multi-step geometric problems using factoring quadratics, use properties of transformations to solve problems, and apply the Pythagorean Theorem.  Analyze and apply ratios and proportions to solve geometric problems such as similar figures, recognize and apply concepts of measurement conversions."]

{"sheet":"Data Analysis, Statistics ...","index":5,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[null,null,"Geometry and Measurement"]
["Needs Improvement",1,"The results suggest that you have the ability to calculate the mean, median, mode, and range for a set of whole number values; calculate the probability of a simple event; read and interpret charts and graphs; apply fundamental counting principles using diagrams.  Recommended study:  calculate probabilities, percentages, measures of center and variability."]
["Limited Proficiency",2,"The results suggest that you have the ability to calculate the mean, median, mode, and range for a set of real number values; calculate the probability of simple independent events; read and interpret charts and graphs; apply fundamental counting principles; calculate percentages.  Recommended study:  make predictions using probabilities and statistics; interpret measures of center and variability; analyze trends in charts and graphs."]
["Proficient",3,"The results suggest that you have the ability to calculate and interpret the mean, median, mode, and range for a set of real number values; calculate the probability of events; make predictions using probabilities and statistics; analyze charts and graphs; apply counting principles; calculate percentages."]

{"sheet":"Look Up tables","index":6,"n_rows":32,"n_cols":23,"rows_kept":32,"cut":false,"hidden":true,"merged":[[1,21,1,22],[0,0,0,4],[0,6,0,10],[0,12,0,16],[1,3,1,4],[1,18,1,19],[0,18,0,22],[27,0,27,1],[1,9,1,10],[1,15,1,16],[1,6,1,7],[1,12,1,13],[1,0,1,1]]}
["Elementary Algebra",null,null,null,null,null,"Intermediate Algebra",null,null,null,null,null,"Geometry and Measurement",null,null,null,null,null,"Data Analysis, Statistics and Probability"]
["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,2,null,6,2,null,5,1,null,6,2,null,5,1,null,6,2]
[6,2,null,7,2,null,6,2,null,7,2,null,6,2,null,7,2,null,6,2,null,7,2]
[7,3,null,8,2,null,7,3,null,8,2,null,7,3,null,8,2,null,7,2,null,8,2]
[8,3,null,9,2,null,8,3,null,9,2,null,8,3,null,9,2,null,8,3,null,9,2]
[9,4,null,10,3,null,9,4,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,5,null,11,3]
[11,6,null,12,3,null,11,4,null,12,3,null,11,5,null,12,3,null,11,5,null,12,3]
[12,7,null,13,3,null,12,5,null,13,3,null,12,6,null,13,3,null,12,6,null,13,3]
[13,7,null,14,3,null,13,6,null,14,3,null,13,6,null,14,3,null,13,6,null,14,3]
[14,7,null,15,3,null,14,7,null,15,3,null,14,7,null,15,3,null,14,7,null,15,3]
[15,8,null,null,null,null,15,8,null,null,null,null,15,8,null,null,null,null,15,8]
[16,8,null,null,null,null,16,9,null,null,null,null,16,8,null,null,null,null,16,8]
[17,9,null,null,null,null,17,10,null,null,null,null,17,9,null,null,null,null,17,9]
[18,9,null,null,null,null,18,11,null,null,null,null,18,10,null,null,null,null,18,10]
[19,11,null,null,null,null,19,12,null,null,null,null,19,11,null,null,null,null,19,12]
[20,13,null,null,null,null,20,14,null,null,null,null,20,14,null,null,null,null,20,15]
[21,15,null,null,null,null,21,15,null,null,null,null,21,15,null,null,null,null,21,15]
[]
[]
["Form V"]
["Category","Labels"]
[1,"Needs Improvement"]
[2,"Limited Proficiency"]
[3,"Proficient"]

{"sheet":"Sheet1","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}