Agenda for Wednesday Oct 10
–Student Debt – College Access and Success Report
–Map Exercise
Student Debt – College Access and Success Report
–Size of the overall problem
–Arkansas ranking
Map Exercise
Open Tableau with ARDebt_Sept26 data
New sheet, begin map: double click on zip codes
Problem #1: Dirty zip code data.
Task: Fix it and revisualize
Problem #2: Associate Zip Code Map Data in Tableau
Tableau – Go to: Map | Edit Locations.
A bunch zip codes in red. Not displaying.
Further edit the zip codes. It doesn’t like the mix of short and long zip code.
Fix:
Tableau. Data. Zip Code. Split.
–New Column has only five-digit zips. Call it Zip1 – delete the other. It keeps the original. Nice.
Dual Mapping
New sheet, begin map: double click on Zip1
Marks Card, Map
Drag White students to Color box, Convert to Average.
Click on Longitude pill in Columns. Press Command. Drag to Right. Release mouse
–Creates two Longitude pills and two maps
–Marks Card Now Has Controls for Two Maps
Lower Map, drag black to color. Change Color Scheme to Orange.
Upper Map, white, Change Color scheme to Green
Edit Tooltips so data displays properly
Class Assignment
#1 – Dual Maps:
– First Gen, Non-first Gen Repayment all schools
– Median Debt by beauty schools, another non beauty schools
– Median Debt by private, public schools
– Repayment by men, women all schools
– Default Rate by private, public schools
– Default rate by men, women all schools
#2 – Default
Build a chart with the Arkansas schools with the highest default rates
Now map that data
–Longitude to Columns, Latitude to Rows. Don’t use Longitude (generated). Generates a blank Arkansas map
–Instnm to Labels. Your map now has all colleges
–CDR3 to Color. Green-Red Diverging, with Red as highest default
–Filter by CDR3 for top 10 default rates in state
Homework:
On a single blog post on WordPress, post the following:
Post both maps as standard static graphics (image files)
Write 200 Words on the patterns you see from these maps.
Post the WordPress url on Blackboard
Due 11:59 pm Saturday, Oct 13
Tutorial
https://onlinehelp.tableau.com/current/pro/desktop/en-us/maps_dualaxis.html