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

Statistics in Excel

Excel Cleaning and Pivot Tables

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 (

Reading Data in Python

Loops in Python

Statistics in Python and Other Python Libraries

Data Cleaning in Python

Machine Learning in Python

Python Projects

Homework

R

Introduction to R

Data Visualization and Linear Regression in R

Machine Learning in R

Projects

  • R Projects (MWF: November 6 - November 8; TR: November 7)

Homework

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

Additional Topics

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.