Schedule Recent changes are marked with red. DAY TOPIC EXERCISE DUE 1/17 1.1 Introduction 1.2 Data, Information and Knowledge 1.2 Data Sources Among Us 1/22 2.1 Data and Science 2.1 Developing Hypotheses WEEK 2 QUIZ (before class starts) See Readings 1/24 2.2 Brief Introduction to Data(sets) 2.2 Building a Data Dictionary, Car fuel economy 2021 data dictionary exercise.xlsx 1/29 3.1 Where Do We Get Data? 3.1 Finding Open Datasets WEEK 3 QUIZ (before class starts) See Readings 1/31 3.2 Trust in Data 3.2 Assessing the Trustworthiness of Data 2/5 4.1 Exploring Data Visually 4.1 Finding Good and Bad Data Visualizations WEEK 4 QUIZ (before class starts) See Readings 2/7 4.2 Functions, Filtering and Sorting 4.2 Getting Familiar with Tableau, COVID cases and deaths by county.xlsx (DO NOT USE THIS FOR THE INDIVIDUAL ASSIGNMENT 1), Getting Familiar with Tableau (complete).twb 2/12 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/14 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/19 Module 1 and 2 Summary 2/21 EXAM 1 (study guide) 2/26 7.1 Corrupting and Cleansing Data 7.1 How to Obtain Corrupt Data WEEK 7 QUIZ (before class starts) See Readings 2/28 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/4 SPRING BREAK (no classes) 3/6 SPRING BREAK (no classes) 3/11 8.1 Integrating Data from Different Sources (taught by Ziyi Zhao) 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/13 8.2 Storing Large Datasets for Analysis (taught by Ziyi Zhao) 3/18 9.1 Aggregating Data for Insights 9.1 Identifying a Key Performance Indicator WEEK 9 QUIZ (before class starts) See Readings 3/20 9.2 Scorecards and Dashboards 9.2 Assessing Product Scorecards 3/25 Module 3 Summary 3/27 EXAM 2 (study guide) 4/1 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/3 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) DUE 4/5 4/8 12.1 Working with Unstructured Data (taught by Ziyi Zhao) 12.1 Manually Determining the Sentiment in Text WEEK 12 QUIZ (before class starts) See Readings 4/10 12.1 Working with Unstructured Data (continued… taught by Ziyi Zhao) 12.2 Building a Sentiment Analysis Pipeline, Sentiment Analysis Tools.xlsm, Example tweets.xlsx 4/15 13.1 Descriptive, Predictive, Prescriptive Analytics 13.1 Simple Predictive Analytics, VandelayOrdersAll.xlsx WEEK 13 QUIZ (before class starts) See Readings 4/17 13.2 Machine Learning and Generative AI 13.2 Machine Learning Simulation, Train an Image Recognition System, Training data.zip 4/22 Module 4 Summary 4/24 EXAM 3 (study guide) 4/29 Group projects due Group Assignment (specification and evaluation criteria)