VA Background
Timeline for Major VA Events
Post One Item on the following spreadsheet so we have a timeline of major events in the VA hospital wait scandal.
You have to follow the format from the first entry, especially the date and the link format. Otherwise, this system breaks down and it is useless.
Timeline Link
https://docs.google.com/spreadsheets/d/1iZ_BaL9HrpiwuwCj9mtoXiYQjs5WHKoY3fly6HRoE9w/edit#gid=0
Links to Key Articles
Calculations and Pivot Tables
Pivot Tables
Backup material:
http://spreadsheets.about.com/od/datamanagementinexcel/ss/8912pivot_table.htm#step1
Jour 405V: Data Journalism
Assignment #1: VA Fayetteville Data – Wait Times
Lemke Digital Media Lab Course, Fall 2017
School of Journalism and Strategic Media
For this assignment, you will analyze a spreadsheet of wait times for Veteran’s Administration hospitals in Fayetteville and Little Rock and write a short story based on your analysis.
The assignment is due Sunday, Sept. 17, 11:59 p.m. on Blackboard.
You are to post an article on Microsoft Word (no PDFs or other file formats) and upload your completed spreadsheet, which will include one pivot table analyzing the data.
The Veterans Administration in 2014 suffered a major scandal when it was revealed that VA employees in many offices lied about how quickly they saw patients and some veterans died waiting for medical care. This dataset will allow us to see trend in wait times at the local hospitals.
Examine the data and determine the overall trend for the Fayetteville and Little Rock hospitals. Compare the two. What percentage of the appointments were within 30 days? What percentage were longer? What other trends did you discover?
Source materials:
1) Data: va_wait_completed: VA station completed wait times information
2) Documentation VA Wait Time Goals
https://www.va.gov/HEALTH/docs/VA_Report_Section101-PL_113-146-Final.pdf
2) Three news articles of background research on VA wait times you will gather on LexisNexis Academic, not Google. This assignment forces you to use LexisNexis Academic, a premier news database available through the university’s library.
Here’s a background report on the wait times controversy to get you started.
https://www.va.gov/health/docs/VAAccessAuditFindingsReport.pdf
You do not have to do interviews for this assignment. Make sure to clearly attribute any background information to the correct source. Include a brief bibliography of your source articles, with permanent links, and follow APA style.
Rubric:
Data: 50%: Pivot table. Percent of whole
Writing: 30%: A clear lede supported by data and research
Research: 20%: Relevant articles cited correctly. Correct attribution
Background:
LexisNexis Academic
http://libraries.uark.edu/eresources/help.asp?TitleCode=UNIV