Below is the complete lecture and section schedule. A Green day indicates that the emphasis will be python programming. A Blue day indicates the emphasis will be UNIX and Bash. An Orange day indicates the emphasis will be SQL and databases. An Teal day indicates the emphasis will be a more general topic. A Red day indicates an exam.
| Monday | Wednesday | Friday | Lab | |
|
1/8/2018 NO CLASS |
1/10/2018 Course Intro, Intro to python, hello world python program |
8/12/2018 Strings and Printing |
NONE | |
|
1/15/2018 NO CLASS - MLK DAY |
1/17/2018 Functions (part I) |
1/19/2018 Functions (part II) |
Lab setup, Strings, Printing | |
|
1/22/2018 Variables, Types, and Expressions (part I) |
1/24/2018 Variables, Types, and Expressions (part II) |
1/26/2018 User Input |
Functions and Variables | |
|
1/29/2018 If-Statements |
1/31/2018 While-Loops |
2/2/2018 Function Parameters and Return-values (part I) |
If-statements |
|
|
2/5/2018 Function Parameters and Return-values (part II) |
2/7/2018 Nested if-statements and while-loops |
2/9/2018 EXAM 1 |
Loops, Parameters, and returns |
|
|
2/12/2018 Lists and for-loops (part I) |
2/14/2018 Lists and for-loops (part II) |
2/16/2018 Advanced Strings |
Lists and for-loops |
|
|
2/19/2018 Breif intro to UNIX OS, file system, and paths |
2/21/2018 Intro to bash: cd, ls, cat, rm, etc... |
2/23/2018 Reading and writing files (part I) |
Files and file systems | |
|
2/26/2018 Reading and writing files (part II) |
2/28/2018 Basic data processing with CSV |
3/2/2018 EXAM 2 |
Files and file systems | |
|
3/5/2018 NO CLASS - SPRING BREAK |
3/7/2018 NO CLASS - SPRING BREAK |
3/9/2018 NO CLASS - SPRING BREAK |
NO CLASS - SPRING BREAK | |
|
3/12/2018 Mapping and Dictionaries |
3/14/2018 Mapping and Dictionaries |
3/16/2018 Sets and Dictionaries |
Files and file systems | |
|
3/19/2018 Intro to databases, DBMSs, and the relational model (part I) |
3/21/2018 Intro to databases, DBMSs, and the relational model (part II) |
3/23/2018 SQL and SQLite (part I) |
SQL and SQLite (part I) |
|
|
3/26/2018 The sqlite3 python module (part I) |
3/28/2018 The sqlite3 python module (part II) |
3/30/2018 Regular Expressions |
SQL, sqlite3 | |
|
4/2/2018 Regex in Python |
4/4/2018 Regex in SQL |
4/6/2018 SQL and DB security |
Regex in python, SQL | |
|
4/9/2018 Data visualization |
4/11/2018 Visualizing data with python and matplotlib (part I) |
4/13/2018 EXAM 3 |
Data vis in python | |
|
4/16/2018 Visualizing data with python and matplotlib (part II) |
4/18/2018 Visualizing data with python and matplotlib (part III) |
4/20/2018 Data cleaning |
matplotlib | |
|
4/23/2018 More shell commands </br> |
4/25/2018 Shell scripting (part I) </br> |
4/27/2018 Shell scripting (part II) </br> |
Shell scripting | |
|
4/30/2018 Regex in bash |
5/2/2018 Course wrap-up |
5/4/2018 FIRST DAY OF FINALS |
Shell scripting |