DSC 140: Fundamentals of Data Science
Course Materials
Introduction to the Course
Introduction to Data Science (MWF: August 26; TR: August 27)
Overview of Software (MWF: August 28; TR: August 27 - 29)
Homework
- Introduction and Excel (Due September 16th by 11:59 pm)
- A set of example solutions can be found here. Note that these are only example solutions and not the only correct answers.
Excel
- Learning Objectives ### Introduction to Excel
- MWF: August 30; TR: August 29
- Slides
- Lecture Notes
- In-Class Excel Project
Statistics in Excel
- MWF: September 4; TR: September 3
- Slides
- Data Set 1 (pizza dataset.xlsx)
- Data Set 1 Solutions
- Data Set 2 (Fires and Thefts.xlsx)
- Data Set 2 Solutions
- Data Set 3 (factbook.csv)
- Data Set 3 Solutions
- Data Set 1 (pizza dataset.xlsx)
- Lecture Notes
Excel Cleaning and Pivot Tables
- MWF: September 6, TR: September 3 - September 5
- Slides
- Data Set 1 (sales data.xlsx)
- Data Set 1 Solutions
- Data Set 2 (Book Data.xlsx)
- Data Set 2 Solutions
- Data Set 1 (sales data.xlsx)
- Lecture Notes
Projects (MWF: September 9 - September 11; TR: September 10)
Homework
- Introduction and Excel (Due September 16th by 11:59 pm)
- A set of example solutions can be found here. Note that these are only example solutions and not the only correct answers.
Python
Introduction to Python (
- MWF: September 13 - September 16; TR: September 12
- Notebooks
- Python Basics (PDF)
- This is a PDF version for quick viewing.
- Python Basics (Notebook)
- This is a Jupyter notebook version that will let you run the Python code.
- MWF In-Class Notebook (Jupyter)
- TR In-Class Notebook (Colab)
- Python Basics (PDF)
- Lecture Notes
Reading Data in Python
- MWF: September 18; TR: September 17
- Notebooks
- Lecture Notes
Loops in Python
- MWF: September 20; TR: September 17 - September 19
- Notebooks
Statistics in Python and Other Python Libraries
- MWF: September 23 - September 25; TR: September 24
- Notebook
- Data Set
Data Cleaning in Python
- MWF: September 30 - October 4; TR: October 1 - October 3
- MWF Section
- TR Section
Machine Learning in Python
- MWF: October 21 - October 25; TR: October 22 - October 24
- Introduction to Machine Learning
- Classification with Machine Learning
- Machine Learning Examples
Python Projects
- Python Projects Part 1 (MWF: September 25 - September 27; TR: September 26)
- Python Projects Part 2 (MWF: October 7 - October 11; TR: October 8 - October 10)
Homework
- Python Homework 1 (Due September 30th by 11:59 pm)
- Sample Solutions. Note that there is more than one correct way to solve most of the problems.
- Python Homework 2 (Due October 21st by 11:59 pm)
- Python Homework 3 (Due October 30th by 11:59 pm)
R
Introduction to R
- MWF: October 28 - November 1; TR: October 29 - October 31
- Lecture Notes as R File
- Data File: IQ Size
Data Visualization and Linear Regression in R
- MWF: October 28 - November 1; TR: October 29 - October 31
- Lecture Notes as R File
- Data File: IQ Size
- Data File: Cancer Probability
- Data File: Rainfall
Machine Learning in R
- MWF: November 4 - November 6; TR: November 5
- Lecture Notes
Projects
- R Projects (MWF: November 6 - November 8; TR: November 7)
Homework
- R Homework (Due November 13th by 11:59 pm)
MySQL
Introduction to MySQL (GUI) (
- MWF: November 11 - November 13; TR: November 12
- Slides
- Lecture Notes
- In-Class Jupyter Notebook
- Solutions
MySQL and Python
- MWF: November 13 - November 15; TR: November 14
- Slides
- Lecture Notes
- In-Class Jupyter Notebook
- Solutions
Projects
- MySQL Projects (MWF: November 18 - November 22; TR: November 19 - November 21)
Homework
- MySQL Homework (Due November 25th by 11:59 pm)
Additional Topics
- Learning Objectives
- Gathering Data from the Internet (MWF: November 25; TR: November 26)
Midterm Exam
Final Exam
- MWF: December 9th at 1:00 pm; TR: December 11th at 8:00 am
Ethics Report
- Due October 7th by 11:59 pm More details can be found here.
Project Report #1
- Due November 1st by 11:59 pm More details can be found here.
Project Report ##2
- Due November 26th by 11:59 pm More details can be found here.
Final Project
- Due dates from December 1st at 11:59 pm to December 6th at 11:59pm More details can be found here.