Schedule Recent changes are marked with red. DAY TOPIC EXERCISE DUE 1/10 1.1 Introduction 1/12 1.2 Data, Information, Knowledge 1.2 Data Sources Among Us 1/17 NO CLASSES (Dr. Martin Luther King, Jr. Day) 1/19 2.1 Data and Science 2.2 Brief Introduction to Data(sets) 2.1 Developing Hypotheses 2.2 Building a Data Dictionary, 2.2 Car fuel economy 2021 data dictionary exercise.xlsx WEEK 2 QUIZ (before class starts) See Readings 1/24 3.1 Where Do We Get Data? 2.1 Developing Hypotheses 3.1 Finding Open Datasets WEEK 3 QUIZ (before class starts) See Readings 1/26 3.2 Trust in Data 3.2 Assessing the Trustworthiness of Data 1/31 4.1 Exploring Data Visually 4.1 Finding Good and Bad Data Visualizations WEEK 4 QUIZ (before class starts) See Readings 2/2 4.2 Getting Familiar with Tableau, 4.2 COVID cases and deaths by county.xlsx 2/7 4.2 Functions, Filtering and Sorting 5.1 Telling Stories with Data Visualizations 5.1 Effective Data Visualizations, 5.1 Gun violence 2017.twb, 5.1 Gun violence in the US – 2017.xlsx WEEK 5 QUIZ (before class starts) See Readings 2/9 5.2 Infographics 5.2 Creating Infographics with Piktochart, 4.2 Getting Familiar with Tableau (complete).twb, 4.2 COVID cases and deaths by county.xlsx, 5.2 Cases per 100k in FL.png, 5.2 Cases per 100k in PA.png, 5.2 Deaths vs cases in PA and FL 2/14 2.2 Brief Introduction to Data(sets) Module 1 and 2 Summary 2.2 Building a Data Dictionary, 2.2 Car fuel economy 2021 data dictionary exercise.xlsx 2/16 EXAM 1 (Study guide) 2/21 7.1 Corrupting and Cleansing Data 7.1 How to Obtain Corrupt Data WEEK 7 QUIZ (before class starts) See Readings 2/23 7.2 Relational Database 7.2 Locating and Correcting Suspicious Data Points Using Excel, Vandelay Orders by Zipcode.xlsx 2/28 NO CLASSES (Spring Break) 3/2 NO CLASSES (Spring Break) 3/7 8.1 Integrating Data from Different Sources WEEK 8 QUIZ (before class starts) See Readings 3/9 8.2 Storing Large Datasets for Analysis 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 Individual Assignment 1 (assignment specification and the dataset) 3/14 9.1 Aggregating Data for Insights 9.1 Identifying a Key Performance Indicator WEEK 9 QUIZ (before class starts) See Readings 3/16 9.2 Scorecards and Dashboards 9.2 Assess Different Different Product Scorecards 3/21 Module 3 Summary 3/23 EXAM 2 (Study guide) 3/28 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 3/30 11.1 Interactive Dashboards and Pivot Tables (continued…) 11.2 Creating an Interactive Dashboards, Pew Story Data.xlsx 4/4 12.1 Working with Unstructured Data 12.1 Manually Determining the Sentiment in Text WEEK 12 QUIZ (before class starts) See Readings 4/6 12.1 Working with Unstructured Data (continued…) 12.2 Building a Sentiment Analysis Pipeline, Sentiment Analysis Tool.xlsm Individual Assignment 2 (specification and dataset) 4/11 13.1 Descriptive, Predictive, Prescriptive Analytics, Machine Learning WEEK 13 QUIZ (before class starts) See Readings 4/13 13.2 Machine Learning Simulation 13.2 Simple Predictive Analytics, VandelayOrdersAll.xlsx, Machine Learning Simulation 4/18 Module 4 Summary 4/20 EXAM 3 (Study guide) 4/25 Group Presentations Group Assignment (specification and evaluation criteria)