Schedule

The first half of the lectures will cover basic programming. The second half of the lectures will cover databases and visualization.

Session Date Topic Assignments / Notes
    PYTHON  
1 M 7/2 Expressions, Variables, and Primitive Data Types
Slides, Whiteboard
Notes 1: A, B, C1-C3, D1
  W 7/4 HOLIDAY  
2 M 7/9 String formatting, Lists, Basic Control Flow
Whiteboard
Notes 1: D2-D5, E, F, G
3 W 7/11 Sets, Dictionaries, Advanced Control Flow
Slides, Whiteboard
HW 1
Notes 1: G, H, I, J
4 M 7/16 Advanced Control Flow
Whiteboard
Notes 1: J
5 W 7/18 List Comprehensions, Functions, Exam Review
Whiteboard
HW 2
Notes 1: J, J2, K, Y2
    »»» ALL PYTHON NOTES «««  
    SQL  
6 M 7/23 Databases and the ER model
Slides
Exam 1
Notes 2: A-B
7 W 7/25 Selecting and joins
Slides, Whiteboard, Query Template
Notes 2: C
8 M 7/30 Aggregation and Python integration
Whiteboard, Query Template
Notes 2: E, F, Y
    PANDAS AND VISUALIZATION  
9 W 8/1 Pandas HW 3
Notes 3: A
10 M 8/6 Visualization in MatPlotLib Exam 2
Notes 3: A2
11 W 8/8 Project expo  



Below is a list of optional readings. The primary resource for the class will be the GitHub notebooks, but additional details and exercises can be found in the linked texts.

Session Topic References
  PYTHON  
1 Expressions, Variables, and Primitive Data Types ABS 1
P4E 1, 2
LPTHW 1-5, 7, 8, 9
2 String formatting, Lists, Sets, Basic Control Flow ABS 2, 4, 6
P4E 3, 6, 8, 10
LPTHW 6-10, 27-31, 34
3 Dictionaries, Advanced Control Flow ABS 2, 5
P4E 5, 9
LPTHW 32-33, 39
4 Files and functions; the command line ABS 3, 8, 9, 14
P4E 4, 7
LPTHW 15-21, 35, Appendix
5 Web scraping and APIs ABS 11
P4E 13
  SQL  
6 Databases and the ER model LMSQL 4, 6
7 Selecting and joins LMSQL 5, 7
8 Aggregation and Python integration P4E 15
  PANDAS AND VISUALIZATION  
9 Pandas P4DA 5-7, 9
10 Visualization in MatPlotLib P4E 16
P4DA 8