Data Journalism Backup Site

Here is my optional tagline

Nov 15 Class

by | Nov 15, 2016 | Fall 2016 Daily-Class

 

 

 

 

 

 

 

 

 

.

The 2016 Media Workshop

Friday Nov 18, 8:30a-11:30a

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.

Trump’s Data Team Saw a Different America—and They Were Right

This is an interesting story Quincy found about how Trump’s polling and analysis operation saw a different electorate than the rest of the news media

 

PROJECTS LIST

Group 1: Trupp, Monk and Ball: Read and comment on Hispanic community interview, and report
Group 2: Flores, Messina, Lyster, Billmyre:  Read and comment on Asian community
Group 3: Dobrin,Thomas, Taylor Pratt: Read, comment and report: Asian community, report
Group 4: Taylor Pray, Eley, Ward: Read, comment and report: Bankers in the Northwest Arkansas area
All Teams
–Fix edits in your transcripts and stories. Upload to Google Drive
Upload your finished project to a new blog post. Name it “Project – Your_Name” 
Ginny:
Complaints data for Arkansas
David:
– Revised Applications by Rejection Rate, 10-31-16
—eliminate the N/A
Julia:
Revise “reasons for denial HMDA data”
cut out the information not provided by applicant and consider normalizing these as a percentage of all applications.
Nanci:
Acceptance Gender and Race
the Y axis — it says “value” – what is it? percentage of something. it needs to be labeled. Also, having labels on the bars would be really useful.
Revise Loan Purpose: Refinance from 10-31
—eliminate Grand Total
—New chart Title: “rejection rate for loan refinancing, 2014, NW Arkansas”
—Label the bars
Quincy:
Chart #3 – I would cut out the info not provided by applicant in the Hispanic denial chart. Fix the X axis label to show just “Count of Denial Reasons”
Chart #5 – Loan Amount average by race – Let’s fix this and get dollar signs on the labels. I want to double check your spreadsheet calculations on this too.
Chart #6 – Rejection reason by minority population. Let’s sort it – highest to smallest, L—>R. Get rid of the null category.
Taylor Pratt
Put headers, code up these datasets
2015-LAR by NW Arkansas MSA
2014-LAR by NW Arkansas MSA
2013-LAR by NW Arkansas MSA
https://drive.google.com/drive/folders/0B9N10qKqBa2zREp2SFdhM29rbUU

Discussion: State – National Comparisons

Mistakes In News

Ch. 6: “10 Most Wanted List: Mistakes in The News”
in Cohen, Numbers in the Newsroom

State and 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

 

Problem: Census Data Doesn’t Map in Tableau

How to Solve This?

1) Link to Zip Codes
2) Link to Latitude-Longitude Data
3) Give Up and Hide
Use Relational Databases to Match Our Data – HMDA – To Another Database with Zip Codes

A) Link to Zip Codes

—4th quarter of 2014

B) Will This DB Link to Our HMDA Data?

05143010104
Our HMDA Files List This:
State Code      County Code      Census Tract Number
 5     7     213.11

C) Link HUD to FCC’s “List of Valid 2010 Census Tracts”

—Filter that to Arkansas
See Field: Tractname: “Census Tract 4801”
Looks Similar to HMDA file with “ 213.11”
—Find and Replace “Census Tract”
New Column is “Tract Name – Clean”

D) Join these spreadsheets

VMWare
Files to Transfer:
MyDocs: smb://Mydocs.uark.edu/mydocs/yourUARKusername/documents
Log in with your UARK username and password.smb://mydocs.uark.edu/mydocs/yourUARKusername/Documents
Access
Table Design
Join Match Tract to Ark 2010 Census
Query Design
/Users/rswells/Dropbox/Data-UARK-Jour405V/Access Screen Grab1.tiff
Created new database that joined the Zip Code with a Census Field we can match to HMDA
Exported

E) Join in Tableau

/Users/rswells/Dropbox/Data-UARK-Jour405V/Mapping FFIEC Files/Tableau Join.tiff
HMDA 2014 data “Census Tract Number” to Zip Query Match “Tractname-Clean”
/Users/rswells/Dropbox/Data-UARK-Jour405V/Mapping FFIEC Files/Tableau – Zip Query1.tiff

F) What is Wrong With This Picture?

Double Counting.
Will the HUD Zip file Serve Our Purpose?
/Users/rswells/Dropbox/Data-UARK-Jour405V/Mapping FFIEC Files/Benton County Census Tracts CT05007_001.pdf
—Look at this map and see the detail of the census tracts
We can assume the HUD data will be good for TOTAL Ration of .95 and above. The rest? Hmmmm
Refilter the Zip-Query spreadsheet to 95% and above.

Working in a Virtual Environment

1) Upload and download files in OneDrive
set up your UARK OneDrive account
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.
(FYI: here is all the software you can run when you are in the virutal environment)
Excel Exercise:
Load the flat files spreadsheet from your Mac into your OneDrive account: XXXXX
Go to the VMWare – Windows environment. Launch Excel in Windows
Open the flat files spreadsheet
Create a pivot table.
Create a pdf.
Store the PDF, Part 1
1) Local Disk C
2) users
3) rswells (your name)
4) Desktop
Save the file here
Part 2: Transfer the File to your OneDrive
Open OneDrive
Upload file from Desktop.

Homework

Blog post Due 11:59 pm Wednesday

Census Demographics and NW Arkansas and HMDA Data

census-demographics-ffiec   and Link to geographic data in Tableau and Visualize

Steps:

  1. Add Census Demographics in Tableau
  2. Add Lat Long in Tableau
  3. Link Tractname-Clean to Tract Code
  4. Convert the Latitude and Longitude Columns to their respective geographic role
  5. Visualize the Tract Minority % to the Size card, convert to Sum
  6. Click on Latitude and Longitude, then convert to dimensions
  7. Focus on NW Arkansas, color and resize the bubbles.
  8. Add a map layer with the roads and place names.
  9. 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:

 

census-tracts-minority-percentage-2015

#2: EVERYONE:

Fix stories and transcripts from first interviews

—Fix transcripts and story edits by Wednesday. Photo captions needed. Kang
Follow these examples for formatting:
—Kill multiple versions of transcript and pick the one we will use

Note: Next Interview Assignment Due Monday, Nov. 21, 11:59 pm

Third Interview Assignment Due Monday Nov. 28, 11:59 pm