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 MON
    28-JAN-19
    1

    Pre-reading for week 2: Maps!

    Pre-reading on Responsible map making

    DAT-201 MON
    4-FEB-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.

    DAT-201 MON
    11-FEB-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 MON
    18-FEB-19
    4

    QGIS and Map Layouts

    • TR.201.DS.8.G - Maps - Layouts & printing
    • TR.201.DS.8.H - Maps - Web compatability
    DAT-201 MON
    25-FEB-19
    5

    Civic mapping with Draw the Lines

    Do some work in the Draw the Lines map maker, and we'll share some of what we've observed about district-drawing, next class. The mapping mini-project is also due next class.
    DAT-201 MON
    4-MAR-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 MON
    11-MAR-19
    7

    Presentations 2nd half & CLI

    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 MON
    18-MAR-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 MON
    25-MAR-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 MON
    1-APR-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 MON
    8-APR-19
    11

    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.

    • 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
    MON
    15-APR-19
    - SPRING BREAK!
    DAT-201 MON
    22-APR-19
    12

    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
    DAT-201 MON
    29-APR-19
    13

    Outside presenter: Mark Egge, high street consulting

    • 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 MON
    6-MAY-19
    13.5

    Collaborative project worktime & overview

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

    1
    DAT-201 MON
    13-MAY-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: