M259 Visualizing Information (4 units)

George Legrady
Yoon Chung Han

Lecture/lab: Tues-Thurs 12:00-1:50 Ellings Studio 2611

Course Description

A production course in data query, analysis, processing and visualization. The course will begin with MySQL data queries, followed by visualization assignments in the java based Processing environment. There are 3/4 projects: 1) A linear frequency visualization, 2) 2D spatial map, 3) a correlation with an external data source such as the NY TImes or Amazin, and 4) a 3D interactive visualization.

Given the short time to realize these projects, we are using a specific multivariated dataset of over 70 million transactions for which various visualization modules have been created to help us focus on the goals of the course: To learn how to use visual language by which to represent abstract data.

The data we are using is representative of any datasets. It consists of library transactions of titles of books, DVDs, CDs and other media checked out by the general public since 2005. Every dataset contains the same scalar, numeric, time-based, semantic and other forms of metadata which allow for a multiplicity and complex modes of data correlation and representation. Our goal is to learn how to discover interesting patterns in the data, and how to visualizat it.

Koolhaas' Seattle Library

OMA/LMN Concept Book | PrinceRamus on TED | SPL Architecture

Data Source

Classification System

DataBase Management

Student Resources
The data consists of checked-out items (books, cds, movies, etc.) retrieved by the hour through the art project "Making Visible the Invisible" | Hourly Histogram

Dewey Classification | SPL Data Explanation | SPL Search | SPL ItemTypes | SPL Library Access | Dewey/LOC | SPL data translation

Code and visualization examples use MySQL (index) and Processing (index)
Sequel Pro (Apple) | HeidiSQL (Windows) | w3School Tutorial

Student Forum| Last Year's Course | Previous Student Visualizations


MAT Seminar 01.07
Andres Burbano: The Latin American Forum at the International Symposium on Electronic Arts – 2010 to 2013

[wk 1].......Lecture 01.08

Course Overview

Lab 01.10
[Setup] [MySQL_Intro][Other Commands]

MAT Seminar 01.14
Stephen Travis Pope: Why I Still Use Smalltalk

[wk 2].......Lecture 01.15

Frequency Mapping

Presentation & Lab 01.17

SQL Queries | Data Mining

SPL Data Examples: Expl | [Top14Avrg] [ShowAvrg] [TotalVolHour] [OrderByVolume]
Words | 500 Billion Words [NGram]

Karl Yerkes [Graph] | [MySql_Lab_2][InnerJoin][Karl's Demos]

MAT Seminar 01.21
Danny Rozin: Daniel Rozin's Mirrors

[wk 3].......Lecture 01.22

12W UCSB Projects
11F New School Projects

Lab 01.24
SQL Queries Review | Grid System | Grid Visuals | infoesthetics

Anis Haron [SQL_Question] [data] | Yoon
Matthew Willse [SQL question] [data] | Andrew Bowe

SimpleSQL | SQL into Processing, Grid lay-out

MAT Seminar 01.28
Mark Goerner: Releasing the Artistic Beast Within

[wk 4].......Lecture 01.29

Frequency Examples

Lab 01.31
Design Basics (General Design Source LInk)

Lives of Numbers | Wattenberg | Timelines

Data Mining & Linear Frequency StudentPresentation


MAT Seminar 02.04
Alan Macy: Beauty and the Origins of Electrophysiology, Telecommunications and the Global Theater

[wk 5].......Lecture 02.05


Lab 02.07

Basak Alper (presenter)

"Weighted Graph Comparison Techniques"

2D Space | Basic Interactivity | Lab: Simple 2D Spatial Examples

MAT Seminar 02.12
Henry Lowood: An Open Game: DOOM, Game Engines, and the New Game Industry of the 1990s

[wk 6].......Lecture 02.12


Lab 02.14
2D Spatial Map Student Idea Presentation Ikeda | open processing| visualizing.org

Visual Criticism (Kosara)

2D Spatial Map Student Presentation | Jay Twitter demo

MAT Seminar 02.18
ISEA Presentors: ISEA Presenters’ Evening

[wk 7].......Lecture 02.19


Lab 02.21

Google Correlate [Instructions] | Correlation Note | Correlation Demo

Culture & Data: Digital Design | Million Dollar blocks | vvoice |

Correlating Other Data Sources


MAT Seminar 02.25
Dean Hovey: From the mouse to mobile bio-sensors: A window into 3 decades of design and interface development

[wk 8].......Lecture 02.26


Lab 02.28

Correlation Student presentation

"Eyes Have it", Shneiderman

Processing in 3D | Peasycam

MAT Seminar 03.04
Sharon Kanach: Xenakis Matters

[wk 9].......Lecture 03.05


Lab 03.07

3D Spatial: RJ Duran | Qian Liu | Yoon Chung Han | 3D + Time

"Unresolved Problems", (Kosara)

Final Project Proposal

[wk 10]..................03.12


Lab & Individual Meetings (Dead Week)

Lab & Individual Meetings (Dead Week)

[wk 11]......Lecture 03.19
Final Student Presentations

Technical TextBooks

Graphics of Large Datasets, Unwin, Theus, Hofmann (Statistics & Computing)[UCSB online]
Visualizing Data, [Examples] Ben Fry (Online text by the co-author of Processing)
MySQL Ben Forta

Information Visualization

Mapping & Design
Graphic Design
Literary Analysis
Online References
Additional Processing Refs
Atlas of Science | The Visual Display of Quantitative Information | Envisioning Information, Edward Tufte
Mapping Graphic Navigational Systems, Fawcett-Tang
DataFlow: Visualizing Information in Graphic Design, Gestalten
Graphs, Maps, Trees, Franco Moretti
Visual Complexity | Infoesthetics | 259 Links Resource
Shiffman | Greenberg [code] | Terzidis [code]

Grading Completion of projects 60%
Final Project 30%
Attendance, Participation and Literature Review 10%

The course is designed to accommodate both beginning and advanced students. All students will be expected to perform at the level of their expertise but programming experience is desirable.