{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Assessment Data","Export","Rubric"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":5,"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":"Assessment Data","index":0,"n_rows":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,3,2,4]]}
["Instructor:"]
["Class:",null,null,"**IMPORTANT: Please complete this scoring rubric using Excel, not Google Sheets.\nHaving issues? Contact Priscilla at psung1@ucsc.edu."]
["Quarter:"]
[]
["Last name","First name","Student ID","Criterion 1:\nAnalyzes text to identify a main idea","Criterion 2:\nUses a range of strategies to understand texts.","Criterion 3:\nRecognizes relationships between genre and context ","Criterion 4:\nIdentifies how other sources helped explain text"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]
[null,null,null,"(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\r\nUsing a Mac: Click once, then click the drop-down arrow)"]

{"sheet":"Export","index":1,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
["Student ID","C1","C2","C3","C4","Instructor","Class","Quarter"]
[{"$f":"IF('Assessment Data'!C6=\"\",\"\",'Assessment Data'!C6)","v":""},{"$f":"IF('Assessment Data'!D6=Rubric!B$3,4,IF('Assessment Data'!D6=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E6=Rubric!C$3,4,IF('Assessment Data'!E6=Rubric!C$4,3,IF('Assessment Data'!E6=Rubric!C$5,2,IF('Assessment Data'!E6=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F6=Rubric!D$3,4,IF('Assessment Data'!F6=Rubric!D$4,3,IF('Assessment Data'!F6=Rubric!D$5,2,IF('Assessment Data'!F6=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G6=Rubric!E$3,4,IF('Assessment Data'!G6=Rubric!E$4,3,IF('Assessment Data'!G6=Rubric!E$5,2,IF('Assessment Data'!G6=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C7=\"\",\"\",'Assessment Data'!C7)","v":""},{"$f":"IF('Assessment Data'!D7=Rubric!B$3,4,IF('Assessment Data'!D7=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E7=Rubric!C$3,4,IF('Assessment Data'!E7=Rubric!C$4,3,IF('Assessment Data'!E7=Rubric!C$5,2,IF('Assessment Data'!E7=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F7=Rubric!D$3,4,IF('Assessment Data'!F7=Rubric!D$4,3,IF('Assessment Data'!F7=Rubric!D$5,2,IF('Assessment Data'!F7=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G7=Rubric!E$3,4,IF('Assessment Data'!G7=Rubric!E$4,3,IF('Assessment Data'!G7=Rubric!E$5,2,IF('Assessment Data'!G7=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C8=\"\",\"\",'Assessment Data'!C8)","v":""},{"$f":"IF('Assessment Data'!D8=Rubric!B$3,4,IF('Assessment Data'!D8=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E8=Rubric!C$3,4,IF('Assessment Data'!E8=Rubric!C$4,3,IF('Assessment Data'!E8=Rubric!C$5,2,IF('Assessment Data'!E8=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F8=Rubric!D$3,4,IF('Assessment Data'!F8=Rubric!D$4,3,IF('Assessment Data'!F8=Rubric!D$5,2,IF('Assessment Data'!F8=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G8=Rubric!E$3,4,IF('Assessment Data'!G8=Rubric!E$4,3,IF('Assessment Data'!G8=Rubric!E$5,2,IF('Assessment Data'!G8=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C9=\"\",\"\",'Assessment Data'!C9)","v":""},{"$f":"IF('Assessment Data'!D9=Rubric!B$3,4,IF('Assessment Data'!D9=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E9=Rubric!C$3,4,IF('Assessment Data'!E9=Rubric!C$4,3,IF('Assessment Data'!E9=Rubric!C$5,2,IF('Assessment Data'!E9=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F9=Rubric!D$3,4,IF('Assessment Data'!F9=Rubric!D$4,3,IF('Assessment Data'!F9=Rubric!D$5,2,IF('Assessment Data'!F9=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G9=Rubric!E$3,4,IF('Assessment Data'!G9=Rubric!E$4,3,IF('Assessment Data'!G9=Rubric!E$5,2,IF('Assessment Data'!G9=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C10=\"\",\"\",'Assessment Data'!C10)","v":""},{"$f":"IF('Assessment Data'!D10=Rubric!B$3,4,IF('Assessment Data'!D10=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E10=Rubric!C$3,4,IF('Assessment Data'!E10=Rubric!C$4,3,IF('Assessment Data'!E10=Rubric!C$5,2,IF('Assessment Data'!E10=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F10=Rubric!D$3,4,IF('Assessment Data'!F10=Rubric!D$4,3,IF('Assessment Data'!F10=Rubric!D$5,2,IF('Assessment Data'!F10=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G10=Rubric!E$3,4,IF('Assessment Data'!G10=Rubric!E$4,3,IF('Assessment Data'!G10=Rubric!E$5,2,IF('Assessment Data'!G10=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C11=\"\",\"\",'Assessment Data'!C11)","v":""},{"$f":"IF('Assessment Data'!D11=Rubric!B$3,4,IF('Assessment Data'!D11=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E11=Rubric!C$3,4,IF('Assessment Data'!E11=Rubric!C$4,3,IF('Assessment Data'!E11=Rubric!C$5,2,IF('Assessment Data'!E11=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F11=Rubric!D$3,4,IF('Assessment Data'!F11=Rubric!D$4,3,IF('Assessment Data'!F11=Rubric!D$5,2,IF('Assessment Data'!F11=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G11=Rubric!E$3,4,IF('Assessment Data'!G11=Rubric!E$4,3,IF('Assessment Data'!G11=Rubric!E$5,2,IF('Assessment Data'!G11=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C12=\"\",\"\",'Assessment Data'!C12)","v":""},{"$f":"IF('Assessment Data'!D12=Rubric!B$3,4,IF('Assessment Data'!D12=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E12=Rubric!C$3,4,IF('Assessment Data'!E12=Rubric!C$4,3,IF('Assessment Data'!E12=Rubric!C$5,2,IF('Assessment Data'!E12=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F12=Rubric!D$3,4,IF('Assessment Data'!F12=Rubric!D$4,3,IF('Assessment Data'!F12=Rubric!D$5,2,IF('Assessment Data'!F12=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G12=Rubric!E$3,4,IF('Assessment Data'!G12=Rubric!E$4,3,IF('Assessment Data'!G12=Rubric!E$5,2,IF('Assessment Data'!G12=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C13=\"\",\"\",'Assessment Data'!C13)","v":""},{"$f":"IF('Assessment Data'!D13=Rubric!B$3,4,IF('Assessment Data'!D13=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E13=Rubric!C$3,4,IF('Assessment Data'!E13=Rubric!C$4,3,IF('Assessment Data'!E13=Rubric!C$5,2,IF('Assessment Data'!E13=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F13=Rubric!D$3,4,IF('Assessment Data'!F13=Rubric!D$4,3,IF('Assessment Data'!F13=Rubric!D$5,2,IF('Assessment Data'!F13=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G13=Rubric!E$3,4,IF('Assessment Data'!G13=Rubric!E$4,3,IF('Assessment Data'!G13=Rubric!E$5,2,IF('Assessment Data'!G13=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C14=\"\",\"\",'Assessment Data'!C14)","v":""},{"$f":"IF('Assessment Data'!D14=Rubric!B$3,4,IF('Assessment Data'!D14=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E14=Rubric!C$3,4,IF('Assessment Data'!E14=Rubric!C$4,3,IF('Assessment Data'!E14=Rubric!C$5,2,IF('Assessment Data'!E14=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F14=Rubric!D$3,4,IF('Assessment Data'!F14=Rubric!D$4,3,IF('Assessment Data'!F14=Rubric!D$5,2,IF('Assessment Data'!F14=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G14=Rubric!E$3,4,IF('Assessment Data'!G14=Rubric!E$4,3,IF('Assessment Data'!G14=Rubric!E$5,2,IF('Assessment Data'!G14=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C15=\"\",\"\",'Assessment Data'!C15)","v":""},{"$f":"IF('Assessment Data'!D15=Rubric!B$3,4,IF('Assessment Data'!D15=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E15=Rubric!C$3,4,IF('Assessment Data'!E15=Rubric!C$4,3,IF('Assessment Data'!E15=Rubric!C$5,2,IF('Assessment Data'!E15=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F15=Rubric!D$3,4,IF('Assessment Data'!F15=Rubric!D$4,3,IF('Assessment Data'!F15=Rubric!D$5,2,IF('Assessment Data'!F15=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G15=Rubric!E$3,4,IF('Assessment Data'!G15=Rubric!E$4,3,IF('Assessment Data'!G15=Rubric!E$5,2,IF('Assessment Data'!G15=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C16=\"\",\"\",'Assessment Data'!C16)","v":""},{"$f":"IF('Assessment Data'!D16=Rubric!B$3,4,IF('Assessment Data'!D16=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E16=Rubric!C$3,4,IF('Assessment Data'!E16=Rubric!C$4,3,IF('Assessment Data'!E16=Rubric!C$5,2,IF('Assessment Data'!E16=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F16=Rubric!D$3,4,IF('Assessment Data'!F16=Rubric!D$4,3,IF('Assessment Data'!F16=Rubric!D$5,2,IF('Assessment Data'!F16=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G16=Rubric!E$3,4,IF('Assessment Data'!G16=Rubric!E$4,3,IF('Assessment Data'!G16=Rubric!E$5,2,IF('Assessment Data'!G16=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C17=\"\",\"\",'Assessment Data'!C17)","v":""},{"$f":"IF('Assessment Data'!D17=Rubric!B$3,4,IF('Assessment Data'!D17=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E17=Rubric!C$3,4,IF('Assessment Data'!E17=Rubric!C$4,3,IF('Assessment Data'!E17=Rubric!C$5,2,IF('Assessment Data'!E17=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F17=Rubric!D$3,4,IF('Assessment Data'!F17=Rubric!D$4,3,IF('Assessment Data'!F17=Rubric!D$5,2,IF('Assessment Data'!F17=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G17=Rubric!E$3,4,IF('Assessment Data'!G17=Rubric!E$4,3,IF('Assessment Data'!G17=Rubric!E$5,2,IF('Assessment Data'!G17=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C18=\"\",\"\",'Assessment Data'!C18)","v":""},{"$f":"IF('Assessment Data'!D18=Rubric!B$3,4,IF('Assessment Data'!D18=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E18=Rubric!C$3,4,IF('Assessment Data'!E18=Rubric!C$4,3,IF('Assessment Data'!E18=Rubric!C$5,2,IF('Assessment Data'!E18=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F18=Rubric!D$3,4,IF('Assessment Data'!F18=Rubric!D$4,3,IF('Assessment Data'!F18=Rubric!D$5,2,IF('Assessment Data'!F18=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G18=Rubric!E$3,4,IF('Assessment Data'!G18=Rubric!E$4,3,IF('Assessment Data'!G18=Rubric!E$5,2,IF('Assessment Data'!G18=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C19=\"\",\"\",'Assessment Data'!C19)","v":""},{"$f":"IF('Assessment Data'!D19=Rubric!B$3,4,IF('Assessment Data'!D19=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E19=Rubric!C$3,4,IF('Assessment Data'!E19=Rubric!C$4,3,IF('Assessment Data'!E19=Rubric!C$5,2,IF('Assessment Data'!E19=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F19=Rubric!D$3,4,IF('Assessment Data'!F19=Rubric!D$4,3,IF('Assessment Data'!F19=Rubric!D$5,2,IF('Assessment Data'!F19=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G19=Rubric!E$3,4,IF('Assessment Data'!G19=Rubric!E$4,3,IF('Assessment Data'!G19=Rubric!E$5,2,IF('Assessment Data'!G19=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C20=\"\",\"\",'Assessment Data'!C20)","v":""},{"$f":"IF('Assessment Data'!D20=Rubric!B$3,4,IF('Assessment Data'!D20=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E20=Rubric!C$3,4,IF('Assessment Data'!E20=Rubric!C$4,3,IF('Assessment Data'!E20=Rubric!C$5,2,IF('Assessment Data'!E20=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F20=Rubric!D$3,4,IF('Assessment Data'!F20=Rubric!D$4,3,IF('Assessment Data'!F20=Rubric!D$5,2,IF('Assessment Data'!F20=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G20=Rubric!E$3,4,IF('Assessment Data'!G20=Rubric!E$4,3,IF('Assessment Data'!G20=Rubric!E$5,2,IF('Assessment Data'!G20=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C21=\"\",\"\",'Assessment Data'!C21)","v":""},{"$f":"IF('Assessment Data'!D21=Rubric!B$3,4,IF('Assessment Data'!D21=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E21=Rubric!C$3,4,IF('Assessment Data'!E21=Rubric!C$4,3,IF('Assessment Data'!E21=Rubric!C$5,2,IF('Assessment Data'!E21=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F21=Rubric!D$3,4,IF('Assessment Data'!F21=Rubric!D$4,3,IF('Assessment Data'!F21=Rubric!D$5,2,IF('Assessment Data'!F21=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G21=Rubric!E$3,4,IF('Assessment Data'!G21=Rubric!E$4,3,IF('Assessment Data'!G21=Rubric!E$5,2,IF('Assessment Data'!G21=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C22=\"\",\"\",'Assessment Data'!C22)","v":""},{"$f":"IF('Assessment Data'!D22=Rubric!B$3,4,IF('Assessment Data'!D22=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E22=Rubric!C$3,4,IF('Assessment Data'!E22=Rubric!C$4,3,IF('Assessment Data'!E22=Rubric!C$5,2,IF('Assessment Data'!E22=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F22=Rubric!D$3,4,IF('Assessment Data'!F22=Rubric!D$4,3,IF('Assessment Data'!F22=Rubric!D$5,2,IF('Assessment Data'!F22=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G22=Rubric!E$3,4,IF('Assessment Data'!G22=Rubric!E$4,3,IF('Assessment Data'!G22=Rubric!E$5,2,IF('Assessment Data'!G22=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C23=\"\",\"\",'Assessment Data'!C23)","v":""},{"$f":"IF('Assessment Data'!D23=Rubric!B$3,4,IF('Assessment Data'!D23=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E23=Rubric!C$3,4,IF('Assessment Data'!E23=Rubric!C$4,3,IF('Assessment Data'!E23=Rubric!C$5,2,IF('Assessment Data'!E23=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F23=Rubric!D$3,4,IF('Assessment Data'!F23=Rubric!D$4,3,IF('Assessment Data'!F23=Rubric!D$5,2,IF('Assessment Data'!F23=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G23=Rubric!E$3,4,IF('Assessment Data'!G23=Rubric!E$4,3,IF('Assessment Data'!G23=Rubric!E$5,2,IF('Assessment Data'!G23=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C24=\"\",\"\",'Assessment Data'!C24)","v":""},{"$f":"IF('Assessment Data'!D24=Rubric!B$3,4,IF('Assessment Data'!D24=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E24=Rubric!C$3,4,IF('Assessment Data'!E24=Rubric!C$4,3,IF('Assessment Data'!E24=Rubric!C$5,2,IF('Assessment Data'!E24=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F24=Rubric!D$3,4,IF('Assessment Data'!F24=Rubric!D$4,3,IF('Assessment Data'!F24=Rubric!D$5,2,IF('Assessment Data'!F24=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G24=Rubric!E$3,4,IF('Assessment Data'!G24=Rubric!E$4,3,IF('Assessment Data'!G24=Rubric!E$5,2,IF('Assessment Data'!G24=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C25=\"\",\"\",'Assessment Data'!C25)","v":""},{"$f":"IF('Assessment Data'!D25=Rubric!B$3,4,IF('Assessment Data'!D25=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E25=Rubric!C$3,4,IF('Assessment Data'!E25=Rubric!C$4,3,IF('Assessment Data'!E25=Rubric!C$5,2,IF('Assessment Data'!E25=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F25=Rubric!D$3,4,IF('Assessment Data'!F25=Rubric!D$4,3,IF('Assessment Data'!F25=Rubric!D$5,2,IF('Assessment Data'!F25=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G25=Rubric!E$3,4,IF('Assessment Data'!G25=Rubric!E$4,3,IF('Assessment Data'!G25=Rubric!E$5,2,IF('Assessment Data'!G25=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C26=\"\",\"\",'Assessment Data'!C26)","v":""},{"$f":"IF('Assessment Data'!D26=Rubric!B$3,4,IF('Assessment Data'!D26=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E26=Rubric!C$3,4,IF('Assessment Data'!E26=Rubric!C$4,3,IF('Assessment Data'!E26=Rubric!C$5,2,IF('Assessment Data'!E26=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F26=Rubric!D$3,4,IF('Assessment Data'!F26=Rubric!D$4,3,IF('Assessment Data'!F26=Rubric!D$5,2,IF('Assessment Data'!F26=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G26=Rubric!E$3,4,IF('Assessment Data'!G26=Rubric!E$4,3,IF('Assessment Data'!G26=Rubric!E$5,2,IF('Assessment Data'!G26=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C27=\"\",\"\",'Assessment Data'!C27)","v":""},{"$f":"IF('Assessment Data'!D27=Rubric!B$3,4,IF('Assessment Data'!D27=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E27=Rubric!C$3,4,IF('Assessment Data'!E27=Rubric!C$4,3,IF('Assessment Data'!E27=Rubric!C$5,2,IF('Assessment Data'!E27=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F27=Rubric!D$3,4,IF('Assessment Data'!F27=Rubric!D$4,3,IF('Assessment Data'!F27=Rubric!D$5,2,IF('Assessment Data'!F27=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G27=Rubric!E$3,4,IF('Assessment Data'!G27=Rubric!E$4,3,IF('Assessment Data'!G27=Rubric!E$5,2,IF('Assessment Data'!G27=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C28=\"\",\"\",'Assessment Data'!C28)","v":""},{"$f":"IF('Assessment Data'!D28=Rubric!B$3,4,IF('Assessment Data'!D28=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E28=Rubric!C$3,4,IF('Assessment Data'!E28=Rubric!C$4,3,IF('Assessment Data'!E28=Rubric!C$5,2,IF('Assessment Data'!E28=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F28=Rubric!D$3,4,IF('Assessment Data'!F28=Rubric!D$4,3,IF('Assessment Data'!F28=Rubric!D$5,2,IF('Assessment Data'!F28=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G28=Rubric!E$3,4,IF('Assessment Data'!G28=Rubric!E$4,3,IF('Assessment Data'!G28=Rubric!E$5,2,IF('Assessment Data'!G28=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C29=\"\",\"\",'Assessment Data'!C29)","v":""},{"$f":"IF('Assessment Data'!D29=Rubric!B$3,4,IF('Assessment Data'!D29=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E29=Rubric!C$3,4,IF('Assessment Data'!E29=Rubric!C$4,3,IF('Assessment Data'!E29=Rubric!C$5,2,IF('Assessment Data'!E29=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F29=Rubric!D$3,4,IF('Assessment Data'!F29=Rubric!D$4,3,IF('Assessment Data'!F29=Rubric!D$5,2,IF('Assessment Data'!F29=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G29=Rubric!E$3,4,IF('Assessment Data'!G29=Rubric!E$4,3,IF('Assessment Data'!G29=Rubric!E$5,2,IF('Assessment Data'!G29=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C30=\"\",\"\",'Assessment Data'!C30)","v":""},{"$f":"IF('Assessment Data'!D30=Rubric!B$3,4,IF('Assessment Data'!D30=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E30=Rubric!C$3,4,IF('Assessment Data'!E30=Rubric!C$4,3,IF('Assessment Data'!E30=Rubric!C$5,2,IF('Assessment Data'!E30=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F30=Rubric!D$3,4,IF('Assessment Data'!F30=Rubric!D$4,3,IF('Assessment Data'!F30=Rubric!D$5,2,IF('Assessment Data'!F30=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G30=Rubric!E$3,4,IF('Assessment Data'!G30=Rubric!E$4,3,IF('Assessment Data'!G30=Rubric!E$5,2,IF('Assessment Data'!G30=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C31=\"\",\"\",'Assessment Data'!C31)","v":""},{"$f":"IF('Assessment Data'!D31=Rubric!B$3,4,IF('Assessment Data'!D31=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E31=Rubric!C$3,4,IF('Assessment Data'!E31=Rubric!C$4,3,IF('Assessment Data'!E31=Rubric!C$5,2,IF('Assessment Data'!E31=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F31=Rubric!D$3,4,IF('Assessment Data'!F31=Rubric!D$4,3,IF('Assessment Data'!F31=Rubric!D$5,2,IF('Assessment Data'!F31=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G31=Rubric!E$3,4,IF('Assessment Data'!G31=Rubric!E$4,3,IF('Assessment Data'!G31=Rubric!E$5,2,IF('Assessment Data'!G31=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C32=\"\",\"\",'Assessment Data'!C32)","v":""},{"$f":"IF('Assessment Data'!D32=Rubric!B$3,4,IF('Assessment Data'!D32=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E32=Rubric!C$3,4,IF('Assessment Data'!E32=Rubric!C$4,3,IF('Assessment Data'!E32=Rubric!C$5,2,IF('Assessment Data'!E32=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F32=Rubric!D$3,4,IF('Assessment Data'!F32=Rubric!D$4,3,IF('Assessment Data'!F32=Rubric!D$5,2,IF('Assessment Data'!F32=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G32=Rubric!E$3,4,IF('Assessment Data'!G32=Rubric!E$4,3,IF('Assessment Data'!G32=Rubric!E$5,2,IF('Assessment Data'!G32=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C33=\"\",\"\",'Assessment Data'!C33)","v":""},{"$f":"IF('Assessment Data'!D33=Rubric!B$3,4,IF('Assessment Data'!D33=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E33=Rubric!C$3,4,IF('Assessment Data'!E33=Rubric!C$4,3,IF('Assessment Data'!E33=Rubric!C$5,2,IF('Assessment Data'!E33=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F33=Rubric!D$3,4,IF('Assessment Data'!F33=Rubric!D$4,3,IF('Assessment Data'!F33=Rubric!D$5,2,IF('Assessment Data'!F33=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G33=Rubric!E$3,4,IF('Assessment Data'!G33=Rubric!E$4,3,IF('Assessment Data'!G33=Rubric!E$5,2,IF('Assessment Data'!G33=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C34=\"\",\"\",'Assessment Data'!C34)","v":""},{"$f":"IF('Assessment Data'!D34=Rubric!B$3,4,IF('Assessment Data'!D34=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E34=Rubric!C$3,4,IF('Assessment Data'!E34=Rubric!C$4,3,IF('Assessment Data'!E34=Rubric!C$5,2,IF('Assessment Data'!E34=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F34=Rubric!D$3,4,IF('Assessment Data'!F34=Rubric!D$4,3,IF('Assessment Data'!F34=Rubric!D$5,2,IF('Assessment Data'!F34=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G34=Rubric!E$3,4,IF('Assessment Data'!G34=Rubric!E$4,3,IF('Assessment Data'!G34=Rubric!E$5,2,IF('Assessment Data'!G34=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C35=\"\",\"\",'Assessment Data'!C35)","v":""},{"$f":"IF('Assessment Data'!D35=Rubric!B$3,4,IF('Assessment Data'!D35=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E35=Rubric!C$3,4,IF('Assessment Data'!E35=Rubric!C$4,3,IF('Assessment Data'!E35=Rubric!C$5,2,IF('Assessment Data'!E35=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F35=Rubric!D$3,4,IF('Assessment Data'!F35=Rubric!D$4,3,IF('Assessment Data'!F35=Rubric!D$5,2,IF('Assessment Data'!F35=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G35=Rubric!E$3,4,IF('Assessment Data'!G35=Rubric!E$4,3,IF('Assessment Data'!G35=Rubric!E$5,2,IF('Assessment Data'!G35=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C36=\"\",\"\",'Assessment Data'!C36)","v":""},{"$f":"IF('Assessment Data'!D36=Rubric!B$3,4,IF('Assessment Data'!D36=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E36=Rubric!C$3,4,IF('Assessment Data'!E36=Rubric!C$4,3,IF('Assessment Data'!E36=Rubric!C$5,2,IF('Assessment Data'!E36=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F36=Rubric!D$3,4,IF('Assessment Data'!F36=Rubric!D$4,3,IF('Assessment Data'!F36=Rubric!D$5,2,IF('Assessment Data'!F36=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G36=Rubric!E$3,4,IF('Assessment Data'!G36=Rubric!E$4,3,IF('Assessment Data'!G36=Rubric!E$5,2,IF('Assessment Data'!G36=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C37=\"\",\"\",'Assessment Data'!C37)","v":""},{"$f":"IF('Assessment Data'!D37=Rubric!B$3,4,IF('Assessment Data'!D37=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E37=Rubric!C$3,4,IF('Assessment Data'!E37=Rubric!C$4,3,IF('Assessment Data'!E37=Rubric!C$5,2,IF('Assessment Data'!E37=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F37=Rubric!D$3,4,IF('Assessment Data'!F37=Rubric!D$4,3,IF('Assessment Data'!F37=Rubric!D$5,2,IF('Assessment Data'!F37=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G37=Rubric!E$3,4,IF('Assessment Data'!G37=Rubric!E$4,3,IF('Assessment Data'!G37=Rubric!E$5,2,IF('Assessment Data'!G37=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C38=\"\",\"\",'Assessment Data'!C38)","v":""},{"$f":"IF('Assessment Data'!D38=Rubric!B$3,4,IF('Assessment Data'!D38=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E38=Rubric!C$3,4,IF('Assessment Data'!E38=Rubric!C$4,3,IF('Assessment Data'!E38=Rubric!C$5,2,IF('Assessment Data'!E38=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F38=Rubric!D$3,4,IF('Assessment Data'!F38=Rubric!D$4,3,IF('Assessment Data'!F38=Rubric!D$5,2,IF('Assessment Data'!F38=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G38=Rubric!E$3,4,IF('Assessment Data'!G38=Rubric!E$4,3,IF('Assessment Data'!G38=Rubric!E$5,2,IF('Assessment Data'!G38=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C39=\"\",\"\",'Assessment Data'!C39)","v":""},{"$f":"IF('Assessment Data'!D39=Rubric!B$3,4,IF('Assessment Data'!D39=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E39=Rubric!C$3,4,IF('Assessment Data'!E39=Rubric!C$4,3,IF('Assessment Data'!E39=Rubric!C$5,2,IF('Assessment Data'!E39=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F39=Rubric!D$3,4,IF('Assessment Data'!F39=Rubric!D$4,3,IF('Assessment Data'!F39=Rubric!D$5,2,IF('Assessment Data'!F39=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G39=Rubric!E$3,4,IF('Assessment Data'!G39=Rubric!E$4,3,IF('Assessment Data'!G39=Rubric!E$5,2,IF('Assessment Data'!G39=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C40=\"\",\"\",'Assessment Data'!C40)","v":""},{"$f":"IF('Assessment Data'!D40=Rubric!B$3,4,IF('Assessment Data'!D40=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E40=Rubric!C$3,4,IF('Assessment Data'!E40=Rubric!C$4,3,IF('Assessment Data'!E40=Rubric!C$5,2,IF('Assessment Data'!E40=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F40=Rubric!D$3,4,IF('Assessment Data'!F40=Rubric!D$4,3,IF('Assessment Data'!F40=Rubric!D$5,2,IF('Assessment Data'!F40=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G40=Rubric!E$3,4,IF('Assessment Data'!G40=Rubric!E$4,3,IF('Assessment Data'!G40=Rubric!E$5,2,IF('Assessment Data'!G40=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C41=\"\",\"\",'Assessment Data'!C41)","v":""},{"$f":"IF('Assessment Data'!D41=Rubric!B$3,4,IF('Assessment Data'!D41=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E41=Rubric!C$3,4,IF('Assessment Data'!E41=Rubric!C$4,3,IF('Assessment Data'!E41=Rubric!C$5,2,IF('Assessment Data'!E41=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F41=Rubric!D$3,4,IF('Assessment Data'!F41=Rubric!D$4,3,IF('Assessment Data'!F41=Rubric!D$5,2,IF('Assessment Data'!F41=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G41=Rubric!E$3,4,IF('Assessment Data'!G41=Rubric!E$4,3,IF('Assessment Data'!G41=Rubric!E$5,2,IF('Assessment Data'!G41=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C42=\"\",\"\",'Assessment Data'!C42)","v":""},{"$f":"IF('Assessment Data'!D42=Rubric!B$3,4,IF('Assessment Data'!D42=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E42=Rubric!C$3,4,IF('Assessment Data'!E42=Rubric!C$4,3,IF('Assessment Data'!E42=Rubric!C$5,2,IF('Assessment Data'!E42=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F42=Rubric!D$3,4,IF('Assessment Data'!F42=Rubric!D$4,3,IF('Assessment Data'!F42=Rubric!D$5,2,IF('Assessment Data'!F42=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G42=Rubric!E$3,4,IF('Assessment Data'!G42=Rubric!E$4,3,IF('Assessment Data'!G42=Rubric!E$5,2,IF('Assessment Data'!G42=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C43=\"\",\"\",'Assessment Data'!C43)","v":""},{"$f":"IF('Assessment Data'!D43=Rubric!B$3,4,IF('Assessment Data'!D43=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E43=Rubric!C$3,4,IF('Assessment Data'!E43=Rubric!C$4,3,IF('Assessment Data'!E43=Rubric!C$5,2,IF('Assessment Data'!E43=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F43=Rubric!D$3,4,IF('Assessment Data'!F43=Rubric!D$4,3,IF('Assessment Data'!F43=Rubric!D$5,2,IF('Assessment Data'!F43=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G43=Rubric!E$3,4,IF('Assessment Data'!G43=Rubric!E$4,3,IF('Assessment Data'!G43=Rubric!E$5,2,IF('Assessment Data'!G43=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C44=\"\",\"\",'Assessment Data'!C44)","v":""},{"$f":"IF('Assessment Data'!D44=Rubric!B$3,4,IF('Assessment Data'!D44=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E44=Rubric!C$3,4,IF('Assessment Data'!E44=Rubric!C$4,3,IF('Assessment Data'!E44=Rubric!C$5,2,IF('Assessment Data'!E44=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F44=Rubric!D$3,4,IF('Assessment Data'!F44=Rubric!D$4,3,IF('Assessment Data'!F44=Rubric!D$5,2,IF('Assessment Data'!F44=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G44=Rubric!E$3,4,IF('Assessment Data'!G44=Rubric!E$4,3,IF('Assessment Data'!G44=Rubric!E$5,2,IF('Assessment Data'!G44=Rubric!E$6,1,\"\"))))","v":""}]
[{"$f":"IF('Assessment Data'!C45=\"\",\"\",'Assessment Data'!C45)","v":""},{"$f":"IF('Assessment Data'!D45=Rubric!B$3,4,IF('Assessment Data'!D45=Rubric!B$4,2,\"\"))","v":""},{"$f":"IF('Assessment Data'!E45=Rubric!C$3,4,IF('Assessment Data'!E45=Rubric!C$4,3,IF('Assessment Data'!E45=Rubric!C$5,2,IF('Assessment Data'!E45=Rubric!C$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!F45=Rubric!D$3,4,IF('Assessment Data'!F45=Rubric!D$4,3,IF('Assessment Data'!F45=Rubric!D$5,2,IF('Assessment Data'!F45=Rubric!D$6,1,\"\"))))","v":""},{"$f":"IF('Assessment Data'!G45=Rubric!E$3,4,IF('Assessment Data'!G45=Rubric!E$4,3,IF('Assessment Data'!G45=Rubric!E$5,2,IF('Assessment Data'!G45=Rubric!E$6,1,\"\"))))","v":""}]

{"sheet":"Rubric","index":2,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[null,"C1","C2","C3","C4"]
[null,"(To reveal scoring choices using a PC, click twice.\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\nUsing a Mac: Click once, then click the drop-down arrow)","(To reveal scoring choices using a PC, click twice.\nUsing a Mac: Click once, then click the drop-down arrow)"]
["Fully meets","HIGH: Identifies a key passage and shows at least a general understanding of the passage and the text. Explanation may be partial or mechanical (not contextualized), but is effective enough to demonstrate understanding of the passage and the text. ","LEVEL 4: Describes HOW they used TWO OR MORE strategies to understand a specific text.","LEVEL 4: Accurately identifies the genre and some main features. Explains with some detail and insight how the chosen genre aligns with the author’s purpose.","LEVEL 4: Identifies SPECIFIC source(s) and explains in some detail how the source(s) helped ACCURATELY explain the text. "]
["Nearly meets","LOW: Response suggests lack of understanding. Student might: (1) Select an inappropriate passage; (2) Select a key passage but misunderstand it or the text as a whole; (3) Declare but not explain the passage’s importance; OR (4) No passage is selected. ","LEVEL 3: Describes WHY a single chosen strategy is effective in understanding a specific text. (May name more than one strategy.)  Or, describes why one or several strategies work IN GENERAL without connecting directly to a specific text.","LEVEL 3: Accurately identifies the genre and explains its appropriateness for the author’s purpose, but doesn’t identify its main features.","LEVEL 3: Identifies a source or sources; in their explanation, shows some analogical or associative understanding to link text and source."]
["Beginning awareness",null,"LEVEL 2: Names one or several strategies, but shows limited understanding of what makes a strategy effective.","LEVEL 2: Shows some limited understanding of how genre and purpose align. May name the genre and some features. Or, shows limited understanding of the purpose of the text.","LEVEL 2: Identifies type(s) of source(s). Explains generally how sources contributed to their understanding of the text. Response may be limited by limited understanding of text or genre."]
["No awareness",null,"LEVEL 1: (1) Chosen strategies do not reflect college-level techniques taught in the class; or (2) Strategies are poorly chosen for the text, and no explanation is provided; or (3) No strategies are identified.","LEVEL 1: Does not explain why the author employs this genre. Does not attempt to name the genre or any of its features. May not understand the concept of genre.","LEVEL 1: Does not identify (appropriate) sources of information, or explain how they connect to text. Failure to understand concepts of genre or sources may mean response is nonsensical or absent."]