Table Design Exercise

From Cmsc734_f13
Jump to: navigation, search

I'd like to try a design exercise in class to demonstrate use of sorting, grouping, layout, and color in tabular data. It's s simple sports data set.... so bring your laptops and let's try this exercise working in pairs....

First we'll make sure we understand the data (Excel file), then discuss that would characterize a good presentation, and then you'll have a chance to create it using Excel, Word, or whatever tool you would like to use.

Brule and Souvik

Andres - Meethu Media: Screen_Shot_2013-11-15_at_11.29.52_AM.png

Matthew - Shobeir Media:Mat Sho.pdf

Varun and Kent

Media:TopTeamsInEachRegion.pdf

Media:playoff_best.png

Ruofei Du - Media:ruofei3.png

Jon Gluck, Hitesh Maidasani, Chris Imbriano - Media:HiteshChrisJon.png

Screen Shot 2013-11-15 at 11.25.49


some chart

LEAGUE REGION TEAM WON LOST PCT

STRING STRING STRING INTEGER INTEGER FLOAT

American East Boston 39 21 0.65

American East NY Yankees 29 31 0.483

American East Baltimore 29 33 0.468

American East Toronto 28 32 0.467

American East Tampa Bay 27 33 0.45

American Central Cleveland 36 23 0.61

American Central Detroit 35 26 0.574

American Central Minnesota 29 31 0.483

American Central Chicago Sox 26 32 0.448

American Central Kansas City 23 40 0.365

American West LA Angels 40 23 0.635

American West Seattle 31 26 0.544

American West Oakland 33 28 0.541

American West Texas 22 39 0.361

National East NY Mets 36 24 0.6

National East Atlanta 34 29 0.54

National East Philadelphia 32 30 0.516

National East Florida 31 32 0.492

National East Washington 26 36 0.419

National Central Milwaukee 33 28 0.541

National Central Chicago Cubs 27 33 0.45

National Central St. Louis 26 33 0.441

National Central Houston 26 35 0.426

National Central Pittsburgh 26 36 0.419

National Central Cincinnati 24 38 0.387

National West San Diego 36 24 0.6

National West Arizona 36 26 0.581

National West LA Dodgers 35 26 0.574

National West Colorado 30 32 0.484

National West San Francisco 28 33 0.459