Schedule DATE TOPIC IN-CLASS EXERCISE DUE 8/23 1.1 Introduction 8/25 1.2 Data, Information, Knowledge 1.2 Data Sources Among Us 8/30 2.1 Data and Science 2.1 Developing Hypotheses WEEK 2 QUIZ (before class starts) See Readings 9/1 2.2 Brief Introduction to Data(sets) 2.2 Building a Data Dictionary, 2.2 Car fuel economy 2021 data dictionary exercise.xlsx In-class activity submission link is here 9/6 3.1 Where Do We Get Data? 3.1 Finding Open Datasets WEEK 3 QUIZ (before class starts) See Readings 9/8 3.2 Trust in Data 3.2 Assessing the Trustworthiness of Data 9/13 4.1 Exploring Data Visually 4.1 Finding Good and Bad Data Visualizations WEEK 4 QUIZ (before class starts) See Readings Video recap for in-class-activity0913 9/15 4.2 Introduction to Tableau 4.2 Functions, Filtering, and Sorting 4.2 Getting Familiar with Tableau, 4.2 COVID cases and deaths by county.xlsx In-class activity submission link is here 9/20 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 9/22 5.2 Infographics 5.2 Creating Infographics with Piktochart, 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 9/27 Module 1 and 2 Review Summary Q&A (Study guide for the exam) 9/29 EXAM 1 (in-person in the class) 10/4 7.1 Corrupting and Cleansing Data 7.1 How to Obtain Corrupt Data WEEK 7 QUIZ (before class starts) See Readings 10/6 7.1 Corrupting and Cleansing Data (continued…) Additional Extra Points 10/11 7.2 Relational Database 8.1 Integrating Data from Different Sources 8.1 Instruction: Setting up an ETL Process to Merge Data, 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/13 8.2 Storing Large Datasets for Analysis 7.2 Instruction: Locating and Correcting Suspicious Data Points Using Excel, Data: Vandelay Orders by Zipcode.xlsx In-class activity submission link is here Individual Assignment 1 (1) assignment specification (2) assignment dataset (3) answer sheet Please submit here 10/18 9.1 Aggregating Data for Insights 9.1 Identifying a Key Performance Indicator WEEK 9 QUIZ (before class starts) See Readings 10/20 9.2 Scorecards and Dashboards 9.2 Assess Different Product Scorecards In-class activity submission link is here Additional Extra Points Due before this class 10/25 Module 3 Review Summary Q&A (Study guide for the exam) 10/27 EXAM 2 (in-person in the class) 11/1 11.1 Interactive Dashboards and Pivot Tables 11.1 Instruction: Pivot Table Analysis in Excel, Data: Employee monthly expenses.xlsx WEEK 11 QUIZ (before class starts) See Readings 11/3 11.1 Interactive Dashboards and Pivot Tables (continued…) 12.1 Working with Unstructured Data 11.2 Instruction: Creating an Interactive Dashboards, Data: Daily delays from PHL by airline.xlsx In-class activity submission link is here 11/8 12.1 Working with Unstructured Data 12.1 Instruction: Building a Sentiment Analysis Pipeline, Data: Sentiment Analysis Tool.xlsm WEEK 12 QUIZ (before class starts) See Readings 11/10 12.2 Guest Speaker: Jim Clavin (CTO, The Hilltop Institute) Individual Assignment 2 Scoring sheet (1) assignment specification (2) assignment dataset (3) answer sheet Please submit here 11/15 13.1 Descriptive, Predictive, Prescriptive Analytics 13.1 Instruction: Simple Predictive Analytics Using Tableau Data: VandelayOrdersAll.xlsx WEEK 13 QUIZ (before class starts) See Readings 11/17 13.2 Machine Learning 13.2 Machine Learning Simulation Get five extra credits by coming to the class and submitting here. 11/22 Fall Break (no classes held) 11/24 Thanksgiving holiday (no classes held) 11/29 Module 4 Review Summary Q&A (Study guide for the exam) Group Presentations Team list is here We can arrange for around three teams to do an in-person presentation. Please email me if your team is interested. Group Assignment (1) specification (2) evaluation criteria Please submit here 12/1 EXAM 3 (in-person in the class) 12/6 University study day No class held If you want to talk, please come to my office (Speakman 208E) during 2-3.30 pm. Group project submission due Upload here 12/8 No class held If you want to talk, please come to my office (Speakman 208E) during 2-3.30 pm. Please email me to schedule a time to talk between 12/6-12/12. Your official letter grade is planned to be uploaded to the school system around 12/13.
