Jour 405v – Jour 5003 Spring 2021 Schedule of Instruction


Wednesday, April 28: Last class!

Announcements:

11 a
Webinar on female journalists' safety. Wednesday, April 28, 11 am. Kiran Nazish, Coalition for Women in Journalism. Details below. Conflicts with last day of class, let me know if you want to attend


Course evaluation:
Students should check their email account for an email with instructions on how to access the evaluation(s) .
I use what students say in the evaluations to assess and improve your own teaching.
Evaluations are also used to shape departmental and program curriculum.
The online evaluations are confidential.
Results of the evaluations will not be reported until after final grades have been submitted.
Students will receive periodic email reminders to complete evaluations for courses they have yet to evaluate.
The evaluations will close at 11:59 p.m. on the final date of the survey.

Last minute edits
https://github.com/profrobwells/Spring2021Data/blob/main/Occupation%20Data_April26.Rmd



Twitter Data

https://raw.githubusercontent.com/profrobwells/Spring2021Data/main/arkcovid_tweets_sept_march2021.csv

--Which tweets had the highest engagement? Chart top 10
--Total tweets by month
--Check your Twitter handle to see the frequency in the data



Tweets:
April 26
M -  Ravi
T -  Caroline
Hutchinson press conf: Graham
W - Rachell
TH - Grayson
F - 
S - ?
S - ?

May 3 - 
M -  
T -  
Hutchinson press conf: 
W - 
TH - 
F - 
S - 
S - 

Review Fact Checks
https://docs.google.com/document/d/1VWaK4LpCTMuGvRTSRHOPGk-d4dhCI1sKvKO7Gc-_8CE/edit

Fact Check Graphics

Arkansas counties with COVID-19 cases by Haley Hale.
https://public.flourish.studio/visualisation/5886015/

Arkansas map with worker cases by Caroline Sellers
https://datawrapper.dwcdn.net/NwfE2/1/

Top Arkansas counties worker cases by Caroline Sellers
https://public.flourish.studio/visualisation/5925981/

Animated Map of Arkansas Worker Cases by Ravi Brock
https://drive.google.com/file/d/1jnwQOkxWYt5f80wv9b2dtrawgwscOu1R/view?usp=sharing


Companies with 200+ Worker Illnesses by Mary Hennigan
Companies with 200+ Worker Illnesses

COVID Worker Illnesses in Arkansas by Rob Wells
https://www.datawrapper.de/_/N2CYu/

Tyson Berry Street COVID Illness Chart by Mary Hennigan
Tyson Berry Street Time Series

COVID-19 Cases per 10,000 Race, Ethnicity Population by ?? Mary Hennigan
Arkansas COVID-19 Cases by Race, per 10,000 population



Data Work
https://github.com/profrobwells/Spring2021Data/blob/main/worker_illness_cleaned_master.csv

Fix this graphic- Emma
https://app.flourish.studio/visualisation/5847959/edit?
https://raw.githubusercontent.com/profrobwells/Spring2021Data/main/occupation_month.csv
--Emma
https://app.flourish.studio/story/833524/#




OSHA Team
Mary, Abby, Rachell 
--Weekend memo: Draft story. 




30 Minute Skills: Protecting Women Journalists
Description
Throughout 2020, the Coalition for Women in Journalism identified 716 miscellaneous attacks worldwide on female reporters — more than double than the year prior. The first months of 2021 foreshadow another demanding year ahead. Women experience the kind of assault and harassment that rarely affects their male counterparts. These attacks are focused not on the reporting, but on the journalists themselves, including death and rape threats. With newsrooms often lacking effective support systems, women journalists are regularly belittled, have their professionalism questioned and endure mistreatment strictly based on their gender. By attending this class, you will learn:

- How to secure your presence online and avoid attacks and trolling.
- How to stay safe while covering riots and protests.
- What can be done to prevent harassment (including mistreatment in the workplace) and what kind of support you should demand from your own newsroom.
Time
Apr 28, 2021 12:00 PM in Eastern Time (US and Canada)
 Add to calendar
Webinar ID
814 4667 7175


To Join the Webinar
Join from a PC, Mac, iPad, iPhone or Android device:

Please click this URL to join. https://us02web.zoom.us/w/81446677175?tk=2MxNMuP2ZuTx8JuXqOFyteIcd-urTBRqcNFg3w6khfQ.DQIAAAAS9pmqtxZKRno3R0paN1FBZUF2bjM3XzEyRzl3AAAAAAAAAAAAAAAAAAAAAAAAAAAA&pwd=VitoWDc5U21IYWNmWEljdEduZ0hJUT09&uuid=WN_8cdiuTBxSQSJYfN81kjINQ

Kiran Nazish
Founding Director @Coalition For Women In Journalism
Kiran Nazish is the founding director of the Coalition For Women In Journalism, a worldwide support organization for women journalists. Nazish is a long-time journalist, and worked as a war correspondent covering the Middle East, South Asia and Mexico among many other locations. She is also a Distinguished Professor at Brandon University in Canada. Nazish can be followed on Twitter @kirannazish.
Monday, April 26: 29th Class

Announcements:
From the Knight Center at the University of Texas at Austin!
FREE online course, "How to report safely: Strategies for women journalists and their allies," held from May 3 to May 30, 2021.


Course evaluation:
Students should check their email account for an email with instructions on how to access the evaluation(s) .
I use what students say in the evaluations to assess and improve your own teaching.
Evaluations are also used to shape departmental and program curriculum.
The online evaluations are confidential.
Results of the evaluations will not be reported until after final grades have been submitted.
Students will receive periodic email reminders to complete evaluations for courses they have yet to evaluate.
The evaluations will close at 11:59 p.m. on the final date of the survey.

Tweets:
April 26
M -  Ravi
T -  Caroline
Hutchinson press conf: Graham
W - Rachell
TH - Grayson
F - Robert
S - ?
S - ?

May 3 - 
M -  
T -  
Hutchinson press conf: 
W - 
TH - 
F - 
S - 
S - 

Review Fact Checks
https://docs.google.com/document/d/1VWaK4LpCTMuGvRTSRHOPGk-d4dhCI1sKvKO7Gc-_8CE/edit

What did you learn? Last thoughts before we send this off?

Fact Check Graphics

Arkansas counties with COVID-19 cases by Haley Hale.
https://public.flourish.studio/visualisation/5886015/

Arkansas map with worker cases by Caroline Sellers
https://datawrapper.dwcdn.net/NwfE2/1/

Top Arkansas counties worker cases by Caroline Sellers
https://public.flourish.studio/visualisation/5925981/

Animated Map of Arkansas Worker Cases by Ravi Brock
https://drive.google.com/file/d/1jnwQOkxWYt5f80wv9b2dtrawgwscOu1R/view?usp=sharing


Companies with 200+ Worker Illnesses by Mary Hennigan
Companies with 200+ Worker Illnesses

COVID Worker Illnesses in Arkansas by Rob Wells
https://www.datawrapper.de/_/N2CYu/

Tyson Berry Street COVID Illness Chart by Mary Hennigan
Tyson Berry Street Time Series

COVID-19 Cases per 10,000 Race, Ethnicity Population by ?? Mary Hennigan
Arkansas COVID-19 Cases by Race, per 10,000 population



Data Work
https://github.com/profrobwells/Spring2021Data/blob/main/worker_illness_cleaned_master.csv

Fix this graphic- Emma
https://app.flourish.studio/visualisation/5847959/edit?
https://raw.githubusercontent.com/profrobwells/Spring2021Data/main/occupation_month.csv
--Emma
https://app.flourish.studio/story/833524/#




OSHA Team
Mary, Abby, Rachell 
--Weekend memo: Draft story. 
Wednesday, April 21: 28th Class


Announcements:

"How to Get a Job In Journalism" Webinar for Journalism Students  April 23 THINK LOCAL: Jumpstart Your Career at Local News & Trade Publications 
April 23, 2021    1 pm EST (10 am PST)
THINK LOCAL :  Jumpstart Your Career at Local News Outlets and Trade Publications
Many reporters got their start at local newspapers or trade publications. In our third webinar a panel of journalism professionals will share their experiences and offer advice on how these options may be the right fit for your first job in journalism. 
RSVP to programs@wpcf.org for your zoom link
https://zoom.us/webinar/register/2016123982743/WN_bkfRoNitR-2E5BFrcT-YrQ

Webinar on female journalists' safety. Wednesday, April 28, 11 am. Kiran Nazish, Coalition for Women in Journalism. Details below. Conflicts with last day of class, let me know if you want to attend
Ravi map


Data Work
https://github.com/profrobwells/Spring2021Data/blob/main/worker_illness_cleaned_master.csv

Worker Illness Data:
https://github.com/profrobwells/Spring2021Data/blob/main/Occupation%20Data_April17.Rmd


Calculating Worker Cases and Comparing to Community
  
Robert and an outside data expert asked to revise the calculation of worker cases as a percentage of community cases.
--Original: Total worker cases in a county per month / total positive cases
--Problem: the worker cases were monthly. The positive cases were cumulative. Small percentages as the pandemic grew

--New: Total worker cases in a county per month / New positive cases per month
--More of an apples - apples comparison.
--Problem: Not all workers live in the community!
--Problem: New cases calculation drops April 2020

--In a few rural counties, such as Madison, where the reports of worker illness exceeded the community reports. 
I think this is because the workers are commuting from outside of the community, which would make sense in Huntsville at the turkey plant. 
  
 https://github.com/profrobwells/Spring2021Data/blob/main/Occupation%20Data_April19.Rmd
  
We just have to be very specific that the worker cases do not necessarily represent residents in that county. Instead, they could be commuters and they jack up the numbers.
    
Here’s the new table: total positive and New_Cases are county figures. Worker covid is the number of cases by workplace and its specific county.
 https://github.com/profrobwells/Spring2021Data/blob/main/occupation_month.csv
  
Haley and Robert check the math.



1) Build a map with this case that changes per month, animated
https://raw.githubusercontent.com/profrobwells/Spring2021Data/main/countysum.csv
--Ravi, once you finish the pending story

2) Map of counties with the highest number of sick workers
https://raw.githubusercontent.com/profrobwells/Spring2021Data/main/occupation_month.csv
--Caroline: https://datawrapper.dwcdn.net/NwfE2/1/
--Grayson: TBA

3) Fix this graphic
https://app.flourish.studio/visualisation/5847959/edit?
https://raw.githubusercontent.com/profrobwells/Spring2021Data/main/occupation_month.csv
--Emma
https://app.flourish.studio/story/833524/#

4) Math on worker illness data, percent of sick workers.
--Robert: Average worker illness rate, find counties above that rate.
--check standard deviation

5) Run calculations on this data, average percentage of cases per month. Top 3 counties per month.
https://raw.githubusercontent.com/profrobwells/Spring2021Data/main/countysum.csv
--Graham

6) Analyze employment data 
Rachell
https://docs.google.com/spreadsheets/d/1cZMDQJsu3fIAdejyOCl9Y4f3KJIeuqkVtAiu1PmkSvQ/edit?usp=sharing

7) County Worker Outbreaks
Haley - Refine your graphic.
https://app.flourish.studio/visualisation/5886015/edit

Data Interviewing / Interrogating / Grilling / Badgering

1) Count frequency of company cases by month
2) Count frequency of cases by county by month
3) Sort the companies alphabetically - check for misspellings
4) Sort counties alphabetically - check for misspellings, omissions
5) Check a sample period against the original data. 

M -  Ravi
T -  Caroline
Hutchinson press conf: Graham
W - Rachell
TH - Grayson
F - Robert
S - ?
S - ?

OSHA Team
Mary, Abby, Rachell 
--Weekend memo: Draft story. 


Weekly memos due Saturday, 11:59 p.m.
Monday, April 19: 27th Class


Haley Graphic
https://public.flourish.studio/visualisation/5885944/

Robert and Uniqueid
https://github.com/profrobwells/Spring2021Data/blob/main/worker_illness_cleaned_master.csv

Company totals
https://www.datawrapper.de/_/N2CYu/

Fact check worker illness data.
Please do not copy or share this data. We are still working on it.

Worker Illness Data:
https://github.com/profrobwells/Spring2021Data/blob/main/Occupation%20Data_April17.Rmd

https://raw.githubusercontent.com/profrobwells/Spring2021Data/main/worker_illness_cleaned_master.csv


1) Map of counties with the highest number of sick workers
https://raw.githubusercontent.com/profrobwells/Spring2021Data/main/occupation_month.csv
--Caroline / Grayson

2) Fix this graphic
https://app.flourish.studio/visualisation/5847959/edit?
https://raw.githubusercontent.com/profrobwells/Spring2021Data/main/occupation_month.csv
--Mary / Abby

3) Math on worker illness data, percent of sick workers.
--Robert: Average worker illness rate, find counties above that rate.
--check standard deviation


4) Build a map with this case that changes per month, animated
https://raw.githubusercontent.com/profrobwells/Spring2021Data/main/countysum.csv
--Ravi, once you finish the pending story

5) Run calculations on this data, average percentage of cases per month. Top 3 counties per month.
https://raw.githubusercontent.com/profrobwells/Spring2021Data/main/countysum.csv
--Graham

6) Analyze employment data 
Rachell
https://docs.google.com/spreadsheets/d/1cZMDQJsu3fIAdejyOCl9Y4f3KJIeuqkVtAiu1PmkSvQ/edit?usp=sharing

7) Haley - Refine your graphic. Slow animation speed. Background have full year instead of "20"


Data Interviewing / Interrogating / Grilling / Badgering

1) Count frequency of company cases by month
2) Count frequency of cases by county by month
3) Sort the companies alphabetically - check for misspellings
4) Sort counties alphabetically - check for misspellings, omissions
5) Check a sample period against the original data. 

Use R 
https://raw.githubusercontent.com/profrobwells/Spring2021Data/main/Occupational%20analysis%20Ap%2012%202021.Rmd

Robert
Ravi
Mary
Rachel
Abby
Haley

Use Tableau / Excel 
Emma
Caroline
Graham
Grayson

M -  Ravi
T -  Caroline
Hutchinson press conf: Graham
W - Rachell
TH - Grayson
F - Robert
S - ?
S - ?

OSHA Team
Mary, Abby, Rachell 
--Weekend memo: Draft story. 


Weekly memos due Saturday, 11:59 p.m.
Wednesday, April 14: 26th Class

Progress:
https://public.flourish.studio/visualisation/5847959/

--Consult with Katy Seiter, Sean Mussenden, Nicholas McMillan
What we did:
https://raw.githubusercontent.com/profrobwells/Spring2021Data/main/Occupation%20Data%20Hennigan_Wells.rmd


Fact Check worker illness data.
Please do not copy or share this data. We are still working on it.

Ravi's fact check. Spot check of the source documents against our data. An example of a detail oriented examination presented in a clean and clear format that was of immediate value to the project.


Robert - Please run the county vaccine data in R and update charts.


Worker Illness Data:
https://raw.githubusercontent.com/profrobwells/Spring2021Data/main/cleaned_master.csv


1) Fact Check totals in county_sum
https://raw.githubusercontent.com/profrobwells/Spring2021Data/main/countysum.csv
--Haley. use Excel to filter a county, filter by a month, select the highest value in the total cases per facility. Add up those.

2) Dig into the worst counties
--Robert, Madison County, produce a graphic / paragraph identifying the top employer cases per month
--Graham, Yell County,  produce a graphic / paragraph identifying the top employer cases per month

3) Add employment data to this spreadsheet
https://docs.google.com/spreadsheets/d/1cZMDQJsu3fIAdejyOCl9Y4f3KJIeuqkVtAiu1PmkSvQ/edit?usp=sharing

Go to this website. Find the county. Find the employer. Put down the employment in the categories, 1-10, 11-49, etc
https://www.arkansasedc.com/why-arkansas/rankings-accolades/compare-arkansas/major-employers-by-county/1

Grayson: Do all Tyson facilities. There are 20 different facilities in various counties.
Caroline: Do georges_poultry. four different facilities. Do Conagra. two. Butterball, 3

If you finish, work down this list
simmons_foods             
peco      
pilgrims_pride           
hytrol conveyor company             
frito lay              
ok foods    
wayne farms    
cargill poultry           
twin rivers foods          
abb             
lennox industries             
nebo poultry              
southeast poultry            
lockheed martin              
riceland_foods              
evergreen packaging

4) Month company totals
--Check to see if this list is accurate, that these are in fact the highest company totals per month. 
https://raw.githubusercontent.com/profrobwells/Spring2021Data/main/monthcostotals.csv
Check it against the master data
https://raw.githubusercontent.com/profrobwells/Spring2021Data/main/cleaned_master.csv
--Emma

5) Build a chart with this data
https://raw.githubusercontent.com/profrobwells/Spring2021Data/main/maxworksite_month.csv
--TBA

6) Build a map with this case that changes per month, animated
https://raw.githubusercontent.com/profrobwells/Spring2021Data/main/countysum.csv
--Ravi, once you finish the pending story

7) Run calculations on this data, average percentage of cases per month. Top 3 counties per month.
https://raw.githubusercontent.com/profrobwells/Spring2021Data/main/countysum.csv

8) Create a unique identifier for each separate facility
https://docs.google.com/spreadsheets/d/1TH6xHzbDys2PWaG0jNStKcAuvBcoVMJZK0CL6RnMFmo/edit?usp=sharing




Data Interviewing / Interrogating / Grilling / Badgering

1) Count frequency of company cases by month
2) Count frequency of cases by county by month
3) Sort the companies alphabetically - check for misspellings
4) Sort counties alphabetically - check for misspellings, omissions
5) Check a sample period against the original data. 

Use R 
https://raw.githubusercontent.com/profrobwells/Spring2021Data/main/Occupational%20analysis%20Ap%2012%202021.Rmd

Robert
Ravi
Mary
Rachel
Abby
Haley

Use Tableau / Excel 
Emma
Caroline
Graham
Grayson

M -  Ravi
T -  Caroline
Hutchinson press conf: Graham
W - Rachell
TH - Grayson
F - Robert
S - ?
S - ?

OSHA Team
Mary, Abby, Rachell 
--Weekend memo: Draft story. 


Weekly memos due Saturday, 11:59 p.m.
Wednesday, April 7: 24th Class

--Howard Center Nowhere to Go series Wins Award
#NowhereToGo collaboration was a finalist in the #IREAwards' Student (Large) category. 
The project brought together students from 7 schools to investigate homelessness across the United States:
Univ of Maryland
Arizona State Univ
Univ of Oregon
Stanford University
Boston University
University of Florida
University of Arkansas

Katy Seiter
Matthew Moore
Brooke Tomlin
Mary Ellis
Whitney King
Michael Adkison
Abby Zimmardi
Mary Hennigan

  homeless.cnsmaryland.org
 IREAwards judges on #NowhereToGo: 

"These stories illustrate why collaborations can lead to groundbreaking investigative work. These stories laid out how cities around the country were responding to homelessness, including criminalizing the people that need the most help."


https://homeless.cnsmaryland.org/2020/07/13/in-the-shadow-of-the-university-life-in-a-homeless-encampment/
https://homeless.cnsmaryland.org/2020/07/13/homeless-women-face-extra-health-safety-worries/
https://homeless.cnsmaryland.org/2020/07/13/homeless-college-students-hiding-in-plain-sight/
https://homeless.cnsmaryland.org/2020/07/13/homeless-counts-in-northwest-arkansas-are-hit-or-miss/
https://homeless.cnsmaryland.org/2020/09/02/milwaukee-evictions-spurred-by-covid-19-longstanding-racism-and-poverty/

 


--Spanish language forum on vaccines


--Statista, via the Mullins Library
https://www-statista-com.eu1.proxy.openathens.net/
https://en.wikipedia.org/wiki/Statista


--Wednesday, April 7. Kathy Roberts Forde, 6 pm Roy Reed Speaker. http://bit.do/royreed

--Story and WordPress post
--Emma story on Rogers
--The power of html and transferring between WordPress sites: Woodruff County
--Vaccine Data: Update: data as partially vs fully vaccinated is consistent with one dose vs two doses.



Examine county data and trends: 

--Table with 7 day averages
https://github.com/profrobwells/Spring2021Data/blob/main/county_averages.csv?raw=true

--Part 1: Filter the county_averages.csv for the latest week. 

--State average for deaths, cases. 
--Since Feb 1: Which of your counties are above/below the state averages?
--Make a map in Datawrapper just for your counties

County vaccine data: Changes, current vs past

April 5
https://github.com/Arkansascovid/Main/blob/master/vaccinecounty.csv

March 16 data:
https://wordpressua.uark.edu/datareporting/files/2021/03/vaccinecounty_March16.csv


R session: Ravi, Haley, Robert, Rachel
Pull down this script, run it and list 5 questions you have about what is going on.
https://raw.githubusercontent.com/profrobwells/CovidFall2020/master/Daily%20Update.Rmd

Training on vaccine county script
1) Download this PDF.
https://github.com/profrobwells/Spring2021Data/blob/main/County%20vaccination%20numbers%204.5.21.pdf
2) Open in Adobe Acrobat. Export as Excel spreadsheet
3) Open sheet in Excel. Unmerge cells. Save
4) Copy link to document using Finder: 
    a) Cntl + click on File. 
    b) Keep holding cntl and also press OPTION. Select copy "FILENAME" as Pathname
5) Paste that url to the hard drive to Line 27 of the R script below. This way you import the data using rio::import

https://raw.githubusercontent.com/profrobwells/Spring2021Data/main/Vaccine%20Data-4_6_2021.Rmd

6) Run script, send me the final vaccinecounty.csv


M -  Ravi
T -  Caroline
Hutchinson press conf: Graham
W - Rachell
TH - Grayson
F - Robert
S - ?
S - ?

OSHA Team
Mary, Abby, Rachell 
--Weekend memo: Draft story. 
--Prepare data to share with UAMS, Facing South

Weekly memos due Saturday, 11:59 p.m.

UPCOMING CLASSES



PAST CLASSES

Third Class: Wednesday, Jan. 20

Review:
--Prof Reed's class
--YouTube - Haley: Romero and tour
--LinkedIn - Heather
--Instagram - Grayson
--Ravi's graphic
--Facebook en Espanol
--Arrow map on changes 

Tableau
Module #2: Data Management
Graphics
Arkansascovid.com schedule: Tuesday press conference. Daily tweets.

Excel Notes
--Rachell: https://exceljet.net/excel-functions/excel-iferror-function
--Robert: -- =F2:F21084/G2:G21084

Track 1: Grayson, Heather, Haley, Emma, Graham
Answer this question with the master_file_jan7.csv dataset:
--Calculate the percentage change in per-capita positivity between Oct. 31, 2020 and Jan 7, 2021. 
--Create a separate tab on your spreadsheet and display the results for the top 10 counties with the greatest percentage change in per capita positivity since Halloween.
--With that data, open Tableau and create a chart.

Track 2: Caroline, Robert, Ravi and Rachell
--progress on Tableau graphics

Download these PDFs and export them into Excel files.
Ravi: Schools. Part 2. Build graphic with Flourish
https://app.flourish.studio/visualisation/5016481/edit
https://www.healthy.arkansas.gov/images/uploads/pdf/School_Report_01112021.pdf

Rachell: Occupational data. https://www.healthy.arkansas.gov/images/uploads/pdf/01.11.21_Occupation_COVID_Cluster_Summary.pdf

Caroline: Prisons. https://www.healthy.arkansas.gov/images/uploads/pdf/congregate_settings_1_11_21.pdf

Robert: Contact tracing. https://www.healthy.arkansas.gov/images/uploads/pdf/AFMC_Weekly_Report_-_20210112.pdf



Weekly memos due Saturday, 11:59 p.m.
Reading:
1) Numbers in the Newsroom, second half of book. Write 2 paragraphs on lessons learned in weekly memo. Include two examples
2) One article / video / podcast on Covid-19 in Arkansas that will help advance our understanding. Draw from Arkansas media or research sources. Link and one paragraph explanation. Write draft Tweet / Facebook post on site.
3) Describe the progress or roadblocks on your particular projects. Include images or links as appropriate.
4) Review Prof. Reed's class on content.https://uark.box.com/s/s00fdwrn26w5w6bvwyju7ld0v1tvju39 
5) Review Gov Hutchinson's weekly press conference. Describe one item from the event you found interesting. https://www.youtube.com/channel/UCLJcNdgp2PMEmiqJEoYzqwQ


------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Jour 5003

Deb Nelson's big questions:
What protections are missing for workers?
Who is responsible for the harm?
What are the consequences?
What are the legal protections for workers and what is lacking on the state and federal level?

My big question:
Who is not being covered by the OSHA data?
Are the OSHA people phoning it in or actually regulating worker safety?

For the weekend memo:


Reporting Tasks:
1) Pulaski County U.S. Department of Veterans Affairs had one hazard, but 1,000 employees were exposed: dig up this specific complaint, full text. Ask OSHA what it means that 1,000 people were exposed. Any idea how many were infected?

2) Look at PPP Data for Arkansas: https://sba.app.box.com/s/ox4mwmvli4ndbp14401xr411m8sefx3i
     -How many Arkansas PPP recipients have OSHA violations? What is needed to do that comparison in R? 
     -Start building an R script that pulls in the OSHA and PPP data and matches it.
     -https://raw.githubusercontent.com/profrobwells/at_2020_fall_data_journalism/master/osha_data/data/closed_complaints.csv
     -Joining Dataframes in R: https://www.youtube.com/watch?v=gLg4D9bMIyc&t=13s
     -Machlis: Ch. 7 Two or more data sets
     -Data Wrangling:  http://learn.r-journalism.com/en/wrangling/
     -Joins in R: https://bit.ly/2OFnGJ6

3) Meat packaging: Latinx makes up 35% of worker population, despite only 18% of the national workforce. What are the demographics for Arkansas?

4) Find lawyers and union people who specialize in worker safety. 

You may not finish these tasks but please start and report your progress.

Reading: 
Keep going through the starter documents. Pick three additional articles each and summarize:
https://www.notion.so/Background-Starter-Links-4b0554ce7460447892c09854c6e2b5b2


Background on poultry and hospital industries in Arkansas. Provide 1-2 paragraph industry profile on the food processing and hospital industries. 
http://www.discover.arkansas.gov/Industry/Industry-Employment-by-Sector
https://www.ibisworld.com/united-states/economic-profiles/arkansas/
https://www.arkansasedc.com/why-arkansas/key-industries

     Look at Tyson's 10-K and see the various subsidiary names so we know businesses owned by Tyson. Do the same with George's, Smithfield, etc. 
AdvancePierre Foods, Inc. dba Tyson Foods
https://www.sec.gov/ix?doc=/Archives/edgar/data/100493/000010049320000132/tsn202010kq4.htm
How to look up a 10-K document? 
https://profrobwells.github.io//Guest_Lectures/IRE.Companies/IRE_20.html


Kaiser Health News:
https://khn.org/news/article/workers-fired-penalized-for-reporting-covid-safety-violations/
https://khn.org/news/osha-investigations-workers-filed-nearly-4000-complaints-about-protective-gear-some-still-died/

Reporting about Tyson in Madison County:
https://alicedriver.substack.com/p/baby-its-covid-outside?token=eyJ1c2VyX2lkIjoxMTA4MjYzLCJwb3N0X2lkIjoyNTk5MTM3MSwiXyI6IjJSOTJFIiwiaWF0IjoxNjA4MjIyNDM0LCJleHAiOjE2MDgyMjYwMzQsImlzcyI6InB1Yi05MjI1Iiwic3ViIjoicG9zdC1yZWFjdGlvbiJ9.WwhyNibv-8t-5lXOTfqffJrUK8F-njhp8QOLh6ruvXM

One article / video / podcast on Covid-19 in Arkansas that will help advance our understanding. Link and one paragraph explanation. Write for possible Tweet / Facebook post on site.

Weekly memos due Saturday, 11:59 p.m.
Fourth Class: Monday, Jan. 25

1) Announcements:
 Join the Ida B. Wells Society for an outstanding lineup of free investigative workshops this semester: 
Investigating PPP Loans led by Ron Nixon, AP and Reese Dunklin, AP 6 p.m., Jan. 19
Investigating Education in the COVID Age led by Aaricka Washington, Chalkbeat and Bracey Harris, NBC News 6 p.m., Jan. 25
Investigating Racial Inequity led by Aaron Morrison, AP and Andale Gross, AP 6 p.m., Feb. 1
Investigating Paper Trails and Public Records led by Kimbriell Kelly, L.A. Times 6 p.m., Feb. 8 
How to Make it in Freelance Investigation led by Mark Rochester, Type Investigations and Azmat Khan, New York Times Magazine 6 p.m. Feb. 11

2) Tableau Workbooks: Template for formatting. See https://wordpressua.uark.edu/datareporting/tableau/
--Graphic labeling: Headline, Source, Credit
--Formatting labels

3) Module #2: Organize Your Data - read this module before Wednesday

4) Tableau Online: https://prod-useast-a.online.tableau.com/#/site/datareportinguofa/home

5) Photo and bio needed by Wednesday. Is anyone seeing the announcements in Teams?

6) Need people to do Tweets this week: M-T-W-TH-F. The stuff can be done after hours for the next morning.

7) Need someone to check the Hutchinson press conference Tuesday.

8) Reading due Saturday: Read Intro, Ch. 1-2 of The Wall Street Journal Guide to Information Graphics. 90 pages.

9) Watch this: Arkansascovid.com Overview. Here's a discussion of the automation process to gather and crunch the daily numbers. 
https://video.uark.edu/media/ADH+Data+Flow+to+Arkcovid/0_c6hn4feo

10) Arkansas Traveler Dashboard Project!
https://health.uark.edu/coronavirus/COVID-19-Data-Summary.xlsx
https://yaledailynews.com/blog/category/covid-19/
--How Dashboards and workbooks operate: https://wordpressua.uark.edu/datareporting/dashboards-embed-tableau-in-wordpress/
--Changing data types
--Date

As a group, produce a short memo by Tuesday 11:59 p.m.
a) Start a Google Doc. Describe your data cleaning steps, getting the spreadsheet ready for Tableau. Make notes on what you are doing since we will be handing this off to the Traveler. For example, the dates.Look at the mix of week totals and two-day results, for example. Weird! How do you fix that?
b) Write down questions about the data. What do the columns mean? Look at the weekly active cases avg, for example
c) Describe issues with this data and how you would resolve it. 



Excel Notes
--Rachell: https://exceljet.net/excel-functions/excel-iferror-function
--Robert: -- =F2:F21084/G2:G21084

Track 1: Grayson, Heather, Haley, Emma, Graham
Arkansas Traveler Dashboard. with Robert Stewart.

Track 2: Caroline, Robert, Ravi and Rachell
--Active vs Cumulative Cases
--Graphic labeling: Headline, Source, Credit
--Formatting labels


Ravi: Schools. Part 2. Build graphic with Flourish
https://app.flourish.studio/visualisation/5016481/edit
https://www.healthy.arkansas.gov/images/uploads/pdf/School_Report_01112021.pdf
--Needs further simplification. Create a Flourish story, searchable table for second page of a story 
--Main panel needs a filter by school name or in chunks of 15. top 15. 16-30, 31-45, 45-60 etc

Rachell: Occupational data. https://www.healthy.arkansas.gov/images/uploads/pdf/01.11.21_Occupation_COVID_Cluster_Summary.pdf
--Active vs Cumulative Cases

Caroline: Prisons. https://www.healthy.arkansas.gov/images/uploads/pdf/congregate_settings_1_11_21.pdf
--Active vs Cumulative Cases

Robert: Contact tracing. https://www.healthy.arkansas.gov/images/uploads/pdf/AFMC_Weekly_Report_-_20210112.pdf
--Work on Arkansas Traveler Dashboard project

 



Jour 5003
FOIA request for Region 6 OSHA documents. Rachel Logan at Howard knows about this; contact her by Slack. FOIA contact is Pamela Robins (972-850-4199) (robins.pamela@dol.gov)
Ron Nixon at AP on PPP loans: https://www.youtube.com/watch?v=FMIYSsaimWU&feature=youtu.be
Phone calls to lawyers
Phone calls to OSHA people
NLRB and Arkansas
Worker's Compensation in Arkansas
Second Class: Wednesday, Jan. 13

Announcements:

Scholarship application due Feb. 5
https://fulbright.uark.edu/departments/journalism/resources/scholarships.php


Track 1: Heather, Emma, Haley, Grayson, Robert, Graham
Track 2: Ravi, Rachell, Caroline, Graphic Assignment, See below

Everyone:
Weekly memos due Saturday, 11:59 p.m. in Blackboard
Reading:
1) Numbers in the Newsroom, first half of book. Write 2 paragraphs on lessons learned in weekly memo. Include two examples
2) Find one article / video / podcast on Covid-19 in Arkansas that will help advance our understanding. Link and one paragraph explanation. Write for possible Tweet / Facebook post on site.
3) License agreement signed and emailed to Dr. Wells
4) Track 2: Graphic

Due Saturday, Jan 16, 11:59 p.m. Blackboard 
Intellectual Property / Data Sharing Releases
UofA Rules of Conduct
https://docs.google.com/document/d/1YkdkRIzIs1WQ3P9KIICvHcppfWvwTyo2bRhGwQPsgVE/edit
License Agreement
https://docs.google.com/document/d/1AahzxDOzTf9Z6PBjBvFBOjnn9_BiM4YldnXW-mHZr9s/edit



Track 1:
Data Literacy Test Discussion
--The per capita calculation. 
--Show your formulas in the spreadsheet
--Filters, sorting
--Creating separate tabs, copying tabs
--Formatting numbers
--Rachell: Excel IFERROR Function

Answers:
https://docs.google.com/document/d/1bbg1oYAn_QTTjXRVMeVJEeKirunon_GNF2Rnq9drPmw/edit?usp=sharing
Data:
https://docs.google.com/spreadsheets/d/1YFayBtoQBMxw7M2e3ZDbOXflRlhYeC4_mCRJCNCXFZQ/edit#gid=1480709327


Excel Bootcamp: https://wordpressua.uark.edu/datareporting/data-intro-excel/
Tableau Mini Lecture
Workshop Tableau: https://wordpressua.uark.edu/datareporting/tableau/  - work through the exercises.

Answer this question with the master_file_jan7.csv dataset:
--Calculate the percentage change in per-capita positivity between Oct. 31, 2020 and Jan 7, 2021. 
--Create a separate tab on your spreadsheet and display the results for the top 10 counties with the greatest percentage change in per capita positivity since Halloween.
--With that data, open Tableau and create a chart.

Track 2: 
Do the same reading and start on producing a graphic. Include graphic in memo or describe where you got stuck. 

Please work together -- if one of you doesn't have Creative Suite just yet, then another can export for the rest.

Download these PDFs and export them into Excel files.
Ravi: Schools. https://www.healthy.arkansas.gov/images/uploads/pdf/School_Report_01112021.pdf
Rachell: Occupational data. https://www.healthy.arkansas.gov/images/uploads/pdf/01.11.21_Occupation_COVID_Cluster_Summary.pdf
Caroline: Prisons. https://www.healthy.arkansas.gov/images/uploads/pdf/congregate_settings_1_11_21.pdf


 
1) Use Adobe Acrobat Pro (part of Creative Suite) export a PDF to a spreadsheet.
Exporting to Excel: Pretty simple. Choose File> Export To > Spreadsheet. 

2) Clean the data, make sure the first row has the correct data. Create a second tab to show the data source and any notes. Your main table should not have any random text. It should just be a pure table.
Example: https://docs.google.com/spreadsheets/d/1CPm6B5WUetniOJN9WLULzEVHUcRucdvI42MkqsZLnJo/edit#gid=1749108144

3) Make a simple chart in Tableau. Write a headline. Export as a .jpg file.
Use this Tableau module for reference: https://wordpressua.uark.edu/datareporting/tableau/ 

You may or may not finish but I want you to start.

Jour 5003
Discuss Brief Group Memo, Arkansas Reporting Ideas

Dig Into Data
https://raw.githubusercontent.com/profrobwells/at_2020_fall_data_journalism/master/osha_data/data/closed_complaints.csv
--Use any tool you want - Tableau, R, Flourish, and discern patterns, issues. 
--Map it
--Hospitals seem to be a source of complaints. 

OSHA Data Dictionary, Divide and Conquer

Howard Center Data Work To Date

Weekly memos due Saturday, 11:59 p.m.
1) Five more articles each for the read-a-thon

Additional Readings to Draw From:
OSHA.GOV
 OSHA.gov overview
 https://www.osha.gov/coronavirus/standards
 OSHA INFECTIOUS DISEASE RULEMAKING
 https://www.osha.gov/dsg/id/
 OSHA GUIDANCE ON COVID-19
 https://www.osha.gov/Publications/OSHA3990.pdf
 OSHA Interim Enforcement Response Plan for Coronavirus Disease 2019 (COVID-19)
 https://www.osha.gov/memos/2020-04-13/interim-enforcement-response-plan-coronavirus-disease-2019-covid-19
 OSHA STATE PLAN MAP with contacts
 https://www.osha.gov/stateplans
 OSHA REGIONAL OFFICE MAP with contacts
 https://www.osha.gov/contactus/bystate
 JAMA 9/2020 Critique: Occupational Safety and Health Administration (OSHA) and Worker Safety During the COVID-19 Pandemic
 OIG Critique: COVID-19: OSHA NEEDS TO IMPROVE ITS HANDLING OF WHISTLEBLOWER COMPLAINTS DURING THE PANDEMIC
 A COUPLE OTHER STUDIES WORTH CHECKING OUT
 Solutions
 An Integrative Total Worker Health Framework for Keeping Workers Safe and Healthy During the COVID-19 Pandemic
 https://journals.sagepub.com/doi/pdf/10.1177/0018720820932699
 Racial disparities
 Racial Capitalism Within Public Health—How Occupational Settings Drive COVID-19 Disparities
 Check Google Scholar for more. 

Watch: Vaccine Information
https://video.uark.edu/edit/1_mq4y6rrv

First Class: Monday Jan. 11
The Three Ring Circus this semester. Tracks 1, 2 and 3.
Syllabus and course overview
Email to students with WordPress code.
Teams: Message me.
WordPress: Invite code sent
Ark. Dept of Health website
Data Literacy Test. 50 points. Due Tuesday, 11:59 pm

In Class Exercise
Write a minimum three paragraphs about yourself. Discussion post on Blackboard. Finish by Tuesday, 11:59 pm

1) You have skills and experience. Tell us about them. 
Describe your skills and background and how they can contribute to Arkansascovid.com. 
What do you bring to the table - reporting experience? Experience as a manager? Roots in a rural community in Arkansas? Language skills? Social or professional associations? Design skills? Ability to lead a team? Ability to follow in a team?

2) Who are you? 
And then summarize: Where are you from? What is your journalism background? What do you read and watch, and why?
What do you want from this class? Do you have any nervousness about taking this class? Why?

Jour 5003 - Howard Center Project


Howard Center Schedule
Load OSHA Data, Exploratory Data Analysis

Notion Howard Center Project Management
https://drive.google.com/drive/u/1/folders/1hmlZYlI_Xxk_JRqzBoH1Se41KwOFBlXa

Brief group memo due Tuesday 11:59 pm

1) OSHA Data
https://www.osha.gov/foia#covid-19
--Describe how the process works. Research elsewhere if needed

2) Read a Thon
--Brief 1-2 sentence summaries of things you find interesting.
--Divide This Up

Tyson Takes a Black Eye

https://www.natlawreview.com/article/novel-theories-covid-19-workplace-assault-and-loss-consortium?utm_content=0f3448cf0cbd570ea95b00e9857b104f&utm_campaign=2020-12-22Coronavirus%20Legal%20News&utm_source=Robly.com&utm_medium=email

https://btlaw.com/en/insights/publications/covid-19-related-workplace-litigation-tracker#Family-and-Medical-Leave-Act

https://www.seattletimes.com/seattle-news/farm-company-fined-2-million-after-2-workers-die-of-virus/

https://publicintegrity.org/politics/system-failure/deaths-cutbacks-workplace-safety-inspections-osha/

https://www.propublica.org/article/poorly-protected-postal-workers-are-catching-covid-19-by-the-thousands-its-one-more-threat-to-voting-by-mail

Pick two articles each from this list
Research clips
https://docs.google.com/spreadsheets/d/1mS2fA2FAtOlyjt3ODd2rPw1t6y5kjOO0CU3y06G8z70/edit?pli=1#gid=0
Fifth Class: Wednesday, Jan. 27

Tableau Dashboards
Tableau Calculations

Hutchinson Press Conference: This is how you do a memo from a press conference. Great job Caroline.
[2:31 PM] Caroline Sellers     https://docs.google.com/document/d/157bbQ1PycHFZ7ACCgNgDMrHZuDU_CcDjshKpBOut3kc/edit?usp=sharing 


Track 1: Update on the Traveler dashboard

Steps to create a single workbook
1) Everyone has to use the exact same Excel document. Suggest someone gives Wells a master Excel sheet and he will load to Google Sheets
2) Everyone downloads the Google sheet as an Excel file and link to their work as a new data source.
3) Everyone labels your contribution with name and description: Wells-Active Cases. etc
4) Drop you TWBX file into Teams. Wells will compile into a single workbook and align the data sources.
https://help.tableau.com/current/pro/desktop/en-us/copy_b_wkbks.htm

5) Wells created a master Tableau workbook to do this, and you'll work from this once this process is finished. https://prod-useast-a.online.tableau.com/t/datareportinguofa/views/TravelerMaster/Dashboard2?:showAppBanner=false&:display_count=n&:showVizHome=n&:origin=viz_share_link


Track 2:

Robert: Traveler dashboard.

Haley: Checking calculations on vaccine supply graphic. Write 1-2 paragraphs for a blog post to go with graphic.

Caroline: Prisons. Map.


Ravi: GitHub test.
1) Link graphics the live Deep Dive Deaths and Deaths from HomePageData folder on Arkansascovid GitHub account: https://github.com/Arkansascovid/Main/tree/master/HomePageData
2) Check the actual time by minutes how fast it takes the updated data in the folder to appear on this post
Arkansascovid Test of Github and Flourish
3) If this works as expected, we'll finish the rest of the Dive graphics for live updates Rachel: Finish podcast Weekly memos due Saturday, 11:59 p.m. Reading: --Read rest of The Wall Street Journal Guide to Information Graphics, Ch 3-5. 60 pages. --Write for possible Tweet / Facebook post on site one article / video / podcast on Covid-19 in Arkansas that will help advance our understanding. Link and one paragraph explanation. --Describe the progress or roadblocks on your particular projects. For Tableau, include a Tableau Online link. Flourish or R, links to GitHub or editable chart --Review Gov Hutchinson's weekly press conference. Describe one item from the event you found interesting. https://www.youtube.com/channel/UCLJcNdgp2PMEmiqJEoYzqwQ Jour 5003 10:45 am meeting. --Cleaning the names in OSHA - PPP Data https://github.com/profrobwells/Spring2021Data/blob/main/Zimmardi%20OSHA_PPP-rsw.Rmd --Compiling the occupational data from ADH in a database in R Here is the occupational data. We compiled it through August. Checking to see if there is more. We will want to pull this into R using the schools script, which I will attached below. https://docs.google.com/spreadsheets/d/1j0IkDVSGjjRvBEU2Xwl0CZQ42dN5-DOXAY8Q2CGtkG0/edit#gid=889222364  ​ Starting at Line 184, this is the process of pulling in the individual sheets and compiling a time series. https://github.com/profrobwells/CovidFall2020/blob/master/School%20Data%20Timeseries.Rmd --In case you were going to post something in Notion: Here is a remind for the workflow for saving those research memos as you work on them 1) Navigate to the background and research folder in the google drive (https://drive.google.com/drive/folders/1gW6MHjv-8Vm8nMhDhTfMzGsJ8MwZksl-?usp=sharing)  2) make a folder with your topic/name and save your google document there 3) Go to the reporting memo page in notion and create an entry, pasting the google drive link to your document and tagging yourself. ((https://www.notion.so/8a6c7cbac38a417389d26aa928bcd133?v=9fc4c9c2d94e43cea74513faf28e878a) Weekly memos due Saturday, 11:59 p.m. Write a short summary like for a news story insert of what we've learned about the poultry industry so far with the number of complaints, size of the industry, demographics etc. Work on PPP-OSHA R script. Create ADH Occupational data R script. Post updates and describe progress / roadblocks. Reading: One article / video / podcast on Covid-19 in Arkansas that will help advance our understanding. Link and one paragraph explanation. Write for possible Tweet / Facebook post on site. --Meyer, “New Precision Journalism,” Ch. 1-2. Write minimum 2 paragraphs on key points you found interesting. --Paper from Harvard correlating OSHA complaints with mortality due to COVID-19: https://cdn1.sph.harvard.edu/wp-content/uploads/sites/1266/2020/10/20_covid-19_federal-[…]g-paper_volume-20_number-2_FINAL_corrected-affiliation.pdf --Deb Nelson I told you about searching GAO.gov and ignet.gov I forgot to mention Congressional Research Service reports!  https://crsreports.congress.gov/product/pdf/R/R46288 “Occupational Safety and Health Administration (OSHA): Emergency Temporary Standards (ETS) and COVID-19 Updated January 14, 2021” (edited)  --This inquiry is in connection to the National Employment Law Project link too. https://www.nelp.org/blog/which-states-cities-have-adopted-comprehensive-covid-19-worker-protections/ (edited) National Employment Law Project Which States and Cities Have Adopted Comprehensive COVID-19 Worker Protections? - National Employment Law Project In the absence of federal leadership, 14 states have adopted comprehensive COVID worker safety protections so far.
Sixth Class: Monday, Feb. 1

--For Monday, review Module #4: Data Visualization


Track 1: 
News format for weekend memo
Update on the Traveler dashboard
Review of weekly memos and issues
Read Module #4: Data Visualization
Key points from Ch 1-2 WSJ book
Guest Speaker Wednesday: KNWA reporter Ninette Sosa and nursing homes

Dual Axis Graphics
See lesson at end of this post: https://wordpressua.uark.edu/datareporting/tableau/


News Format for Weekend Memo
--Find something we don't already know about
--We do the daily and weekly trends. Look for something different. Look local and outside of NWA - Pine Bluff, Texarkana, Jonesboro, Hot Springs
--Write a draft tweet! Don't forget

Grayson
KATV released a story on January 28th about a high school principal who died Wednesday due to Covid-19. Bobby Hulse was the principal at Norfork High School and was an educator for 54 years. Former students of Bobby’s released statements regarding their love and admiration for Bobby. I think this story is important because it goes beyond data to shed light on a real person who lost his life because of Covid-19. While data numbers are significant for looking at the bigger picture, this story shows the personal impacts of Covid-19 on communities. 
https://katv.com/news/local/arkansas-school-principal-dies-from-covid-19

According to KATV, more than a dozen educators across Arkansas have died from COVID-19. The latest is Bobby Hulse, former principal at Norfork High School and educator for 54 years. https://katv.com/news/local/arkansas-school-principal-dies-from-covid-19 @GraysongGreen4

Tableau Public
Here's the Tableau Public link, which I will discuss Monday. https://public.tableau.com/views/NursingHomeDataJan25/Dashboard1?:language=en&:display_count=y&publish=yes&:origin=viz_share_link

Track 2:

Robert: Traveler dashboard.

Haley: Checking calculations on vaccine supply graphic. Write 1-2 paragraphs for a blog post to go with graphic.

Caroline: Prisons. Map. Write 1-2 paragraphs with key findings.


Ravi: GitHub and Flourish.
1) You will be updating the links to graphics on this test page: https://wordpressua.uark.edu/datareporting/arkansascovid-test-of-github-and-flourish/
2) Link graphics HomePageData folder on Arkansascovid GitHub account: https://github.com/Arkansascovid/Main/tree/master/HomePageData
3) Check the actual time by minutes how fast it takes the updated data in the folder to appear on this post
4) If this works as expected, we'll move to the live Home Page


Rachel: Finish podcast


Traveler Dashboard

Tableau Dashboards

The working memo
https://docs.google.com/document/d/1g9UggW7Zz8c85W7Rvo_yT148v1v7S4sKDMwGXV8i0So/edit

Steps to create a single workbook
1) Everyone has to use the exact same Excel document. Suggest someone gives Wells a master Excel sheet and he will load to Google Sheets
2) Everyone downloads the Google sheet as an Excel file and link to their work as a new data source.
3) Everyone labels your contribution with name and description: Wells-Active Cases. etc
4) Drop you TWBX file into Teams. Wells will compile into a single workbook and align the data sources.
https://help.tableau.com/current/pro/desktop/en-us/copy_b_wkbks.htm

5) Wells created a master Tableau workbook to do this, and you'll work from this once this process is finished. https://prod-useast-a.online.tableau.com/t/datareportinguofa/views/TravelerMaster/Dashboard2?:showAppBanner=false&:display_count=n&:showVizHome=n&:origin=viz_share_link



Weekly memos due Saturday, 11:59 p.m.
Reading:
--Finish The Wall Street Journal Guide to Information Graphics, Ch. 3-5, 60 pages. 
--In Module #4: Select two examples from the Dataviz Catalog and FT Visual Vocabulary that you find interesting or useful. Include a screenshot of the chart in your memo and describe how it could apply for our project.
--One article / video / podcast on Covid-19 in Arkansas that will help advance our understanding. Link and one paragraph explanation. Write for possible Tweet / Facebook post on site.
--Describe the progress or roadblocks on your particular projects. For Tableau, include a Tableau Online link. Flourish or R, links to GitHub or editable chart
--Review Gov Hutchinson's weekly press conference. Describe one item from the event you found interesting. https://www.youtube.com/channel/UCLJcNdgp2PMEmiqJEoYzqwQ
--Module #4: Data Visualization


Jour 5003
10:30 am meeting. 

--Compiling the occupational data from ADH in a database in R
Here is the occupational data. We compiled it through August. Checking to see if there is more. We will want to pull this into R using the schools script, which I will attached below. https://docs.google.com/spreadsheets/d/1j0IkDVSGjjRvBEU2Xwl0CZQ42dN5-DOXAY8Q2CGtkG0/edit#gid=889222364  
​
Starting at Line 184, this is the process of pulling in the individual sheets and compiling a time series. https://github.com/profrobwells/CovidFall2020/blob/master/School%20Data%20Timeseries.Rmd 


Weekly memos due Saturday, 11:59 p.m.
Write a short summary like for a news story insert of what we've learned about the poultry industry so far with the number of complaints, size of the industry, demographics etc.
Reading:
One article / video / podcast on Covid-19 in Arkansas that will help advance our understanding. Link and one paragraph explanation. Write for possible Tweet / Facebook post on site.



Seventh Class: Wednesday, Feb. 3

--Module #4: Data Visualization
--Dual Axis Graphics
--Traveler dashboard
--Ninette Sosa

Track 1: 
Tableau Maps

About Page.

Guest Speaker Wednesday: KNWA reporter Ninette Sosa and nursing homes



Ninette Sosa: at 10:15 a.m.
Hi all - Tomorrow, we will have Ninette Sosa, a reporter for KNWA and a former CNN journalist, speak to us about her coverage of COVID and a few other things. Please prepare a few questions for her. https://www.linkedin.com/in/ninette-sosa-47398420/  She has been doing this regular feature on nursing homes on the KNWA website: https://www.nwahomepage.com/news/a-closer-look/a-closer-look-adh-reports-a-total-of-1735-nursing-home-deaths/   Here's her Twitter feed: https://twitter.com/NinetteSosa?ref_src=twsrc%5Egoogle%7Ctwcamp%5Eserp%7Ctwgr%5Eauthor  Ninette is active in the National Association of Hispanic Journalists and earned a Master's Degree in Journalism here in 2018. Some news about her thesis film - Trump pardoned the guy she profiled: https://news.uark.edu/articles/55700/journalism-alumna-directs-exclusive-documentary-on-pardoned-politician-duke-cunningham

Track 2:

Robert: Traveler dashboard.
Haley: Update Vaccine supply graphic, compare with ADH vaccine data. Do video on your graphic.
Caroline: Prisons. Map. Write 1-2 paragraphs for a blog post to go with graphic.
Ravi: Datawrapper.
Rachel: Occupational data

Weekly memos due Saturday, 11:59 p.m.
Reading:
--Finish The Wall Street Journal Guide to Information Graphics, Ch. 3-5, 60 pages. 
--In Module #4: Select two examples from the Dataviz Catalog and FT Visual Vocabulary that you find interesting or useful. Include a screenshot of the chart in your memo and describe how it could apply for our project.
--One article / video / podcast on Covid-19 in Arkansas that will help advance our understanding. Link and one paragraph explanation. Write for possible Tweet / Facebook post on site.
--Describe the progress or roadblocks on your particular projects. For Tableau, include a Tableau Online link. Flourish or R, links to GitHub or editable chart
--Review Gov Hutchinson's weekly press conference. Describe one item from the event you found interesting. https://www.youtube.com/channel/UCLJcNdgp2PMEmiqJEoYzqwQ
--Watch this video and write down two insights from Burn-Murdoch's presentation: https://rstudio.com/resources/rstudioglobal-2021/reporting-on-and-visualising-the-pandemic/


Jour 5003
3 pm meeting. 

Weekly memos due Saturday, 11:59 p.m.
Write a short summary on what you have learned this week in your reporting. Add it to the OSHA Narrative Background document I asked you to create.

--Analyze occupational data from ADH n R
https://github.com/profrobwells/Spring2021Data/blob/main/2.2Occupation%20Data%20Hennigan.rmd
--Produce basic descriptive statistics (counts, medians, timelines) on the cases, deaths etc by industry

Reading/Videos:

--Watch this video and write down two insights from Burn-Murdoch's presentation: https://rstudio.com/resources/rstudioglobal-2021/reporting-on-and-visualising-the-pandemic/

--Meyer, “New Precision Journalism,” Ch. 1-2. Write minimum 2 paragraphs on key points you found interesting. 

--Paper from Harvard correlating OSHA complaints with mortality due to COVID-19: https://cdn1.sph.harvard.edu/wp-content/uploads/sites/1266/2020/10/20_covid-19_federal-[…]g-paper_volume-20_number-2_FINAL_corrected-affiliation.pdf

--Deb Nelson: "I told you about searching GAO.gov and ignet.gov I forgot to mention Congressional Research Service reports!"
https://crsreports.congress.gov/product/pdf/R/R46288 
“Occupational Safety and Health Administration (OSHA): Emergency Temporary Standards (ETS) and COVID-19 Updated January 14, 2021” (edited) 

--This inquiry is in connection to the National Employment Law Project link too. https://www.nelp.org/blog/which-states-cities-have-adopted-comprehensive-covid-19-worker-protections/ (edited) National Employment Law Project
Which States and Cities Have Adopted Comprehensive COVID-19 Worker Protections? - National Employment Law Project
In the absence of federal leadership, 14 states have adopted comprehensive COVID worker safety protections so far.

--https://www.propublica.org/article/after-hundreds-of-meatpacking-workers-died-from-covid-19-congress-wants-answers?utm_source=sailthru&utm_medium=email&utm_campaign=dailynewsletter&utm_content=feature

--https://www.propublica.org/series/on-the-line

--Write a tweet based on one article / video / podcast on Covid-19 in Arkansas that will help advance our understanding. Link and one paragraph explanation. Write for possible Tweet / Facebook post on site.




Eighth Class: Monday, Feb. 8

National Institute for Computer Assisted Reporting - NICAR. 
You are going. 
Arkansascovid is paying for you to attend.
Please clear your schedules to attend as much of this as possible. March 3-5, 2021
https://www.ire.org/training/conferences/nicar-2021/

Fill out your information:
https://docs.google.com/spreadsheets/d/1VDjpsb39b0rZQPAZx3FRH5lnUW0Cox37OS1sWQqOzDI/edit?usp=sharing


Swapping notes with our cousins in South Carolina.
Michelle LaRoche, Baldwin Endowed Chair in Business and Financial Journalism
University of South Carolina

Our Data:
Get to know the Arkansascovid.com data sources
https://github.com/Arkansascovid/Main
Master File
Documentation


Discuss: Burn-Murdoch Video
From Mary and Abby
Key points: text is critical
1) If readers are confused, it’s your fault
2) Consider emotional and political context
3) Don't just publish your chart and disappear. Listen to feedback from readers.
4) Ease of understanding comes first
5) Use animation to create a bigger impact
6) Don’t make your chart fancy to impress “chart people,” make them for everyone to understand.

Tableau Maps

Stories and Dashboards
--How Dashboards and workbooks operate: https://wordpressua.uark.edu/datareporting/dashboards-embed-tableau-in-wordpress/


The Wall Street Journal Guide to Information Graphics, Ch. 3-5, 60 pages. 
--Let's experiment with new data visualization forms. Send one new graphic by Wednesday.


--Module #4: Data Visualization

Beats - Produce two graphics with draft tweets from this week's data. 
Send them to me in Teams throughout the week so we can move stuff out. 
Note them on the weekly memo.
Then we will build dashboards with these graphics next week.

Grayson: Nursing Homes
Rachell: Occupational Data
Caroline: Prisons
Haley: Vaccines
Emma: Deaths, focusing on per capita trends in counties
Graham: New cases, focusing on per capita trends in counties
Ravi: Schools
Heather: Hospital data from Arkansas Hospital Assn
Robert: Testing

Daily Slides
M - Caroline
T - Grayson
Hutchinson press conf: Haley 
W - Rachel
TH - Emma
F - Robert
S - Heather


Twitter Voice: Mary Hennigan.
https://docs.google.com/document/d/1DwoQpchvq57n_AkGqC6XgUtnGAmgAJZFFwVEWOzrBRs/edit?ts=60207c49

Twitter: Little Rock teenager story.
Incoming: 
1) Little Rock Teen suffering the after-effects of COVID  raises the question of what the long-term affect of COVID truly is. 
2) Kylee Carleson, Little Rock teenager, beat Covid-19 but still suffers from its affect’s months later. According to KARK.com, 
the family is searching for specialists and doctors in Arkansas to research the lasting effects of Covid-19.     

Final: 
Little Rock teenager Kylee Carleson beat COVID-19 but still suffers seizures and medical problems months later, KARK reports.
Carleson's family is searching for specialists to research the lasting effects of the disease. kark.com/news/local-new… -- @GraysongGreen4


Track 1: 

Update on the Traveler dashboard
Assignments for the week
Tableau Maps

Track 2:

Graphics assignments, above


Weekly memos due Saturday, 11:59 p.m.
Reading:
--Read Ch. 6, Chapter 6 The Truthful Art
--Review the NICAR21 schedule, select one event you would like to attend and explain why
--One article / video / podcast on Covid-19 in Arkansas that will help advance our understanding. Link and one paragraph explanation. Write for possible Tweet / Facebook post on site.
--Describe the progress or roadblocks on your particular projects. For Tableau, include a Tableau Online link. Flourish or R, links to GitHub or editable chart
--Review Gov Hutchinson's weekly press conference. Describe one item from the event you found interesting. https://www.youtube.com/channel/UCLJcNdgp2PMEmiqJEoYzqwQ
--Module #4: Data Visualization
--Beyond Memorability: Visualization Recognition and Recall
https://vcg.seas.harvard.edu/files/pfister/files/infovis_submission251-camera.pdf?m=1441898216


Jour 5003
10:30 am meeting. 

--Doing Data Reports in R
https://docs.google.com/document/d/1nnpAMKHiBWM7Vpxao63_yChZ8mqpFoIBmlOaiFBSI4Y/edit

--Compiling findings in the narrative file. Do we have one yet? 
Let's add the early results with the OSHA findings.
https://docs.google.com/document/d/1nuRS5PrrhPEOBKFdtTD8utc1qC7BwRb69W3Tkp1x3Nc/edit


R: 
--Cleaning the names in OSHA - PPP Data
https://github.com/profrobwells/Spring2021Data/blob/main/Zimmardi%20OSHA_PPP-rsw.Rmd



Weekly memos due Saturday, 11:59 p.m.
Create a data report in R
Write that draft narrative blending OSHA, preliminary ADH and industry background information
write it like for a news story of what we've learned so far.
Focus on poultry industry so far with the number of complaints, size of the industry, demographics etc.

Reading:
One article / video / podcast on Covid-19 in Arkansas that will help advance our understanding. Link and one paragraph explanation. Write for possible Tweet / Facebook post on site.


--Beyond Memorability: Visualization Recognition and Recall
https://vcg.seas.harvard.edu/files/pfister/files/infovis_submission251-camera.pdf?m=1441898216
Ninth Class: Wednesday, Feb. 10

Build Tableau Workbooks
Haley update on governor's press conference
Vaccine data by county coming soon
Video for this week: Ideas
Experiment with new data visualization forms. Send one new graphic by Wednesday
Site improvements

Bubble Map: See Maps in Tableau



Beats - Produce two graphics with draft tweets from this week's data. 
Send them to me in Teams throughout the week so we can move stuff out. 
Note them on the weekly memo.

Grayson: Nursing Homes
Emma: Deaths, focusing on per capita trends in counties. Map
Graham: New cases, focusing on per capita trends in counties
Heather: Hospital data, incl. Arkansas Hospital Assn

Daily Slides
M - Caroline
T - Grayson
Hutchinson press conf: Haley 
W - Rachel
TH - Emma
F - Robert
S - Heather


Track 1: 
Beat slides and data 


Track 2:
Robert: Traveler dashboard.
--Write the steps to download and update the file
--Update The Boss main spreadsheet
--Ask Abbi for Tableau host account and Google host account
--Wells will link up

Haley: Vaccines
Caroline: Prisons - map problem
Ravi: Schools, Datawrapper and API adventure
Rachel: Occupational data, one-day slide
Robert: Vaccine map, finish with updated data. Testing data.


Weekly memos due Saturday, 11:59 p.m.

Links to your Tableau workbooks. 

Prepare two questions for our guest speaker on Monday: Huda Sharaf, medical director, Pat Walker Health Center. She's involved with the public health 
response to COVID-19 as a member of the Fayetteville Board of Health
https://www.nwaonline.com/news/2020/jul/26/dr-huda-sharaf-student-care-her-specialty/
https://studentaffairsbulletin.uark.edu/staff-q-a-huda-sharaf-m-d/

Writing Reflections on the Following Readings:
--Read Ch. 6, Chapter 6 The Truthful Art - Write 1 paragraph on this reading and how it can apply to Arkansascovid.

--Review the NICAR21 schedule, select one event you would like to attend and explain why. If possible, link it to your work at Arkansascovid.

--Local media: One article / video / podcast on Covid-19 in Arkansas that will help advance our understanding. Link and one paragraph explanation. Write for possible Tweet / Facebook post on site.

--Problems: Describe the progress or roadblocks on your particular projects. For Tableau, include a Tableau Online link. Flourish or R, links to GitHub or editable chart

--Review Gov Hutchinson's weekly press conference. Describe one item from the event you found interesting. https://www.youtube.com/channel/UCLJcNdgp2PMEmiqJEoYzqwQ

Grayson and Heather: Bonus Readings
Meyer, “New Precision Journalism,” Ch. 1-2. Write minimum 2 paragraphs on key points you found interesting. 


Jour 5003
10:30 am meeting. 

Review / Work on R script. Start at Line 275
Fork / pull request to GitHub
https://github.com/profrobwells/Spring2021Data/blob/main/Occupation%20Data%20Hennigan_Wells.rmd


Exercise: Pull Request
 https://docs.google.com/presentation/d/1MbltRcOerktc-E26HMDjYj0BO9CTubQWu1Z2bB9CpVY/edit#slide=id.g448ccc227721fe56_10
 See the above link, Max Harlow on How to Use GitHub   
 Follow Wells on GitHub: https://github.com/profrobwells/Spring2021Data
 Fork Spring2021Data
 Download Hennigan_Wells.rmd and make a change to the file - add something
 Create a pull request. See slides #54-68
 

Weekly memos due Saturday, 11:59 p.m.
Continue to add to summary of what we've learned about the poultry industry so far.
https://docs.google.com/document/d/1b3bEUWj-54U0eeO7CpgjbMfx69LqVRWljp9Y260BAew/edit


Prepare two questions for our guest speaker on Monday: Huda Sharaf, medical director, Pat Walker Health Center. She's involved with the public health 
response to COVID-19 as a member of the Fayetteville Board of Health
https://www.nwaonline.com/news/2020/jul/26/dr-huda-sharaf-student-care-her-specialty/
https://studentaffairsbulletin.uark.edu/staff-q-a-huda-sharaf-m-d/


Reading and Writing Reflections:
--Meatpacking: https://investigatemidwest.org/2021/02/05/osha-and-usda-waited-months-into-pandemic-to-coordinate-effort-into-covid-19-crisis-in-meatpacking-plants-emails-show/
--Read Confirmation Bias:  https://www.datasciencecentral.com/profiles/blogs/the-deadly-data-science-sin-of-confirmation-bias
--Read: Beyond Memorability: Visualization Recognition and Recall
https://vcg.seas.harvard.edu/files/pfister/files/infovis_submission251-camera.pdf?m=1441898216


One article / video / podcast on Covid-19 in Arkansas that will help advance our understanding. Link and one paragraph explanation. Write for possible Tweet / Facebook post on site.


Tenth Class: Monday, Feb. 15

Dr. Huda Sharaff

Due Wednesday, Feb 24, 11:59 p.m. Story and Workbook
Students will use Excel and Tableau (or Flourish) to gather, analyze and visualize Arkansascovid data by demographic and report and write a 300 word story.
Produce a three panel Tableau workbook ready for publication (or similar in Flourish / Datawrapper).
You will work with your assigned workbooks. Due Wednesday, Feb 24, 11:59 p.m.

Robert: Vaccine data - CDC / regional comparison
Haley: Vaccines / county data
Caroline: Prisons (One Datawrapper map; two Tableau graphics)
Ravi: Schools
Rachel: Occupational data
Grayson: Nursing Homes
Emma: Deaths
Graham: New cases
Heather: Hospital data
This does not apply to the Howard Center project.

Beats
Grayson: Nursing Homes
Emma: Deaths, focusing on per capita trends in counties. Map
Graham: New cases, focusing on per capita trends in counties
Heather: Hospital data, incl. Arkansas Hospital Assn

Daily Slides - New Sign ups
Graham
Ravi

M -  Ravi 
T -  Emma
Hutchinson press conf: Graham
W - Robert
TH - Rachell
F - Grayson
S - Heather


Track 1: 
Workbooks

Writing Headlines for Graphics


Track 2:
Robert: Traveler dashboard. Vaccine data - CDC / regional comparison
Haley: Vaccines / county data
Caroline: Prisons - map problem
Ravi: API documentation.
Rachel: Occupational data, one-day slide



Weekly memos due Saturday, 11:59 p.m.

NICAR Schedule.
1) Put your panel and time on the attached schedule sheet. Why? NICAR is a big deal and you need to have a plan. Please provide the time and session title so we can share that information and swap notes with our cousins in South Carolina 
2) Everyone puts down at least three items you plan to attend.

For the memo:
--Background one of the speakers in a panel you plan to attend. Provide a detailed paragraph about their background, their news organization, and find a recent piece of journalism they produced. Tell us about the news article, what you liked and didn't like. Be prepared to discuss this with the class when we meet on Wednesday, Feb 24



Writing Reflections on the Following Readings:

Read the following and write about two central points from this group of articles:
--Read Confirmation Bias:  https://www.datasciencecentral.com/profiles/blogs/the-deadly-data-science-sin-of-confirmation-bias
--Read Overview from Paul Bradshaw on basic data journalism. Three chords. 
 https://github.com/paulbradshaw/MED7373-Data-Journalism/blob/master/1basics/dj3chords.md
--Read: Beyond Memorability: Visualization Recognition and Recall
https://vcg.seas.harvard.edu/files/pfister/files/infovis_submission251-camera.pdf?m=1441898216

--Local media: One article / video / podcast on Covid-19 in Arkansas that will help advance our understanding. Link and one paragraph explanation. Write for possible Tweet / Facebook post on site.

--Problems: Describe the progress or roadblocks on your particular projects. For Tableau, include a Tableau Online link. Flourish or R, links to GitHub or editable chart

--Review Gov Hutchinson's weekly press conference. Describe one item from the event you found interesting. https://www.youtube.com/channel/UCLJcNdgp2PMEmiqJEoYzqwQ

Grayson and Heather: Bonus Readings


Jour 5003
10:30 am meeting. 

Priority: Produce summary results in the R script
https://github.com/profrobwells/Spring2021Data/blob/main/Occupation%20Data%20Hennigan_Wells.rmd

Interviewing:
https://sway.office.com/Wr4oe5IoxlFWwQBk?ref=Link&loc=play

Interviewing:
https://www.youtube.com/watch?v=_S3LL-zqv9c&feature=youtu.be

Weekly memos due Saturday, 11:59 p.m.
Continue to add to summary of what we've learned about the poultry industry so far.
https://docs.google.com/document/d/1b3bEUWj-54U0eeO7CpgjbMfx69LqVRWljp9Y260BAew/edit

Analyze guest worker data
https://docs.google.com/spreadsheets/d/1Idd4PdwX0D4V3PiKrybGFDSe9juy4qJp/edit#gid=1666776442


Reading and Writing Reflections:


One article / video / podcast on Covid-19 in Arkansas that will help advance our understanding. Link and one paragraph explanation. Write for possible Tweet / Facebook post on site.


Eleventh Class: Wednesday Feb. 17

No class on Monday, Feb. 22. Volunteers needed for tweets on Monday-Tuesday
M -  Ravi 
T -  Emma
Hutchinson press conf: Graham
W - Robert
TH - Rachell
F - Grayson
S - Heather
S - ?
M - Grayson
T - Caroline

Updates:

1) Wells, Mary and Katy presenting Friday at national data journalism conference. COMPUTATION + JOURNALISM SYMPOSIUM 2021, Northeastern University. Free to attend, register first.

2) Writing Headlines for Graphics

3) Datawrapper Maps: Haley
https://datawrapper.dwcdn.net/HZNsT/2/

To get the labels to show up, I had to do some coding work in the excel sheet. Here's a link to it, so you can check it out for the future https://docs.google.com/spreadsheets/d/1LizI76tf28RHmnEhd4ZOCZBoKZBh8Oimp4ModoIxWk8/edit?usp=sharing 

Datawrapper
Sheet1 State/Territory/Federal Entity,TEXT + LABEL,Total Delivered,Total Administered,Delivered per 100K,Administered per 100K,People with 1+ Doses,People with 1+ Doses per 100K,People with 2 Dose...
docs.google.com
​
I found an article in the datawrapper academy page that shows how to display a label and value, and I used the basic formula from that for this. Then it was a bit of trial and error to figure out how to get multiple values and their correct labels added https://academy.datawrapper.de/article/257-how-to-display-both-label-and-value-on-choropleth-maps 

4) Automatic updates: Ravi

Adjourn to Gather: Workshop

Traveler Dashboard - Robert

Data Cleaning Class Exercise
County vaccine data and processing from a PDF
Take this spreadsheet, clean it and get it into Tableau for a quick bar chart.
--Remember, the top row needs to have the headers.
--Text to columns to split data on common identifier
--Watch for merged cells
--Find / replace to remove characters
--Data Cleaning
text to columns
=trim(E4)


Beats
Grayson: Nursing Homes
Emma: Deaths, focusing on per capita trends in counties. Map
Graham: New cases, focusing on per capita trends in counties
Heather: Hospital data, incl. Arkansas Hospital Assn


Jour 405v

Due Wednesday, Feb 24, 11:59 p.m. Story and Workbook
Students will use Excel and Tableau (or Flourish) to gather, analyze and visualize Arkansascovid data by demographic and report and write a 300 word story.
Produce a three panel Tableau workbook ready for publication (or similar in Flourish / Datawrapper).
You will work with your assigned workbooks. Due Wednesday, Feb 24, 11:59 p.m.
Robert: Vaccine data - CDC / regional comparison
Haley: Vaccines / county data
Caroline: Prisons (One Datawrapper map; two Tableau graphics)
Ravi: Schools
Rachel: Occupational data
Grayson: Nursing Homes
Emma: Deaths
Graham: New cases
Heather: Hospital data
This does not apply to the Howard Center project.

Weekly memos due Saturday, 11:59 p.m.

NICAR Schedule.
1) Put your panel and time on the attached schedule sheet. Why? NICAR is a big deal and you need to have a plan. Please provide the time and session title so we can share that information and swap notes with our cousins in South Carolina 
2) Everyone puts down at least three items you plan to attend.

For the memo:
--Background one of the speakers in a panel you plan to attend. Provide a detailed paragraph about their background, their news organization, and find a recent piece of journalism they produced. Tell us about the news article, what you liked and didn't like. Be prepared to discuss this with the class when we meet on Wednesday, Feb 24

Flourish
Module #5 Flourish: https://wordpressua.uark.edu/datareporting/flourish-module/
For Saturday's memo - produce one Flourish graphic, put link in memo. We'll discuss Wednesday.

Writing Reflections on the Following Readings:

Read the following and write about two central points from this group of articles:
--Read Confirmation Bias:  https://www.datasciencecentral.com/profiles/blogs/the-deadly-data-science-sin-of-confirmation-bias
--Read Overview from Paul Bradshaw on basic data journalism. Three chords. 
 https://github.com/paulbradshaw/MED7373-Data-Journalism/blob/master/1basics/dj3chords.md
--Read: Beyond Memorability: Visualization Recognition and Recall
https://vcg.seas.harvard.edu/files/pfister/files/infovis_submission251-camera.pdf?m=1441898216

--Local media: One article / video / podcast on Covid-19 in Arkansas that will help advance our understanding. Link and one paragraph explanation. Write for possible Tweet / Facebook post on site.

--Problems: Describe the progress or roadblocks on your particular projects. For Tableau, include a Tableau Online link. Flourish or R, links to GitHub or editable chart

--Review Gov Hutchinson's weekly press conference. Describe one item from the event you found interesting. https://www.youtube.com/channel/UCLJcNdgp2PMEmiqJEoYzqwQ

Grayson and Heather: Bonus Assignment
Module #5 Flourish: https://wordpressua.uark.edu/datareporting/flourish-module/
For Saturday's memo - produce a Flourish story book. See Ravi's video for guidance. Put link in memo. We'll discuss Wednesday.

Jour 5003
10:30 am meeting. 

R script
https://github.com/profrobwells/Spring2021Data/blob/main/Occupation%20Data%20Hennigan_Wells.rmd
--Data cleaning
--Math
--Additional data May-July from ADH
--Basic counts of reports per month
--Basic counts of reports by industry
--Basic counts of reports by city
--Map of reports


Weekly memos due Saturday, 11:59 p.m.
Continue to add to summary with preliminary findings from data. Generate tables in R, describe the top-level trends, screenshot tables and put them here.
https://docs.google.com/document/d/1b3bEUWj-54U0eeO7CpgjbMfx69LqVRWljp9Y260BAew/edit


Reading and Writing Reflections:

 Aucoin, James L. The Evolution of American Investigative Journalism,. University of Missouri Press, 2005. ProQuest Ebook Central, https://0-ebookcentral-proquest-com.library.uark.edu/lib/uark/detail.action?docID=3440699.  p 26-40

One article / video / podcast on Covid-19 in Arkansas that will help advance our understanding. Link and one paragraph explanation. Write for possible Tweet / Facebook post on site.


Twelfth Class: Wednesday Feb. 24

Report on at national data journalism conference. COMPUTATION + JOURNALISM SYMPOSIUM 2021, Northeastern University

NICAR panel selections

Flourish
Module #5 Flourish: https://wordpressua.uark.edu/datareporting/flourish-module/

Hutchinson Press Conf notes
https://uark-my.sharepoint.com/:w:/g/personal/jgsmiths_uark_edu/EUpZe8p3-0hMh4HRM3FdvgcBsid1vScTCHtoVF6yDEcWMA?e=JuNbGW


Beats
Grayson: Nursing Homes
Emma: Deaths, focusing on per capita trends in counties. Map
Graham: New cases, focusing on per capita trends in counties
Heather: Hospital data, incl. Arkansas Hospital Assn

Track 1: 
Workbooks

Writing Headlines for Graphics

M -  Graysonx
T -  CarolineX
Hutchinson press conf: Grahamx
W - Robertx
TH - Rachellx
F - Graysonx
S - Heatherx
S - ?

Updates:

1) Writing Headlines for Graphics
2) Adjourn to Gather: Workshop


Beats
Grayson: Nursing Homes
Emma: Deaths, focusing on per capita trends in counties. Map
Graham: New cases, focusing on per capita trends in counties
Heather: Hospital data, incl. Arkansas Hospital Assn


Jour 405v

Due Wednesday, Feb 24, 11:59 p.m. Story and Workbook
Students will use Excel and Tableau (or Flourish) to gather, analyze and visualize Arkansascovid data by demographic and report and write a 300 word story.
Produce a three panel Tableau workbook ready for publication (or similar in Flourish / Datawrapper).
You will work with your assigned workbooks. Due Wednesday, Feb 24, 11:59 p.m.
Robert: Vaccine data - CDC / regional comparison
Haley: Vaccines / county data
Caroline: Prisons (One Datawrapper map; two Tableau graphics)
Ravi: Schools
Rachel: Occupational data
Grayson: Nursing Homes
Emma: Deaths
Graham: New cases
Heather: Hospital data
This does not apply to the Howard Center project.

Weekly memos due Saturday, 11:59 p.m.

NICAR Schedule.


For the memo:
NICAR Articles: Read about the panels your colleagues will be attending at NICAR

Writing Reflections on the Following Readings:

Read all of the following articles. Select one, write a detailed paragraph about central points in each article:

An outstanding piece of work about interviewing.
https://docs.google.com/document/d/1fz1j70aWz5grWo2B44_6_yVTFx4_RVs3-7AnnCLx2cI/edit

Relationships with immigrant communities
https://www.lenfestinstitute.org/solution-set/a-new-report-offers-strategies-for-how-newsrooms-can-better-serve-immigrant-communities/

Local Newsletter and Covid
https://medium.com/the-newsletter-wizards-project/montana-free-press-experiments-with-newsletters-for-local-covid-19-coverage-77115ac44619

Beware of the Infographic
https://www.cjr.org/the_media_today/alberto-cairo-infographics.php

 https://timetoherd.com/

--Local media: One article / video / podcast on Covid-19 in Arkansas that will help advance our understanding. Link and one paragraph explanation. Write for possible Tweet / Facebook post on site.

--Problems: Describe the progress or roadblocks on your particular projects. For Tableau, include a Tableau Online link. Flourish or R, links to GitHub or editable chart

--Review Gov Hutchinson's weekly press conference. Describe one item from the event you found interesting. https://www.youtube.com/channel/UCLJcNdgp2PMEmiqJEoYzqwQ

Grayson and Heather: Bonus Assignment
--Find three data journalism articles by a NICAR speaker you have not profiled. Describe any techniques they use that we have addressed in class or techniques you would like to address. Summarize it and we'll discuss your findings on Monday.

Jour 5003
10:30 am meeting. 

R script
https://github.com/profrobwells/Spring2021Data/blob/main/Occupation%20Data%20Hennigan_Wells.rmd
--Data cleaning. Finish building the May-August data
--Import the OSHA complaints into R. Normalize the names as you did with the ADH data. Match OSHA to ADH complaints.

Weekly memos due Saturday, 11:59 p.m.
Continue to add to summary with preliminary findings from data. Generate tables in R

Reading and Writing Reflections:

--Read all of the articles below. Each of you select one (no overlaps) that best pertains to our work. Write one paragraph reflection.

An outstanding piece of work about interviewing.
https://docs.google.com/document/d/1fz1j70aWz5grWo2B44_6_yVTFx4_RVs3-7AnnCLx2cI/edit

Examine this memo and follow it for our Arkansas work. Some great questions here.
https://docs.google.com/document/d/1392QMwIafMa008GzMVodKgv7hy67KlWir0gUaaYaXvk/edit

Relationships with immigrant communities
https://www.lenfestinstitute.org/solution-set/a-new-report-offers-strategies-for-how-newsrooms-can-better-serve-immigrant-communities/

Workplace deaths
https://www.wcnc.com/article/news/health/coronavirus/nc-had-highest-number-of-workplace-deaths-in-a-decade-workers-rights-groups-are-blaming-lack-of-covid-19-protections/275-e9b06d16-958e-420b-a4e0-a1d87843d39b

Las Vegas Sun and worker safety
https://www.pulitzer.org/winners/las-vegas-sun-and-notably-courageous-reporting-alexandra-berzon

OSHA Tracker - FYI
https://www.thestrikewave.com/osha-complaint-map

OSHA Tracker Twitter feed
https://twitter.com/workingwcovid


NICAR
Find two data journalism articles by a NICAR speaker you have not profiled.

One article / video / podcast on Covid-19 in Arkansas that will help advance our understanding. Link and one paragraph explanation. Write for possible Tweet / Facebook post on site.


Thirteenth Class: Monday March 1

NICAR on Wednesday. No class meeting Wednesday. The class is NICAR. 
Take NOTES, report for weekend memo.

This is the largest group of University of Arkansas students to ever attend a NICAR conference.

--You should be registered for NICAR already and have an introductory email explaining what to do. If not, let me know.

NICAR Schedule

Schedule some time next week to check out panels you were not able to attend. I want students to make the most of this opportunity.

One-year anniversary graphic idea: Due Tuesday, 11:59 p.m., in Teams
Hutchinson's Emergency Order Began March 11
--Flourish preferred
--Summarize the number of deaths, cases, etc over the past year

Emma - Deaths
Grayson - Nursing Homes
Ravi - Schools
Caroline - Prisons
Graham - New positive cases, worst months
Robert - 
Haley - Vaccines


Fact check stories. 
The protocol:
https://docs.google.com/document/d/1ni0pLjAmr2XhEUgIV6XWhUiaQhsK7FXHDwa76hjFxlM/edit
Assignments:
https://docs.google.com/spreadsheets/d/1xiD7IXkiRLOAt-QVHx99RPfgMiCTRlrR9PbON00XXXY/edit?usp=sharing
Due Saturday.
https://learn.uark.edu/ultra/courses/_291872_1/cl/outline

Contribute to Mass Vaccination List
https://docs.google.com/forms/d/e/1FAIpQLSdQ1I8IP1suCJB1FMnsuUYEpgsAMHOntLMroS0rnX96_FIYrw/viewform


Beginning R: 
Haley, Ravi, Robert, Caroline
Module #10: R and R Studio – The Basics
1) Writing Headlines for Graphics 2) Adjourn to Gather: Workshop OSHA Team Mary, Abby, Rachell Track 1: M - Graysonx T - CarolineX Hutchinson press conf: Haley W - Robertx TH - Rachellx F - Graysonx S - ? S - ? Weekly memos due Saturday, 11:59 p.m. Jour 405v memo: --Notes on three panels you attended; one paragraph per panel. I am expecting URLs on resources, reflections on what you found difficult and how we could use or not use this for Arkansascovid. --Draft of your anniversary graphic Readings: Supply two readings from panels you attended. They can be news articles authored by the speakers or how-to tips or useful websites. --Write one paragraph each on these readings. Grayson: Bonus Assignment --Notes on FOUR panels you attended; one paragraph per panel. I am expecting URLs on resources, reflections on what you found difficult and how we could use or not use this for Arkansascovid. Supply THREE readings from panels you attended. They can be news articles authored by the speakers or how-to tips or useful websites. --Write one paragraph each on these readings. Jour 5003- OSHA Project R script https://github.com/profrobwells/Spring2021Data/blob/main/Occupation%20Data%20Hennigan_Wells.rmd --Data cleaning. Finish building the May-August data --Import the OSHA complaints into R. Normalize the names as you did with the ADH data. Match OSHA to ADH complaints. Weekly memos due Saturday, 11:59 p.m. --Notes on FOUR panels you attended; one paragraph per panel. I am expecting URLs on resources, reflections on what you found difficult and how we could use or not use this for Arkansascovid. Readings: Supply THREE readings from panels you attended. They can be news articles authored by the speakers or how-to tips or useful websites. --Write one paragraph each on these readings.
Fourteenth Class: Wednesday March 3

NICAR on Wednesday. No class meeting Wednesday. The class is NICAR. 

If you have questions about your one-year anniversary graphics or fact check, meet in Gather

Adjourn to Gather: Workshop
Fifteenth Class: Monday March 8

Discuss NICAR highlights
NICAR Summary

For Wednesday:
Guest Speaker: Fola Akinnibi, Reporter, Bloomberg News, New York.
He will discuss this project:
 https://www.bloomberg.com/graphics/2021-city-budget-police-funding/?srnd=premium&sref=IUm3fzs0

Check out his other work, a mix of politics and finance:
https://www.bloomberg.com/authors/AUVJBBuMflw/fola-akinnibi

Fola's career from the Univ of Maryland's student newspaper to now:
https://www.linkedin.com/in/fola-akinnibi-958b2183/

--Two questions for Fola by Tuesday 5 pm in Teams.

Fact Check Updates

One-year anniversary graphic. Workshop


M -  Ravi
T -  Caroline
Hutchinson press conf: Graham
W - Emma
TH - Rachell?
F - Grayson
S - ?
S - ?


One Year Anniversary Covid Graphics.
 Use Flourish / Datawrapper when possible. If you use Tableau, it will be a static graphic, or an image.
 
Ravi: Animated graphic on cases. A bar chart race on flourish showing the progress of COVID in arkansas w/ positive cases through time from 3/11/20 (or whenever the data started) to 3/11/21

 Robert: County-level data, graph the counties with the highest and lowest infection rates. 1) Top 10 worst counties per capita 2) An attractive searchable chart of the counties by per capita infection rates and also include the overall rate for additional detail.

 Caroline: A Datawrapper chart with the top 10 prison facilities that have had total positive cases for the year 

 Haley: An animated one in flourish tracking the fully vaccinated county populations (by second dose pct). Maybe we can do all, but it might be better to do the top 10-20ish

 Grayson: Nursing homes. My "highest deaths in Arkansas nursing homes" graphic. Except for instead of visualizing 10 I am going to visualize the top 20 nursing homes with the highest deaths in residents. So I will just be filtering like usual but adding more nursing homes to the graphic 

 Graham: Graham: Flourish to represent the counties that had the worst amount of new cases during the three worst months. The peak of the crisis November, December,January. So I would just filter the data for those three months. Sum he counties per month. Pick the top 5.  https://github.com/Arkansascovid/Main/blob/master/master_file.csv?raw=true​​​​​​​

 Emma: Deaths per capita map. A datawrapper map would be great. So calculate total deaths per capita using the latest data, the most recent  day, and map that. Sound like a plan?  It's just like Flourish. The main thing will be to get the calculation completed in Excel, trim down the data only what you need: County, Deaths, Population. Divide deaths into population in a new column. This is the one-day data you can start with. https://github.com/Arkansascovid/Main/blob/master/HomePageData/countyonlytoday.csv

Volunteer! 
--Animation by race, per capita evolution of the cases over time.


Add to Mass Vaccination list
https://docs.google.com/forms/d/e/1FAIpQLSdQ1I8IP1suCJB1FMnsuUYEpgsAMHOntLMroS0rnX96_FIYrw/viewform

Beginning R: Haley, Ravi, Robert

1) Writing Headlines for Graphics
2) Adjourn to Gather: Workshop





Beats - Regions
I am going to shift gears a bit with our beat assignments and have the students reach out to the various rural communities around the state, start asking what is going on with vaccines and the rest. 

Metro Little Rock/Conway/ Hot Springs - Graham & Ravi 
Pine Bluff to the southeast - Lake Village - Caroline (Graham may assist)
Mena to Texarkana to El Dorado - Grayson
Fort Smith/Arkansas River Valley - Emma
Jonesboro, Forrest City, Helena - Haley, Robert 

I'm thinking we start with the community colleges and the county health departments. 
First question: do you have any vaccine clinics going on? Talk to local leaders and pharmacies - how's it going? We can get a bunch of cool little stories that need statewide visibility. And we can illustrate all of this with county level data
Everything is fair game. I just want to know from the local level how they are dealing with vaccines, good stories and bad stories. we need to diversify as the covid story has changed here.

What happens when they reopen businesses
GoFundme for medical bills
Mass vaccination clinics
Use school, prison, occupational data

Facebook slide of Hot Springs vaccination.

OSHA Team
Mary, Abby, Rachell 


Track 1: 

Weekly memos due Saturday, 11:59 p.m.
Jour 405v memo:
--Select NICAR panel you didn't attend, write up a one-paragraph summary. Include speakers' names, URLs, how it may or may not apply to Arkansascovid.
--Select two NICAR readings, write up a one-paragraph summary. Include speakers' names, URLs, how it may or may not apply to Arkansascovid.
--Call your beat communities, write a minimum two-paragraph story on how they are addressing COVID, vaccines etc.

Readings:

Grayson: Bonus Assignment
--Brief story from local beat with graphic

Jour 5003- OSHA Project

