Schedule Recent changes are marked with red. DAY TOPIC EXERCISE DUE 1/18 1.1 Introduction 1/23 1.2 Data, Information and Knowledge 2.1 Data and Science 1.2 Data Sources Among Us WEEK 2 QUIZ (before class starts) See Readings 1/25 2.2 Brief Introduction to Data(sets) 2.1 Developing Hypotheses 1/30 3.1 Where Do We Get Data? 3.1 Finding Open Datasets WEEK 3 QUIZ (before class starts) See Readings 2/1 3.2 Trust in Data 2.2 Building a Data Dictionary, Car fuel economy 2021 data dictionary exercise.xlsx 3.2 Assessing the Trustworthiness of Data 2/6 4.1 Exploring Data Visually 4.1 Finding Good and Bad Data Visualizations WEEK 4 QUIZ (before class starts) See Readings 2/8 4.2 Functions, Filtering and Sorting 4.2 Getting Familiar with Tableau, COVID cases and deaths by county.xlsx, Getting Familiar with Tableau (complete).twb 2/13 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 2/15 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 2/20 Module 1 and 2 Summary 2/22 EXAM 1 (study guide) 2/27 7.1 Corrupting and Cleansing Data 7.1 How to Obtain Corrupt Data WEEK 7 QUIZ (before class starts) See Readings 3/1 7.2 Relational Database 7.2 Locating and Correcting Suspicious Data Points Using Excel, Vandelay Orders by Zipcode.xlsx Individual Assignment 1 (specification and dataset) 3/6 SPRING BREAK (no classes) 3/8 SPRING BREAK (no classes) 3/13 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 3/15 8.2 Storing Large Datasets for Analysis 3/20 9.1 Aggregating Data for Insights 9.1 Identifying a Key Performance Indicator WEEK 9 QUIZ (before class starts) See Readings 3/22 9.2 Scorecards and Dashboards 9.2 Assessing Product Scorecards 3/27 Module 3 Summary 3/29 EXAM 2 (study guide) 4/3 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 4/5 11.1 Interactive Dashboards and Pivot Tables (continued…) 11.2 Creating an Interactive Dashboard, Daily delays from PHL by airline.xlsx Individual Assignment 2 (specification and dataset) 4/10 12.1 Working with Unstructured Data 12.1 Manually Determining the Sentiment in Text WEEK 12 QUIZ (before class starts) See Readings 4/12 12.1 Working with Unstructured Data (continued…) 12.2 Building a Sentiment Analysis Pipeline, Sentiment Analysis Tools.xlsm 4/17 13.1 Descriptive, Predictive, Prescriptive Analytics 13.1 Simple Predictive Analytics, VandelayOrdersAll.xlsx WEEK 13 QUIZ (before class starts) See Readings 4/19 13.2 Machine Learning 12.3 Machine Learning Simulation 4/24 Module 4 Summary 4/26 EXAM 3 (study guide) 5/1 Group presentations Group Assignment (specification and evaluation criteria)
