---
title: "Lectures"
---

The course covers the following main topics, with corresponding lecture
materials available in the [lectures
folder in our course repository](https://github.com/danilofreire/qtm151/tree/main/lectures):

## Schedule

- Wednesday, August 28: [Lecture 01: Welcome to QTM 151 -
  Introduction](https://danilofreire.github.io/qtm151/lectures/lecture-01/01-introduction.html).
  Please make sure to install the necessary software for the course by
  following the [Course Tutorials: How to Install Anaconda, Jupyter, PostgreSQL, VSCode, and
  Open a Free Educational Account on
  GitHub](https://danilofreire.github.io/qtm151/tutorials/tutorials.html).

- Monday, September 02: Labour Day (no class)

- Wednesday, September 04: [Lecture 02: GitHub Review](https://danilofreire.github.io/qtm151/lectures/lecture-02/02-github-review.html) and [Introduction to Jupyter Notebooks](https://github.com/danilofreire/qtm151/blob/main/lectures/lecture-02/02-jupyter.ipynb)
  - **Assignment 01:** [Problem Set 01](https://github.com/danilofreire/qtm151/blob/main/assignments/01-assignment.ipynb)

- Monday, September 09: [Lecture 03: Variables and Lists](https://github.com/danilofreire/qtm151/blob/main/lectures/lecture-03/03-variables-lists.ipynb)

- Wednesday, September 11: [Lecture 04: Mathematical Operations, Arrays, and Random Numbers](https://github.com/danilofreire/qtm151/blob/main/lectures/lecture-04/04-maths-arrays-random.ipynb)
  - **Assignment 01 due (5%)**
  - **Assignment 02:** [Problem Set 02](https://github.com/danilofreire/qtm151/blob/main/assignments/02-assignment.ipynb)

- Monday, September 16: [Lecture 05: Boolean Variables and If/Else Statements](https://github.com/danilofreire/qtm151/blob/main/lectures/lecture-05/05-boolean-if-else.ipynb)

- Wednesday, September 18: [Lecture 06: While Loops and For Loops](https://github.com/danilofreire/qtm151/blob/main/lectures/lecture-06/06-while-for.ipynb)
  - **Assignment 02 due (5%)**
  - **Assignment 03:** [Problem Set 03](https://github.com/danilofreire/qtm151/blob/main/assignments/03-assignment.ipynb)

- Monday, September 23: [Lecture 07: Applications 1: Simulation Studies](https://github.com/danilofreire/qtm151/blob/main/lectures/lecture-07/07-applications-simulation.ipynb)

- Wednesday, September 25: [Lecture 08: Functions and Arguments](https://danilofreire.github.io/qtm151/lectures/lecture-08/08-functions-arguments.ipynb)
  - **Assignment 03 due (5%)**
  - **Assignment 04:** [Problem Set 04](https://github.com/danilofreire/qtm151/blob/main/assignments/04-assignment.ipynb)

- Monday, September 30: [Lecture 09: Global and Local Variables](https://github.com/danilofreire/qtm151/blob/main/lectures/lecture-09/09-global-local.ipynb)

- Wednesday, October 02: [Lecture 10: Quiz 01: Application 02 - Operations over Multiple Datasets (6%)](https://github.com/danilofreire/qtm151/blob/main/lectures/lecture-10/10-operations-multiple-datasets.ipynb)
  - **Assignment 05:** [Problem Set 05](https://github.com/danilofreire/qtm151/blob/main/assignments/05-assignment.ipynb)

- Friday, October 04: **Assignment 04 due (5%)**

- Monday, October 07: [Lecture 11: Subsetting Data](https://github.com/danilofreire/qtm151/blob/main/lectures/lecture-11/11-subsetting-data.ipynb)

- Wednesday, October 09: [Lecture 12: Application 03: Linear Models](https://github.com/danilofreire/qtm151/blob/main/lectures/lecture-12/12-linear-models.ipynb)
  - **Assignment 05 due (5%)**
  - **Assignment 06:** [Problem Set 06](https://github.com/danilofreire/qtm151/blob/main/assignments/06-assignment.ipynb)

- Monday, October 14: Fall Break (no class)

- Wednesday, October 16: [Lecture 13: Creating and Replacing Variables](https://github.com/danilofreire/qtm151/blob/main/lectures/lecture-13/13-creating-replacing-variables.ipynb)
  - **Assignment 06 due (5%)**
  - **Assignment 07:** [Problem Set 07](https://github.com/danilofreire/qtm151/blob/main/assignments/07-assignment.ipynb)

- Monday, October 21: [Lecture 14: Quiz 2: Application 4: Random Assignment (6%)](https://github.com/danilofreire/qtm151/blob/main/lectures/lecture-14/14-random-assignment.ipynb)

- Wednesday, October 23: [Lecture 15: Aggregating Data](https://github.com/danilofreire/qtm151/blob/main/lectures/lecture-15/15-aggregating-data.ipynb)
  - **Assignment 07 due (5%)**
  - **Assignment 08:** [Problem Set 08](https://github.com/danilofreire/qtm151/blob/main/assignments/08-assignment.ipynb)

- Monday, October 28: [Lecture 16: Merging Data](https://github.com/danilofreire/qtm151/blob/main/lectures/lecture-16/16-merging-data.ipynb)

- Wednesday, October 30: [Lecture 17: Introduction to SQL](https://github.com/danilofreire/qtm151/blob/main/lectures/lecture-17/17-introduction-sql.ipynb)
  - **Assignment 08 due (5%)**
  - **Assignment 09:** [Problem Set 09](https://github.com/danilofreire/qtm151/blob/main/assignments/09-assignment.ipynb)
  - **Instructions for the Final Project:** [Final Project](https://github.com/danilofreire/qtm151/blob/main/final-project)

- Monday, November 04: [Lecture 18: Quiz 3: Application 5: Practicing Chaining (6%)](https://github.com/danilofreire/qtm151/blob/main/lectures/lecture-18/18-chaining.ipynb)

- Wednesday, November 06: [Lecture 19: Import SQL Data into Python](https://github.com/danilofreire/qtm151/blob/main/lectures/lecture-19/19-sql-python.ipynb)
  - **Assignment 09 due (5%)**
  - **Assignment 10:** [Problem Set 10](https://github.com/danilofreire/qtm151/blob/main/assignments/10-assignment.ipynb)

- Monday, November 11: [Lecture 20: Merging Tables in SQL](https://github.com/danilofreire/qtm151/blob/main/lectures/lecture-20/20-sql-merging.ipynb)

- Wednesday, November 13: [Lecture 21: Time Series Analysis](https://github.com/danilofreire/qtm151/blob/main/lectures/lecture-21/21-time-series.ipynb)
  - **Assignment 10 due (5%)**

- Monday, November 18: [Lecture 22: Quiz 4: Application 6: Practice SQL Queries (6%)](https://github.com/danilofreire/qtm151/blob/main/lectures/lecture-22/22-sql-queries.ipynb)

- Wednesday, November 20: [Lecture 23: Pivot Tables](https://github.com/danilofreire/qtm151/blob/main/lectures/lecture-23/23-pivot-tables.ipynb)

- Monday, November 25: [Lecture 24: Quiz 5: Application 8: Time Data, Panel Data, and Plots (6%)](https://github.com/danilofreire/qtm151/blob/main/lectures/lecture-24/24-time-panel-plots.ipynb)

- Wednesday, November 27: Thanksgiving Break (no class)

- Monday, December 02: [Lecture 25: Manipulating Text Data](https://github.com/danilofreire/qtm151/blob/main/lectures/lecture-25/25-text-data.ipynb)

- Wednesday, December 04: [Lecture 26: Advanced Plots](https://github.com/danilofreire/qtm151/blob/main/lectures/lecture-26/26-advanced-plots.ipynb)

- Monday, December 09: **Final Project due (20%)**

Each lecture folder contains an HTML file or a Jupyter notebook (`.ipynb`) with code examples and explanations, along with any additional resources or datasets used in the lecture.
