home
techred home > data anlaytics master sequence

Three-course data analytics series at CCAC's North Campus

  1. DAT-102: Introduction to Data Analytics
  2. DAT-201: Data Analytics 1
  3. DAT-202: Data Analytics 2

Course concept progression

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
29-JAN-19
1

Introduction to data analytics

  • TR.102.DS.3.A - Decompose the data analytics field
  • TR.102.DS.1.A - Data Tables - Creating: Create a data table with logically assigned types for each column and a unique identifier for each row
DAT-102 TUE
5-FEB-19
2
  • TR.102.DS.3.B Broadly Classify data analytic artifacts/products/displays (Quant/qual/categorical/textual)
  • TR.102.DS.3.C - Continuous & categorical variables
  • TR.102.DS.3.D - Data structures (list, set, stream, table, graph, tree)
  • TR.102.DS.3.E - Analytic modes: describing, modeling, predicting
  • TR.102.DS.1.B - Data Tables - Converting: Export and import data tables in .xslx, .ods, .csv formats
DAT-102 TUE
12-FEB-19
3
1
DAT-102 TUE
19-FEB-19
4

KISS: Non-summary descriptive statistics

Phase 0: Ida's whiskers

Phase 1: (full group): IQR, Box plots, and outliers

Phase 2: (full group): Scaled scores and percentiles

