home
techred home > python 2 session schedule

Course concept progression

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
29-Jan-2020
1

Intro to course and data structure exercise

  1. Complete phase 1 specification in the icon moudle
  2. Update or create a git respository to house your work in this classs. Setting up GIT tutorial
  3. Email Eric at edarsow@ccac.edu with a URL to your current respository for posting on our course website
DAT-129 Wed
5-Feb-2020
2

Dictionaries, JSON, and git

git branching, forking, and pull requests

Implement code modularity suggestions in a peer's project

  1. Clone down a peer's git repository from last week. Create a new branch from their primary work branch on which you can make adjustments without interfering with their workflow.
  2. Implement functionality to allow for display of an icon written to a text file. The program should ask the user for the name of the file (assuming it's in script's directory) AND the character used to represent no shading and the character used to represent shading.
DAT-129 Wed
12-Feb-2020
3

File i/o, JSON, and git

  1. Review modularity of code concerning Icon processing
  2. Git merging, conflict resolution, forking, pull requests
  3. Reviewing essential text file processing: dictionary traversals
  4. File processing examples
  1. Complete our icon project with as many transformations as possible
  2. Make sure to have it pushed to your git repo and have emailed Eric the link and Be sure to have reviewed a peer's project
  3. Explore the city of Pittsburg's capital projects on the WPRDC and answer a question by processing the dataset as a CSV
DAT-129 Wed
19-Feb-2020
4

Query spec building in JSON; advanced git

Deitel 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

  1. Create a .json file which encodes a search criteria for capital projects in Pittsburgh. Write python code which ingests that JSON file and uses it when iterating over the capital projects file, creating an output file featuring only projects that match your criteria.
  2. Create a markdown file in your capital projects work folder that details how to use your JSON file to encode a search criteria. Include at least three different criteria in your search.
  3. Push your changes to your own github repository
DAT-129 Wed
26-Feb-2020
5

Application programming interfaces 1

DAT-129 Wed
4-March-2020
6

Unit testing

Content to be developed

DAT-129 Wed
11-March-2020
7

Application programming interfaces: Share mini-projects

DAT-129 Wed
18-March-2020
8

Object-oriented python

DAT-129 Wed
25-March-2020
9

Web fundamentals & scraping

DAT-129 Wed
1-April-2020
10

Scraping mini project sharing

DAT-129 Wed
8-April-2020
X

Break

No class meeting!

DAT-129 Wed
15-April-2020
11

OS & file tree traversals

DAT-129 Wed
22-April-2020
12

Database connectivity

PA crash data home

First 100 rows of the 1+ GB CSV file for testing

DAT-129 Wed
29-April-2020
12

Python on the web with Django!

Final project design consultations

DAT-129 Wed
6-May-2020
14

Final grade proposals

Note: Attendance at final session and sharing of fully-baked final project is required to sufficiently justify a grade proposal of A or B except for pre-approved absences and “urgent, incidental, overriding life events”

Final project Sharing