Schedule Recent changes are marked with red. DAY TOPIC EXERCISE DUE 8/28 1.1 Introduction 1.2 Data Sources Among Us 8/30 1.2 Data, Information and Knowledge 2.1 Data and Science 2.1 Developing Hypotheses 9/4 LABOR DAY (no classes) 9/6 2.2 Brief Introduction to Data(sets) 2.2 Building a Data Dictionary, Car fuel economy 2021 data dictionary exercise.xlsx WEEK 2 QUIZ (before class starts) See Readings 9/11 3.1 Where Do We Get Data? 3.1 Finding Open Datasets WEEK 3 QUIZ (before class starts) See Readings 9/13 3.2 Trust in Data 3.2 Assessing the Trustworthiness of Data 9/18 4.1 Exploring Data Visually 4.1 Finding Good and Bad Data Visualizations WEEK 4 QUIZ (before class starts) See Readings 9/20 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 9/25 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/27 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 10/2 Module 1 and 2 Summary 10/4 EXAM 1 (study guide) 10/9 7.1 Corrupting and Cleansing Data 7.1 How to Obtain Corrupt Data WEEK 7 QUIZ (before class starts) See Readings 10/11 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) 10/16 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 10/18 8.2 Storing Large Datasets for Analysis 10/23 9.1 Aggregating Data for Insights 9.1 Identifying a Key Performance Indicator WEEK 9 QUIZ (before class starts) See Readings 10/25 9.2 Scorecards and Dashboards 9.2 Assessing Product Scorecards 10/30 Module 3 Summary 11/1 EXAM 2 (study guide) 11/6 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/8 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) 11/13 12.1 Working with Unstructured Data 12.1 Manually Determining the Sentiment in Text WEEK 12 QUIZ (before class starts) See Readings 11/15 12.1 Working with Unstructured Data (continued…) 12.2 Building a Sentiment Analysis Pipeline, Sentiment Analysis Tools.xlsm, Example tweets.xlsx 11/20 FALL BREAK (no classes) 11/22 FALL BREAK (no classes) 11/27 13.1 Descriptive, Predictive, Prescriptive Analytics 13.1 Simple Predictive Analytics, VandelayOrdersAll.xlsx WEEK 13 QUIZ (before class starts) See Readings 11/29 13.2 Machine Learning and Generative AI, Module 4 Summary 12.3 Machine Learning Simulation, Learning to Use ChatGPT, Train an Image Recognition System, Training data 12/4 NO CLASSES 12/6 EXAM 3 (study guide) 12/11 NO CLASSES (submit your group projects) Group Assignment (specification and evaluation criteria)
