Robert Else & Jordan Morris Santa Barbara City College

Robert Else: Sr. Director of Institutional Assessment, Research, and Planning

Jordan Morris:

Information Systems Analyst

• One of the first CCC’s – founded in 1909 • About 20,000 students in Fall 2013 • Aspen Prize #1 Community College in the U.S.

• • IR Department of 4 IT Department of 8 + Network services + User Services

Searching for a Decision Support System…

• It has to be easy to use • It has to be affordable

• It has to be easy to use…

• • Fast implementation

It has to be easy to use…

• How many students completed “x” units and English 110/111 and Math 117, 120, or above • I need to know about students who have changed their major a lot.

• How many FTES did we generate in Online courses, over time? • Do Business majors finish or transfer earlier than Chemistry majors?

• I need facts about Ethnicity and transfer for a grant that is due Friday • Sorry, I meant Ethnicity and degree completion. Breakdown by age. Noon Friday still OK? • How many matriculating students have close to 100 units? How long have they been here?

• And while you’re at it...this should be easy...

• I need the option to exclude Summer...

• And then I would like to see...

Ahhh...

the last report I’ll need to write...

What I really want to know is...

It’s not like we don’t have the data …

Maybe we need…

Dashboards!

B I

Where is the WISDOM we have lost in the KNOWLEDGE?

Where is the knowledge we have lost in the INFORMATION?

GPA by Residency and Gender Female AB540 Male Out of Country Female Male Out of State Female Male Fall 2004 Fall 2005 2.74

2.2

2.18

3.07

3.15

2.84

2.56

2.13

3.61

2.96

2.67

2.55

Resident CA Female Male 2.75

2.47

2.7

2.52

Fall 2006 Fall 2007 Fall 2008 Fall 2009 Fall 2010 Fall 2011 2.26

2.55

2.49

2.5

2.59

2.59

2.23

3.24

2.82

2.81

2.37

2.71

2.52

2.38

2.79

2.9

2.75

2.35

2.7

2.47

2.26

2.64

2.74

2.77

2.4

2.73

2.49

2.49

2.98

1.95

2.83

2.31

2.74

2.49

2.69

3.08

2.26

2.83

2.34

2.75

2.52

2.54

2.59

2.65

2.7

2.33

2.78

2.53

Edward Tufte

Stephen Few: ThePerceptual Edge.com

We evaluated the usual suspects… Eventually Gartner led us to Tableau…

Tableau: noun: tableau; plural noun: tableaux

A group of models or motionless figures representing a scene from a story or from history; a tableau vivant….

Synonyms: picture, painting, representation, illustration, image…

Recreating a Living Picture of a historical event… The Original The recreation…

The Raft of the Medusa (1819) by Géricault

The recreation…

SBCC Data Warehouse

www.tableausoftware.com

• Robert Else [email protected]

805-897-3522 • Jordan Morris [email protected]

805-965-0581 x3029

Tableau Live Demo: Course Fill Rates

Tableau Live Demo: Student Pathways

Tableau - Student Demographics

Tableau Live Demo: Assessment Placement

Tableau Live Demo: Cohort Comparisons

Tableau Live Demo: Grades Heatmap

We set out to reproduce this study using our own data…

Work in Progress: Reproducing the CCRC study “Intensity and Attachment” (Crosta 2013)

More Crosta (2013)

Visit the Tableau Public Gallery http://www.tableausoftware.com/public/gallery