Lectures
The course covers the following main topics, with corresponding lecture materials available in the lectures folder in our course repository:
Schedule
Tuesday, May 13: Lecture 01: Welcome to QTM 151 - Introduction and Course Overview. 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.
Wednesday, May 14: Lecture 02: Jupyter Notebooks, Packages, Variables, and Lists. Lecture Slides, Lecture Notebook.
Thursday, May 15: Lecture 03: Maths Operations, Arrays, and Boolean Logic. Lecture Slides, Lecture Notebook
- Kahoot Quiz. The quiz is optional and will not be graded. We will do it in class! It is a fun way to review the material covered in the lecture.
Friday, May 16: Lecture 04: Quiz 01 - Based on Lectures 01-03. The repository contains the quiz questions and will be made online on the day of the quiz.
Monday, May 19: Lecture 05: Conditional Statements. Lecture Slides, Lecture Notebook.
Tuesday, May 20: Lecture 06: While and For Loops. Lecture Slides, Lecture Notebook.
Wednesday, May 21: Lecture 07: Functions. Lecture Slides, Lecture Notebook.
Thursday, May 22: Lecture 08: Data Wrangling with Pandas. Lecture Slides, Lecture Notebook.
Friday, May 23: Lecture 09: Quiz 02 - Based on Lectures 05-08. As with Quiz 01, the repository will be available on the day of the quiz.
Monday, May 26: Lecture 10: Subsetting and Filtering Data. Lecture Slides, Lecture Notebook.
Tuesday, May 27: Lecture 11: Introduction to SQL. Lecture Slides, Lecture Notebook.
Wednesday, May 28: Lecture 12: SQL in Python. Lecture Slides, Lecture Notebook.
Thursday, May 29: Lecture 13: Merge Tables in SQL. Lecture Slides, Lecture Notebook.
Friday, May 30: Lecture 14: Quiz 03 - Based on Lectures 10-13.
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.