CSE-6040 - Computing For Data Analytics

Page load time:

Bootcamp Schedule for Spring 2025

This is the schedule for the bootcamp sessions.

The sessions are conducted live for OMSA students, and the session recordings are made available for VMM students via Piazza.

Recordings will be available 24-48 hours after the session and will be published in the Bootcamp Post on Piazza, for both OMSA and VMM sections.

Note: Sections titled "Student Review Content" indicate content which students should watch but will not be covered live.

Schedule Updates: Updates will be announced via Piazza and posted on the pinned bootcamp thread (although we don't anticipate many updates)

Session 1 -- Tuesday January 7

  1. Course Introduction by Professor Vuduc
  2. Bootcamp introduction, objectives, and purpose. -- Presentation Slides

Sessions below are to prepare for Midterm 1

*********************************************************************************

Student Review Content-- Watch these two videos before the next session -- Will not be covered live in the Bootcamp

Bootcamp History and Ground Rules

Bootcamp Introduction to Google Colab

**********************************************************************************

Session 2 -- Monday January 13

  1. Python Functions and Data Types Colab Notebook
  2. Variable Naming, Comments and Readability, Python Error Handling Colab Notebook

Session 3 -- Tuesday January 14

  1. Tuples Colab Notebook
  2. Lists Colab Notebook
  3. Loops Colab Notebook
  4. Range Objects Colab Notebook

Session 4 -- Wednesday January 15

  1. Sets Colab Notebook
  2. Dictionaries Part 1 Colab Notebook
  3. Dictionaries Part 2 Colab Notebook

Session 5 -- Thursday January 16

  1. Helper Functions Colab Notebook
  2. List and Dictionary Comprehensions Colab Notebook

Session 6 -- Tuesday January 21 (Monday January 20 is USA holiday)

  1. Nested Data Colab Notebook
  2. Nested Data examples Colab Notebook

Session 7 -- Wednesday January 22

  1. Lambda Functions Colcab Notebook
  2. Sorting Colab Notebook

Session 8 -- Thursday January 23

  1. Bootcamp Problem Solving Method

  2. Coding exercises to show Problem Solving Method (These are examples, and we will cover as much as we can in the two hours, but we may not get to all 4 of them)

Session 9 -- Monday January 27

  1. Zip and Enumerate Colab Notebook
  2. General Q&A on topics covered so far in the Bootcamp

Session 10 -- Wednesday January 29

Session 11 -- Monday February 3

  1. MT1 Prep Discussion -- PDF Slides
  2. TA Walkthrough of Fall 2024 Midterm 1 -- PMT1-FA24

Session 12 -- Wednesday February 5

  1. TA Walkthrough of Fall 2023 Midterm 1 -- PMT1-FA23

Session 13 -- Monday February 10

  1. TA Walkthrough of Spring 2023 Midterm 1 -- PMT1-SP23

Session 14 -- Wednesday February 12

  1. TA Walkthrough of Fall 2022 Midterm 1 -- PMT1-FA22
  2. Exam Prep Q&A Final -- PDF to be posted in the Bootcamp Piazza thread

■ Midterm 1 February 14-19

Session 15 -- Thursday February 20

  1. Prof Vuduc exam results review
  2. TA Walkthrough of exam solution

Sessions below are to prepare for Midterm 2

Session 16 -- Monday February 24

  1. Selection on Pandas Data Frames with .loc[] and .iloc[] Colab Notebook
  2. Additional Pandas functions: index, concat, merge Colab Notebook

Session 17 -- Tuesday February 25

  1. Pandas groupby and aggregation – Colab Notebook
  2. Pandas groupby with apply, summary functions, Boolean Masks Colab Notebook

*********************************************************************************

Student Review Content on SQL-- Watch these four videos on your own -- Will not be covered live in the Bootcamp

The videos are from a Bootcamp session during the Spring 2024 semester.

They cover foundational topics that we feel are necessary for all students to work with SQL in the class.

Note that the last 3 videos use the same Colab Notebook, with the link for each of these videos the same.

SQLite, SQL Queries in Jupyter NBs, DBrowser for SQLite video -- Colab Notebook

Intro to Aggregate Functions in SQLite video -- Colab Notebook

Return SQL Query Results in Pandas Dataframes video -- Colab Notebook

String Manipulation in SQLite video -- Colab Notebook

**********************************************************************************

Session 18 -- Wednesday February 26

  1. SQL content TBD

Session 19 -- Thursday February 27

  1. SQL Content TBD

*********************************************************************************

Student Review Content on numpy, will not be covered live in the Bootcamp.

Notebook to introduce numpy, does not have an accompanying video. Introduction to numpy Colab Notebook

Numpy functions and modules video -- Colab Notebook

**********************************************************************************

Session 20 -- Monday March 3

  1. Numpy array shapes – Colab Notebook
  2. Numpy Boolean masks/argsort Colab Notebook

Session 21 -- Wednesday March 5

  1. Numpy multiply and matrix multiplication, dot product Colab Notebook
  2. Broadcasting Colab Notebook

Session 22 -- Monday March 10

  1. TA Walkthrough of PMT2-EX1 (MT2 SQLite and Pandas)

    (This is the sample PMT2 for SQL and Pandas exercise formats, not an actual exam)

  2. TA Walkthrough of Fall 2024 Midterm 2 -- PMT2-FA24

Session 23 -- Wednesday March 12

  1. TA Walkthrough of Fall 2023 Midterm 2 -- PMT2-SP23

No Bootcamp Sessions the week of March 17-21, Spring Break

Session 24 -- Monday March 24

  1. TA Walkthrough of Spring 2022 Midterm 2 -- PMT2-SP22

Session 25 -- Wednesday March 26

  1. TA Walkthrough of Fall 2021 Midterm 2 -- PMT2-FA21
  2. Final Exam Prep

■ Midterm 2 March 28- April 2

Session 26 -- Thursday April 3

  1. Prof Vuduc exam results review
  2. TA Walkthrough of exam solution

Sessions below are to prepare for the Final Exam

Session 27 -- Monday April 7

  1. CSE6040 In the Real World, Panel discussion with course/program alumni -- OMSA only, details to be posted on Piazza

Session 28 -- Monday April 14

  1. TA Walkthrough of Fall 2024 Final Exam -- PFX-FA24

Session 29 -- Wednesday April 16

  1. TA Walkthrough of Spring 2024 Final Exam -- PFX-SP24

Session 30 -- Monday April 21

  1. TA Walkthrough of Fall 2023 Final Exam -- PFX-FA23

Session 31 -- Wednesday April 23

  1. TA Walkthrough of Fall 2021 Final Exam -- PFX-FA21
  2. Final Exam Prep

■ Final Exam April 25- April 30

Session 32 -- Thursday May 1

  1. Prof Vuduc exam results review
  2. TA Walkthrough of exam solution
Updated: 2025-01-17