{"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":"2024-04-15T15:42:32","modified_gmt":"2024-04-15T19:42:32","slug":"schedule","status":"publish","type":"page","link":"https:\/\/community.mis.temple.edu\/mis0855sec750spring2024\/","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
1\/22<\/td>\n1.1\u00a0Introduction<\/a><\/td>\n1.2 Data Sources Among Us<\/a><\/td>\n\u00a0<\/td>\n<\/tr>\n
\u00a0<\/td>\n1.2 Data. Information, Knowledge<\/a><\/td>\n\u00a0<\/td>\n1.2 Readings<\/a><\/td>\n<\/tr>\n
1\/29<\/td>\n2.1 Data and Science<\/a><\/td>\n2.1 Developing Hypotheses<\/a><\/td>\n\n

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

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

\u00a0<\/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\u00a0<\/td>\n<\/tr>\n
2\/5<\/td>\n\n

3.1 Where Do We Get Data?<\/a><\/p>\n

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

\n

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

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

\n

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

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

2\/12<\/td>\n4.1 Exploring Data Visually<\/a><\/td>\n4.1 Finding Good and Bad Data Visualizations<\/a><\/td>\n\u00a0<\/td>\n<\/tr>\n
\u00a0<\/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>\n\n

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

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

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

2\/16<\/td>\n\n

Assignment 1: Tableau<\/strong><\/a>\u00a0<\/strong><\/p>\n

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

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

Due to my inbox 3 p.m. Friday Feb. 16<\/strong><\/td>\n\u00a0<\/td>\n<\/tr>\n
2\/19<\/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>\n\n

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

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

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

Creating Infographics with Piktochart\u00a0<\/a><\/p>\n

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

\u00a0<\/td>\n<\/tr>\n
\u00a0<\/td>\n\u00a0<\/td>\n\u00a0<\/td>\n\u00a0<\/td>\n<\/tr>\n
2\/26<\/td>\n6.2 EXAM 1<\/td>\nOn Canvas<\/a><\/td>\n\u00a0<\/td>\n<\/tr>\n
3\/11<\/td>\n7.1\u00a0Corrupting and Cleansing Data<\/a><\/td>\n7.1 How to Obtain Corrupt Data<\/a><\/td>\n\n

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

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

3\/15<\/td>\n\n

 <\/p>\n

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

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

 <\/p>\n

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

\n

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

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

\n

 <\/p>\n

 <\/p>\n

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

3\/18<\/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>\n\n

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

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

\u00a0<\/td>\n8.2\u00a0Storing Large Datasets for Analysis<\/a><\/td>\n\u00a0<\/td>\n\u00a0<\/td>\n<\/tr>\n
3\/25<\/td>\n9.1\u00a0Aggregating Data for Insights<\/a><\/td>\n9.1 Identifying a Key Performance Indicator<\/a><\/td>\n\n

Quiz 7\u00a0<\/a><\/p>\n

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

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

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

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

\u00a0<\/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\u00a0<\/td>\n<\/tr>\n
4\/15<\/td>\n12.1\u00a0Working with Unstructured Data<\/a><\/td>\n12.1 Manually Determining the Sentiment in Text<\/a><\/td>\n\n

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

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

\u00a0<\/td>\nTwitter Sentiment Analysis using Excel and Google Drive<\/td>\n12.2 Building a Sentiment Analysis Pipeline<\/a>, Sentiment Analysis Tools.xlsm<\/a>, Sample Tweets<\/a><\/td>\n\u00a0<\/td>\n<\/tr>\n
4\/22<\/td>\n13.1\u00a0Descriptive, Predictive, Prescriptive Analytics<\/a><\/td>\n13.1\u00a0Simple Predictive Analytics<\/a>,\u00a0VandelayOrdersAll.xlsx<\/a><\/td>\n\n

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

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

\u00a0<\/td>\n13.2 Machine Learning, GenAI<\/a><\/td>\n13.2 Learn ChatGPT<\/a>, Train image recognition system<\/a>, files<\/a><\/td>\n\u00a0<\/td>\n<\/tr>\n
4\/29<\/td>\nExam Review<\/td>\n\u00a0<\/td>\n\u00a0<\/td>\n<\/tr>\n
\u00a0<\/td>\nGroup Final Assignment Presentations<\/a><\/td>\nDeliverables due to 3 p.m. 4\/26<\/strong><\/td>\n\u00a0<\/td>\n<\/tr>\n
5\/6<\/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 1\/22 1.1\u00a0Introduction 1.2 Data Sources Among Us \u00a0 \u00a0 1.2 Data. Information, Knowledge \u00a0 1.2 Readings 1\/29 2.1 Data and Science 2.1 Developing Hypotheses Quiz 1 2.1 & 2.2 Readings \u00a0 2.2\u00a0Intro […]<\/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\/mis0855sec750spring2024\/wp-json\/wp\/v2\/pages\/22","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/community.mis.temple.edu\/mis0855sec750spring2024\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/community.mis.temple.edu\/mis0855sec750spring2024\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis0855sec750spring2024\/wp-json\/wp\/v2\/users\/15730"}],"replies":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis0855sec750spring2024\/wp-json\/wp\/v2\/comments?post=22"}],"version-history":[{"count":53,"href":"https:\/\/community.mis.temple.edu\/mis0855sec750spring2024\/wp-json\/wp\/v2\/pages\/22\/revisions"}],"predecessor-version":[{"id":2243,"href":"https:\/\/community.mis.temple.edu\/mis0855sec750spring2024\/wp-json\/wp\/v2\/pages\/22\/revisions\/2243"}],"wp:attachment":[{"href":"https:\/\/community.mis.temple.edu\/mis0855sec750spring2024\/wp-json\/wp\/v2\/media?parent=22"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}