Schedule DAY TOPIC IN-CLASS EXERCISE DUE 8/22 1.1 Introduction 1.2 Data Sources Among Us 1.2 Data. Information, Knowledge 1.2 Readings 8/29 2.1 Data and Science 2.1 Developing Hypotheses Quiz 1 2.1 & 2.2 Readings 2.2 Intro to Data(sets) 2.2 Building a Data Dictionary, 2.2 Car fuel economy 2021 data dictionary exercise.xlsx 9/12 3.1 Where Do We Get Data? 3.2 Trust in Data 3.1 Finding Open Datasets 3.2 Assessing the Trustworthiness of Data Quiz 2 3.1 Readings 9/19 4.1 Exploring Data Visually 4.1 Finding Good and bad Data Visualizations 4.2 Introduction to Tableau 4.2 Getting Familiar with Tableau, COVID cases and deaths by county.xlsx Quiz 3 4.1 & 4.2 Readings 9/23 Assignment 1: Tableau (Covid cases spreadsheet) Due to my inbox 3 p.m. Friday Sept. 23 9/26 5.1 Telling Stories with Data Effective Data Visualizations, Gun violence 2017.twb, Gun violence in the US – 2017.xlsx Quiz 4 5.1 & 5.2 Readings 5.2 Storytelling with Infographics Creating Infographics with Piktochart, Getting Familiar with Tableau updated (complete).twb, COVID cases and deaths by county.xlsx 5.2 Deaths vs. case in PA and FL.png, Cases per 100k in FL.png, Cases per 100k in PA.png Module 1 and 2 Summary 10/3 6.2 EXAM 1 On Canvas 10/10 7.1 Corrupting and Cleansing Data 7.1 How to Obtain Corrupt Data Quiz 5 7.1 & 7.2 Readings 7.2 Relational Database Assignment 2: Data cleansing in Excel due 10/14, 3 p.m. Vandelay spreadsheet. 7.2 Locating and Correcting Suspicious Data Points, Vandelay Orders by Zipcode.xlsx 10/17 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 Quiz 6 8.1 & 8.2 Readings 8.2 Storing Large Datasets for Analysis 10/24 9.1 Aggregating Data for Insights 9.1 Identifying a Key Performance Indicator Quiz 7 9.1 & 9.2 Readings 9.2 Creating Interactive Dashboards 9.2 Assess Different Different Product Scorecards 10.1 Exam Review Module 3 Summary 10/31 10.2 EXAM 2 On Canvas 11/7 11.1 Interactive Dashboards and Pivot Tables 11.1 Pivot Table Analysis in Excel, Employee monthly expenses.xlsx Quiz 8 11.1 & 11.2 Readings 11.2 Using Tableau to Aggregate Data 11.2 Creating an Interactive Dashboard, Airline delay and weather data.xlsx 11/14 12.1 Working with Unstructured Data 12.1 Manually Determining the Sentiment in Text Quiz 9 12.1 & 12.2 Readings Twitter Sentiment Analysis using Excel and Google Drive 12.2 Building a Sentiment Analysis Pipeline, Sentiment Analysis Tool.xlsm 12.2 Intermediary saved file.xlsm 11/28 13.1 Descriptive, Predictive, Prescriptive Analytics 13.1 Simple Predictive Analytics, VandelayOrdersAll.xlsx Quiz 10 13.1 & 13.2 Readings 13.1 Machine Learning 12/5 Exam Review Group Final Assignment Presentations Deliverables due to 3 p.m. 12/2 12/12 Exam 3 On Canvas Any missing assignments