{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["P(1)","P(2)","P(3)","Score","P(1an)","P(2an)","P(3an)"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":1},"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":"P(1)","index":0,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["In the range A5:E16, add Conditional Formatting to format the lowest price in row"]
[]
[]
["Crank'ys","Bay Air","Compressor R Us","Mech-Aid","Han's Shop","Vendor for Low Bid"]
[38.99,48.6,43.53,40.08,47.92,{"$f":"INDEX($A$4:$E$4,MATCH(MIN(A5:E5),A5:E5,0))","v":"Crank'ys"}]
[57.68,31.8,52.78,31.42,55.19,{"$f":"INDEX($A$4:$E$4,MATCH(MIN(A6:E6),A6:E6,0))","v":"Mech-Aid"}]
[53.32,32.64,37.69,48.29,41.59,"Bay Air"]
[35.200000000000003,40.549999999999997,32.65,36.81,41.14,"Compressor R Us"]
[56.72,47.16,36.42,49.56,39.25,"Compressor R Us"]
[47.91,35.08,51.129999999999995,49.84,42.12,"Bay Air"]
[34.81,35.11,48.629999999999995,33.32,37.83,"Mech-Aid"]
[42.25,35.76,58.6,46.28,40.53,"Bay Air"]
[40.14,42.31,37.619999999999997,59.97,42.57,"Compressor R Us"]
[36.480000000000004,40.79,53.239999999999995,51.010000000000005,51.239999999999995,"Crank'ys"]
[38.57,40.06,54.71,39.700000000000003,54.730000000000004,"Crank'ys"]
[52.66,43.61,59.980000000000004,34.61,52.65,"Mech-Aid"]

{"sheet":"P(2)","index":1,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["In the range A4:A14, add Conditional Formatting to the project name that has had no numbers entered in the row."]
[]
[null,"Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7","Day 8","Day 9","Day 10"]
["Product 1",4]
["Product 2",null,null,null,null,null,null,null,4]
["Product 3",null,null,null,3,null,34]
["Product 4",null,null,34]
["Product 5",3]
["Product 6"]
["Product 7"]
["Product 8",null,null,null,3,null,4,null,5]
["Product 9",3,3]
["Product 10"]
["Product 11"]

{"sheet":"P(3)","index":2,"n_rows":66,"n_cols":1,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
["Create a Histogram Chart that shows the count or frequency for student scores."]
["You will first have to create a solution to count student scores between upper and lower limits such as 0 up to 10, 10 up to 20, and so on."]
["Be sure to create enough classes with upper and lower limits so that all values will be counted given that the Min = 6 and the Max = 98."]
["You can use whichever method you would like for counting: FREQUENCY function, COUNTIFS function, PivotTable."]
["After you have your count or frequency for student scores (Frequency Distribution), then you can create a Histogram Chart."]
[]
["Test Scores"]
[19]
[25]
[85]
[74]
[69]
[42]
[35]
[76]
[61]
[71]
[73]
[74]
[51]
[75]
[48]
[13]
[82]
[69]
[67]
[81]
[13]
[57]
[98]
[86]
[83]
[89]
[97]
[80]
[75]
[40]
[6]
[71]
[50]
[49]
[77]
[75]
[56]
[20]
[13]
[35]
[70]
[96]
[18]
[62]
[98]
[63]
[49]
[70]
[68]
[83]
[83]
[53]
[72]
[40]
[76]
[98]
[71]
[79]
[55]

{"sheet":"Score","index":3,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Graded Element","Possible Points","Your Points","Comments"]
["Conditional Formatting for smallest in each row like: =MIN($A5:$E5)=A5",5,{"$f":"B2","v":5},{"$f":"IF(B2<>C2,K2,\"\")","v":""},null,null,null,null,null,null,{"$f":"\"Didn't \"&A2","v":"Didn't Conditional Formatting for smallest in each row like: =MIN($A5:$E5)=A5"}]
[null,5,5,{"$f":"IF(B3<>C3,K3,\"\")","v":""},null,null,null,null,null,null,{"$f":"\"Didn't \"&A4","v":"Didn't Conditional Formatting for rows with nothing like:  =NOT(COUNTA(B4:K4))"}]
["Conditional Formatting for rows with nothing like:  =NOT(COUNTA(B4:K4))",5,5,"",null,null,null,null,null,null,{"$f":"\"Didn't \"&#REF!","v":{"$error":"#REF!"}}]
[null,5,{"$f":"B5","v":5},"",null,null,null,null,null,null,"Didn't "]
["Frequency Distribution",5,5,"",null,null,null,null,null,null,"Didn't Frequency Distribution"]
["Histogram",5,{"$f":"B7","v":5},"",null,null,null,null,null,null,{"$f":"\"No \"&A7&\" The perfect answer to why we need to unpivot is 'so we can do any Data Analysis task such as Sort, Filter, PivotTable'.\"","v":"No Histogram The perfect answer to why we need to unpivot is 'so we can do any Data Analysis task such as Sort, Filter, PivotTable'."}]
[null,null,{"$f":"IF(C9=\"Late\",-0.25*SUM(C1:C7),\"\")","v":""},{"$f":"IF($C$9=\"Late\",\"Late\",\"\")","v":""}]
["Total Possible:",{"$f":"SUM(B2:B7)","v":30},null,{"$f":"IF($C$9=\"Late\",\"In accordance with the syllabus, late points are subtracted from score (25%).\",\"\")","v":""}]
[null,null,{"$f":"SUM(C2:C8)","v":30}]

{"sheet":"P(1an)","index":4,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["In the range A5:E16, add Conditional Formatting to format the lowest price in row"]
[]
[]
["Crank'ys","Bay Air","Compressor R Us","Mech-Aid","Han's Shop","Vendor for Low Bid"]
[38.99,48.6,43.53,40.08,47.92,{"$f":"INDEX($A$4:$E$4,MATCH(MIN(A5:E5),A5:E5,0))","v":"Crank'ys"},null,{"$f":"MIN($A5:$E5)=A5","v":true},false,false,false,false]
[57.68,31.8,52.78,31.42,55.19,{"$f":"INDEX($A$4:$E$4,MATCH(MIN(A6:E6),A6:E6,0))","v":"Mech-Aid"},null,false,false,false,true,false]
[53.32,32.64,37.69,48.29,41.59,"Bay Air",null,false,true,false,false,false]
[35.200000000000003,40.549999999999997,32.65,36.81,41.14,"Compressor R Us",null,false,false,true,false,false]
[56.72,47.16,36.42,49.56,39.25,"Compressor R Us",null,false,false,true,false,false]
[47.91,35.08,51.129999999999995,49.84,42.12,"Bay Air",null,false,true,false,false,false]
[34.81,35.11,48.629999999999995,33.32,37.83,"Mech-Aid",null,false,false,false,true,false]
[42.25,35.76,58.6,46.28,40.53,"Bay Air",null,false,true,false,false,false]
[40.14,42.31,37.619999999999997,59.97,42.57,"Compressor R Us",null,false,false,true,false,false]
[36.480000000000004,40.79,53.239999999999995,51.010000000000005,51.239999999999995,"Crank'ys",null,true,false,false,false,false]
[38.57,40.06,54.71,39.700000000000003,54.730000000000004,"Crank'ys",null,true,false,false,false,false]
[52.66,43.61,59.980000000000004,34.61,52.65,"Mech-Aid",null,false,false,false,true,false]

{"sheet":"P(2an)","index":5,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["In the range A5:A15, add Conditional Formatting to the project name that has had no numbers entered in the row."]
[]
[null,"Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7","Day 8","Day 9","Day 10"]
["Product 1",4]
["Product 2",null,null,null,null,null,null,null,4]
["Product 3",null,null,null,3,null,34]
["Product 4",null,null,34]
["Product 5",3]
["Product 6"]
["Product 7"]
["Product 8",null,null,null,3,null,4,null,5]
["Product 9",3,3]
["Product 10"]
["Product 11"]

{"sheet":"P(3an)","index":6,"n_rows":66,"n_cols":7,"rows_kept":66,"cut":false,"hidden":true,"merged":[]}
["Create a Histogram Chart that shows the count or frequency for student scores."]
["You will first have to create a solution to count student scores between upper and lower limits such as 0 up to 10, 10 up to 20, and so on."]
[{"$f":"\"Be sure to create enough classes with upper and lower limits so that all values will be counted given that the \"&C7&\" = \"&D7&\" and the \"&C8&\" = \"&D8&\".\"","v":"Be sure to create enough classes with upper and lower limits so that all values will be counted given that the Min = 6 and the Max = 98."}]
["You can use whichever method you would like for counting: FREQUENCY function, COUNTIFS function, PivotTable."]
["After you have your count or frequency for student scores (Frequency Distribution), then you can create a Histogram Chart."]
[]
["Test Scores",null,"Min",{"$f":"MIN(A8:A66)","v":6}]
[19,null,"Max",{"$f":"MAX(A8:A66)","v":98}]
[25,null,null,null,null,null,"Histogram Chart Count of Student Scores"]
[85,null,"Class Limits","Score Upper Limit","Frequency"]
[74,null,{"$f":"\"         Score <= \"&D11","v":"         Score <= 10"},10,{"$f":"FREQUENCY(A8:A66,D11:D20)","v":1}]
[69,null,{"$f":"D11&\" < Score <= \"&D12","v":"10 < Score <= 20"},20,6]
[42,null,"20 < Score <= 30",30,1]
[35,null,"30 < Score <= 40",40,4]
[76,null,"40 < Score <= 50",50,5]
[61,null,"50 < Score <= 60",60,5]
[71,null,"60 < Score <= 70",70,9]
[73,null,"70 < Score <= 80",80,15]
[74,null,"80 < Score <= 90",90,8]
[51,null,"90 < Score <= 100",100,5]
[75,null,{"$f":"D20&\" < Score\"","v":"100 < Score"}]
[48]
[13]
[82]
[69]
[67]
[81,null,"Row Labels","Count of Test Scores"]
[13,null,"1-10",1]
[57,null,"11-20",6]
[98,null,"21-30",1]
[86,null,"31-40",4]
[83,null,"41-50",5]
[89,null,"51-60",5]
[97,null,"61-70",9]
[80,null,"71-80",15]
[75,null,"81-90",8]
[40,null,"91-100",5]
[6,null,"Grand Total",59]
[71]
[50,null,"Increment",10]
[49]
[77,null,"Class Limits","Score Lower Limit","Score Upper Limit","Frequency"]
[75,null,{"$f":"D43&\" <= Score < \"&E43","v":"0 <= Score < 10"},0,{"$f":"D43+$D$40","v":10},{"$f":"COUNTIFS($A$8:$A$66,\">=\"&D43,$A$8:$A$66,\"<\"&E43)","v":1}]
[56,null,{"$f":"D44&\" <= Score < \"&E44","v":"10 <= Score < 20"},{"$f":"E43","v":10},{"$f":"D44+$D$40","v":20},5]
[20,null,{"$f":"D45&\" <= Score < \"&E45","v":"20 <= Score < 30"},{"$f":"E44","v":20},30,2]
[13,null,"30 <= Score < 40",30,40,2]
[35,null,"40 <= Score < 50",40,50,6]
[70,null,"50 <= Score < 60",50,60,6]
[96,null,"60 <= Score < 70",60,70,7]
[18,null,"70 <= Score < 80",70,80,16]
[62,null,"80 <= Score < 90",80,90,9]
[98,null,"90 <= Score < 100",90,100,5]
[63,null,{"$f":"D53&\" <= Score\"","v":"100 <= Score"},100,110,0]
[49]
[70]
[68]
[83]
[83]
[53]
[72]
[40]
[76]
[98]
[71]
[79]
[55]