Data Journalism Backup Site

Here is my optional tagline

Nov. 10 class

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

Lessons from the Election

“It’s the overselling of precision”

—Dr. Pradeep Mutalik, a research scientist at the Yale Center for Medical Informatics

How Data Failed Us In Calling An Election

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.

PROJECTS LIST

Review Interviews

Group 1: Trupp, Monk and Ball: Read and comment on Hispanic community interview, and report. Edit story.
https://wordpressua.uark.edu/datareporting/group-2-flores-messina-lyster-billmyre-hispanic-community/

 

Group 2: Flores, Messina, Lyster, Billmyre: Read and comment on Asian community.

Fix your interview transcripts

Group 3: Dobrin,Thomas: Edit story.: Kang interview

Fix your interview transcripts

Group 4: Taylor Pray, Eley, Ward: Read, comment and report: Bankers in the Northwest Arkansas area. Edit story.

Wells Fargo interview
Fix your interview transcripts
Upload your finished project to a new blog post. Name it “Project – Your_Name” 
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
Taylor Pray:
Revise Rate of Denials by Race
—Cut info not provided by applicant.
—Eliminate the legend
Ashton:
put the source of the data in the title slide, HMDA 2014 , FFIEC. Change the “value” on X axis to number of incidents.
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

Cleaning HMDA flat Files

Fill in all fields with codes.
Create a “race labeled” and a “ethnic labeled” field with the race and ethnicity labeled.

2013 – tba

2014 – ??

2015 – ??

PART #1 – HMDA FLAT FILES

https://www.ffiec.gov/hmda/hmdarawdata2015.htm#by_msa

CODING SHEETS
“File Formats & Documentation (PDFs)”
See Code Sheet, Inst Record Format, LAR Record Format, MSA Office, Reporter Panel

https://www.ffiec.gov/hmda/hmdaflat.htm

Exercise #1: RECODE Flat Files to Show Race, Ethnicity

Exercise #2: Recode Flat Files to Show Loan Rejection, Acceptance Etc

Google Drive

https://drive.google.com/drive/folders/0B9N10qKqBa2zVGtWbVctNU9kZTQ

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

Due 11:59 pm Monday Nov 14

*Updated*:
Read 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 using the data below:
https://drive.google.com/file/d/0B9N10qKqBa2zUlJnT1NUM2pxZUU/view?usp=sharing

 

Produce two Tableau charts.

Working in your teams on this is fine. Just spell out who worked on it and what they did.