Exploration activities:

  1. 1: Ida's Whiskers
  2. 2: Measuring measurement error
  3. 3: Slicer-segemented blox plot wall strip
  4. 4: Displaying categorical data
  5. 5: Frequency distribution (Historgram) interpretation
  6. 6: Data range and scale categorization
  • Phase 4: (full group): Making sense of a wall of data: figure translations & the high bar of generalization
    • Data.quant.1.A: Generate box and whisker plots for categorical and non-categorical data

    Inquiry cycle on the MN trees

    DAT-102 TUE
    26-FEB-19
    5

    Summary-based descriptive stats: mean and standard deviation

    • Phase 1: Spreadsheet play-along: center and spread computation and manipulation
    • Phase 3: Trade-offs and conflicting priorities group exercise
    • Phase 4: Debrief and discussion of normality assumptions in statistical inference
    • Complete activities 1A - 1K in Chapter 1 of Statistics Notes handout
    DAT-102 TUE
    5-MAR-19
    6

    Census vs. sampling: estimates and margins of errors

    • TR.102.DS.6.A - Surveys - Designing:
    • TR.102.DS.6.B - Surveys - Sampling & Administering:
    • TR.102.DS.6.C - Surveys - Analyzing:
    DAT-102 TUE
    12-MAR-19
    7

    Univariate and multi-variate experiments

      d
    DAT-102 TUE
    19-MAR-19
    8

    Opportunity Atlas mini-project: multi-type data policy inquiry

    DAT-102 TUE
    26-MAR-19
    9

    Population proportions

    1
    DAT-102 TUE
    2-APR-19
    10

    Interpreting p-values through experimentation

    1
    DAT-102 TUE
    9-APR-19
    11

    Data gathering 2: Human subject experiments

    • TR.102.DS.7.A - Experiments - Designing:
    • TR.102.DS.7.B - Experiments - Treatment assignment & Implementing:
    • TR.102.DS.7.C - Experiments - Analyzing:
    • TR.102.Q.10 - Standard errors
    • TR.102.Q.11 - Student's T-tests - Setup
    • TR.102.Q.12 - Student's T-tests - Interpretation
    1
    TUE
    16-APR-19
    - SPRING BREAK!
    DAT-102 TUE
    23-APR-19
    12

    Sampling (final) project practice and design

    1 1
    DAT-102 TUE
    30-APR-19
    13

    Visualization best practices

    Final project concept development

    1 1
    DAT-102 TUE
    7-MAY-19
    14

    Final project sharing and celebration of data

    FINAL SESSION 1

    Data 201: Data Analytics 1

    course date wk no. session links learning objectives out-of-class work
    DAT-201 TUE
    03-SEP-19
    1

    Session outline:

    1. Welcome and introductions
    2. Project-based learning in action: Review of past term projects: project repository and student response sheet
    3. Syllabus review
    4. Pivot table glory: Past example
    5. Pivot table glory: Your turn! Grade comparison.
    • SPDSHT1: Implement VLOOKUP formulas in spreadsheets
    • SPDSHT2: Fomulate a spreadsheet to properly get slurped up by a pivot table
    • SPDSHT3: Create a pivot table to answer inquiry questions by configuring row and column selections

    Part 1: Pre-reading for week 2: Maps!

    Pre-reading on Responsible map making

    Part 2: Install QGIS

    QGIS 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).

    DAT-201 TUE
    10-SEP-19
    2

    Map projections and Intro to QGIS

    • TR.201.DS.8.A - Maps - Projections
    • TR.201.DS.8.B - Maps - Vector (points, lines, and polys) & raster (bands)
    • TR.201.DS.8.C - Maps - QGIS fundamentals

    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

    • TR.201.DS.8.D - Maps - Creating study areas
    • TR.201.DS.8.E - Maps - Flat Joins
    • TR.201.DS.8.F - Maps - Spatial Joins

    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

    (Tentative) Mapping with Nine Mile Run Watershed Association

    Solve real-world problems with a local nonprofit!
    DAT-201 TUE
    01-OCT-19
    5

    QGIS and Map Layouts

    • TR.201.DS.8.G - Maps - Layouts & printing
    • TR.201.DS.8.H - Maps - Web compatability
    DAT-201 TUE
    08-OCT-19
    6

    Worktime and presenting mapping mini-project

    6-7pm: Finlize mapping mini-project
    7-8pm: Present project to class with feedback
    8-9pm: Intro to Command Line

    • TR.201.DS.9.E - Clients - Feedback presentations
    1
    DAT-201 TUE
    15-OCT-19
    7

    Data cleaning and project lifecycle skills

    • Cleaning and batch processing with open refine
    • Data flow/tool chain building

    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 Maniuplate 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
    22-OCT-19
    8

    Clip board databases!

    How are spreadsheets and databases related? By the table, of course! Dig into the fundamentals of structure data system design, population, and querying.

    • TR.201.DB.1: Database use cases
    • TR.201.DB.2: Types (File, relational, NOSQL)
    • TR.201.DB.4.A - Tables - Data types
    • TR.201.DB.4.B - Tables - Keys
    • TR.201.DB.4.C - Tables - Foreign Keys
    • TR.201.DB.5.A - Queries - SELECT
    1
    DAT-201 TUE
    29-OCT-19
    9

    Databases: Designs, features, & use cases

    • TR.201.DB.4.D - Tables - Manipulating
    • TR.201.DB.6.A - Data - INSERT
    • TR.201.DB.6.B - Data - UPDATE
    • TR.201.DB.5.B - Queries - FROM (Joins)
    • TR.201.DB.5.C - Queries - WHERE
    • TR.201.DB.5.D - Queries - ORDER BY
    • TR.201.DB.3: Leading vendors
    • TR.201.DB.7 - Exporting
    • TR.201.DB.8.A - Connecting - Spreadsheets
    • TR.201.DB.8.B - Connecting - Python & Java
    1
    DAT-201 TUE
    05-NOV-19
    10

    Databases: Designs, features, & use cases

    • TR.201.DB.10.A - Design - Methodologies
    • TR.201.DB.10.B - Design - Creating from data statements
    • TR.201.DB.10.C - Design - Normalization
    • TR.201.DB.10.D - Design - Many-to-many relationships
    • TR.201.DB.10.E - Design - Spotting traps
    1
    DAT-201 TUE
    12-NOV-19
    11

    Tentative:

    Digital meeting with Mark Egge of High Street Consulting

    • TR.201.DB.9.A - Server - User configuration & permissions
    • TR.201.DB.9.B - Server - Access, GUIs, and SSH
    • TR.201.DB.9.D - Server - Indexes & query optimization
    • TR.201.DB.5.E - Queries - Functions
    • TR.201.DB.5.F - Queries - Fuzzy matching
    DAT-201 TUE
    19-NOV-19
    12

    Database server configuration

    Carrying 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. Creating data system flow diagram & work proceslogs
    2. Troubleshooting postgreSQL /copy commands
    3. Writing queries with aggregate functions and GROUP BY for analytics
    1 1
    TUE
    26-NOV-19
    - THANKSGIVING BREAK!
    DAT-201 TUE
    03-DEC-19
    13

    Collaborative project worktime & overview

    Please bring questions, your data, computers, and enthusiasm for collaborative help.

    • TR.201.DS.9.A - Clients - Client interviews & problem scoping
    • TR.201.DS.9.B - Clients - Specification negotiation
    • TR.201.DS.9.C - Clients - Work process logs & billing
    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.

    • TR.201.DS.9.D - Clients - Feedback conversations
    • TR.201.DS.9.E - Clients - Feedback presentations
    • TR.201.DS.9.F - Clients - Tool maintenance planning:
    • TR.201.DS.9.G - Clients - Iterative tool development: