Data Journalism Backup Site

Here is my optional tagline

Aug. 20, Day #1

by | Aug 19, 2018 | Fall2018_class

 

Class Agenda

Syllabus / Schedule

Email to students.

Basics of data analysis.

Intro Excel
Refresher Excel exercise

Previous Class Projects:

Spring 2018: Low-Wage Workers

https://wordpressua.uark.edu/workingandpoor/

http://arkansaspublicmedia.org/post/chuck-e-cheeses-ez-mart-low-wage-workers-are-profile-frailty-hope-0

Andrew Epperson, center, and Katie Serrano discuss their reporting and data analysis on low-wage workers with KUAF News Director Kyle Kellams. The students’ work was broadcast on KUAF in Fayetteville and KUAR in Little Rock and their multimedia work was published on the websites of KUAF, KUAR as well as KASU Jonesboro and KBSA El Dorado.

 

Fall 2017: Veterans Administration Health Care

https://www.linkedin.com/pulse/student-journalists-examine-va-health-rob-wells/?published=t

Fall 2016: Racial Disparities in Mortgage Lending

http://arkansaspublicmedia.org/post/housing-loans-difficult-most-northwest-arkansas-minorities

News coverage of project:

http://arkansaspublicmedia.org/post/ua-database-journalism-digs-home-mortgages-race-discoversits-complicated

Segment on KUAF “Ozarks at Large”:

http://news.uark.edu/articles/37691/lemke-journalism-students-investigate-mortgage-lending-disparities-in-northwest-arkansas

Basics of Data Analysis

Transparency
Reliability: How sure are we that we got the right answer? That we’ve done everything correctly?
Replicability: If we had to do it all again, would we get the same answer? If someone else did it, would they?
Transparency: If our results are challenged, can we show exactly what we’ve done to defend it?
–Matt Waite
 
—
Data Analysis
— Review methodology with one or more other data people
— Check results to other available comparable data
— Ensure all record counts are consistent across stages
— Check averages
 
— Examine outputs to ensure logical consistency (do things that should add up to 100% add up to 100%?)
— Recheck all coding line by line if possible or in aggregate if not
 
— Re-read all programs/scripts
— Re-run entire analysis from scratch
— Check each number against analysis or source material prior to publication
— Recheck each number against analysis or source material on each draft
 
Credit: Daniel Lathrop. Dallas Morning News
 
<div class='tableauPlaceholder' id='viz1534703179238' style='position: relative'><noscript><a href='#'><img alt='Median Debt of Graduated Students in Arkansas, 2016Source: CollegeScorecard ' src='https://public.tableau.com/static/images/St/StudentLoans-ARK20168-19-18/Sheet1/1_rss.png' style='border: none' /></a></noscript><object class='tableauViz' style='display:none;'><param name='host_url' value='https%3A%2F%2Fpublic.tableau.com%2F' /> <param name='embed_code_version' value='3' /> <param name='site_root' value='' /><param name='name' value='StudentLoans-ARK20168-19-18/Sheet1' /><param name='tabs' value='no' /><param name='toolbar' value='yes' /><param name='static_image' value='https://public.tableau.com/static/images/St/StudentLoans-ARK20168-19-18/Sheet1/1.png' /> <param name='animate_transition' value='yes' /><param name='display_static_image' value='yes' /><param name='display_spinner' value='yes' /><param name='display_overlay' value='yes' /><param name='display_count' value='yes' /><param name='filter' value='publish=yes' /></object></div> <script type='text/javascript'> var divElement = document.getElementById('viz1534703179238'); var vizElement = divElement.getElementsByTagName('object')[0]; vizElement.style.width='100%';vizElement.style.height=(divElement.offsetWidth*0.75)+'px'; var scriptElement = document.createElement('script'); scriptElement.src = 'https://public.tableau.com/javascripts/api/viz_v1.js'; vizElement.parentNode.insertBefore(scriptElement, vizElement); </script>

________________________________________________

 

Refresher: Basic Excel

NICAR Coursepack: Basics and Sorting in Excel 

Open sample dataset: citybudget.xls

1. Make a copy

2. Four corners test

3. Check the math

4. Sorting

5. Percentage Change

Formula: (New number-Old Number)/Old Number * 100 and use % symbol

Background and Help:

Tutorial Video

Lynda.com tutorial videos on Excel.

More on Lynda.com  

 

Homework

  1. Readings

Cohen, Sarah. Numbers in the Newsroom: Using Math and Statistics in News. 2nd ed. Columbia, Mo.: Investigative Reporters & Editors Inc., 2014. Figuring Rates – Numbers in Newsroom

 
Sheffo, Catherine. “How to Avoid 10 Common Mistakes in Data Reporting.” American Press Institute (blog), August 9, 2016. https://www.americanpressinstitute.org/publications/data-reporting-common-mistakes/

 –Write two questions or observations about each of the readings.

 

2. Answer questions in the NICAR coursepack, UrbanPop Data

Sorting:

–Which urban agglomeration was the largest in 1950?

–Which is expected to be the largest in 2030?

Percentage Change:

–Which had greatest rate of change between 1950-2015?

–Are any urban areas expected to lose population from 2010 to 2030?

–If so, how many and which one is expected to lose the most?

–Which United States urban area is expected to have the largest percent increase from 2015 to 2030?

 

Answers due 11:59 pm Tuesday, Aug 21. Email to rswells@uark.edu

 

 

Wednesday, Aug. 22 Class Agenda

Review Homework

                                                                                                    WordPress

Tableau

Work with student loan data

 

 

In Class Data Exercise

Excel: NICAR pack

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

Examine Student Loan Data: Tuition costs at Arkansas colleges and universities.

What does this mean? Look at the data dictionary.

—

 

Tableau Software

 

Thank you for your interest in the Tableau for Teaching program. Below is a website (landing page link) for your upcoming class. Each student should go to the landing page to download Tableau Desktop and enter the product key noted below. This key will allow your entire class to activate Tableau Desktop for the duration of the course.

Please forward these instructions to your students:

  • Download the latest version of Tableau Desktop here
  • Click on the link above and select Get Started. On the form, enter your school email address for Business E-mail and enter the name of your school for Organization.
  • Activate with your product key:  TCN8-F401-A980-11F5-79E7 
  • Already have a copy of Tableau Desktop installed? Update your license in the application: Help menu -> Manage Product Keys

Are your students new to Tableau? Share our free Data Analytics for University Students guide to help them get started.

Students can continue using Tableau after the class is over by individually requesting their own one-year license through the Tableau for Students program here

Need help? Find answers to frequently asked questions here.

Best,

Academic Programs Team
Tableau Software
tft@tableau.com

 
 
 
 

 

Exercise 4: Rates and Ratios

Exercise4

Data

transit

 

Calculations and Pivot Tables

https://www.youtube.com/watch?v=6sOzoR2l-dQ