R script
https://github.com/profrobwells/Spring2021Data/blob/main/Occupation%20Data%20Hennigan_Wells.rmd
--Data cleaning. Finish building the May-August data
--Import the OSHA complaints into R. Normalize the names as you did with the ADH data. Match OSHA to ADH complaints.

Weekly memos due Saturday, 11:59 p.m.


Readings:

Sixteenth Class: Wednesday March 10


Monday: Hybrid class, Kimpel 145



Beats - Regions

For this weekend's memo:
--One tweet on a local news story in your community
--Two paragraph story and a graphic based on an event in your community or a data finding using Arkansascovid data.
Everything is fair game. Start with vaccine data but you can use school, prison, occupational data

The latest vaccine data by county, March 9.
https://github.com/Arkansascovid/Main/blob/master/vaccinecounty.csv

The vaccine data by race and health region, March 8-9. We will build this out as a time series.
https://github.com/Arkansascovid/Main/blob/master/vax_haa.csv

Metro Little Rock/Conway/ Hot Springs - Graham & Ravi 
Pine Bluff to the southeast - Lake Village - Caroline (Graham may assist)
Mena to Texarkana to El Dorado - Grayson
Fort Smith/Arkansas River Valley - Emma
Jonesboro, Forrest City, Helena - Haley, Robert 

Beat calls: 
Start with the community colleges and the county health departments. 
First question: do you have any mass vaccine clinics scheduled?
Business reopening - how is that going? Local Chamber of Commerce
GoFundme for medical bills?



Guest Speaker: Fola Akinnibi, Reporter, Bloomberg News, New York.
He will discuss this project:
 https://www.bloomberg.com/graphics/2021-city-budget-police-funding/?srnd=premium&sref=IUm3fzs0

Check out his other work, a mix of politics and finance:
https://www.bloomberg.com/authors/AUVJBBuMflw/fola-akinnibi

Fola's career from the Univ of Maryland's student newspaper to now:
https://www.linkedin.com/in/fola-akinnibi-958b2183/


Fact Check Updates

One-year anniversary graphic. Workshop


M -  Ravi
T -  Caroline
Hutchinson press conf: Graham
W - Emma
TH - Rachell?
F - Grayson
S - ?
S - ?


One Year Anniversary Covid Graphics.
 Use Flourish / Datawrapper when possible. If you use Tableau, it will be a static graphic, or an image.
 

--Pending update with latest data Robert: County-level data, graph the counties with the highest and lowest infection rates. 1) Top 10 worst counties per capita 2) An attractive searchable chart of the counties by per capita infection rates and also include the overall rate for additional detail.

 Grayson: Nursing homes. My "highest deaths in Arkansas nursing homes" graphic. Except for instead of visualizing 10 I am going to visualize the top 20 nursing homes with the highest deaths in residents. So I will just be filtering like usual but adding more nursing homes to the graphic 

 Graham: Graham: Flourish to represent the counties that had the worst amount of new cases during the three worst months. The peak of the crisis November, December,January. So I would just filter the data for those three months. Sum he counties per month. Pick the top 5.  https://github.com/Arkansascovid/Main/blob/master/master_file.csv?raw=true​​​​​​​

--Pending final tweaks Emma: Deaths per capita map. A datawrapper map would be great. So calculate total deaths per capita using the latest data, the most recent  day, and map that. Sound like a plan?  It's just like Flourish. The main thing will be to get the calculation completed in Excel, trim down the data only what you need: County, Deaths, Population. Divide deaths into population in a new column. This is the one-day data you can start with. https://github.com/Arkansascovid/Main/blob/master/HomePageData/countyonlytoday.csv

-Update with latest data. DONE: Ravi: Animated graphic on cases. A bar chart race on flourish showing the progress of COVID in arkansas w/ positive cases through time from 3/11/20 (or whenever the data started) to 3/11/21

DONE: Caroline: A Datawrapper chart with the top 10 prison facilities that have had total positive cases for the year 

-Update with latest data DONE: Haley: An animated one in flourish tracking the fully vaccinated county populations (by second dose pct). Maybe we can do all, but it might be better to do the top 10-20ish
--Story: --Pending update with latest data

Volunteer! 
--Animation by race, per capita evolution of the cases over time.


Add to Mass Vaccination list
https://docs.google.com/forms/d/e/1FAIpQLSdQ1I8IP1suCJB1FMnsuUYEpgsAMHOntLMroS0rnX96_FIYrw/viewform

Beginning R: Haley, Ravi, Robert

OSHA Team
Mary, Abby, Rachell 


Track 1: 

Weekly memos due Saturday, 11:59 p.m.
Jour 405v memo:
For this weekend's memo:
--One tweet on a local news story in your community
--Two paragraph story and a graphic based on an event in your community or a data finding using Arkansascovid data.
Everything is fair game. Start with vaccine data but you can use school, prison, occupational data


Grayson: Bonus Assignment
--Attend a NICAR panel that you missed and write a one paragraph report on it with URLs

Jour 5003- OSHA Project

R script
https://github.com/profrobwells/Spring2021Data/blob/main/Occupation%20Data%20Hennigan_Wells.rmd
--Data cleaning. Finish cleaning city-county data, run summary tables.
--The big company reporting. Interviews
--Poultry worker reporting

Weekly memos due Saturday, 11:59 p.m.

No readings. Finish the data.

Seventeenth Class: Monday March 15

Hybrid class, Kimpel 145
--Bring a mask
--Bring your laptop - the software on the class machines will need updating.

Update Tableau
Update R

Ginny Monk, guest speaker, Wednesday
A recent graduate from our program, former Traveler editor, is now a top investigative reporter in Arkansas. 
https://www.arkansasonline.com/childabuse/
https://www.arkansasonline.com/news/2021/feb/14/5252-virus-deaths-leave-state-grieving/
https://www.arkansasonline.com/staff/ginny-monk/
--Submit two questions by Tuesday 11:59 p.m.

Traveler Dashboard
Thanks to Robert and Haley
http://www.uatrav.com/covid-19/

Local stories: Context!
--Statewide vaccination averages
--Paint a picture of the county. Population. Employer. Landmarks
--Pick up the phone and speak to someone.
--Let's get some stuff in these stories and make them interesting.
--Find out what is happening on the ground. Call a local pharmacist. Call the county health department. Are you getting the doses you were promised?
--Stories in the business community. Call the local Chamber of Commerce. How is business doing with the pandemic? Who is reopening and who is not. Why?

Writing Headlines for Graphics

Audience Feedback: Vaccine Data, Normalized
--R Script
https://twitter.com/mammabejamma/status/1369459682541264902

Workshop
--Make calls, check county level data on cases, schools, prisons, etc work on local stories

--R session: Ravi, Haley, Robert
Pull down this script, run it and list 5 questions you have about what is going on.
https://raw.githubusercontent.com/profrobwells/CovidFall2020/master/Daily%20Update.Rmd

--Grayson and nursing home data

--Rachell, Mary and Abby, interviews and strategy




Fact Check Updates

One-year anniversary graphic. Workshop


M -  Ravix
T -  Carolinex
Hutchinson press conf: Grahamx
W - Emmax
TH - Rachellx
F - Robertx
S - ?
S - ?


One Year Anniversary Covid Graphics.
Grayson: Nursing homes. My "highest deaths in Arkansas nursing homes" graphic. Except for instead of visualizing 10 I am going to visualize the top 20 nursing homes with the highest deaths in residents. So I will just be filtering like usual but adding more nursing homes to the graphic 

Graham: Graham: Flourish to represent the counties that had the worst amount of new cases during the three worst months. The peak of the crisis November, December,January. So I would just filter the data for those three months. Sum he counties per month. Pick the top 5.  https://github.com/Arkansascovid/Main/blob/master/master_file.csv?raw=true​​​​​​​

Add to Mass Vaccination list
https://docs.google.com/forms/d/e/1FAIpQLSdQ1I8IP1suCJB1FMnsuUYEpgsAMHOntLMroS0rnX96_FIYrw/viewform

Beginning R: Haley, Ravi, Robert

1) Writing Headlines for Graphics
2) Adjourn to Gather: Workshop


Beats - Regions
I am going to shift gears a bit with our beat assignments and have the students reach out to the various rural communities around the state, start asking what is going on with vaccines and the rest. 

Metro Little Rock/Conway/ Hot Springs - Graham & Ravi 
Pine Bluff to the southeast - Lake Village - Caroline (Graham may assist)
Mena to Texarkana to El Dorado - Grayson
Fort Smith/Arkansas River Valley - Emma
Jonesboro, Forrest City, Helena - Haley, Robert 

I'm thinking we start with the community colleges and the county health departments. 
First question: do you have any vaccine clinics going on? Talk to local leaders and pharmacies - how's it going? We can get a bunch of cool little stories that need statewide visibility. And we can illustrate all of this with county level data
Everything is fair game. I just want to know from the local level how they are dealing with vaccines, good stories and bad stories. we need to diversify as the covid story has changed here.

What happens when they reopen businesses
GoFundme for medical bills
Mass vaccination clinics
Use school, prison, occupational data

Facebook slide of Hot Springs vaccination.

OSHA Team
Mary, Abby, Rachell 


Track 1: 

Weekly memos due Saturday, 11:59 p.m.
Jour 405v memo:
--Select NICAR panel you didn't attend, write up a one-paragraph summary. Include speakers' names, URLs, how it may or may not apply to Arkansascovid.
--Select two NICAR readings, write up a one-paragraph summary. Include speakers' names, URLs, how it may or may not apply to Arkansascovid.
--Call your beat communities, write a minimum two-paragraph story on how they are addressing COVID, vaccines etc.

Readings:

Grayson: Bonus Assignment
--Brief story from local beat with graphic

Jour 5003- OSHA Project

R script
https://github.com/profrobwells/Spring2021Data/blob/main/Occupation%20Data%20Hennigan_Wells.rmd
--Data cleaning. Finish building the May-August data
--Import the OSHA complaints into R. Normalize the names as you did with the ADH data. Match OSHA to ADH complaints.

Weekly memos due Saturday, 11:59 p.m.


Readings:

Wednesday March 17: 18th Class

Hybrid class, Kimpel 145

Graham and Hutchinson announcement

Writing Headlines 

Audience Feedback: Vaccine Data, Normalized
--R Script
https://twitter.com/mammabejamma/status/1369459682541264902

Workshop
Using master_file.csv to examine county data and trends.
https://github.com/Arkansascovid/Main/blob/master/master_file.csv?raw=true

--State average for deaths, cases. 
--Since Feb 1: Which of your counties are above/below the state averages?
--Make a map in Datawrapper just for your counties

R session: Ravi, Haley, Robert, Rachel
Pull down this script, run it and list 5 questions you have about what is going on.
https://raw.githubusercontent.com/profrobwells/CovidFall2020/master/Daily%20Update.Rmd

--Grayson and nursing home data

Ginny Monk, guest speaker, Wednesday
A recent graduate from our program, former Traveler editor, is now a top investigative reporter in Arkansas. 
https://www.arkansasonline.com/childabuse/
https://www.arkansasonline.com/news/2021/feb/14/5252-virus-deaths-leave-state-grieving/
https://www.arkansasonline.com/staff/ginny-monk/


M -  Ravi
T -  Caroline
Hutchinson press conf: Graham
W - Emma
TH - Grayson
F - Robertx
S - ?
S - ?


One Year Anniversary Covid Graphics.
Grayson: Nursing homes. My "highest deaths in Arkansas nursing homes" graphic. 
Graham: Flourish to represent the counties that had the worst amount of new cases during the three worst months. 

Beats - Regions
Metro Little Rock/Conway/ Hot Springs - Graham & Ravi 
Pine Bluff to the southeast - Lake Village - Caroline (Graham may assist)
Mena to Texarkana to El Dorado - Grayson
Fort Smith/Arkansas River Valley - Emma
Jonesboro, Forrest City, Helena - Haley, Robert 

Local stories: Context!
--Statewide vaccination averages
--Paint a picture of the county. Population. Employer. Landmarks
--Pick up the phone and speak to someone.
--Let's get some stuff in these stories and make them interesting.
--Find out what is happening on the ground. Call a local pharmacist. Call the county health department. Are you getting the doses you were promised?
--Stories in the business community. Call the local Chamber of Commerce. How is business doing with the pandemic? Who is reopening and who is not. Why?

OSHA Team
Mary, Abby, Rachell 

Track 1: 

Weekly memos due Saturday, 11:59 p.m.
Jour 405v memo:

One story from your local communities with a graphic.
--Call and speak to at least two people.
--Provide context


Readings:

Grayson: Bonus Assignment


Jour 5003- OSHA Project

Interviews. 

R script
https://github.com/profrobwells/Spring2021Data/blob/main/Occupation%20Data%20Hennigan_Wells.rmd
--Import the OSHA complaints into R. Normalize the names as you did with the ADH data. Match OSHA to ADH complaints.

Weekly memos due Saturday, 11:59 p.m.


Monday March 22: 19th Class

Hybrid class, Kimpel 145

Local stories
Shout out:
Caroline, pharmacist in Fordyce
Emma, Chamber of Commerce and a teacher in Fort Smith
Haley, superintendent in Phillips County

Graphics checklist
https://docs.google.com/document/d/12XgNedUBjcgiTNJmJj_pxyvVwA4zhkx88jprJQhkCGc/edit#

Workshop

Build a timeline of COVID-19 in Arkansas
https://docs.google.com/spreadsheets/d/14FjQhCJiIv8_GU-dTgs8mubFnVkBEGE18T2moHUB4Eo/edit#gid=0

