The following table maps course session dates, lesson topics, references, and content links for ATE-252, a cross-disicplinary exploration of issues in transportation analytics.
course | date | wk no. | session links | learning objectives | out-of-class work |
---|---|---|---|---|---|
DAT-129 | Wed 2-SEP-2020 |
1 |
Intro to course and data structure exerciseIcon project Overview |
|
|
DAT-129 | Wed 9-SEP-2020 |
2 |
git essentails |
Implement code modularity suggestions in a peer's project |
|
DAT-129 | Wed 16-SEP-2020 |
3 |
Session RecordingFile i/o, JSON, and gitBook resources (Dietel)
|
|
|
DAT-129 | Wed 23-SEP-2020 |
4 |
Session RecordingQuery spec building in JSON; advanced gitDeitel textbook: Chapter 9, special focus on 9.5 |
Clone, push to, pull from, and make pull requests to remote git repos Encode and decode JSON files in Python |
|
DAT-129 | Wed 30-SEP-2020 |
5 |
Session recordingApplication programming interfaces 1 |
Encode a query in a URL and demonstrate its use by making a URL-encoded query against a remote API compouter Write python to make HTTP requests using the requests library |
|
DAT-129 | Wed 7-OCT-2020 |
6 |
Application programming interfaces 2: Share mini-projectsPrepare peer tutorial for next week |
Wrap-up API proj
Prepare peer tutorials |
|
DAT-129 | Wed 14-OCT-2020 |
7 |
Video recordingCheck-in on peer teaching-Visualize API Data |
Prepare your peer mini-lessons and reference sheets for next week Attempt a rudimentary contiainerization and visualization of your API data for the 28th of October. |
|
DAT-129 | Wed 21-OCT-2020 |
8 |
DAT Planning SurveyBurst peer-teaching round robins
|
Tidy up and fully-bake API project for "formal" sharing next week before Scraping soup madness! |
|
DAT-129 | Wed 28-OCT-2020 |
9 |
Session Recording
passcode: %t3chnology%
Formal API sharingPrepared 5-minute overview of your process, data, conclusions, and ideas for future work. Prepare to field questions from other students. Database interactivity |
|
|
DAT-129 | Wed 4-NOV-2020 |
10 |
Video recording of session
passcode: %t3chnology%
|
Practice DB inserts & selectsChoose a data source, either a CSV related to your project or from your API calls: create a table of appropriate column types, write inserts to store the data, and demonstrate that you can extract data with the cursor.extractall() function. Enjoy |
|
DAT-129 | Wed 11-NOV-2020 |
11 |
DB Joins VideoScraping demo
passcode: %t3chnology%
Slack connectWeb fundamentals & scraping |
ToDo for wrap-up of scrapingChoose a site to scrape interesting data from and include it in our tracker. Plan to have some work time next week on Scraping! |
|
DAT-129 | Wed 18-NOV-2020 |
12 |
Video recording of session
passcode: %t3chnology%
Scraping mini project worktimeShared worktime on scraping Final project |
Begin your final projectMake an entry in our master tracker spreadsheet |
|
DAT-129 | Wed 25--NOV-2020 |
x |
Turkey day; no class all week |
||
DAT-129 | Wed 2-DEC-2020 |
13 |
FA20 Session RecordingSP20 Session RecordingOS & file tree traversalsVisualization with matplotlibFinal project design |
|
|
DAT-129 | Wed 9-DEC-2020 |
14 |
Final project design consultations |
|