{"id":2079,"date":"2023-10-09T10:03:42","date_gmt":"2023-10-09T14:03:42","guid":{"rendered":"https:\/\/community.mis.temple.edu\/mis0855sec750fall2023\/?p=2079"},"modified":"2023-10-15T19:50:08","modified_gmt":"2023-10-15T23:50:08","slug":"what-you-need-to-know-for-week-7-class-on-march-7","status":"publish","type":"post","link":"https:\/\/community.mis.temple.edu\/mis0855sec750fall2023\/2023\/10\/09\/what-you-need-to-know-for-week-7-class-on-march-7\/","title":{"rendered":"What you need to know for Week 7"},"content":{"rendered":"<ol>\n<li>Read the following:<\/li>\n<\/ol>\n<ul>\n<li><a href=\"https:\/\/www.dropbox.com\/s\/zqr3yd5nz64qv16\/Moss%20-%202021%20-%20Five%20Times%20Excel%20Led%20to%20Disaster.pdf?dl=0\">Moss \u2013 2021 \u2013 Five Times Excel Led to Disaster<\/a><\/li>\n<li><a href=\"https:\/\/www.dropbox.com\/s\/odbajvy6p8319q4\/Redman%20-%202013%20-%20Data%27s%20Credibility%20Problem.pdf?dl=0\">Redman \u2013 2013 \u2013 Data\u2019s Credibility Problem<\/a><\/li>\n<li><a href=\"https:\/\/www.dropbox.com\/s\/rvemlu9uqi4jm8w\/Rosenblum%20and%20Dorsey%20-%202014%20-%20Knowing%20Just%20Enough%20about%20Relational%20Databases.pdf?dl=0\">Rosenblum and Dorsey \u2013 2014 \u2013 Knowing Just Enough about Relational Databases<\/a><\/li>\n<li><a href=\"https:\/\/www.dropbox.com\/s\/lyw7zr6e5n1vf1n\/Tableau%20-%20Guide%20to%20data%20cleaning.pdf?dl=0\">Tableau \u2013 Guide to data cleaning<\/a><\/li>\n<\/ul>\n<p>2. Take <a href=\"https:\/\/forms.gle\/paRDx3yQBvdFQ5Nw9\">Quiz<\/a>.<\/p>\n<p>3. Look over class materials for 10\/16. Note that we have an assignment due that Friday, but unlikely to provide a lot of class time to completing it this time. It may be beneficial to look over 7.2 in class assignment as well as assignment 2.<\/p>\n<p>4. <strong>Assignment 2:\u00a0<a href=\"https:\/\/docs.google.com\/document\/d\/1o4fMYo2IvLRdBP52XAVRUrfRjRAz4ww2\/edit?usp=sharing&amp;ouid=112777917139483837179&amp;rtpof=true&amp;sd=true\">Data cleansing in Excel due 10\/20, 3 p.m<\/a>.\u00a0<a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1WPPx8t7lMaF0UpplPmqPEJORhP1898nJ\/edit?usp=sharing&amp;ouid=112777917139483837179&amp;rtpof=true&amp;sd=true\">Vandelay spreadsheet<\/a>.\u00a0<\/strong>Will need spreadsheet as well as answer sheet emailed to me.<\/p>\n<p>5. Additional stuff.<\/p>\n<h2><b>What is a Relational Database?<\/b><\/h2>\n<p><span style=\"font-weight: 400\">This video demonstrates differences between a relational database and an Excel spreadsheet for storing data<\/span><span style=\"font-weight: 400\">:<\/span><\/p>\n<p><a href=\"https:\/\/youtu.be\/iKK3P11OCyM\"><span style=\"font-weight: 400\">https:\/\/youtu.be\/iKK3P11OCyM<\/span><\/a><\/p>\n<h2><b>How Bad Data Ruins Your Day<\/b><\/h2>\n<p><span style=\"font-weight: 400\">Here are some of my favorite horror stories how things went wrong due to bad data:<\/span><\/p>\n<p><a href=\"https:\/\/www.simscale.com\/blog\/2017\/12\/nasa-mars-climate-orbiter-metric\/\"><span style=\"font-weight: 400\">https:\/\/www.simscale.com\/blog\/2017\/12\/nasa-mars-climate-orbiter-metric\/<\/span><\/a><\/p>\n<p><span style=\"font-weight: 400\">(A blog post with examples \u2013 including the classic NASA mishap \u2013 of how things go wrong when people get data types wrong.)<\/span><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Read the following: Moss \u2013 2021 \u2013 Five Times Excel Led to Disaster Redman \u2013 2013 \u2013 Data\u2019s Credibility Problem Rosenblum and Dorsey \u2013 2014 \u2013 Knowing Just Enough about Relational Databases Tableau \u2013 Guide to data cleaning 2. Take Quiz. 3. Look over class materials for 10\/16. Note that we have an assignment due [&hellip;]<\/p>\n","protected":false},"author":15730,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[663943],"tags":[],"class_list":{"0":"post-2079","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-instructor","7":"entry"},"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/community.mis.temple.edu\/mis0855sec750fall2023\/wp-json\/wp\/v2\/posts\/2079","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/community.mis.temple.edu\/mis0855sec750fall2023\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/community.mis.temple.edu\/mis0855sec750fall2023\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis0855sec750fall2023\/wp-json\/wp\/v2\/users\/15730"}],"replies":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis0855sec750fall2023\/wp-json\/wp\/v2\/comments?post=2079"}],"version-history":[{"count":11,"href":"https:\/\/community.mis.temple.edu\/mis0855sec750fall2023\/wp-json\/wp\/v2\/posts\/2079\/revisions"}],"predecessor-version":[{"id":2203,"href":"https:\/\/community.mis.temple.edu\/mis0855sec750fall2023\/wp-json\/wp\/v2\/posts\/2079\/revisions\/2203"}],"wp:attachment":[{"href":"https:\/\/community.mis.temple.edu\/mis0855sec750fall2023\/wp-json\/wp\/v2\/media?parent=2079"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis0855sec750fall2023\/wp-json\/wp\/v2\/categories?post=2079"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis0855sec750fall2023\/wp-json\/wp\/v2\/tags?post=2079"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}