Add at least three four items for your particular month. Look at the Democrat-Gazette coverage (library, America's News)
Dates have to be in that same gregorian format for this thing to work: 3/19/2021  not March 19, 21 etc

Ravi - March
Robert - February
Emma - January
Grayson - December
Haley - November
Caroline - October
Rachell - September
Graham - August
Mary - July
Abby - June


Examine county data and trends.
Local trends -- Haley's spreadsheet
March 11 vs. March 18

Local trends - Robert's graphic
https://app.flourish.studio/visualisation/5615525/edit
Nice job with the state and regional averages. Important addition for context. 

--7 Day Averages
https://github.com/Arkansascovid/Main/blob/master/master_file.csv?raw=true

--Table with 7 day averages
https://github.com/profrobwells/Spring2021Data/blob/main/county_averages.csv?raw=true

--Latest week 7 day averages
https://raw.githubusercontent.com/profrobwells/Spring2021Data/main/county_latest.csv



--State average for deaths, cases. 
--Since Feb 1: Which of your counties are above/below the state averages?
--Make a map in Datawrapper just for your counties

R session: Ravi, Haley, Robert, Rachel
Pull down this script, run it and list 5 questions you have about what is going on.
https://raw.githubusercontent.com/profrobwells/CovidFall2020/master/Daily%20Update.Rmd

M -  Ravix
T -  Carolinex
Hutchinson press conf: Grahamx
W - Emma/ Robertx
TH - Graysonx
F - Rachellx
S - ?
S - ?


One Year Anniversary Covid Graphics.
Grayson: Nursing homes. My "highest deaths in Arkansas nursing homes" graphic. 
Graham: Flourish to represent the counties that had the worst amount of new cases during the three worst months. 

Beats - Regions
Metro Little Rock/Conway/ Hot Springs - Graham & Ravi 
Pine Bluff to the southeast - Lake Village - Caroline (Graham may assist)
Mena to Texarkana to El Dorado - Grayson
Fort Smith/Arkansas River Valley - Emma
Jonesboro, Forrest City, Helena - Haley, Robert 

Local stories: Context!
--Statewide vaccination averages
--Paint a picture of the county. Population. Employer. Landmarks
--Pick up the phone and speak to someone.
--Let's get some stuff in these stories and make them interesting.
--Find out what is happening on the ground. Call a local pharmacist. Call the county health department. Are you getting the doses you were promised?
--Stories in the business community. Call the local Chamber of Commerce. How is business doing with the pandemic? Who is reopening and who is not. Why?

OSHA Team
Mary, Abby, Rachell 

Track 1: 

Weekly memos due Saturday, 11:59 p.m.
Jour 405v memo:

One story from your local communities with a graphic.
--Call and speak to at least two people.
--Provide context


Readings:

Grayson: Bonus Assignment


Jour 5003- OSHA Project

Interviews. 

R script
https://github.com/profrobwells/Spring2021Data/blob/main/Occupation%20Data%20Hennigan_Wells.rmd
--Import the OSHA complaints into R. Normalize the names as you did with the ADH data. Match OSHA to ADH complaints.

Weekly memos due Saturday, 11:59 p.m.


Wednesday March 24: 20th Class

Hybrid class, Kimpel 145

Online, asynchronous class Monday, March 29
Online class Wednesday March 31

Graphics checklist
https://docs.google.com/document/d/12XgNedUBjcgiTNJmJj_pxyvVwA4zhkx88jprJQhkCGc/edit#

Workshop

Timeline of COVID-19 in Arkansas
https://docs.google.com/spreadsheets/d/14FjQhCJiIv8_GU-dTgs8mubFnVkBEGE18T2moHUB4Eo/edit#gid=0

Progress Report
https://wordpressua.uark.edu/datareporting/files/2021/03/arkcovid_tweets_sept_march2021.csv
--Need New column to designate Spanish tweets

Examine county data and trends.

County vaccine data: Changes, current vs past
Current, March 22:
https://raw.githubusercontent.com/Arkansascovid/Main/master/vaccinecounty.csv

March 16 data:
https://wordpressua.uark.edu/datareporting/files/2021/03/vaccinecounty_March16.csv


--7 Day Averages
https://github.com/Arkansascovid/Main/blob/master/master_file.csv?raw=true

--Table with 7 day averages
https://github.com/profrobwells/Spring2021Data/blob/main/county_averages.csv?raw=true

--Latest week 7 day averages
https://raw.githubusercontent.com/profrobwells/Spring2021Data/main/county_latest.csv

--State average for deaths, cases. 
--Since Feb 1: Which of your counties are above/below the state averages?
--Make a map in Datawrapper just for your counties

R session: Ravi, Haley, Robert, Rachel
Pull down this script, run it and list 5 questions you have about what is going on.
https://raw.githubusercontent.com/profrobwells/CovidFall2020/master/Daily%20Update.Rmd

M -  Ravix
T -  Carolinex
Hutchinson press conf: Grahamx
W - Emma/ Robertx
TH - Graysonx
F - Rachellx
S - ?
S - ?


One Year Anniversary Covid Graphics.
Grayson: Nursing homes. My "highest deaths in Arkansas nursing homes" graphic. 
Graham: Flourish to represent the counties that had the worst amount of new cases during the three worst months. 

Beats - Regions
Metro Little Rock/Conway/ Hot Springs - Graham & Ravi 
Pine Bluff to the southeast - Lake Village - Caroline (Graham may assist)
Mena to Texarkana to El Dorado - Grayson
Fort Smith/Arkansas River Valley - Emma
Jonesboro, Forrest City, Helena - Haley, Robert 

Local stories: Context!
--Statewide vaccination averages
--Paint a picture of the county. Population. Employer. Landmarks
--Pick up the phone and speak to someone.
--Let's get some stuff in these stories and make them interesting.
--Find out what is happening on the ground. Call a local pharmacist. Call the county health department. Are you getting the doses you were promised?
--Stories in the business community. Call the local Chamber of Commerce. How is business doing with the pandemic? Who is reopening and who is not. Why?

OSHA Team
Mary, Abby, Rachell 

Track 1: 

Weekly memos due Saturday, 11:59 p.m.
Jour 405v memo:

One story from your local communities with a graphic.
--Call and speak to at least two people.
--Provide context


Readings:

Grayson: Bonus Assignment


Jour 5003- OSHA Project

Interviews. 

R script
https://github.com/profrobwells/Spring2021Data/blob/main/Occupation%20Data%20Hennigan_Wells.rmd
--Import the OSHA complaints into R. Normalize the names as you did with the ADH data. Match OSHA to ADH complaints.

Weekly memos due Saturday, 11:59 p.m.


Wednesday March 31: 22nd Class

Online class Wednesday March 31

--Wednesday, April 7. Kathy Roberts Forde, 6 pm Roy Reed Speaker. http://bit.do/royreed

--Update on summer plans

--Accessibility Discussion
https://docs.google.com/document/d/12XgNedUBjcgiTNJmJj_pxyvVwA4zhkx88jprJQhkCGc/edit#

--Story and WordPress post

--Weekend memo 

Workshop: Embed charts in WordPress
https://wordpressua.uark.edu/datareporting/wordpress/

--Create a chart in Flourish, see below. 
--Embed chart in a WordPress post. Embed an image and some text.
--Follow this process with your post with your weekend memo.

Examine county data and trends: 

--Table with 7 day averages
https://github.com/profrobwells/Spring2021Data/blob/main/county_averages.csv?raw=true

--Latest week 7 day averages
https://raw.githubusercontent.com/profrobwells/Spring2021Data/main/county_latest.csv

--State average for deaths, cases. 
--Since Feb 1: Which of your counties are above/below the state averages?
--Make a map in Datawrapper just for your counties

County vaccine data: Changes, current vs past

March 26
https://github.com/Arkansascovid/Main/blob/master/vaccinecounty.csv

March 16 data:
https://wordpressua.uark.edu/datareporting/files/2021/03/vaccinecounty_March16.csv


R session: Ravi, Haley, Robert, Rachel
Pull down this script, run it and list 5 questions you have about what is going on.
https://raw.githubusercontent.com/profrobwells/CovidFall2020/master/Daily%20Update.Rmd

M -  Ravi
T -  Caroline
Hutchinson press conf: Graham
W - Robert
TH - Grayson
F - 
S - ?
S - ?

OSHA Team
Mary, Abby, Rachell 
--Weekend memo: First 4 grafs of the story. Describe the most compelling lead anecdote so far
--The most compelling data
--Draft Tyson questions

Weekly memos due Saturday, 11:59 p.m.

Everyone for the weekend: Two questions for Dr. Kathy Roberts Forde, Roy Reed Speaker. http://bit.do/royreed

An editor and his newspaper helped build white supremacy in Georgia
https://theconversation.com/an-editor-and-his-newspaper-helped-build-white-supremacy-in-georgia-111030
  
Blog: Letter from a Region
https://kathyrobertsforde.substack.com/

Bio:
https://www.umass.edu/journalism/facultyStaff/bio/forde
https://theconversation.com/profiles/kathy-roberts-forde-334183

Monday, April 5: 23rd Class

--What to expect for the rest of the semester

10 am - Guest Speaker, Allison Herrerra, KOSU

--Wednesday, April 7. Kathy Roberts Forde, 6 pm Roy Reed Speaker. http://bit.do/royreed

--Story and WordPress post
--Emma story on Rogers
--The power of html and transferring between WordPress sites: Woodruff County
--Vaccine Data: Haley. On March 22, ADH began reporting the data as partially vs fully vaccinated. Prior to that, it was one dose vs two doses. I made the change in the charts and map but we haven't done the time series like this. So I would want to check with ADH about the consistency of these measures. They may be consistent but I am not sure. 



Examine county data and trends: 

--Table with 7 day averages
https://github.com/profrobwells/Spring2021Data/blob/main/county_averages.csv?raw=true

--Part 1: Filter the county_averages.csv for the latest week. 

--State average for deaths, cases. 
--Since Feb 1: Which of your counties are above/below the state averages?
--Make a map in Datawrapper just for your counties

County vaccine data: Changes, current vs past

March 31
https://github.com/Arkansascovid/Main/blob/master/vaccinecounty.csv

March 16 data:
https://wordpressua.uark.edu/datareporting/files/2021/03/vaccinecounty_March16.csv


R session: Ravi, Haley, Robert, Rachel
Pull down this script, run it and list 5 questions you have about what is going on.
https://raw.githubusercontent.com/profrobwells/CovidFall2020/master/Daily%20Update.Rmd

M -  Ravi
T -  Caroline
Hutchinson press conf: Graham
W - Robert
TH - Grayson
F - 
S - ?
S - ?

OSHA Team
Mary, Abby, Rachell 
--Weekend memo: Draft story. 
--Prepare data to share with UAMS, Facing South

Weekly memos due Saturday, 11:59 p.m.
Monday, April 12: 25th Class

--Katy Seiter, Mary Hennigan, Abby Zimmardi win Society of Professional Journalists Region 12 award for Data Visualization. Hennigan a finalist, Newspaper, Magazine, Online coverage large.


--Spanish language forum on vaccines


--Story and WordPress post

--Fact Check worker safety data.
Please do not copy or share this data. We are still working on it. It is exclusive to Arkansascovid
https://raw.githubusercontent.com/profrobwells/Spring2021Data/main/cleaned_master.csv


Data Interviewing / Interrogating / Grilling / Badgering

1) Count frequency of company cases by month
2) Count frequency of cases by county by month
3) Sort the companies alphabetically - check for misspellings
4) Sort counties alphabetically - check for misspellings, omissions
5) Check a sample period against the original data. 

Use R 
https://raw.githubusercontent.com/profrobwells/Spring2021Data/main/Occupational%20analysis%20Ap%2012%202021.Rmd

Robert
Ravi
Mary
Rachel
Abby
Haley

Use Tableau / Excel 
Emma
Caroline
Graham
Grayson




M -  Ravi
T -  Caroline
Hutchinson press conf: Graham
W - Rachell
TH - Grayson
F - Robert
S - ?
S - ?


END OF PAST CLASS LISTINGS



Overview of Skills Modules

Module #1: Basic Data – Math
--Basics of Data Analysis
--AP Stylebook Entry on Data Journalism
-- Numbers in the Newsroom
--Rates and Ratios
--Excel Exercise: Transit Data and Calculating a Rate
--Relative Risk
--Excel Exercises
Click here for Module #1:
https://wordpressua.uark.edu/datareporting/basic-excel-introduction-to-data/
Module #2 Data Management

 --Best practices in data management
 --Organizational tips for files
 --Data documentation skills 

Click here for Module #2: https://wordpressua.uark.edu/datareporting/organize-your-data/
Module #3: Tableau
 This module addresses:
--Downloading instructions for Tableau
--Getting started tutorial with video
--Building a basic COVID data chart with video and transcript
--Using filters and calculations with video and transcript
--Tutorial on Tableau calculations with video
--Proper formatting of a filter bar in Tableau, video
Links to additional Tableau Tutorials
 Dashboards and Embedding Tableau Public in WordPress
 Maps in Tableau - NEEDS UPDATING FOR SPRING 2021 

https://wordpressua.uark.edu/datareporting/category/tableau/
Module #4: Data Visualization


https://wordpressua.uark.edu/datareporting/data-visualization/
Module #5: Flourish


TBA
Module #6: Writing Well

https://wordpressua.uark.edu/datareporting/writing-well/
Module #7: WordPress

https://wordpressua.uark.edu/datareporting/wordpress/
Module #8: Module #8: Census Data Download And Cleaning

https://wordpressua.uark.edu/datareporting/census-data-download-and-cleaning/
Module #9: Datawrapper

tba

Readings

Readings For Jour 405v:
1) Numbers in the Newsroom, first half of book. Write 2 paragraphs on lessons learned in weekly memo. Include two examples
2) Numbers in the Newsroom, second half of book. Write 2 paragraphs on lessons learned in weekly memo. Include two examples
3) WSJ Guide to Graphics, first half of book. Write 2 paragraphs on lessons learned in weekly memo. Include graphic example. 
4) WSJ Guide to Graphics, second half of book. Write 2 paragraphs on lessons learned in weekly memo. Include graphic example.
5) Read Overview from Paul Bradshaw on basic data journalism. 
https://github.com/paulbradshaw/MED7373-Data-Journalism/blob/master/1basics/dj3chords.md
6) Meyer, “New Precision Journalism,” Ch. 1-2
7) Google search terms:https://ahrefs.com/blog/google-advanced-search-operators/
8) Suspect Correlations: https://www.datasciencecentral.com/profiles/blogs/tutorial-how-to-detect-spurious-correlations-and-how-to-find-the-
9) Beware of the Infographic
https://www.cjr.org/the_media_today/alberto-cairo-infographics.php
10) BuzzFeed spy planes
Peter Aldhous adds an example of his from BuzzFeed: BuzzFeed News Trained A Computer To Search For Hidden Spy Planes. This Is What We Found. Again there’s a GitHub page explaining the methods employed, and a GitHub repo with the data and an R Markdown file.
The project includes examples of abstraction (in this case, filtering) and algorithms (in this case the random forest algorithm).
10) Jon Schleuss
Bio LinkedIn 
EXAMPLES-his projects involving data and visualizing it (both hard news and light)
Affordable Housing
Election project
Unclaimed Dead
11) Reading: Washington Post covering elections
How to cover 11,250 elections at once: Here’s how The Washington Post’s new computational journalism lab will tackle 2020
12) Media Future. Read and post for class discussion: Future Today Institute report on media trends   ------------------------- Reading: Confirmation Bias https://www.datasciencecentral.com/profiles/blogs/the-deadly-data-science-sin-of-confirmation-bias Overview from Paul Bradshaw on basic data journalism. Three chords https://github.com/paulbradshaw/MED7373-Data-Journalism/blob/master/1basics/dj3chords.md Weekly Reading 1 GRAD: Aucoin, James L. The Evolution of American Investigative Journalism,. University of Missouri Press, 2005. ProQuest Ebook Central, https://0-ebookcentral-proquest-com.library.uark.edu/lib/uark/detail.action?docID=3440699.  p 26-40 Beginners Guide to Microsoft Teams https://www.chorus.co/resources/news/microsoft-teams-a-beginners-guide-to-teams-in-office-365 22 tools and apps every journalism student should know about https://www.journalism.co.uk/news/22-tools-and-apps-every-journalism-student-should-know-about/s2/a550112/ White House Report https://www.documentcloud.org/documents/7204533-Arkansas-9-6-20.html https://publicintegrity.org/health/coronavirus-and-inequality/white-house-coronavirus-red-zone-reports-covid/ 2 Best Practices with Twitter https://media.twitter.com/en_us/articles/best-practice/2020/twitter-for-journalists-ten-protips-for-using-twitter.html How To: Use Twitter to Your Advantage as a Journalist https://www.newsmediaalliance.org/how-to-twitter-for-journalists/ Best practices for journalists to effectively use Twitter amid crises https://blog.twitter.com/en_in/topics/company/2020/best-practices-for-Journalist-to-effectively-use-twitter-amid-crises.html How journalists can best engage with their audience https://media.twitter.com/en_us/articles/best-practice/2018/how-journalists-can-best-engage-with-their-audience.html @sree and learning social media tips https://twitter.com/search?q=%23LearnSocMedia%20%40sree&src=typd 3 CMS Nursing Home Data https://data.cms.gov/Special-Programs-Initiatives-COVID-19-Nursing-Home/COVID-19-Nursing-Home-Dataset/s2uc-8wxp 4 Reading: Corona Virus and job losses https://projects.propublica.org/coronavirus-unemployment/ 5 Add to reading https://medium.economist.com/a-year-in-graphic-detail-d1825b28e06f 6 Wash Post  https://www.poynter.org/reporting-editing/2020/how-a-blockbuster-washington-post-story-made-social-distancing-easy-to-understand/?utm_source=Pew+Research+Center&utm_campaign=27f3667465-EMAIL_CAMPAIGN_2020_03_18_01_41&utm_medium=email&utm_term=0_3e953b9b70-27f3667465-399357317 7 Data in Situ https://medium.com/hcil-at-umd/data-in-situ-bringing-data-into-your-world-where-you-need-it-ed8528cb135f 8 Data Visualizations to Replace Stats? https://medium.com/hcil-at-umd/for-whom-the-bell-tolls-1e7d3e731999 9 * Read: An app that uses machine learning to guess if a Twitter account is a bot   https://www.r-bloggers.com/botrnot-an-r-app-to-detect-twitter-bots/    https://mikewk.shinyapps.io/botornot/     * Read: Article about Botometer   https://www.vox.com/technology/2018/4/9/17214720/pew-study-bots-generate-two-thirds-of-twitter-links    * Read:  Stanford research paper on this topic    https://pdfs.semanticscholar.org/e219/6b47133c2191d380098744c13ba77133e625.pdf    10 Read: What is code? http://www.bloomberg.com/graphics/2015-paul-ford-what-is-code/ Read: String data manipulation https://dereksonderegger.github.io/570L/13-string-manipulation.html Read: StoryBench, Northeastern Univ. https://twitter.com/storybench 11 * Read:  Amy Webb future of journalism trends    https://futuretodayinstitute.wetransfer.com/downloads/0e84e883e140bafe9a3436a6464032be20171003123607/ecda17 * Read: Google search tips  https://blog.expertisefinder.com/top-6-google-search-tips-for-journalists/ * Read: Artificial intelligence in the news      https://aiethicsinitiative.org/news/2019/3/12/artificial-intelligence-and-the-news-seven-ideas-receive-funding-to-ensure-ai-is-used-in-the-public-interest 12 13 14 5 Books for Data Engineers https://towardsdatascience.com/5-books-for-data-engineers-f174bc1e7906 15 UAMS Covid Projection https://publichealth.uams.edu/wp-content/uploads/sites/3/2020/12/COPH-COVID-Report-Dec-18-2020.pdf NYC comptroller calls on SEC to investigate Tyson Foods https://www.fooddive.com/news/nyc-comptroller-calls-on-sec-to-investigate-tyson-foods/592317/ Facing South: Georges-poultry-workers-walk-out-Arkansas-protest-covid-19-conditions​​​​​​​ https://www.facingsouth.org/2020/12/georges-poultry-workers-walk-out-arkansas-protest-covid-19-conditions Howard Center Collaboration https://www.bu.edu/articles/2020/com-journalism-class-reporting-on-homelessness-grabs-national-attention/ Readings For Jour 5283: 1) Meyer, “New Precision Journalism,” Ch. 1-2 2) Summarize key points in Data Journalism Handbook readings, Ch 1-3. Four paragraphs max. 2) Read Data Journalism Handbook, Ch 1-3: https://datajournalism.com/read/handbook/two After reading this material, please write three paragraphs examining the Broken Homes project produced by Al Jazerra:  Megan O’Toole et al., ‘Broken Homes: A Record Year of Home Demolitions in Occupied East Jerusalem ’, Al Jazeera, 2017. See Blackboard discussion for instructions. 3) Read Overview from Paul Bradshaw on basic data journalism.  https://github.com/paulbradshaw/MED7373-Data-Journalism/blob/master/1basics/dj3chords.md 4) 5) Google search terms:https://ahrefs.com/blog/google-advanced-search-operators/ 6) Suspect Correlations: https://www.datasciencecentral.com/profiles/blogs/tutorial-how-to-detect-spurious-correlations-and-how-to-find-the- 7) Hadley Wickham Interview: https://www.propublica.org/nerds/hadley-wickham-your-default-position-should-be-skepticism-and-other-advice-for-data-journalists 8) Beware of the Infographic https://www.cjr.org/the_media_today/alberto-cairo-infographics.php 9) BuzzFeed spy planes Peter Aldhous adds an example of his from BuzzFeed: BuzzFeed News Trained A Computer To Search For Hidden Spy Planes. This Is What We Found. Again there’s a GitHub page explaining the methods employed, and a GitHub repo with the data and an R Markdown file. The project includes examples of abstraction (in this case, filtering) and algorithms (in this case the random forest algorithm). 10) Jon Schleuss Bio LinkedIn  EXAMPLES-his projects involving data and visualizing it (both hard news and light) Affordable Housing Election project Unclaimed Dead 11) Reading: Washington Post covering elections
How to cover 11,250 elections at once: Here’s how The Washington Post’s new computational journalism lab will tackle 2020
12) Media Future. Read and post for class discussion: Future Today Institute report on media trends  

Websites

Websites
Hutchison's Daily YouTube Press Conference 
https://www.youtube.com/channel/UCLJcNdgp2PMEmiqJEoYzqwQ 
 
 
ADH Covid Data Dashboard  
https://experience.arcgis.com/experience/c2ef4a4fcbe5458fbf2e48a21e4fece9 
 
UofA Pat Walker Dashboard 
https://health.uark.edu/coronavirus/covid-dashboard.php 
 
 
ADH Daily Summary - 1:30 pm 
https://www.healthy.arkansas.gov/programs-services/topics/novel-coronavirus#Covidnumbers 
Tableau Online 
https://prod-useast-a.online.tableau.com/#/site/datareportinguofa/home 
 
Arkansascovid 
https://arkansascovid.com/ 
 
 
 
 
Raw Feed API from ADH- Austin's spreadsheet 
https://docs.google.com/spreadsheets/d/16mdoWm0k3JUllm3InhoD_Jiq0lbArO_UGum8NMp9USU/edit#gid=0 
Daily Form to Update State Data 
https://docs.google.com/forms/d/e/1FAIpQLSfV-Radxbjy9UsFZvCqtY3XKvlmky2lvOM4-pow8QZ4oEX_jg/viewform 
New Story Pitch Form:  
https://docs.google.com/forms/d/e/1FAIpQLScws1-wOhgQ7DV4MhGNoX8QbJFdX6LH91oY6NBv76GtRzTBTA/viewform 
Class Daily Schedule 
https://profrobwells.github.io/CovidFall2020/Schedule_Fall2020_Jour5283_Data.html 
 
ADH Data Dashboard        https://experience.arcgis.com/experience/c2ef4a4fcbe5458fbf2e48a21e4fece9 
Fact Check Protocol https://docs.google.com/document/d/1ni0pLjAmr2XhEUgIV6XWhUiaQhsK7FXHDwa76hjFxlM/edit 

Class Logistics

Join Zoom Meeting
https://uark.zoom.us/j/81760060028?pwd=MVRsWGNUcjEyNVJmREhTY2swSjFtUT09

Meeting ID: 817 6006 0028
Passcode: C6N*Uhq?

WHAT YOU HAVE LEARNED: 
End of Semester Review
You can put this on your resume and in your job cover letters. You have learned:
–Basic data analysis. Continuous vs discreet variables. Managing versions of complex government datasets. Understanding data dictionaries. 
–Excel, file types, cleaning, intermediate functions such as pivot tables and =vlookup
–Tableau. Static graphics. Interactive graphics. Calculated fields. Grouping. Workbooks. Story books. Exporting multiple file types to web. Using source code for blogs
–Data visualization. Best practices in design, labeling and data presentation.
–R. Introduction to R. Importing data. Joining datasets. Creating basic visualization. Basic calculations. Exporting calculations to Excel, WordPress
–WordPress. Managing posts, projects. Building interactive graphics using embed code. Creating multimedia presentations using text, data and graphics. Divi builder
–In sum, you have learned the basic workflow in a modern digital newsroom.

Module #5: Flourish

Flourish

Videos to Get Started:

Alberto Cairo and Flourish - Overview
https://www.youtube.com/watch?v=cN1Q9MusZbc

Overview
https://www.youtube.com/watch?v=fKO_jjqgooc&feature=emb_title

Ravi Brock and Flourish in 9 mins
https://video.uark.edu/media/Flourish+tutorial+with+Ravi+Brock/1_g6nzw3h0

Cairo - Flourish - Stories
https://www.youtube.com/watch?v=P7AmUdSBOVU

Alberto Cairo, Flourish Tutorials, Parts 1-6
https://www.youtube.com/user/albertocairo1706/videos

Beginning Documents

Basic Tips:
--It's all about the templates. Select the one that best matches your idea
--Do your math, sorting, formatting in Excel before uploading to Flourish. Easier
--There are hidden menus and functions in the data section. A bit frustrating but you will figure it out.


Intro
https://help.flourish.studio/article/9-creating-a-visualization

Stories in Flourish
https://www.youtube.com/watch?v=9HTZUXNOLVQ&feature=emb_rel_end


Importing Data
https://www.youtube.com/watch?v=Rscfi7QZVvs&feature=emb_rel_end https://help.flourish.studio/article/12-adding-data-to-a-template

Flourish Design Tips
 --Labels: be judicious with text labels. 

--Annotations. 
Within Flourish story: Once you're finished creating your visualization, click on the "Create story" button in the top right corner. This will take you through to a new Flourish story with your visualization as the first slide. 
https://help.flourish.studio/article/89-how-to-create-a-single-slide-story-in-flourish

too many numbers on the labels, so think of using annotations to fix that issue.
https://help.flourish.studio/article/180-how-to-add-annotations-to-your-visualization#:~:text=Inside%20the%20story%20editor%2C%20you,an%20annotation%20will%20be%20added.

--Colors: 
https://help.flourish.studio/article/91-how-to-customize-colors#:~:text=The%20main%20color%20tool%20in,delete%20and%20add%20new%20colors.


 --Sorting: have the chart tell a story - sorting.
 --X axis labels. rotate the x axis labels, drop the font a bit and get more of the counties represented. bump up the fonts on the x axis. rather faint.
 --Delete rows "missing county info"
 --Labels: "become the boss of this data." we take control of these ridiculous labels. what is "administrative support and waste management and remediation services" - what does that mean? 
 --Style: your credit at the bottom in the footer
Work with this version: https://app.flourish.studio/story/775979/edit
More Resources

Bar chart race template
https://towardsdatascience.com/step-by-step-tutorial-create-a-bar-chart-race-animation-da7d5fcd7079
https://help.flourish.studio/article/63-how-to-change-label-positioning

Misc
Google sheets https://help.flourish.studio/article/165-how-to-pull-through-data-from-a-google-sheet
Basic Help page
https://help.flourish.studio/

Content to popups
https://help.flourish.studio/article/69-how-to-add-custom-content-to-your-popups


Overview
https://flourish.studio/2019/12/19/2019-year-in-review/
Spanish https://flourish.studio/2019/10/23/informar-elecciones-con-flourish/
Different accounts https://help.flourish.studio/article/16-controling-access-to-visualizations-and-stories
Sorting data https://help.flourish.studio/article/36-how-to-display-your-data-in-a-different-order
Adam Marton Cheat Sheet
Flourish.studio

Examples:
https://flourish.studio/examples/ 

*** Graphic stories and animated stories
See the slider at the top of this page for examples of graphic stories and animation
Bar chart race
Animated dot animation
Animated charts
Story maps
Animated maps


Templates from Flourish Team: (more examples)
https://app.flourish.studio/@flourish 

Interesting examples:
Time map - map with time slider
Twitter timelines - good for events
Election results chart
Icon map
Photo slider
Sankey - 2
Table
Parliament “C” chart - useful for showing votes on an issue, more
Sports - player positions on a field
Chord diagram- visualize connections between entities
Survey / Dot viz (good for exploring survey results and more)
Arc map - display connections between points on a map
Cards - 2 - blocks in a grid (candidates, much more)
Quiz
Bar race / Line race
Point map - 2 - visualize large data sets on a map, animate around it
Animated scatterplot
Elections | Elections 2
Background: Flourish newsrooms plan

Private projects, HTML export and much more!

Get started here

In case your account has administrative privileges for your newsroom, you will be able to invite more users to your newsroom. You can find more information on how to do that and how to administer your newsroom here.

Our extensive help docs are carefully crafted to help you overcome the occasional issue you may run into, and also show you how to create cool things.

You can find them here.

Keep track of how Flourish is constantly improving and new features are being added through our new changelog.

If you want to see what we did – and what users like you made – in 2019, take a look at our Year in Review blog post!

As an extra, for our Spanish-speaking users, we've also recently published our popular elections blog post – in Spanish! Check it out here!
Flourish - Stories
https://www.youtube.com/watch?v=P7AmUdSBOVU


Intro
https://help.flourish.studio/article/9-creating-a-visualization


How to Create a Flourish Chart
https://www.youtube.com/watch?v=fKO_jjqgooc&feature=emb_title


Bar chart race template
https://towardsdatascience.com/step-by-step-tutorial-create-a-bar-chart-race-animation-da7d5fcd7079


https://help.flourish.studio/article/63-how-to-change-label-positioning


Survey template- break out to different groups, histogram or a map


Tables with sparklines


Mobile settings
Part 5 Scatter plot and animation
https://www.youtube.com/watch?v=XehZFhNt8mw


Part 6:
https://www.youtube.com/user/albertocairo1706/videos
Examples from Fall Class
Flourish So Far
Abby:
https://public.flourish.studio/visualisation/3936735/
https://public.flourish.studio/visualisation/3941284/

Kendal:
https://app.flourish.studio/visualisation/3923703/
Part 3 Basic world Map
https://www.youtube.com/watch?v=AfoGkoqmvqY


Create an Active and New Cases Map: 
https://app.flourish.studio/visualisation/3967148/edit 
Click data. 
On the Regions layer, upload “arkansascounties.json” which is found in Teams files or on Github: https://raw.githubusercontent.com/Arkansascovid/Main/master/arkansascounties.json 

Click the arrow button next to “Upload data” and select “Upload data and merge”, then upload countyonlytoday.csv and merge on “NAME” and “County_Name”, 76 rows should be imported 
Geometry should be column A. Name should be column G. Select Active_cases, Active_cases_10k_pop, Confirmed_active, Probable_active, New_cases_today, New_cases_today_10k_pop, Pct_pos_new_to_dashboard (columns U,AV,AE-AF,AO,AU,AX) for the values. 
Make sure no counties are missing/greyed out on map 
In top right corner, select Export & Publish 
Flourish Links
https://app.flourish.studio/projects
https://www.youtube.com/watch?v=9HTZUXNOLVQ&feature=emb_rel_end
https://help.flourish.studio/article/16-controling-access-to-visualizations-and-stories
https://help.flourish.studio/
https://flourish.studio/whats-new/
https://flourish.studio/2019/12/19/2019-year-in-review/
https://flourish.studio/2019/10/23/informar-elecciones-con-flourish/
https://help.flourish.studio/article/16-controling-access-to-visualizations-and-stories
https://help.flourish.studio/category/42-line-bar-and-pie-charts/2?sort=updatedAt
https://help.flourish.studio/article/107-how-to-create-a-scatter-plot-with-a-filter
https://help.flourish.studio/category/10-flourish-basics
https://app.flourish.studio/visualisation/4080552/edit
https://public.flourish.studio/visualisation/4080552/

Module #4: Data Visualization

Principles of Data Visualization

“Our limited brains are incapable of grasping reality in all its glorious complexity.”
What you design is never exactly what your audience ends up interpreting so reducing the chances for misinterpretation becomes crucial.

Cleveland McGill Scale

Cleveland McGill Scale for Data Visualization



Important Resources for Surveying the Data Visualization Options

Dataviz Catalog http://www.datavizcatalogue.com/
FT Visual Vocabulary https://github.com/ft-interactive/chart-doctor/blob/master/visual-vocabulary/Visual-vocabulary.pdf

For the weekly memo: Select two examples from the Dataviz Catalog and FT Visual Vocabulary that you find interesting or useful. Include a screenshot of the chart in your memo and describe how it could apply for our project.


Graphics Comments from Jon Schleuss, Los Angeles Times

And the colors. What does “red” mean when it’s used? And what about using too many colors. At the Times we really only have two or three colors: basic default, a highlight color and a negative color. We break from convention, but keeping it simple helps. I figure now I’ll show them how I approach chart building from start to finish.

Also, I see a desire to combine different data into the same chart. So there’s a left, bottom and right axis. But that’s a bit confusing to the reader, especially when things have the same values (percentages vs. percentages instead of percentages vs. hard counts).

I think my big takeaways are that most of these charts should be flipped on their sides. That’s because when we sort data largest to smallest (nearly everyone did) we then think of it as time passing if it’s a column chart (bars situated left to right). And that there’s a downward marching trend. Best to flip a lot of these on their side.

Build choropleth maps


A Comment on Color Choices

A reader made an excellent point that the red shading of the active cases map was misleading since ‘red zone’ is a specific concept in the White House task force reports.
Our shading does not match the red zone definition of the task force report and most readers would expect that it would.
I swapped out the shading for blue-green until we figure out the calculations for active cases per capita on that White House task force scale.
It just goes to show you how color choices on graphics are major communication issues.

Reader Comment: @BruceWard2
Have you considered using a standard for which counties are red?  The map gives a false impression that Arkansas counties are not “red zones” for CoVID when they are. Replying to @BruceWard2 and @KatySeiter


Build a Cover Image Using Canva or InDesign or Powerpoint

https://www.canva.com/  

Rachell Sanchez-Smith used Canva for a simple animation.



Higher Resolution Graphics in Tableau
https://www.dataplusscience.com/HighResolution.html
Higher Resolution Photos: at least 72 DPI. Practically, should be higher.
–500k or more is a safe bet
–Cropping reduces file size.
Grainy Guidance: https://cft.vanderbilt.edu/wp-content/uploads/sites/59/Image_resolutions.pdf
Higher Resolution Graphics in Tableau https://www.dataplusscience.com/HighResolution.html  
 


Maps in Tableau

Mapping in Tableau

Please review this mapping tutorial
basic-mapping-transcript
Sample Workbook
Videos: https://www.tableau.com/learn/tutorials/on-demand/getting-started-mapping?playlist=230855



Build a Map COVID-19 Positivity in Arkansas Counties

Data: County data for one day.

–Import the countyonlytoday.csv data as text into Tableau
–Check the geographic role of county is assigned to county.
–Go to Sheet 1:
a) drag Longitude to columns
b) Latitude to rows
c) County Name to the pane
–A map of Arkansas appears.
d) In top Menu: MAP | Edit Locations | State / Province | Fixed – Select the great state of Arkansas
–The map now has all counties represented as dots
e) In Marks card: Change Automatic to Map
f) drag Positive to the pane – you now have a map of positive rates by county.
Video below with all of these steps:


Dual MappingBubble Maps




Tutorial
https://onlinehelp.tableau.com/current/pro/desktop/en-us/maps_dualaxis.html


Using countyonlytoday.csv

New sheet, begin map: Drag counties to map
Fix the missing counties: Map | Edit Locations | Fixed | Arkansas
Marks Card | Map
Drag Deaths map

Here’s where it is tricky:


Click on Longitude pill in Columns. Press Command key. Drag to Right. Release mouse
–Creates two Longitude pills and two maps
–Marks Card Now Has Controls for Two Maps

Marks Card Has Two Maps. 
Lower Map, Drag off color pill. Marks Card, switch to Circle.
Drag Deaths to Size. Enlarge the Circles
Drag Deaths to Labels.


In Columns, Select Down Arrow on Longitude | Dual Axis
–Maps are combined 

Drag County to Marks Card | Tooltip

Edit Tooltips so data displays properly


Excel Bootcamp

Review four corners:
1. Make a copy
2. Freeze Panes
3. Four corners test
4. Check the math
Excel and the Black cross copy function
5. Sorting
6. Percentage Change:
(New Number-Old Number)/Old Number *100
NICAR coursepack

How to Filter in Excel

Basics and Sorting in Excel

Excel formulas

Practice Rates and Ratios  using this test data: Transit

Basic Data Types: Importing Data into Excel

NICAR Coursepack: Basics and Sorting in Excel 
 
 Open sample dataset: citybudget.xls
 
 1. Make a copy
 
 2. Four corners test
 
 3. Check the math
 
 4. Sorting
 
 5. Percentage Change
 
 Formula: (New number-Old Number)/Old Number * 100 and use % symbol
 
 Background and Help:
 
 Tutorial Video
 
 Lynda.com tutorial videos on Excel.
 
 More on Lynda.com  

Excel: NICAR pack—Cohen reading: Think in ratios – construct a ratio on the student loan beat. Memorize common numbers on the beat———

  
More Basic Excel Tricks

How to freeze panes in Excel

PIVOT TABLES

Basic introduction to pivot tables

Calculations and Pivot Tables

 


COUNTIF Function for Tabulating Text

Spring 2021 Tech Notes

Teams:

Screen Sharing:
Check system settings: System Preferences > Security & Privacy and allow Screen Recording by Microsoft Teams

Also, the latest version of the Mac OSX 11.1, Big Sur, can cause some issues with Teams.

Zoom Meeting
Rob Wells is inviting you to a scheduled Zoom meeting.
Join Zoom Meeting
https://uark.zoom.us/j/81760060028?pwd=MVRsWGNUcjEyNVJmREhTY2swSjFtUT09

Topic: Jour 405v/5003 Spring 2021 Class
Time: Jan 11, 2021 09:30 AM Central Time (US and Canada)
        Every week on Mon, Wed, until Apr 28, 2021, 32 occurrence(s)
        Please download and import the following iCalendar (.ics) files to your calendar system.
Weekly: https://uark.zoom.us/meeting/tZUqcemoqDsqGNy9BsfqtbdEz81Qxg1PqYdu/ics?icsToken=98tyKuGpqT0qGtKVsBuPRpwcB4_oc_TwpmJfjY1ExT32BTFHYAfTLLoTA6p4QejB

Join Zoom Meeting
https://uark.zoom.us/j/81760060028?pwd=MVRsWGNUcjEyNVJmREhTY2swSjFtUT09

Meeting ID: 817 6006 0028
Passcode: C6N*Uhq?
One tap mobile
+13126266799,,81760060028#,,,,*47463978# US (Chicago)
+19292056099,,81760060028#,,,,*47463978# US (New York)

Dial by your location
        +1 312 626 6799 US (Chicago)
        +1 929 205 6099 US (New York)
        +1 301 715 8592 US (Washington D.C)
        +1 346 248 7799 US (Houston)
        +1 669 900 6833 US (San Jose)
        +1 253 215 8782 US (Tacoma)
Meeting ID: 817 6006 0028
Passcode: 47463978
Find your local number: https://uark.zoom.us/u/kcbVNf8FH

Join by SIP
81760060028@zoomcrc.com

Join by H.323
162.255.37.11 (US West)
162.255.36.11 (US East)

Meeting ID: 817 6006 0028
Passcode: 47463978