Schedule Recent changes are marked with red. DAY TOPIC EXERCISE DUE 8/22 1.1 Introduction 8/24 1.2 Data, Information and Knowledge 1.2 Data Sources Among Us 8/29 2.1 Data and Science 2.1 Developing Hypotheses WEEK 2 QUIZ (before class starts) See Readings 8/31 2.2 Brief Introduction to Data(sets) 2.2 Building a Data Dictionary, Car fuel economy 2021 data dictionary exercise.xlsx 9/5 LABOR DAY (no classes) 9/7 3.1 Where Do We Get Data? 3.2 Trust in Data 3.1 Finding Open Datasets 3.2 Assessing the Trustworthiness of Data WEEK 3 QUIZ (before class starts) See Readings 9/12 4.1 Exploring Data Visually 4.1 Finding Good and Bad Data Visualizations WEEK 4 QUIZ (before class starts) See Readings 9/14 4.2 Functions, Filtering and Sorting 4.2 Getting Familiar with Tableau, COVID cases and deaths by county.xlsx 4.2 Getting Familiar with Tableau (completed).twb 9/19 5.1 Telling Stories with Data Visualizations 5.1 Effective Data Visualizations, Gun violence 2017.twb, Gun violence in the US – 2017.xlsx WEEK 5 QUIZ (before class starts) See Readings 9/21 5.2 Infographics 5.2 Creating Infographics with Piktochart, Cases per 100k in FL.png, Cases per 100k in PA.png, Deaths vs cases in PA and FL.png 9/26 Module 1 and 2 Summary 9/28 EXAM 1 (study guide) 10/3 6.2 Admin and other matters 7.1 Corrupting and Cleansing Data 7.1 How to Obtain Corrupt Data WEEK 7 QUIZ (before class starts) See Readings 10/5 7.2 Relational Database 7.2 Locating and Correcting Suspicious Data Points Using Excel, Vandelay Orders by Zipcode.xlsx 10/10 8.1 Integrating Data from Different Sources 8.1 Setting up an ETL Process to Merge Data, Carrier names.csv, Delta – PHL – Jan-2018.csv, Frontier – PHL – Jan-2018.csv, JetBlue – PHL – Jan-2018.csv, Republic – PHL – Jan-2018.csv, Southwest – PHL – Jan-2018.csv, Hourly weather for PHL in January 2018.csv WEEK 8 QUIZ (before class starts) See Readings Individual Assignment 1 (specification and dataset) 10/12 8.2 Storing Large Datasets for Analysis 10/17 9.1 Aggregating Data for Insights 9.1 Identifying a Key Performance Indicator WEEK 9 QUIZ (before class starts) See Readings 10/19 9.2 Scorecards and Dashboards 9.2 Assessing Product Scorecards 10/24 Module 3 Summary 10/26 EXAM 2 (study guide) 10/31 11.1 Interactive Dashboards and Pivot Tables 11.1 Pivot Table Analysis in Excel, Employee monthly expenses.xlsx WEEK 11 QUIZ (before class starts) See Readings 11/2 11.1 Interactive Dashboards and Pivot Tables (continued…) 11.2 Creating an Interactive Dashboard, Daily delays from PHL by airline.xlsx 11/7 12.1 Working with Unstructured Data 12.1 Manually Determining the Sentiment in Text WEEK 12 QUIZ (before class starts) See Readings 11/9 12.1 Working with Unstructured Data (continued…) 12.2 Building a Sentiment Analysis Pipeline, Sentiment Analysis Tools.xlsm Individual Assignment 2 (specification and dataset) 11/14 13.1 Descriptive, Predictive, Prescriptive Analytics 13.2 Machine Learning 13.1 Simple Predictive Analytics, VandelayOrdersAll.xlsx WEEK 13 QUIZ (before class starts) See Readings 11/16 13.2 Machine Learning Simulation 12.3 Machine Learning Simulation 11/21 THANKSGIVING (No classes) 11/23 THANKSGIVING (No classes) 11/28 Module 4 Summary 11/30 EXAM 3 (study guide) 12/5 Submit Your Group Presentation (we will NOT have in-class session) Group Assignment (specification and evaluation criteria)
