{"id":22,"date":"2021-12-14T18:40:08","date_gmt":"2021-12-14T23:40:08","guid":{"rendered":"http:\/\/community.mis.temple.edu\/mis3580sec001s2018\/?page_id=22"},"modified":"2023-10-15T20:07:33","modified_gmt":"2023-10-16T00:07:33","slug":"schedule","status":"publish","type":"page","link":"https:\/\/community.mis.temple.edu\/mis0855sec750fall2023\/","title":{"rendered":"Schedule"},"content":{"rendered":"
\n

Note: Log in to your Temple Workspace account from TU portal to access many of these decks, exercises.<\/em><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
DAY<\/th>\nTOPIC<\/th>\nIN-CLASS EXERCISE<\/th>\nDUE<\/th>\n<\/tr>\n<\/thead>\n
8\/28<\/td>\n1.1\u00a0Introduction<\/a><\/td>\n1.2 Data Sources Among Us<\/a><\/td>\n<\/td>\n<\/tr>\n
<\/td>\n1.2 Data. Information, Knowledge<\/a><\/td>\n<\/td>\n1.2 Readings<\/a><\/td>\n<\/tr>\n
9\/11<\/td>\n2.1 Data and Science<\/a><\/td>\n2.1 Developing Hypotheses<\/a><\/td>\nQuiz 1<\/a><\/p>\n

2.1 & 2.2 Readings<\/a><\/td>\n<\/tr>\n

<\/td>\n2.2\u00a0Intro to Data(sets)<\/a><\/td>\n2.2 Building a Data Dictionary<\/a>,\u00a0Car fuel economy 2021 data dictionary exercise.xlsx<\/a><\/td>\n<\/td>\n<\/tr>\n
9\/18<\/td>\n3.1 Where Do We Get Data?<\/a><\/p>\n

3.2 Trust in Data<\/a><\/td>\n

3.1 Finding Open Datasets<\/a><\/p>\n

3.2 Assessing the Trustworthiness of Data<\/a><\/td>\n

Quiz 2<\/a><\/p>\n

3.1 Readings<\/a><\/td>\n<\/tr>\n

9\/25<\/td>\n4.1 Exploring Data Visually<\/a><\/td>\n4.1 Finding Good and Bad Data Visualizations<\/a><\/td>\n<\/td>\n<\/tr>\n
<\/td>\n4.2 \u00a0 \u00a0Introduction to Tableau<\/a><\/td>\n4.2 Getting Familiar with Tableau<\/a>,\u00a0COVID cases and deaths by county.xlsx<\/a><\/td>\nQuiz 3<\/a><\/p>\n

4.1 & 4.2 Readings<\/a><\/p>\n

 <\/td>\n<\/tr>\n

9\/29<\/td>\nAssignment 1: Tableau<\/strong><\/a>\u00a0<\/strong><\/p>\n

Use data set below for Assignment 1<\/strong><\/p>\n

(Covid cases spreadsheet<\/a>)<\/a><\/strong><\/td>\n

Due to my inbox 3 p.m. Friday Sept. 29<\/strong><\/td>\n<\/td>\n<\/tr>\n
10\/2<\/td>\n5.1 Telling Stories with Data<\/a><\/td>\nEffective Data Visualizations<\/a>,\u00a0Gun violence 2017.twb<\/a>,\u00a0Gun violence in the US \u2013 2017.xlsx<\/a><\/td>\nQuiz 4<\/a><\/p>\n

5.1 & 5.2 Readings<\/a><\/td>\n<\/tr>\n

<\/td>\n5.2\u00a0Storytelling with Infographics<\/a><\/td>\nCreating Infographics with Piktochart\u00a0<\/a><\/p>\n

5.2 Tableau workbook<\/a>, data<\/a>.<\/td>\n

<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
10\/9<\/td>\n6.2 EXAM 1<\/td>\nOn Canvas<\/a><\/td>\n<\/td>\n<\/tr>\n
10\/16<\/td>\n7.1\u00a0Corrupting and Cleansing Data<\/a><\/td>\n7.1 How to Obtain Corrupt Data<\/a><\/td>\nQuiz 5<\/a><\/p>\n

7.1 & 7.2 Readings<\/a><\/td>\n<\/tr>\n

10\/20<\/td>\n <\/p>\n

7.2\u00a0Relational Database<\/a><\/p>\n

Assignment 2: Data cleansing in Excel due 10\/20, 3 p.m<\/a>.<\/strong><\/p>\n

 <\/p>\n

(Vandelay spreadsheet for assignment.<\/a> )<\/strong><\/td>\n

7.2 Locating and Correcting Suspicious Data Points Using Excel<\/a>,<\/p>\n

(Vandelay Orders by Zipcode.xlsx)<\/a><\/td>\n

 <\/p>\n

 <\/p>\n

 <\/td>\n<\/tr>\n

10\/23<\/td>\n8.1\u00a0Integrating Data from Different Sources<\/a><\/td>\n8.1 Setting up an ETL Process to Merge Data<\/a>,\u00a0Carrier names.csv<\/a>,\u00a0Delta \u2013 PHL \u2013 Jan-2018.csv<\/a>,\u00a0Frontier \u2013 PHL \u2013 Jan-2018.csv<\/a>,\u00a0JetBlue \u2013 PHL \u2013 Jan-2018.csv<\/a>,\u00a0Republic \u2013 PHL \u2013 Jan-2018.csv<\/a>,\u00a0Southwest \u2013 PHL \u2013 Jan-2018.csv<\/a>,\u00a0Hourly weather for PHL in January 2018.csv<\/a><\/td>\nQuiz 6<\/a><\/p>\n

8.1 & 8.2 Readings<\/a><\/td>\n<\/tr>\n

<\/td>\n8.2\u00a0Storing Large Datasets for Analysis<\/a><\/td>\n<\/td>\n<\/td>\n<\/tr>\n
10\/30<\/td>\n9.1\u00a0Aggregating Data for Insights<\/a><\/td>\n9.1 Identifying a Key Performance Indicator<\/a><\/td>\nQuiz 7\u00a0<\/a><\/p>\n

9.1 & 9.2 Readings<\/a><\/td>\n<\/tr>\n

<\/td>\n9.2\u00a0Creating Interactive Dashboards<\/a><\/td>\n9.2 Assessing Product Scorecards<\/a><\/td>\n<\/td>\n<\/tr>\n
<\/td>\n10.1 Exam Review<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
11\/6<\/td>\n10.2 EXAM 2<\/td>\nOn Canvas<\/a><\/td>\n<\/td>\n<\/tr>\n
11\/13<\/td>\n11.1\u00a0Interactive Dashboards and Pivot Tables<\/a><\/td>\n11.1 Pivot Table Analysis in Excel<\/a>,\u00a0Employee monthly expenses.xlsx<\/a><\/td>\nQuiz 8<\/a><\/p>\n

11.1 & 11.2 Readings<\/a><\/td>\n<\/tr>\n

<\/td>\n11.2\u00a0Using Tableau to Aggregate Data<\/td>\n11.2 Creating an Interactive Dashboard<\/a>,\u00a0Daily delays from PHL by airline.xlsx<\/a><\/td>\n<\/td>\n<\/tr>\n
11\/27<\/td>\n12.1\u00a0Working with Unstructured Data<\/a><\/td>\n12.1 Manually Determining the Sentiment in Text<\/a><\/td>\nQuiz 9<\/a><\/p>\n

12.1 & 12.2 Readings<\/a><\/td>\n<\/tr>\n

<\/td>\nTwitter Sentiment Analysis using Excel and Google Drive<\/td>\n12.2\u00a0Building a Sentiment Analysis Pipeline<\/a>,\u00a0Sentiment Analysis Tools.xlsm<\/a><\/td>\n<\/td>\n<\/tr>\n
12\/4<\/td>\n13.1\u00a0Descriptive, Predictive, Prescriptive Analytics<\/a><\/td>\n13.1\u00a0Simple Predictive Analytics<\/a>,\u00a0VandelayOrdersAll.xlsx<\/a><\/td>\nQuiz 10<\/a><\/p>\n

13.1 & 13.2 Readings<\/a><\/td>\n<\/tr>\n

<\/td>\n13.2 Machine Learning, GenAI<\/a><\/td>\n13.2 Learn ChatGPT<\/a>, Train image recognition system<\/a>, files<\/a><\/td>\n<\/td>\n<\/tr>\n
12\/11<\/td>\nExam Review<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
<\/td>\nGroup Final Assignment Presentations<\/a><\/td>\nDeliverables due to 3 p.m. 12\/8<\/strong><\/td>\n<\/td>\n<\/tr>\n
12\/18<\/td>\nExam 3<\/td>\nOn Canvas<\/a><\/td>\nAny missing assignments<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Note: Log in to your Temple Workspace account from TU portal to access many of these decks, exercises. DAY TOPIC IN-CLASS EXERCISE DUE 8\/28 1.1\u00a0Introduction 1.2 Data Sources Among Us 1.2 Data. Information, Knowledge 1.2 Readings 9\/11 2.1 Data and Science 2.1 Developing Hypotheses Quiz 1 2.1 & 2.2 Readings 2.2\u00a0Intro to Data(sets) 2.2 Building […]<\/p>\n","protected":false},"author":15730,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","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":""},"class_list":{"0":"post-22","1":"page","2":"type-page","3":"status-publish","5":"entry"},"_links":{"self":[{"href":"https:\/\/community.mis.temple.edu\/mis0855sec750fall2023\/wp-json\/wp\/v2\/pages\/22","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/community.mis.temple.edu\/mis0855sec750fall2023\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/community.mis.temple.edu\/mis0855sec750fall2023\/wp-json\/wp\/v2\/types\/page"}],"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=22"}],"version-history":[{"count":49,"href":"https:\/\/community.mis.temple.edu\/mis0855sec750fall2023\/wp-json\/wp\/v2\/pages\/22\/revisions"}],"predecessor-version":[{"id":1746,"href":"https:\/\/community.mis.temple.edu\/mis0855sec750fall2023\/wp-json\/wp\/v2\/pages\/22\/revisions\/1746"}],"wp:attachment":[{"href":"https:\/\/community.mis.temple.edu\/mis0855sec750fall2023\/wp-json\/wp\/v2\/media?parent=22"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}