{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Score","Initial-Instructions","P(1)","P(2)","P(3)","P(4)","P(5)"],"not_rendered":{"charts":0,"images":1,"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":59,"n_cols":6,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Problem","Description","Possible Points","Earned Points","Note"]
[null,"1)","Did you drag Phone field to Rows area?",{"$f":"100/ROWS($C$3:$C$53)","v":1.9607843137254901},{"$f":"D3","v":1.9607843137254901}]
[null,null,"Did you drag Phone field to Values area for Count calculation?",1.9607843137254901,1.9607843137254901]
[null,null,"Did you drag Phone field to Values area for % Count calculation?",1.9607843137254901,1.9607843137254901]
[null,null,"Did you create Informative Report Column Header Names, like Phones Purchased, Count, % Count?",1.9607843137254901,1.9607843137254901]
[null,"2)","Use a Line Chart to show Trends",1.9607843137254901,1.9607843137254901]
[null,null,"Use an Informative Chart Title like \"Sales By Year\"",1.9607843137254901,1.9607843137254901]
[null,null,"Show Sales in Vertical Axis",1.9607843137254901,1.9607843137254901]
[null,null,"Show Years in Horizontal Axis",1.9607843137254901,1.9607843137254901]
[null,null,"Did you remove unnecessary chart elements that do not contribute to message?",1.9607843137254901,1.9607843137254901]
[null,"3)","Download File Part:",1.9607843137254901,1.9607843137254901]
[null,null,"Did you go to this web site: https://data.seattle.gov/dataset/Trees/f93e-gna8",1.9607843137254901,1.9607843137254901]
[null,null,"Did you NOT download it to the default location on your computer.",1.9607843137254901,1.9607843137254901]
[null,null,"Did you use the Save As dialog box to save the csv file to your Busn 218 folder.",1.9607843137254901,1.9607843137254901]
[null,null,"Did you change the csv file name from \"Trees.csv\" to \"YourNameTrees.csv\". If your name is Ty Cox, your file name must be: \"TyCoxTrees.csv\". If you do not rename this file, your test score will be zero.",1.9607843137254901,1.9607843137254901]
[null,null,"Power Query Part:",1.9607843137254901,1.9607843137254901]
[null,null,"Did you import your csv file into the Power Query Editor",1.9607843137254901,1.9607843137254901]
[null,null,"Did you choose the fields: OBJECTID, COMPKEY, UNITID, UNITDESC, PRIMARYDISTRICTCD, SPACETYPE, COMMON_NAME",1.9607843137254901,1.9607843137254901]
[null,null,"Did you Filter the [SPACETYPE] field to show only \"GRAVEL\"",1.9607843137254901,1.9607843137254901]
[null,null,"Did you Filter the [PRIMARYDISTRICTCD] field to show only \"DISTRICT1\"",1.9607843137254901,1.9607843137254901]
[null,null,"Did you Load the 31 records to the Test problem Excel Worksheet",1.9607843137254901,1.9607843137254901]
[null,"4)","From the people web site did you already downloaded the zipped folder named \"Test03Problem04TextFiles.zip\"?",1.9607843137254901,1.9607843137254901]
[null,null,"Power Query Part:",1.9607843137254901,1.9607843137254901]
[null,null,"Did you use Power Query to import the three csv files into the Power Query Editor?",1.9607843137254901,1.9607843137254901]
[null,null,"Did you combine the three csv files into one table?",1.9607843137254901,1.9607843137254901]
[null,null,"Did you add correct Data Types to table?",1.9607843137254901,1.9607843137254901]
[null,null,"Did you load table to the PivotTable Cache?",1.9607843137254901,1.9607843137254901]
[null,null,"Did you NOT load it to the Worksheet?",1.9607843137254901,1.9607843137254901]
[null,null,"PivotTable Part:",1.9607843137254901,1.9607843137254901]
[null,null,"Did you drag Department field to Rows area?",1.9607843137254901,1.9607843137254901]
[null,null,"Did you drag Hourly Wage Rate field to Values area for Average calculation?",1.9607843137254901,1.9607843137254901]
[null,null,"Did you drag Hourly Wage Rate field to Values area for Min calculation?",1.9607843137254901,1.9607843137254901]
[null,null,"Did you drag Hourly Wage Rate field to Values area for Max calculation?",1.9607843137254901,1.9607843137254901]
[null,null,"Did you use the Summarize Values By aggregate function Average?",{"$f":"100/ROWS($C$3:$C$53)","v":1.9607843137254901},{"$f":"D35","v":1.9607843137254901}]
[null,null,"Did you use the Summarize Values By aggregate function Min?",1.9607843137254901,1.9607843137254901]
[null,null,"Did you use the Summarize Values By aggregate function Max?",1.9607843137254901,1.9607843137254901]
[null,null,"Count Formula Part:",1.9607843137254901,1.9607843137254901]
[null,null,"Did you create labels for conditional counting calculation, like \"Criteria\" and \"Count for 'Max of Hourly Rate' >100\"?",1.9607843137254901,1.9607843137254901]
[null,null,"Did you enter criteria into cell like: >100?",1.9607843137254901,1.9607843137254901]
[null,null,"Did you use the COUNTIFS function?",1.9607843137254901,1.9607843137254901]
[null,"5) ","Did you create the formula to being Product into Fact Table, like :=XLOOKUP([@ProductID],dProducts15[ProductID],dProducts15[Product])",1.9607843137254901,1.9607843137254901]
[null,null,"Did you create the formula to being Customer into Fact Table, like :=XLOOKUP([@CustomerID],dCustomer[CustomerID],dCustomer[CustomerName])",1.9607843137254901,1.9607843137254901]
[null,null,"For Product Report:",1.9607843137254901,1.9607843137254901]
[null,null,"Did you drag Product field to Rows area?",1.9607843137254901,1.9607843137254901]
[null,null,"Did you drag Units field to Values area for Sum calculation?",1.9607843137254901,1.9607843137254901]
[null,null,"Did you create Informative Report Column Header Names, like \"Total Units\"?",1.9607843137254901,1.9607843137254901]
[null,null,"For Customer Report:",1.9607843137254901,1.9607843137254901]
[null,null,"Did you drag Customer field to Rows area?",1.9607843137254901,1.9607843137254901]
[null,null,"Did you drag Units field to Values area for Sum calculation?",1.9607843137254901,1.9607843137254901]
[null,null,"Did you create Informative Report Column Header Names, like \"Total Units\"?",1.9607843137254901,1.9607843137254901]
[null,null,"Other",1.9607843137254901,1.9607843137254901]
[null,null,null,1.9607843137254901,1.9607843137254901]
[null,null,"Total Possible Points",{"$f":"SUM(D3:D53)","v":99.999999999999872}]
[null,null,"Is Test Submitted Past due date-time?","No",{"$f":"IF(D55=\"Yes\",-0.25*SUM(E3:E53),\"\")","v":""},{"$f":"IF(D55=\"Yes\",\"Deduction for late test\",\"\")","v":""}]
[null,null,null,"Your Earned Test Score:",{"$f":"SUM(E3:E55)","v":99.999999999999872}]
[]
[]
[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 00:00 to 01:28:37 in MECS 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 “Busn218Fall2022Test03.xlsm\","]
[null,"you MUST rename the file to become: “SiouxNoline Busn218Fall2022Test03.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 five problems on the worksheets with the names \"P(1)\", \"P(2)\", \"P(3)\", \"P(4)\" and \"P(5)\". You will also have to use other files for these problems."]
["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 e-mail me at mgirvin@highline.edu"]
[null,null,null,null,null,"Fall, 2022 File"]

