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
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.Congrats to our partners at UO, BU, UArk, Stanford, UFla and ASU! And thanks @BrentWalth @rwells1961 @maggiemulvihill @cephillips @TheMoniBasu!! https://t.co/IMb09hueJ1
— Kathy Best (@kbest) April 7, 2021
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 ReleasesUofA Rules of Conducthttps://docs.google.com/document/d/1YkdkRIzIs1WQ3P9KIICvHcppfWvwTyo2bRhGwQPsgVE/editLicense Agreementhttps://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 postArkansascovid Test of Github and Flourish3) 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, CarolineModule #10: R and R Studio – The Basics1) 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 electionsHow to cover 11,250 elections at once: Here’s how The Washington Post’s new computational journalism lab will tackle 202012) 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 electionsHow to cover 11,250 elections at once: Here’s how The Washington Post’s new computational journalism lab will tackle 202012) 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.
