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
1/22	1.1 Introduction	1.2 Data Sources Among Us
	1.2 Data. Information, Knowledge		1.2 Readings
1/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, Car fuel economy 2021 data dictionary exercise.xlsx
2/5	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
2/12	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
2/16	Assignment 1: Tableau  Use data set below for Assignment 1 (Covid cases spreadsheet)	Due to my inbox 3 p.m. Friday Feb. 16
2/19	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.
2/26	6.2 EXAM 1	On Canvas
3/11	7.1 Corrupting and Cleansing Data	7.1 How to Obtain Corrupt Data	Quiz 5 7.1 & 7.2 Readings
3/15	7.2 Relational Database Assignment 2: Data cleansing in Excel due 3/15, 3 p.m.   (Vandelay spreadsheet for assignment. )	7.2 Locating and Correcting Suspicious Data Points Using Excel, (Vandelay Orders by Zipcode.xlsx)
3/18	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
3/25	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
4/1	10.2 EXAM 2	On Canvas
4/8	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
4/15	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, Sample Tweets
4/22	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
4/29	Exam Review
	Group Final Assignment Presentations	Deliverables due to 3 p.m. 4/26
5/6	Exam 3	On Canvas	Any missing assignments