{"sheet":"P(1)","index":2,"n_rows":569,"n_cols":10,"rows_kept":569,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Goal: ","Create a Count and % Count Report, similar to Example #4 in MECS video #4 at the 15:58 minute mark. Link to right =>",null,null,null,null,null,null," https://www.youtube.com/watch?v=TjSnQ4VDHTE&list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW&index=8&t=958s"]
[null,null,"Data = about 560 rows = "]
[null,null,"From sample of Phone Purchases"]
[null,"Create the Report on this Worksheet."]
[null,"Do not copy and paste work previously done."]
[null,"Do not ask for help with test or work with others on test."]
[null,"It is OK to re-watch class videos, read pdf notes, look at the Excel files for this class, or e-mail Michael Girvin at mgirvin@highline.edu with questions."]
[]
[null,null,"Phones Purchased"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 10"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Apple iPhone 10"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Apple iPhone 10"]
[null,null,"Apple iPhone 9"]
[null,null,"Moto G Plus"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Pixel"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"LeEco"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"LeEco"]
[null,null,"Apple iPhone 9"]
[null,null,"Moto G Plus"]
[null,null,"Moto G Plus"]
[null,null,"Samsung Galaxy S5"]
[null,null,"LeEco"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S5"]
[null,null,"LeEco"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 10"]
[null,null,"Apple iPhone 10"]
[null,null,"Pixel"]
[null,null,"Samsung Galaxy S8"]
[null,null,"LeEco"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 9"]
[null,null,"LeEco"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 10"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Pixel"]
[null,null,"LeEco"]
[null,null,"Apple iPhone 10"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 10"]
[null,null,"LeEco"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S5"]
[null,null,"LeEco"]
[null,null,"Apple iPhone 10"]
[null,null,"LeEco"]
[null,null,"Apple iPhone 10"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Moto G Plus"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 10"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Apple iPhone 10"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 10"]
[null,null,"LeEco"]
[null,null,"LeEco"]
[null,null,"Pixel"]
[null,null,"Samsung Galaxy S8"]
[null,null,"LeEco"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 10"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Samsung Galaxy S8"]
[null,null,"LeEco"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 10"]
[null,null,"Apple iPhone 10"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Pixel"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Pixel"]
[null,null,"Pixel"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 10"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"LeEco"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 10"]
[null,null,"LeEco"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 10"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 10"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"Moto G Plus"]
[null,null,"Samsung Galaxy S8"]
[null,null,"LeEco"]
[null,null,"Apple iPhone 10"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Pixel"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Apple iPhone 10"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 10"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 10"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 9"]
[null,null,"LeEco"]
[null,null,"Pixel"]
[null,null,"Pixel"]
[null,null,"LeEco"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 10"]
[null,null,"Apple iPhone 10"]
[null,null,"Apple iPhone 10"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 10"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Apple iPhone 10"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Apple iPhone 10"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 10"]
[null,null,"LeEco"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 10"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Pixel"]
[null,null,"Apple iPhone 9"]
[null,null,"Moto G Plus"]
[null,null,"LeEco"]
[null,null,"Apple iPhone 10"]
[null,null,"Apple iPhone 10"]
[null,null,"Samsung Galaxy S5"]
[null,null,"LeEco"]
[null,null,"Apple iPhone 10"]
[null,null,"Apple iPhone 10"]
[null,null,"Pixel"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S5"]
[null,null,"LeEco"]
[null,null,"Pixel"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 10"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"Pixel"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Apple iPhone 10"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Apple iPhone 10"]
[null,null,"LeEco"]
[null,null,"LeEco"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 10"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 10"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 10"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"Pixel"]
[null,null,"LeEco"]
[null,null,"Apple iPhone 10"]
[null,null,"LeEco"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 10"]
[null,null,"Apple iPhone 9"]
[null,null,"LeEco"]
[null,null,"LeEco"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Pixel"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 10"]
[null,null,"Apple iPhone 9"]
[null,null,"LeEco"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"LeEco"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"LeEco"]
[null,null,"LeEco"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 10"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Apple iPhone 10"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 10"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"LeEco"]
[null,null,"Apple iPhone 9"]
[null,null,"Moto G Plus"]
[null,null,"Apple iPhone 10"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Pixel"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 10"]
[null,null,"LeEco"]
[null,null,"Apple iPhone 10"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"Pixel"]
[null,null,"Moto G Plus"]
[null,null,"Pixel"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 10"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Pixel"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 10"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Pixel"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Moto G Plus"]
[null,null,"Pixel"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"LeEco"]
[null,null,"Moto G Plus"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Apple iPhone 10"]
[null,null,"Moto G Plus"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 10"]
[null,null,"LeEco"]
[null,null,"LeEco"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Pixel"]
[null,null,"Moto G Plus"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 10"]
[null,null,"LeEco"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"LeEco"]
[null,null,"Apple iPhone 10"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"LeEco"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"LeEco"]
[null,null,"LeEco"]
[null,null,"Apple iPhone 10"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Pixel"]
[null,null,"Apple iPhone 10"]
[null,null,"Apple iPhone 10"]
[null,null,"Pixel"]
[null,null,"Apple iPhone 10"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"LeEco"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Pixel"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Moto G Plus"]
[null,null,"Apple iPhone 9"]
[null,null,"LeEco"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"LeEco"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 10"]
[null,null,"LeEco"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Pixel"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"LeEco"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Pixel"]
[null,null,"Apple iPhone 9"]
[null,null,"Moto G Plus"]
[null,null,"Moto G Plus"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 9"]
[null,null,"LeEco"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"LeEco"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 10"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 10"]
[null,null,"Pixel"]
[null,null,"Pixel"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 10"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Pixel"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Samsung Galaxy S5"]
[null,null,"LeEco"]
[null,null,"Apple iPhone 10"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 10"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"LeEco"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Apple iPhone 10"]
[null,null,"LeEco"]
[null,null,"Apple iPhone 10"]
[null,null,"Apple iPhone 10"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 9"]
[null,null,"LeEco"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"LeEco"]
[null,null,"Apple iPhone 10"]
[null,null,"LeEco"]
[null,null,"LeEco"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Pixel"]
[null,null,"Samsung Galaxy S8"]
[null,null,"LeEco"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 9"]
[null,null,"Pixel"]
[null,null,"Apple iPhone 10"]
[null,null,"LeEco"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 9"]
[null,null,"LeEco"]
[null,null,"Apple iPhone 10"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 10"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Apple iPhone 10"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 9"]
[null,null,"LeEco"]
[null,null,"Apple iPhone 10"]
[null,null,"Apple iPhone 10"]
[null,null,"Pixel"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Moto G Plus"]
[null,null,"Samsung Galaxy S8"]
[null,null,"LeEco"]
[null,null,"Apple iPhone 10"]
[null,null,"Moto G Plus"]
[null,null,"LeEco"]
[null,null,"Apple iPhone 10"]
[null,null,"Pixel"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Pixel"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 10"]
[null,null,"Apple iPhone 10"]
[null,null,"LeEco"]
[null,null,"Moto G Plus"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 10"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"Moto G Plus"]
[null,null,"Samsung Galaxy S5"]
[null,null,"LeEco"]
[null,null,"Apple iPhone 10"]
[null,null,"LeEco"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S5"]
[null,null,"LeEco"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 10"]
[null,null,"LeEco"]
[null,null,"LeEco"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Apple iPhone 10"]
[null,null,"LeEco"]
[null,null,"Pixel"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 10"]
[null,null,"LeEco"]
[null,null,"Pixel"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Moto G Plus"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S5"]
[null,null,"LeEco"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Samsung Galaxy S5"]
[null,null,"LeEco"]
[null,null,"LeEco"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S8"]
[null,null,"Apple iPhone 9"]
[null,null,"Apple iPhone 9"]
[null,null,"Samsung Galaxy S5"]
[null,null,"Pixel"]
[null,null,"Apple iPhone 10"]

{"sheet":"P(2)","index":3,"n_rows":20,"n_cols":17,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Goal: ","Create a chart that shows the trend over time (year)."]
[null,"Hint:","If the horizontal axis does not show years, use the Select Data dialog box to"]
[null,null,"edit the horizontal categories (axis labels)."]
[null,null,"You can access the Select Data dialog box by right-clicking the chart."]
[null,"MECS video #4 at the 01:10:18 minute mark shows how to create the correct chart for showing trends: Line Chart.  Link to right =>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://www.youtube.com/watch?v=TjSnQ4VDHTE&list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW&index=8&t=4218s"]
[null,"Do not copy and paste work previously done."]
[null,"Do not ask for help with test or work with others on test."]
[null,"It is OK to re-watch class videos, read pdf notes, look at the Excel files for this class, or e-mail Michael Girvin at mgirvin@highline.edu with questions."]
[]
[null,null,"Year","Sales"]
[null,null,2005,577023]
[null,null,2006,566239]
[null,null,2007,580987]
[null,null,2008,603500]
[null,null,2009,605821]
[null,null,2010,669356]
[null,null,2011,664569]
[null,null,2012,717832]
[null,null,2013,700144]

{"sheet":"P(3)","index":4,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Back Story:"]
[null,"Your boss works in the maintenance department for the City of Seattle and needs to replace the gravel around trees in District 1. "]
[null,"She asks you to get a list of all trees in Seattle that are in District 1 and have gravel surrounding the base."]
["1)","Goal: Download Seattle tree data in a csv file and then import, clean, transform and load the data as a Table to this Excel Worksheet."]
["2)","Go to this web site: ",null,"https://data.seattle.gov/dataset/Trees/f93e-gna8"]
["3)","Download the csv file using the blue \"Text/CSV\" button using this guidelines:"]
[null,"1) DO NOT download it to the default location on your computer."]
[null,"2) Using the Save As dialog box save the csv file to your Busn 218 folder."]
[null,"3) When you download the csv file, change the file name from \"Trees.csv\" to \"YourNameTrees.csv\"."]
[null,"4) If your name is Ty Cox, your file name must be: \"TyCoxTrees.csv\". If you do not rename this file, your test score will be zero."]
["4) Using Power Query to import, clean, transform and load the data to the Worksheet, follow these steps:"]
[null,"1) Import your csv file into the Power Query Editor"]
[null,"2) Choose the fields: OBJECTID, COMPKEY, UNITID, UNITDESC, PRIMARYDISTRICTCD, SPACETYPE, COMMON_NAME"]
[null,"3) Filter the [SPACETYPE] field to show only \"GRAVEL\""]
[null,"4) Filter the [PRIMARYDISTRICTCD] field to show only \"DISTRICT1\""]
[null,"5) Load the 31 records to the Excel Worksheet below."]
["MECS video #4 at the 20:25 minute mark shows how to import a csv file and then clean and transform the data before loading to Worksheet.  Link to right =>",null,null,null,null,null,null,null,null,"https://www.youtube.com/watch?v=TjSnQ4VDHTE&list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW&index=8&t=1225s"]
["Do not copy and paste work previously done."]
["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 e-mail Michael Girvin at mgirvin@highline.edu with questions."]

{"sheet":"P(4)","index":5,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Back Story:"]
[null,"You have been given three separate csv files with hourly wage data for employees in the City of Seattle."]
[null,"You would like to know what the typical wage is by department for the City of Seattle, departments like: Arts & Culture, Fire Department, Mayor's Office, and others."]
[null,"You obtained three separate csv files that need to be combined before you can create a hourly wage report based on City of Seattle departments using a PivotTable."]
["1)","Goal: Combine three csv files into one table, load the table to the PivotTable Cache on this Worksheet, and then"]
[null,"calculate the average, minimum and maximum hourly wage by the different departments for the City of Seattle. (a picture of the top part of report is shown below for reference)."]
["2) ","After you create your report, off to the side create a formula (with a label) that counts how many departments have a max hourly wage of over $100."]
[null,"Hints:"]
[null,"1) From the people web site you already downloaded the zipped folder named \"Test03Problem04TextFiles.zip\". You will need to unzip that (right-click, Expand All)."]
[null,"2) Use Power Query to import, clean and transform the data, combine the csv files into one table, then load it to the PivotTable Cache."]
[null,"3) To create PivotTable, drag the Department field to the Rows area, then drag the Hourly Wage data field to the Values area three times and"]
[null,"change the aggregate calculation to Average, Min and Max."]
[null,"4) After you create your PivotTable with Average, Min and Max, notice that the Grand Total Row shows the Average, Min and Max for all hourly wage data for the City of Seattle."]
["MECS video #4 at the 55:05 minute mark shows how to import and combine csv files using the From Folder feature in Power Query.  Link to right =>",null,null,null,null,null,null,null,null,null,"https://www.youtube.com/watch?v=TjSnQ4VDHTE&list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW&index=8&t=3305s"]
["Do not copy and paste work previously done."]
["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 e-mail Michael Girvin at mgirvin@highline.edu with questions."]

{"sheet":"P(5)","index":6,"n_rows":142,"n_cols":14,"rows_kept":142,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Goal: To the right of the below tables, create two reports that show the sum of units for Product and Customer."]
[null,"Create PivotTable reports on this Worksheet."]
[null,"Name the report column header for Units \"Total Units\"."]
[null,"Hint: You will have to do some data modeling by using worksheet formula to create two new fields in the fUnits table, one for Product Name and one for Customer name."]
[null,"Data = about 130 rows = "]
[null,"From business sales data"]
["MECS video #4 at the MECS 01:17:51 minute mark shows how to using XLOOKUP to do Data Modeling.  Link to right =>",null,null,null,null,null,null,null,null,null,null,null,null,"https://www.youtube.com/watch?v=TjSnQ4VDHTE&list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW&index=8&t=4671s"]
["Do not copy and paste work previously done."]
["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 e-mail Michael Girvin at mgirvin@highline.edu with questions."]
[]
[]
[null,"Fact Table = fUnits",null,null,null,null,null,"Dimension Table = dProducts"]
[]
[null,"ProductID","CustomerID","UnitsSold",null,null,null,"ProductID","Product","FlightRange(M)","RetailPrice"]
[null,"1503-YI",2185,94,null,null,null,"1503-YI","Yanaki",35,27.95]
[null,"6816-BN",2255,22,null,null,null,"6816-BN","Bellen",25,26.95]
[null,"6816-BN",2045,67,null,null,null,"9720-CA","Carlota",20,31.95]
[null,"3414-AN",2010,21,null,null,null,"3414-AN","Aspen",40,37.950000000000003]
[null,"1503-YI",2080,13]
[null,"6816-BN",2150,16]
[null,"3414-AN",2220,123,null,null,null,"Dimension Table = dCustomer"]
[null,"6816-BN",2185,64]
[null,"6816-BN",2080,71,null,null,null,"CustomerID","CustomerName","Email","Contact"]
[null,"6816-BN",2220,120,null,null,null,2010,"Kite Flight",{"$f":"LOWER(dCustomer[[#This Row],[Contact]])&\"@\"&LOWER(SUBSTITUTE(dCustomer[[#This Row],[CustomerName]],\" \",\"\"))&\".com\"","v":"han@kiteflight.com"},"Han"]
[null,"6816-BN",2255,12,null,null,null,2045,"Fred Myer",{"$f":"LOWER(dCustomer[[#This Row],[Contact]])&\"@\"&LOWER(SUBSTITUTE(dCustomer[[#This Row],[CustomerName]],\" \",\"\"))&\".com\"","v":"tim@fredmyer.com"},"Tim"]
[null,"3414-AN",2080,69,null,null,null,2080,"Great Winds",{"$f":"LOWER(dCustomer[[#This Row],[Contact]])&\"@\"&LOWER(SUBSTITUTE(dCustomer[[#This Row],[CustomerName]],\" \",\"\"))&\".com\"","v":"sonia@greatwinds.com"},"Sonia"]
[null,"9720-CA",2220,25,null,null,null,2115,"Flying Toys",{"$f":"LOWER(dCustomer[[#This Row],[Contact]])&\"@\"&LOWER(SUBSTITUTE(dCustomer[[#This Row],[CustomerName]],\" \",\"\"))&\".com\"","v":"chantel@flyingtoys.com"},"Chantel"]
[null,"6816-BN",2220,24,null,null,null,2150,"Boomerang Man",{"$f":"LOWER(dCustomer[[#This Row],[Contact]])&\"@\"&LOWER(SUBSTITUTE(dCustomer[[#This Row],[CustomerName]],\" \",\"\"))&\".com\"","v":"rich@boomerangman.com"},"Rich"]
[null,"6816-BN",2045,49,null,null,null,2185,"Bailey Boomerangs",{"$f":"LOWER(dCustomer[[#This Row],[Contact]])&\"@\"&LOWER(SUBSTITUTE(dCustomer[[#This Row],[CustomerName]],\" \",\"\"))&\".com\"","v":"sioux@baileyboomerangs.com"},"Sioux"]
[null,"9720-CA",2220,32,null,null,null,2220,"Top Ten Toys",{"$f":"LOWER(dCustomer[[#This Row],[Contact]])&\"@\"&LOWER(SUBSTITUTE(dCustomer[[#This Row],[CustomerName]],\" \",\"\"))&\".com\"","v":"miki@toptentoys.com"},"Miki"]
[null,"3414-AN",2010,52,null,null,null,2255,"Flying High",{"$f":"LOWER(dCustomer[[#This Row],[Contact]])&\"@\"&LOWER(SUBSTITUTE(dCustomer[[#This Row],[CustomerName]],\" \",\"\"))&\".com\"","v":"gigi@flyinghigh.com"},"Gigi"]
[null,"1503-YI",2220,53]
[null,"1503-YI",2045,53]
[null,"1503-YI",2150,31]
[null,"1503-YI",2185,71]
[null,"1503-YI",2150,73]
[null,"1503-YI",2220,25]
[null,"3414-AN",2150,5]
[null,"3414-AN",2045,121]
[null,"9720-CA",2185,49]
[null,"6816-BN",2150,30]
[null,"6816-BN",2220,56]
[null,"1503-YI",2010,60]
[null,"1503-YI",2080,34]
[null,"9720-CA",2010,27]
[null,"1503-YI",2150,20]
[null,"1503-YI",2010,77]
[null,"3414-AN",2045,33]
[null,"1503-YI",2150,40]
[null,"3414-AN",2150,16]
[null,"9720-CA",2080,58]
[null,"6816-BN",2080,32]
[null,"6816-BN",2080,24]
[null,"9720-CA",2115,35]
[null,"9720-CA",2255,12]
[null,"9720-CA",2255,30]
[null,"6816-BN",2150,35]
[null,"6816-BN",2115,5]
[null,"6816-BN",2185,61]
[null,"9720-CA",2115,26]
[null,"3414-AN",2115,51]
[null,"9720-CA",2045,12]
[null,"6816-BN",2150,115]
[null,"1503-YI",2185,30]
[null,"6816-BN",2115,21]
[null,"1503-YI",2080,25]
[null,"9720-CA",2185,67]
[null,"1503-YI",2010,60]
[null,"1503-YI",2185,29]
[null,"1503-YI",2220,28]
[null,"6816-BN",2010,59]
[null,"1503-YI",2115,94]
[null,"1503-YI",2010,62]
[null,"9720-CA",2255,35]
[null,"1503-YI",2255,48]
[null,"3414-AN",2220,5]
[null,"1503-YI",2080,26]
[null,"9720-CA",2255,75]
[null,"3414-AN",2010,103]
[null,"1503-YI",2150,21]
[null,"3414-AN",2080,58]
[null,"9720-CA",2080,17]
[null,"3414-AN",2220,8]
[null,"3414-AN",2080,46]
[null,"3414-AN",2255,70]
[null,"3414-AN",2080,90]
[null,"6816-BN",2080,34]
[null,"6816-BN",2185,83]
[null,"6816-BN",2150,15]
[null,"1503-YI",2045,47]
[null,"9720-CA",2115,13]
[null,"3414-AN",2220,19]
[null,"9720-CA",2185,7]
[null,"6816-BN",2115,59]
[null,"3414-AN",2255,34]
[null,"6816-BN",2080,9]
[null,"6816-BN",2220,53]
[null,"6816-BN",2010,23]
[null,"9720-CA",2115,34]
[null,"6816-BN",2115,35]
[null,"3414-AN",2080,48]
[null,"6816-BN",2115,24]
[null,"1503-YI",2080,13]
[null,"3414-AN",2255,111]
[null,"6816-BN",2150,43]
[null,"3414-AN",2185,44]
[null,"1503-YI",2220,124]
[null,"9720-CA",2045,21]
[null,"6816-BN",2045,61]
[null,"9720-CA",2185,16]
[null,"1503-YI",2115,45]
[null,"6816-BN",2115,59]
[null,"1503-YI",2185,23]
[null,"9720-CA",2045,30]
[null,"9720-CA",2185,14]
[null,"9720-CA",2150,107]
[null,"3414-AN",2080,37]
[null,"6816-BN",2045,86]
[null,"3414-AN",2150,24]
[null,"6816-BN",2220,59]
[null,"1503-YI",2115,48]
[null,"3414-AN",2185,12]
[null,"9720-CA",2045,97]
[null,"9720-CA",2255,108]
[null,"3414-AN",2045,22]
[null,"3414-AN",2255,1]
[null,"6816-BN",2080,22]
[null,"9720-CA",2185,27]
[null,"9720-CA",2045,6]
[null,"9720-CA",2220,82]
[null,"1503-YI",2080,102]
[null,"3414-AN",2080,15]
[null,"6816-BN",2185,119]
[null,"3414-AN",2115,43]
[null,"1503-YI",2255,19]
[null,"6816-BN",2185,33]
[null,"1503-YI",2045,34]
[null,"9720-CA",2185,29]
[null,"3414-AN",2045,40]
[null,"9720-CA",2010,28]