home
techred home > dat-203 sequence

DAT-203: Visualization and warehousing Course schedule | CCAC | FALL 2020 | North Campus

course date wk no. session links learning objectives out-of-class work
DAT-203 Monday
31-AUG-2020
1

Session Recording

youtube screen cast

Design a personally relevant data gathering project

  1. Create a git repo for your visualize yourself project
  2. Make an entry in our visualize yourself tracker (linked at the top of the module page)
DAT-203 Monday
7-SEP-2020
xx

LABOR DAY:NO CLASS

DAT-203 Monday
14-SEP-2020
2

Indicies

Categorical data I:
Country-level development indicies

Visualize Yourself: Factor model

Please create a factor model with your core outcome variable and your theory about its primary influencing factors. Compose this by hand, with a pen, or in software. Upload the image to your repository on git. Use markdown to describe the image and embed it in your markdown script. Remember , make the file called readme.md.

Internet Encyclopedic Source Quality

Create a sharable directory

      Create a spreadsheet to compute index values for wikipedia and non-wikipedia sources
      Choose three underlying measures of quality, with accompanying documentation such that we can assess test-retest reliability across testers.
      Devise a sampling mechanism in which you assess the quality of at least 6 topics on both wikipedia.org AND the next highest quality available encyclopedic source. Meaning: You should find some third party to choose your sampled topics.
      Create a directory in our shared drive linked below and upload your findings. Please record the actual URL of both wikipedia and non-wikipedia sources used so they can be retested. Use first names only on files.
DAT-203 Monday
21-SEP-2020
3 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 Monday
28-SEP-2020
4

Video recording of session

video link

Index Analysis Review

Visualize Self Project Updates

Tufte Chapter 1 Example

    DAT-203 Monday
    5-OCT-2020
    5

    Session recording

    video link

    Create and Elaborate on a data project plan

    Make a good faith effort at using pivot tables/charts to investigate some or all of the Hazelwood inquiry questions.

    Submission

    Upload screen shots of your pivot tables and use markdown to document the figures. Push to your github account. Then post a link in our tracker.

    DAT-203 Monday
    12-OCT-2020
    6

    Session recording

    video link

    Tufte Ch. 3

    Peer presentations by Paula

    Review beta data tools

    1. Firm up your visualization of self project topic, inquiry question, and factor model. Zero in on a measurable, compelling outcome variable of interest to you.
    2. Study and attempt an example or two from one of the python libraries in the visualization Triumvirate linked below
    3. Illustrate your hypothesis about the relationship between one independent variable and your outcome variable by creating mock data that conveys the shape and intensity (slope) of your chosen bivariate relationship. Prepare to share in small groups next week.
    DAT-203 Monday
    19-OCT-2020
    7

    Session recording

    video link

    DAT Planning Survey

    Tufte Chapter 4

    Zach and Kayla (Ch. 3: Drew)

        What is a rug plot useful for? Tufte p. 135
    DAT-203 Monday
    26-OCT-2020
    8

    Tufte presentations

    ch.5: Joanne, Chelsea

    DAT-203 Monday
    2-NOV-2020
    9

    Tufte presentations

    ch.6: Eric W. Steve W.

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

    DAT-203 Monday
    9-NOV-2020
    10

    Tufte Presentaitons

    Ch. 7: Michael F. Rachel R.

    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-203 Monday
    16-NOV-2020
    11

    Tufte Presentations

    Ch. 8: Brandyn, Vajiheh

    DAT-203 Monday
    16-NOV-2020
    xx

    TURKEY DAY BREAK ALL WEEK

    DAT-203 Monday
    30-NOV-2020
    12

    Tofte chapter notes

    Database/project check-in

      DAT-203 Monday
      7-DEC-2020
      13

      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 Monday
        14-DEC-2020
        14

        Share final projects

          DAT-203 Thursday
          7-May-2020
          14

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