The following table maps course session dates, lesson topics, references, and content links for all three Data Analytics courses in the series.
course | date | wk no. | session links | learning objectives | out-of-class work |
---|---|---|---|---|---|
DAT-102 | Tue 28-Jan-2020 |
1 |
Introduction to data analytics |
|
|
DAT-102 | Tue 4-Feb-2020 |
2 | ` |
|
|
DAT-102 | Tue 11-Feb-2020 |
3 |
|
Please transfer all of your strip survey data into a spreadsheet with columns for the Strip survey ID, the slicer question response, and the raw spectrum question measurement. Upload your spreadsheet to the cloud drive of strip surveys with the SAME NAME as your strip survey except with "_results" attached to the end. So if your original file name was "eric_stripsurvey.pdf" your results file will be called "eric_stripsurvey_results.ods". If you are a spreadsheet whiz, review the sample strip survey analysis and begin your spreadsheet creation process which we'll continue next week. |
|
DAT-102 | Tue 18-Feb-2020 |
4 |
KISS: Non-summary descriptive statisticsPhase 0: Ida's whiskers Phase 1: (full group): IQR, Box plots, and outliers Phase 2: (full group): Scaled scores and percentiles Exploration activities:
|
|
|
DAT-102 | Tue 25-Feb-2020 |
5 |
Wrapping up non-summary statisticsSummary-based descriptive stats: mean and standard deviation
|
The key for the exercises will be posted here during class next week. |
|
DAT-102 | Tue 3-March-2020 |
6 |
Applying mean, median, and standard deviationMatch up the Distribution, stats blocks, box plot, and data source in this file
|
|
|
DAT-102 | Tue 10-March-2020 |
7 |
Sampling!Begin library section sampling, to be continued next week. |
|
Please study the two American Journal of Public Health articles distributed in class. Prepare to dig into their confience intervals for each sub-population:
|
DAT-102 | Tue 17-March-2020 |
- | rescheduled "spring break" | ||
DAT-102 | Tue 24-March-2020 |
8 |
Session cancelled by CCAC admin due to COVID-19 reorganization planning |
||
DAT-102 | Tue 31-March-2020 |
9 |
MtngID: 614 961 8122 Library samples continued |
|
NOTE: Skip hypothesis testing questions/sectionsDedicate a few hours hours to carefully responding to the analysis questions from your library sample. See our sampling module, and choose the library sampling mini-project. Uplod all your work in our Shared drive for library upload also linked in the module resources. Be sure to generate your own file prefix to ensure grouping of your work when the directory is sorted. |
Tue 7-Apr-2020 |
10 |
MtngID: 614 961 8122 Interpreting sample dataSession agenda
|
Wrap-up library samplingPlease follow the out-of-class assignment instructions from last week if you didn't yet complete a thorough working through of questions 1-6 of our analysis guide. Remember: no hypothesis tests at this stage. And then upload your work to the shared drive linked in last week's HW. |
||
DAT-102 | Tue 14-April-2020 |
11 |
MtngID: 614 961 8122 Opportunity Atlas mini-project: multi-type data policy inquiry |
|
Dig into the Opp AtlasPlease complete the exercises 1 and 2 on the Exploring the Opportunity Atlas and upload your results to our shared drive when complete. Be sure to print off the student worksheet (or edit it digitally) linked inside the module. Est. Time: 3-ish hoursThe true/false exercise in the student worksheet is very rigorous and worthy of some thought. Dedicating beyond 3 ish hours to this assignment is not intended, so please do not stress about "not finishing". I'd rather you take your time and explore the Atlas than worry about the status of your answers to questions on a worksheet. In other words, the worksheet is our means of familiarity and not meant to be an assignment in its own right. Start thinking about your final project |
DAT-102 | Tue 21-April-2020 |
12 |
MtngID: 614 961 8122 Opp Atlas 2Final project practice and design |
1 |
OPTIONAL Out of class:Digest PGH Inquality reportDue to COVID-19 reorganiation, we will be unable to discuss the data and the sociology behind Pittsburgh's Inequality Across Gender and Race Report issued by the Pittsburgh Gender Equity Commission. As you desire, please engage with the report on your own and with others in your various circles. These discussion questions may be a guide for your discussion:
|
DAT-102 | Tue 28-April-2020 |
13 |
MtngID: 614 961 8122 Final project concept development |
1 | 1 |
DAT-102 | Tue 5-May-2020 |
14 |
MtngID: 614 961 8122 FINAL EXAM PERIOD from 6:00 - 8:00 pm |
course | date | wk no. | session links | learning objectives | out-of-class work |
---|---|---|---|---|---|
DAT-201 | TUE 03-SEP-19 |
1 |
Session outline:
|
|
|
DAT-201 | TUE 10-SEP-19 |
2 |
Map projections and Intro to QGIS |
|
Part 1: Pre-reading for week 2: Maps!Pre-reading on Responsible map making Part 2: Install QGISQGIS install homepage by platform. This software package is large and complicated, but has been ported to Windows and OSX. Many students have no problems with the install, but in some cases, there are dependency issues that take quite a bit of time to resolve because QGIS is based on python and several other packages. Please follow the instructions carefully and have a working copy on your computer by 10-SEP-19 for in-class demo (but realistically, the 17th is when we'll start using it in class). Homework:Explore QGIS, make sure you understand what a layer is and how to add one. Come with questions next week. For anyone who doesn't want to aimlessly explore, here's a good (but fast!) video introduction to QGIS. |
DAT-201 | TUE 17-SEP-19 |
3 |
QGIS Demonstrations |
|
Homework:Details available on the session guide; short version: make a map with PASDA data (mostly in-class), and start on your mid-semester mapping project (mostly out-of-class). Be ready to share what you're planning to do and any initial steps you've taken, next week. |
DAT-201 | TUE 24-SEP-19 |
4 |
Mapping with Nine Mile Run Watershed AssociationSolve real-world problems with a local nonprofit! |
||
DAT-201 | TUE 01-OCT-19 |
5 |
QGIS and Map Layouts |
|
|
DAT-201 | TUE 08-OCT-19 |
6 |
Work time on projects and open refineTutorial set of nuclear explosions dataset |
CLI.FUND.1 Differentiate between the unix BASH, Microsoft Corporation's command prompt, and the Apple terminal in terms of origins, function, use, and proprietary status CLI.FUND.2 Navigate a diredctory structure with cd, ls, tab completions, and the use of the files named . and .. CLI.FUND.3 Maniplate files and directories safetly with mkdir, mv, rm, and cp CLI.FUND.4 Parse file access permissions info as displayed by ls -al and safely issue commands with superuser powers via sudo |
1 |
DAT-201 | TUE 15-OCT-19 |
7 |
Worktime and presenting mapping mini-project6-7pm: Finalize mapping mini-project |
|
1 |
DAT-201 | TUE 22-OCT-19 |
8 |
Database configuration |
|
Unless progress in class is slower than expected, please attempt the query challenges in the last section of our postgreSQL module and be prepared to share your results with your peers next week. |
DAT-201 | TUE 29-OCT-19 |
9 |
Databases continuedOverview of core linux tools:
|
|
Please copy in the jail census flat file, and attempt the sample quriers in our postgres guide Choose another flat file, perhaps one from the wprdc.org (hopefully, a really really big one), create a receiving table in postgres into which you copy the contents of the flat file for querying. Identify at least one compelling question you can answer using SQL statements to share with the class next week. |
DAT-201 | TUE 05-NOV-19 |
10 |
Databases: Designs, features, & use cases |
|
Please devote a few hours to completing this command line exercise. you will want to secure a meaningful BASH command reference on line. Look for resources with not many ads, or ones with a .edu extension. This exercise will ask you to answer lettered questions--please record answers to them as you progress through the exercises. Also, please remember to take your time and read the man pages for commands that you aren't familiar with, such as wc and others. Also, please start in on our postgres mini-project found with the button called "postgres mini-project" in our postgres module page. |
DAT-201 | TUE 12-NOV-19 |
11 |
PostGIS in actionSee steps in "postgres mini-project outline" |
|
|
DAT-201 | TUE 19-NOV-19 |
12 |
Database server configurationCarrying out even small administration tasks correctly on a database requires a basic foundation in how the larger DB system works with the operating systems and its users. Project work time
|
1 | 1 |
TUE 26-NOV-19 |
- | THANKSGIVING BREAK! | |||
DAT-201 | TUE 03-DEC-19 |
13 |
MEET AT Monroeville Gov't Center 2700 Monroeville Blvd, Monroeville, PA 15146Tentative:Digital meeting with Mark Egge of High Street Consulting Collaborative project worktime & overviewPlease bring questions, your data, computers, and enthusiasm for collaborative help. |
|
1 |
DAT-201 | TUE 10-DEC-19 |
14 |
Final project sharing!Bring fully-baked final project to class at our normal 6:00 pm. We'll share what you've discovered, submit grade proposals, and offer final program feedback. |
|