{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Score","Initial-Instructions","P(1)","CustomerCompressorReport"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":1,"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":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Problem","Description","Possible Points","Earned Points","Note"]
[null,"1)","Did you use Power Query in this test Workbook file, import the one fact table and three dimension tables from the file \"Test04Problem01SourceTables.xlsx\" into Power Query Editor window?",{"$f":"50/ROWS($C$3:$C$24)","v":2.2727272727272729},{"$f":"D3","v":2.2727272727272729}]
[null,null,"Did you add the proper Data Types to each table?",2.2727272727272729,2.2727272727272729]
[null,null,"Did you load the tables to the Power Pivot Data Model?",2.2727272727272729,2.2727272727272729]
[null,null,"Did you NOT load the tables to the worksheets?",2.2727272727272729,2.2727272727272729]
[null,null,"Did you create relationships for the Data Model tables?",2.2727272727272729,2.2727272727272729]
[null,null,"Did you create the Measure: TotalUnitsSold:=SUM(fSales[Quantity])?",2.2727272727272729,2.2727272727272729]
[null,null,"Did you add Number Formatting to the above Measure é?",2.2727272727272729,2.2727272727272729]
[null,null,"Did you create the Measure: TotalSales($):=SUM(fSales[Sales($)])?",2.2727272727272729,2.2727272727272729]
[null,null,"Did you add Number Formatting to the above Measure é?",2.2727272727272729,2.2727272727272729]
[null,null,"Did you create the Measure: TotalCosts($):=SUM(fSales[Costs($)])?",2.2727272727272729,2.2727272727272729]
[null,null,"Did you add Number Formatting to the above Measure é?",2.2727272727272729,2.2727272727272729]
[null,null,"Did you create the Measure: Profit($):=[TotalSales($)]-[TotalCosts($)]?",2.2727272727272729,2.2727272727272729]
[null,null,"Did you add Number Formatting to the above Measure é?",2.2727272727272729,2.2727272727272729]
[null,null,"Did you create the Measure: NumberTransactions:=COUNTROWS(fSales)?",2.2727272727272729,2.2727272727272729]
[null,null,"Did you add Number Formatting to the above Measure é?",2.2727272727272729,2.2727272727272729]
[null,null,"Did you hide fields that you do not need to see in the PivotTable Field List?",2.2727272727272729,2.2727272727272729]
[null,null,"Did you create the Year and Month Sales and Costs Report?",2.2727272727272729,2.2727272727272729]
[null,null,"Did you create the Manufacturer and Product Profit Report?",2.2727272727272729,2.2727272727272729]
[null,null,"Did you create the Customer Profit Report?",2.2727272727272729,2.2727272727272729]
[null,null,"Did you create the Column Chart for Customer Profit?",2.2727272727272729,2.2727272727272729]
[null,null,"Dies the chart have chart junk (elements that don't help deliver message)?",2.2727272727272729,2.2727272727272729]
[null,null,"Other",2.2727272727272729,2.2727272727272729]
[null,null,"Total Possible Points",{"$f":"SUM(D3:D24)","v":50.000000000000007}]
[null,null,"Is Test Submitted Past due date-time?","No",{"$f":"IF(D26=\"Yes\",-0.25*SUM(E3:E24),\"\")","v":""},{"$f":"IF(D26=\"Yes\",\"Deduction for late test\",\"\")","v":""}]
[null,null,null,"Your Earned Test Score:",{"$f":"SUM(E3:E26)","v":50.000000000000007}]
[]
[]
[null,"Be sure to scroll up to see whole score sheet.",null,null,null,"fall 2022"]

{"sheet":"Initial-Instructions","index":1,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["* This test covers everything in class up to minute marks 01:28:04 to 02:07:05 in the MECS class video #4"]
[null,"Test Instructions:"]
["1)","You must rename each test file so that the file name contains your name."]
[null,"For example, if your name is “Sioux Noline” and the test file has the name “Busn218Fall2022Test08.xlsm\","]
[null,"you MUST rename the file to become: “SiouxNoline Busn218Fall2022Test08.xlsm”."]
[null,"Tests that do not follow this naming rule are scored as zero."]
["2)","The Excel test file MUST use the file extension \".xlsm\". Tests that do not follow this rule are scored as zero."]
["3)","This test has one problem on the worksheets with the name \"P(1)\". You will also have to use other files for this problem."]
["4)","Late tests without a documentable emergency are assessed as a 25% deduction."]
[null,"You can hand in tests late if a documentable emergency occurs, like documented deaths or medical emergencies."]
[5,"The test scores earned will count toward your grade for the class."]
[]
["If you have questions you can contact Michael Girvin: mgirvin@highline.edu, 206-592-3562, or office 29-307."]
[null,null,null,null,null,"Fall, 2022 File"]

{"sheet":"P(1)","index":2,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Data: You are given data from a compressor distributor company that sells compressors to the auto industry customers: Ford, GM, Toyota and Honda."]
[null,"Goal: Import one fact table and three dimension tables from an Excel file into the Power Pivot Data Model in this test Workbook file, build a Data Model and then create the required reports and visualizations"]
[null,"Suggested steps to complete this data analysis task:"]
[null,"1) Open the Excel file named \"Test08Problem01SourceTables.xlsx\" and look at the one fact table and three dimension tables on the worksheet named \"Tables\""]
[null,"2) Close the Excel file named \"Test08Problem01SourceTables.xlsx\""]
[null,"3) For this Power Pivot problem, be sure to save the test file after each step."]
[null,"At minimum, save after you complete the Power Query step, save after the Relationships step, save after the DAX Measure step, save after the reporting and visualization step. "]
[null,"4) Using Power Query in this test Workbook file, import the one fact table and three dimension tables from the file \"Test08Problem01SourceTables.xlsx\" and load them to the Data Model"]
[null,"HINT: When you load the tables to the Data Model, in the Import Data dialog box, be sure to select \"Only Create Connection\" and \"Add data to the Data Model\". Picture of this dialog box is shown to the right =>"]
[null,"5) Create Relationships for the Data Model tables"]
[null,"6) Create the two DAX Measures:"]
[null,"1. Total Sales ($):=SUM(fSales[Sales])"]
[null,"2. Transactional Count:=COUNTROWS(fSales)"]
[null,"7) Hide fields that you do not need to see in the PivotTable Field List"]
[null,"8) Picture of finished Power Pivot Data Model is shown to right =>"]
[null,"9) Create the Data Model PivotTable reports and visualizations on the Worksheet named \"CustomerCompressorReport\" as shown in the picture below ê"]
["MECS video #4 at the 01:28:37 minute mark shows how to complete a data analysis task that requires importing tables from an Excel file and create reports and charts using Excel Power Pivot. Link to right =>",null,null,null,null,null,null,null,null,null,null,"https://www.youtube.com/watch?v=TjSnQ4VDHTE&list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW&index=7&t=5317s"]
["Do not copy and paste work previously done.",null,null,null,null,null,null,null,null,null,"MECS04"]
["Do not ask for help with test or work with others on test."]
["It is OK to re-watch class videos, read pdf notes, look at the Excel files for this class, or contact Michael Girvin with questions: mgirvin@highline.edu, 206-592-3562, or office 29-307."]

{"sheet":"CustomerCompressorReport","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}