Course Schedule¶
Week # |
Week |
Course Topics |
Labs |
Project |
Test |
Test Concepts |
|---|---|---|---|---|---|---|
1 |
September 7-13 |
Introduction to Data Analytics and Community Building |
- |
- |
- |
- |
2 |
September 14-20 |
Command line and Microsoft Excel |
Lab 0: (Optional) Installation and setup |
- |
- |
- |
3 |
September 21-27 |
Command line and Jupyter Lab |
Lab 1: OS file systems & Excel |
- |
- |
- |
4 |
September 28 - Oct 4 |
Introduction to Python |
Lab 2: Git & command line |
- |
Test 1 |
Git; OS and Excel |
5 |
October 5 - 11 |
Programming in Python |
Lab 3: Python I |
- |
Bonus Test 1 |
- |
6 |
October 12 - 18 |
Rest and Catchup (no new material) |
N/A |
- |
Test 2 |
General Python |
7 |
October 19 - 25 |
Data analysis in Python |
N/A |
Milestone 1: Topic/area/dataset |
Bonus Test 2 |
- |
8 |
October 26 - Nov 1 |
Introduction to Data Visualization |
Lab 4: Python II |
- |
Test 3 |
Pandas and Python Functions |
9 |
November 2 - 8 |
Choosing an appropriate visualization & EDA |
Lab 5 and 6: Git and Data Visualization |
Milestone 2: Data Analysis |
Bonus Test 3 |
- |
10 |
November 9 - 15 |
~Introduction to Tableau~ (Cancelled) |
Lab 7: Tableau |
- |
Test 4 (Extended Window) |
Data Visualizations |
11 |
November 16 - 22 |
Introduction to Databases |
Lab 8: SQL I |
Milestone 3: Cleanup and addressing feedback |
Bonus Test 4 |
- |
12 |
November 23 - 29 |
Working with Databases |
Lab 9: SQL II |
- |
Test 5 |
Databases |
13 |
November 30 - Dec 6 |
Poster Session: Better Posters v2 |
Lab 10: Poster Session |
Milestone 4: Final Project |
Bonus Test 5 |
- |