home
techred home > dat-203 sequence

DAT-203: Visualization and warehousing Course schedule | CCAC | Spring 2020 | West Hills Center

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-203 Thursday
30-JAN-2020
1

Indicies

Creating indicies to aggregate several measures

Create a sharable directory

      Create a spreadsheet to compute index values for wikipedia and non-wikipedia sources
      Sample a handful of sites around three different topics
      Create a directory in our shared drive linked below and upload your findings. Use first names only.
DAT-203 Thursday
6-February-2020
2

Categorical data I:
Country-level development indicies

  1. Create a git repository dedicated to your work for this course, DAT-203. Email Eric a link to your repo, please.
  2. Compile a multi-country comparison of two or more development index values as described in our index mini-project.
DAT-203 Thursday
13-Februrary-2020
3

Categorical data II:
Visualizing categorical data over time

table_chart Shared google doc of index explorations

      Prepare a final, fully-baked version of a figure showing change in your chosen indexes during the end of the cold war. Include a beefy title, source attribution, well-formatted lines, and a caption discussing what changes are visible.
DAT-203 Thursday
20-Februrary-2020
4

    DAT-203 Thursday
    27-Februrary-2020
    5

    Create and Elaborate on a data project plan

    1. Dedicate time to fully planning your project using our phase guide for phase 1: planning
    2. Proceed through phase 2 and 3: building a quantitative scale data gathering instrument. Begin using your tool informally for beta testing and recording your observations
    DAT-203 Thursday
    5-March-2020
    6

    Mid-term grade proposals: Meet in person at North

    You'll be asked to propose a fair mid-term grade based on work completed up to that moment

    Review beta data tools

    1. Read your assigned chapter in the Tofte book
    2. Distill down 3-6 key points from your chapter to share with the class
    3. Choose 3 visualziations by other folks related to the topic of your donation solicitation letter
    4. Discuss your chapter's principles as applied to your chosen visualizations. Rememeber, you can find examples and "non-examples" of the book principles
    5. Create an audience profile for your data visualization
    DAT-203 Thursday
    12-March-2020
    7

    Synchronous Zoom only @
    6:00pm; Don't drive to North!

    Join Zoom Meeting
    Time: Mar 12, 2020 06:00 PM ET
    https://ccac.zoom.us/j/743230305
    +1 646 558 8656 US (New York)
    Meeting ID: 743 230 305

    Data for Good

    1. Read your assigne chapter in the Tofte book
    2. Distill down 3-6 key points from your chapter to share with the class
    3. Choose 3 visualziations by other folks related to the topic of your donation solicitation letter
    4. Discuss your chapter's principles as applied to your chosen visualizations. Rememeber, you can find examples and "non-examples" of the book principles
    5. Create an audience profile for your data visualization

        What is a rug plot useful for? Tufte p. 135
    DAT-203 Thursday
    19-March-2020
    -

    No session: rescheduled "spring break"

    DAT-203 Thursday
    26-March-2020
    8

    No session meeting due to instructor burnout

    Please continue gathering data for your personal data project and the data-for-good mini project.

    DAT-203 Thursday
    2-April-2020
    9

    MtngID: 614 961 8122
    Ph:+1 646-558-8656

    Book notes

    Databaseify your vis-of-self

    Please prepare to create a data warehouse with your data by first creating a simple relational database in which to store your evolving information about yourself

        Create a SQL script which creates a database and appropriately linked tables in which you can readily insert your data.
        Upload your SQL script to your project github repository before next class on warehousing
    DAT-129 Thu
    9-April-2020
    10

    MtngID: 614 961 8122
    Ph:+1 646-558-8656

    DAT-203 Thursday
    16-April-2020
    11

    MtngID: 614 961 8122
    Ph:+1 646-558-8656

    Tofte chapter notes

    Database/project check-in

      DAT-203 Thursday
      23-April-2020
      12

      MtngID: 614 961 8122
      Ph:+1 646-558-8656

      Extracting and visualizing data

      Please be ready to do some select statements on your database in python or R and we'll tinker with Pandas

        DAT-203 Thursday
        30-April-2020
        13

        MtngID: 614 961 8122
        Ph:+1 646-558-8656

        Data warehouse and dashboard group project

        Work with your peers to create a mini tool-chain from multiple discrete sources into a warehouse and into a simple dashboard for visualization and manipulation

          DAT-203 Thursday
          7-May-2020
          14

          MtngID: 614 961 8122
          Ph:+1 646-558-8656

          Share final projects