{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Score","Project(2)","Project(2an)"],"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":"Score","index":0,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Graded Element","Possible Points","Your Points","Comments"]
["Use Power Query to Unpivot Cross Tabulated Table",5,{"$f":"B2","v":5},{"$f":"IF(B2<>C2,K2,\"\")","v":""},null,null,null,null,null,null,{"$f":"\"Didn't \"&A2","v":"Didn't Use Power Query to Unpivot Cross Tabulated Table"}]
["Name the Excel Table a Smart Name (Different than Query)",5,5,{"$f":"IF(B3<>C3,K3,\"\")","v":""},null,null,null,null,null,null,"Didn't Name the Excel Table a Smart Name (Different than Query)"]
["Name the Query a Smart Name (Different than Excel Table)",5,5,"",null,null,null,null,null,null,"Didn't Name the Query a Smart Name (Different than Excel Table)"]
["Make sure each Field has correct Data Type",5,5,"",null,null,null,null,null,null,"Didn't Make sure each Field has correct Data Type"]
["Sort GPA Grade \"Z to A\" within Major (\"A to Z\")",5,5,"",null,null,null,null,null,null,"Didn't Sort GPA Grade \"Z to A\" within Major (\"A to Z\")"]
["Written Response",5,{"$f":"B7","v":5},"",null,null,null,null,null,null,{"$f":"\"No \"&A7","v":"No Written Response"}]
[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":"Project(2)","index":1,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,1,2,7]]}
["1) Unpivot the cross tabulated table (Use Power Query and put the output from Power Query on a new sheet). 2) Then Sort GPA Grade \"Z to A\" within Major (\"A to Z\"). 3) In Cell B3, describe (write)  what sort of information the sorted table provides and describe (write) why we had to unpivot the table to get this information. "]
[]
[]
[]
[]
[]
[]
[]
[null,"Average GPA Grade"]
[]
[null,"Class/Major","Accounting","Business","Law","Trade & Logistics","International Bus"]
[null,"Busn 216",4,3.6,3.1,3.1,3.9]
[null,"Busn 218",2.9,3.2,2.2999999999999998,2.7,3.1]
[null,"Busn 210",2.4,2.7,3,2.4,3.6]
[null,"Acc 121",2.9,2.4,3.5,2.9,2.2000000000000002]
[null,"Eng 101",3.1,2.8,3,2.1,3]
[null,"Math 97",2.7,2.8,2.9,3.2,3.2]

{"sheet":"Project(2an)","index":2,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":true,"merged":[[2,1,2,7]]}
["1) Unpivot the cross tabulated table. 2) Then Sort GPA Grade \"Z to A\" within Major (\"A to Z\"). 3) In Cell B3, describe (write)  what sort of information the sorted table provides and describe (write) why we had to unpivot the table to get this information."]
[]
[null,"The sorted table shows us what class each major did best in. We had to use the unpivot feature because it is NOT possible to sort the crosstabulated table to show the biggest grade for each major.",null,null,null,null,null,null,null,null,"I had to delete the Power Query and remove the Excel Table"]
[null,null,null,null,null,null,null,null,null,null,"feature so that I did not clutter up this Excel Workbook file with too"]
[null,null,null,null,null,null,null,null,null,null,"many Names (confusing for students)."]
[]
[]
[]
[null,"Average GPA Grade"]
[]
[null,"Class/Major","Accounting","Business","Law","Trade & Logistics","International Bus",null,null,"Class","Major","GPA"]
[null,"Busn 216",4,3.6,3.1,3.1,3.9,null,null,"Busn 216","Accounting",4]
[null,"Busn 218",2.9,3.2,2.2999999999999998,2.7,3.1,null,null,"Eng 101","Accounting",3.1]
[null,"Busn 210",2.4,2.7,3,2.4,3.6,null,null,"Busn 218","Accounting",2.9]
[null,"Acc 121",2.9,2.4,3.5,2.9,2.2000000000000002,null,null,"Acc 121","Accounting",2.9]
[null,"Eng 101",3.1,2.8,3,2.1,3,null,null,"Math 97","Accounting",2.7]
[null,"Math 97",2.7,2.8,2.9,3.2,3.2,null,null,"Busn 210","Accounting",2.4]
[null,null,null,null,null,null,null,null,null,"Busn 216","Business",3.6]
[null,null,null,null,null,null,null,null,null,"Busn 218","Business",3.2]
[null,null,null,null,null,null,null,null,null,"Eng 101","Business",2.8]
[null,null,null,null,null,null,null,null,null,"Math 97","Business",2.8]
[null,null,null,null,null,null,null,null,null,"Busn 210","Business",2.7]
[null,null,null,null,null,null,null,null,null,"Acc 121","Business",2.4]
[null,null,null,null,null,null,null,null,null,"Busn 216","International Bus",3.9]
[null,null,null,null,null,null,null,null,null,"Busn 210","International Bus",3.6]
[null,null,null,null,null,null,null,null,null,"Math 97","International Bus",3.2]
[null,null,null,null,null,null,null,null,null,"Busn 218","International Bus",3.1]
[null,null,null,null,null,null,null,null,null,"Eng 101","International Bus",3]
[null,null,null,null,null,null,null,null,null,"Acc 121","International Bus",2.2000000000000002]
[null,null,null,null,null,null,null,null,null,"Acc 121","Law",3.5]
[null,null,null,null,null,null,null,null,null,"Busn 216","Law",3.1]
[null,null,null,null,null,null,null,null,null,"Busn 210","Law",3]
[null,null,null,null,null,null,null,null,null,"Eng 101","Law",3]
[null,null,null,null,null,null,null,null,null,"Math 97","Law",2.9]
[null,null,null,null,null,null,null,null,null,"Busn 218","Law",2.2999999999999998]
[null,null,null,null,null,null,null,null,null,"Math 97","Trade & Logistics",3.2]
[null,null,null,null,null,null,null,null,null,"Busn 216","Trade & Logistics",3.1]
[null,null,null,null,null,null,null,null,null,"Acc 121","Trade & Logistics",2.9]
[null,null,null,null,null,null,null,null,null,"Busn 218","Trade & Logistics",2.7]
[null,null,null,null,null,null,null,null,null,"Busn 210","Trade & Logistics",2.4]
[null,null,null,null,null,null,null,null,null,"Eng 101","Trade & Logistics",2.1]