Active Learning Resources for Understanding and Communicating Multimodal Transportation Data

Instructor Log In (click)

Datafiles to accompany the activities (do not simply click and open these files; they must be downloaded):

 

route19march07.csv

bicycle.csv

incid_types.csv

incidents.csv

loop1559.csv

loop1560.csv

loopjan09.csv

speed.csv

tjune6.csv

wim.csv

wimaug10_14.csv

wimaug8.csv

wimax1.csv

 
Bonus R-scripts:    BONUS_plyr.R    BONUS_sample_query_calls.R   BONUS_trimet_timespaceplot.R   BONUS_WIMSpacing.R
 

Chapter

Activity

Resources Link

Download the Entire Book

Frontis

1

Principles of Scientific Graphical Display

1

Principles of Graphics

2

Overview of the Datasets Available for the Class

3

An Experiment in Graphical Perception

4

Critiquing a Graphic for Graphicacy

2

Getting Started with Data

5

Setting up Your Accounts

6

Creating a Simple Database An Excel Strawman

 

7

Overview of SQL

 

8

Creating a Simple Database Now with PostgreSQL

 

9

Simple SQL

 

3

Introduction to R

 

10

An Introduction to R and R Studio

 

11

Setting Up R

 

12

A Starting Point Some Simple R

act12_StartingPoint.r

13

Reading in Data Files

act13_ReadDataFiles.r

14

R Plots

15

Learning Some Simple Plotting Features of R

act15_SomeSimplePlotting.r

16

Your First Advanced Plot

17

Code Sharing

18

Thinking like a Computer Pseudo-coding and Functions

act18_ThinkLikeComputer.r

19

Write Your Own Function

act19_WriteYourOwnFunction.r

20

Connecting to the Class Database via RODBC and PostgresSQL Drivers

21

Using R with PostgreSQL

act21_RwSQL.r

22

Packages

23

Working with Time in R

act23_Time_Lubridate.R

4

Using Graphics for Exploratory Data Analysis

24

Interactive Review of Basic Statistics Using R

act24_BasicStatReview.r

25

Basic Charts for Single Discrete Variable

 

26

Exploring Single Discrete Variable Plots

act26_DiscreteVarPlots.R

27

Exploratory and Diagnostic Plots for the Distribution of a Single Continuous Variable

 

28

Probability Distributions

 

29

Kernel Density Estimates and Histograms

act29_KDE_Histograms.R

30

Diagnosing a Distribution

act30_DiagDistrib.R

31

Depicting the Distribution Involving Discrete Variables

 

32

Depicting the Distribution of Two Continuous Variables

 

33

Introduction of Final Project Topics

 

34

One and Two Sample Tests

 

35

Exploring Confidence Intervals and Simple Hypothesis Testing

act35_ConfInteval_HypoTest.R

36

An Application of Hypothesis Testing

act36_ApplHypothesisTest_Revised.R

5

Data Exploration for Understanding

 

37

Advanced Multivariate Continuous Displays and Diagnostics

act37_AdvancedMultiVariarte.R

38

Introduction to Random Sampling

act38_RandomSampling.R

6

Putting it All Together: An Independent Structured Analysis

T1

Assessing The Accessibility Of Trimet Bus Stops

T2

Assessing Trimet Bus Headway Reliability

T3

Bicycle Performance

T4

Freeway Data and Incidents

T5

Freeway Data and Weather

T6

WIM Data Side By Side Loadings

Appendix

Dataset Narratives

 
 

Other Helpful Resources

Required:

Scientific Approaches to Transportation Research Volumes 1 and 2

Manuals:

R Manual

PostgreSQL 8.1.23 Documentation

R Help:

Quick R

R reference card

Great color reference PDF Image Maindonald & Braun, Data Analysis and Graphics Using R. Cambridge University Press, 2003

Excellent (indespensible) graph layout reference and parameters - Paul Murrell's R Graphics