The 2016 Media Workshop
Friday Nov 18, 8:30a-11:30a
Reynolds Building
The 2016 Media Workshop will focus on covering issues of race and gender during the election year. The workshop will consist of two panels, one national and one local, to discuss everything from how to cover police brutality to discussing the differences and similarities between a male and female political candidates. Registration begins at 8:30 a.m. with a complementary breakfast and the first panel begins at 9:00 a.m. The event will wrap up at 11:30 a.m.
This is an excellent opportunity for students to network with local professionals from Arkansas, Missouri and Oklahoma as well as dive into the topic of diversity in the media. The group exercise in the middle of the day is designed to translate into classroom activities to use later next semester or throughout your teaching career.
The national panelists are: Michael Fletcher, ESPN’s The Undefeated; Anne Gearan, The Washington Post; Jesse Holland, The Associated Press and our visiting distinguished professor; and April Ryan, American Urban Radio Network. Christi Welter will moderate the first panel.
The local panelists are: Wayne Greene, The Tulsa World; Bryan Pollard, director of tribal relations at the UA Law School and former editor of the Cherokee Phoenix; and Tony Russell, Tulsa News on 6. Channing Barker of KNWA will moderate this panel.
Review Homework
Census Demographics and NW Arkansas and HMDA Data
census-demographics-ffiec and Link to geographic data in Tableau and Visualize
Steps:
- Add Census Demographics in Tableau
- Add Lat Long in Tableau
- Link Tractname-Clean to Tract Code
- Convert the Latitude and Longitude Columns to their respective geographic role
- Visualize the Tract Minority % to the Size card, convert to Sum
- Click on Latitude and Longitude, then convert to dimensions
- Focus on NW Arkansas, color and resize the bubbles.
- Add a map layer with the roads and place names.
- Upload this sucker into a blog post.
–Optional: Add a data layer to the map. (See Map layers, bottom option, demographic data)
My spin through this exercise yielded this:
Issues:
Format labels to no decimals and add % signs
Background layer filtered to census tract instead of state because there is no variation in the data.
Bunching up of the data points around Fayetteville, so that needs to be cleaned up. Zoom in and have a smaller geographic area.
#2: EVERYONE:
Fix stories and transcripts from first interviews
Note: Next Interview Assignment Due Monday, Nov. 21, 11:59 pm
Third Interview Assignment Due Monday Nov. 28, 11:59 pm
Arkansas Consumer Complaints Against Banks
PROJECTS LIST
2013-LAR by NW Arkansas MSA
Discussion: State – National Comparisons
Using the 2015 National HMDA dataset, determine the Rejection Rate by Race for the U.S., Tables 4-1 and 4-2
https://www.ffiec.gov/hmdaadwebreport/NatAggWelcome.aspx
Using the 2015 State HMDA dataset, determine the Rejection Rate by Race for Arkansas
https://learn.uark.edu/bbcswebdav/xid-26747593_1
Create New Database In Access
Log in with your UARK username and password.smb://mydocs.uark.edu/mydocs/yourUARKusername/Documents
3) Launch VMWare and Microsoft Access
VMWare
Launch VMWare Horizon Client
Enter https://vdesk2.uark.edu as the name of the Connection Server. Click Connect.
Enter your UARK username and password. Click Login.
—>This will launch Windows. You are now working on a computer in another building on campus. You are running software on that machine. This means you can’t save anything to your desktop in the computer lab. You have to transfer files via the Cloud, in this case, OneDrive.
Access
Import External Data
4) Join these spreadsheets
Access
Import
Table Design
Join LATLONG to CENSUS_MATCH
Query Design
Export File and Name it: “LAT_CENSUS”
5) Link to HMDA Data
Query Design. Link LAT_CENSUS to HMDA 2014 NW Arkansas
Export Excel File and Name it: “2014HMDA_LAT_NWARK”
6) Import into Tableau. Map Denials