{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Curricula Tool","Sheet4"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":4,"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":"Curricula Tool","index":0,"n_rows":122,"n_cols":9,"rows_kept":122,"cut":false,"hidden":false,"merged":[[3,1,3,4],[13,1,13,4],[13,5,13,7],[5,1,5,4],[5,5,5,7],[18,5,19,7],[16,5,16,6],[7,1,7,4],[4,1,4,4],[6,1,6,4],[8,1,8,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[12,1,12,4],[14,1,14,4],[15,1,15,4]]}
[]
[]
[null,null,null,null,null,null,null,null,"Dec"]
[null,"Criterion 1: Informed by Mastery Data",null,null,null,"Check If True","Weight","Total","Jan"]
[null,"1. At least 80% of students have not demonstrated mastery of this skill or content",null,null,null,false,4,{"$f":"IF(F5=TRUE,G5,\"\")","v":""},"Feb"]
[null,"Criterion 2: Necessary for Grade Level Progression",null,null,null,null,null,null,"March"]
[null,"2. This skill or content will be assessed on state achievement tests (and/or college prep test) this year",null,null,null,null,5,{"$f":"IF(F7=TRUE,G7,\"\")","v":""},"May"]
[null,"3. My district has a list of essential standards that explicitly includes this skill or content",null,null,null,false,5,{"$f":"IF(F8=TRUE,G8,\"\")","v":""},"April"]
[null,"4. Teachers in the next grade level expect mastery of this skill or content and will likely not teach it in whole-group instruction",null,null,null,false,4,{"$f":"IF(F9=TRUE,G9,\"\")","v":""},"June"]
[null,"5. Lessons that I plan to teach later on this year require mastery of this skill or content",null,null,null,null,3,"","July"]
[null,"6. This skill or content is necessary for future lessons and only taught once this year ",null,null,null,false,4,""]
[null,"7. Every single teacher in my grade intends to teach this skill or content",null,null,null,false,2,""]
[null,"8. I can remediate prior essential skills or content (that at least 80% of students have not mastered) in this lesson",null,null,null,false,3,""]
[null,"Criterion 3: Promotes Lifelong Success "]
[null,"9. Students will use this skill or content knowledge at least once a week in their adult life",null,null,null,false,5,{"$f":"IF(F15=TRUE,G15,\"\")","v":""}]
[null,"10. This skill or content will improve at least 2 of the following: collaboration, critical thinking, communication, or creativity",null,null,null,false,2,""]
[null,null,null,null,null,"Total",null,{"$f":"SUM(H5,H7:H13,H15:H16)","v":0}]
[]
[null,null,null,null,null,"High-value lessons score 15 or above."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2020-10-01","Review: Length"]
[null,"2020-10-02","Volume"]
[null,"2020-10-03","Weight"]
[null,"2020-10-04","Exploring Weight and Volume"]
[null,"2020-10-05","Capacity"]
[null,"2020-10-06","The Mean and the Median"]
[null,"2020-10-07","Calculating the Mean"]
[null,"2020-10-08","Calculator Memory"]
[null,"2020-10-09","Frequency Distributions"]
[null,"2020-10-10","Coordinate Grids"]
[null,"2020-11-01","The Length-of-Day Project Revisited"]
[null,"2020-11-02","National High/Low Temperatures Summaries"]
[null,"2020-11-03","Spinner Experiments"]
[null,"2020-11-04","Designing Spinners"]
[null,"2020-11-05","Using Data to Predict Outcomes"]
[null,"2020-11-06","Progress Check 11"]

{"sheet":"Sheet4","index":1,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["RAW DATA"]
[{"$f":"COUNTA(#REF!)","v":1},{"$f":"IF(IFERROR((COUNTIF(#REF!,\"TRUE\")/(COUNTA(#REF!)*C4)),0)>1,1,IFERROR((COUNTIF(#REF!,\"TRUE\")/(COUNTA(#REF!)*C4)),0))","v":0},{"$f":"1-B2","v":1}]
[{"$f":"IFERROR((COUNT(#REF!)/COUNTA(#REF!)),0)","v":0}]
[{"$f":"IFERROR((COUNTIF(#REF!,\"<15\")/COUNTA(#REF!)),0)","v":0},{"$f":"B9","v":1100},{"$f":"(B4/1000)-1","v":0.10000000000000009},{"$f":"1-C4","v":0.89999999999999991},null,"# selected to cut","how many more?","tied to checkbox"]
[{"$f":"IFERROR((COUNTIF(#REF!,\">14\")/COUNTA(#REF!)),0)","v":0},null,{"$f":"C4","v":0.10000000000000009},null,false,{"$f":"SUM(COUNTIFS(#REF!,{\"Sept\",\"Aug\"},#REF!,\"TRUE\"))","v":{"$error":"#REF!"}},{"$f":"ROUNDUP(IF(((Sheet4!A2*Sheet4!C4)/10)-F5>0,((Sheet4!A2*Sheet4!C4)/10)-F5,0),0)","v":{"$error":"#REF!"}},{"$f":"IF(E5=TRUE,0,G5)","v":{"$error":"#REF!"}}]
[null,{"$f":"ROUNDUP(C4*A2-B7,0)","v":{"$error":"#REF!"}}]
[null,{"$f":"COUNTIF(#REF!,\"TRUE\")","v":{"$error":"#REF!"}},{"$f":"IFERROR(ROUNDUP(COUNTIF(#REF!,\"TRUE\")/A2,2),0)","v":0}]
[null,{"$f":"(COUNT(#REF!))-B7","v":{"$error":"#REF!"}},null,false,"Oct",{"$f":"COUNTIFS(#REF!,\"Oct\",#REF!,\"TRUE\")","v":{"$error":"#REF!"}},{"$f":"ROUNDUP(IF(((Sheet4!A2*Sheet4!C4)/10)-F8>0,((Sheet4!A2*Sheet4!C4)/10)-F8,0),0)","v":{"$error":"#REF!"}},{"$f":"IF(D8=TRUE,0,G8)","v":{"$error":"#REF!"}}]
[null,1100,null,null,null,null,null,{"$f":"IF(D9=TRUE,0,G9)","v":0}]
[null,{"$f":"ROUNDUP(C4+1,1)","v":1.1000000000000001},null,null,null,null,null,0]
[null,null,null,false,"Nov",{"$f":"COUNTIFS(#REF!,\"Nov\",#REF!,\"TRUE\")","v":{"$error":"#REF!"}},{"$f":"ROUNDUP(IF(((Sheet4!$A$2*Sheet4!$C$4)/10)-F11>0,((Sheet4!$A$2*Sheet4!$C$4)/10)-F11,0),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,null,false,"Dec",{"$f":"COUNTIFS(#REF!,\"Dec\",#REF!,\"TRUE\")","v":{"$error":"#REF!"}},{"$f":"ROUNDUP(IF(((Sheet4!$A$2*Sheet4!$C$4)/10)-F12>0,((Sheet4!$A$2*Sheet4!$C$4)/10)-F12,0),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,1,null,false,"Jan",{"$f":"COUNTIFS(#REF!,\"Jan\",#REF!,\"TRUE\")","v":{"$error":"#REF!"}},{"$f":"ROUNDUP(IF(((Sheet4!$A$2*Sheet4!$C$4)/10)-F13>0,((Sheet4!$A$2*Sheet4!$C$4)/10)-F13,0),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,null,null,"Feb",{"$f":"COUNTIFS(#REF!,\"Feb\",#REF!,\"TRUE\")","v":{"$error":"#REF!"}},{"$f":"ROUNDUP(IF(((Sheet4!$A$2*Sheet4!$C$4)/10)-F14>0,((Sheet4!$A$2*Sheet4!$C$4)/10)-F14,0),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,null,null,"March",{"$f":"COUNTIFS(#REF!,\"March\",#REF!,\"TRUE\")","v":{"$error":"#REF!"}},{"$f":"ROUNDUP(IF(((Sheet4!$A$2*Sheet4!$C$4)/10)-F15>0,((Sheet4!$A$2*Sheet4!$C$4)/10)-F15,0),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,null,null,"April",{"$f":"COUNTIFS(#REF!,\"April\",#REF!,\"TRUE\")","v":{"$error":"#REF!"}},{"$f":"ROUNDUP(IF(((Sheet4!$A$2*Sheet4!$C$4)/10)-F16>0,((Sheet4!$A$2*Sheet4!$C$4)/10)-F16,0),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,null,false,"May",{"$f":"COUNTIFS(#REF!,\"May\",#REF!,\"TRUE\")","v":{"$error":"#REF!"}},{"$f":"ROUNDUP(IF(((Sheet4!$A$2*Sheet4!$C$4)/10)-F17>0,((Sheet4!$A$2*Sheet4!$C$4)/10)-F17,0),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,null,false,"June/July",{"$f":"SUM(COUNTIFS(#REF!,{\"June\",\"July\"},#REF!,\"TRUE\"))","v":{"$error":"#REF!"}},{"$f":"ROUNDDOWN(IF(((Sheet4!$A$2*Sheet4!$C$4)/10)-F18>0,((Sheet4!$A$2*Sheet4!$C$4)/10)-F18,0),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]