Data Science

Note: Log in to your Temple Workspace account from TU portal to access many of these decks, exercises.

DAY	TOPIC	IN-CLASS EXERCISE	DUE
8/28	1.1 Introduction	1.2 Data Sources Among Us
	1.2 Data. Information, Knowledge		1.2 Readings
9/11	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, Car fuel economy 2021 data dictionary exercise.xlsx
9/18	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/25	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/29	Assignment 1: Tableau  Use data set below for Assignment 1 (Covid cases spreadsheet)	Due to my inbox 3 p.m. Friday Sept. 29
10/2	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  5.2 Tableau workbook, data.
10/9	6.2 EXAM 1	On Canvas
10/16	7.1 Corrupting and Cleansing Data	7.1 How to Obtain Corrupt Data	Quiz 5 7.1 & 7.2 Readings
10/20	7.2 Relational Database Assignment 2: Data cleansing in Excel due 10/20, 3 p.m.   (Vandelay spreadsheet for assignment. )	7.2 Locating and Correcting Suspicious Data Points Using Excel, (Vandelay Orders by Zipcode.xlsx)
10/23	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/30	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 Assessing Product Scorecards
	10.1 Exam Review
11/6	10.2 EXAM 2	On Canvas
11/13	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, Daily delays from PHL by airline.xlsx
11/27	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 Tools.xlsm
12/4	13.1 Descriptive, Predictive, Prescriptive Analytics	13.1 Simple Predictive Analytics, VandelayOrdersAll.xlsx	Quiz 10 13.1 & 13.2 Readings
	13.2 Machine Learning, GenAI	13.2 Learn ChatGPT, Train image recognition system, files
12/11	Exam Review
	Group Final Assignment Presentations	Deliverables due to 3 p.m. 12/8
12/18	Exam 3	On Canvas	Any missing assignments