Week #15: Multimedia
Tableau Queen
Megan Putney, Mike’s Hard Lemonade
https://training.uark.edu/professional-development/courses/tableau.php
Almost there!
- Hold off on social media promotion until you get the go-ahead email from me. Other professors doing check.
- Review the stories. Check for gaps, missing stories, etc.
- Stories still pending: Baird, Bonner, Duby, Fracchia/Tillson, Ramirez
What you have learned this semester
You can put this on your resume:
–Proficiency in basic Tableau
–Proficiency in Excel
–Basic training in data analysis and visualization
–Multimedia production in WordPress
Data Cleaning and Joining Exercise
–You will join the CollegeScorecard data with 2017 Census Data with the average household income
The goal is to compare the average student debt in a college to the income in the surrounding town.
This in-class task will stretch over two class sessions, unless you are a DATA KING OR QUEEN
This exercise builds on the data analysis, cleaning and visualization skills you learned this semester.
Task 1: Retrieve the Census Data
Use Excel
–Examine the data dictionary.
–Examine the data, the range of incomes and number of cities, towns and places
–Create a copy of the Census sheet for the data cleaning
Task 2: Data Cleaning
You will need to match the town in the Census to the city in College Scorecard.
Look at the “city” column in the College Scorecard data: ARDebt17_10_23.csv
–Tip: Data cleaning tools in Excel: Text to columns and find and replace
Task 3: Joining
–Join the Census data to the ARDebt17_10_23.csv in Tableau
–Chart the Income and the Grad debt by the 10 largest public schools
Task 4: Analysis
–Construct a Ratio of Grad Debt to Per Capita Income. Map it
Data Literacy – Number in the Newsroom Exercises
–Reversing Percent Differences
–Adjust for Inflation
–Weighted Averages
Embedding Video, Photos in Tableau Workbooks
Build Animated Student Loan Graphic – Make Screen Video – Add to Posts
Look at the data structure: Tidy Data
1) Process Data (2008-2016)
–R Demonstration using Student Loan Data Management 10-15-19.R
—Examine Combined Data
2) Build Animated Student Loan Debt, 2008-16
3) Screen video
4) Embed in post, loop, autoplay
Embedding Videos in Tableau
https://kb.tableau.com/articles/howto/adding-embedded-videos-to-dashboards
Add video to published Razorback Reporter stories
https://razorbackreporter.uark.edu/student-loans-in-arkansas/
New York Semester. Tuesday, Dec. 3, 3:30 p.m., Student Media Conference Room
Spend a semester learning from top-notch journalism faculty and interning at a news media organization in the journalism capital of America. Led by Wall Street Journal veteran Professor Paul Glader and New York Daily News veteran Professor Clemente Lisi, the NYC Semester in Journalism (NYCJ) program includes newsroom visits to outlets such as BuzzFeed, The Wall Street Journal, The Associated Press and ProPublica. Students in the program have interned at outlets such as The New York Daily News, The Brooklyn Paper and Newsweek. They have heard from journalists from outlets such as The New York Times, SkyNews and Reuters. Studying with professors who are deeply rooted in Christian faith, NYCJ students cultivate their commitment to the truth and the skill to tell it well. https://www.tkc.edu/nycs
Course Evaluation
- Check for an e-mail with instructions on how to access the evaluation .
- These are important to the future of this class: I use these to modify and improve the course
- They are important in shaping departmental and program curriculum.
- The online evaluations are confidential. Results won’t be reported until final grades have been submitted.
Census Data
https://wordpressua.uark.edu/datareporting/census-data-download-and-cleaning/
Filtering
Reading Data Dictionaries
WordPress details
https://wordpressua.uark.edu/datareporting/wordpress/
Build a Cover Image Using Canva or InDesign or Powerpoint
https://www.canva.com/
Week #16: Multimedia, Project #3
Past Classes
Week #1: Excel, Data
Class Work:
Intro Excel w Exercise #1
Link for Today’s Course:
https://wordpressua.uark.edu/datareporting/basic-excel-introduction-to-data/
- Talk
- Syllabus and course overview
- Email to students
- Review NICAR Coursepack.
- Work with Excel
Write a minimum three paragraphs about yourself.
–What is your journalism background?
–Who are you? Where are you from?
–What do you read and watch, and why?
–What do you want from this class?
–Do you have any nervousness about taking a data class? Why?
Read:
1) NICAR Coursepack
2) 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 paragraphs total on the Sheffo article and discuss two items that impressed you the most and explain why.
Due Wednesday, Aug 28, 11:59 pm on Blackboard. “Homework for Aug. 28”
- Review homework
- Elena’s mouse hack
- Continue with NICAR Coursepack.
Link for Today’s Course:
https://wordpressua.uark.edu/datareporting/basic-excel-introduction-to-data/
Refresher on Mac OSX operating system
Here is a short video course that you can skim through and get up to speed on how to use the Apple operating system, OSX.
https://www.linkedin.com/learning/macos-mojave-essential-training/understand-macos-the-foundation-of-working-with-a-mac?u=50849081
I would hammer through the following as soon as possible.
Chs. 1, 3 are important
Chapter 2: Finder will be crucial.
Ch. 5 on downloading from the web is important
Ch. 4, 13 should be skimmed
Chs 6-11 aren’t important for our class
End of Semester Review
Beginning of Semester PreviewYou 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.
Excel Proficiency: entering data, cursors, formatting, sum, average, median, change, percent change
Skills: Data Dictionary, Part 1
Skills: Organize Your Data. Finder, Storage, File Organization
Intro Excel, WordPress
Exercise 2, tuition
Follow and complete the tasks in the Exericse 2 of the NICAR course pack, analyzing change in tuition. Use the University of Arkansas data from the College Navigator website.
Submit Excel spreadsheet and a brief two-paragraph discussion highlighting your findings on a Blackboard discussion post. Answer these questions.
Analyze the estimated tuition, fees and living expenses data for students to help you answer the questions below. Total expenses include the Room and Board and Other and Books and Supplies. The two living scenarios will be on-campus and off-campus; disregard off campus with family.
1) How much would an in-state student expect to pay for the 2018-2019 school year?
2) How much would an out-of-state student expect to pay for the 2018-2019 school year?
3) How much more did out-of-students pay in 2018-2019 than in-state students?
4) Which category increased the most from the 2015-2016 to the 2018-2019 school years? Raw change? Percent
change?
5) Write a lead for a story based on your analysis.
6) What other information and/or sources would help you finish this story?
Week #3: Data, Tableau
Review Quiz
Filtering
Pivot Tables
Numbers in the Newsroom
Numeracy; Filtering
Homework - discussion questions
File and Data Management
https://wordpressua.uark.edu/datareporting/organize-your-data/
Link for this week:
File and Data Management
https://wordpressua.uark.edu/datareporting/organize-your-data/
Exercise Filtering: Crime Rates and Ratios
–Find Average Crime Rate Statewide
–Filter above and below average
–Find Average Population
–Filter above and below average
NICAR coursepack: Pivot Tables
In class exercise: MLB Salaries
QUESTIONS
1) Did the National League or the American League pay more in salaries? Who has the higher average salary?
2) Which division pays the most in salaries? The least?
3) Which team had the most players on the roster?
In-class exercise WorldBank
Using the WorldBank data , build a Pivot Table.
–Trick: Shift+Ctrl+8
–Produce a list ranking the countries with the most companies disbarred, sorted descending. Copy the results and paste into a new tab.
–Produce a list of the firms that have more than one disbarment, sorted descending. Copy the results and paste into a new tab.
What is the most common violation, and how many times did it occur?
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
Read AP chapter on data journalism
12-Sep Rates and Ratios – Tableau
Exploratory Data Analysis
Part 2 Data Dictionary
Tableau: https://wordpressua.uark.edu/datareporting/tableau-license/
Introduction to College Scorecard Data: https://collegescorecard.ed.gov/data/
Read Overview from Paul Bradshaw on basic data journalism.
https://github.com/paulbradshaw/MED7373-Data-Journalism/blob/master/1basics/dj3chords.md
Meyer, “New Precision Journalism,” Ch. 1-2
Homework for Sept. 11
Discussion questions
Cohen, Sarah. Numbers in the Newsroom: Using Math and Statistics in News. 2nd ed. Columbia, Mo.: Investigative Reporters & Editors Inc., 2014.
Cohen Figuring Rates Numbers in Newsroom.pdf
Cohen Numbers in Newsroom – Common mistakes.pdf
Write a paragraph with at least two questions or observations.
Read AP chapter on data journalism
Write one paragraph with major findings in this reading.
Data management
Show me a screenshot of your data diary and a screen shot of your Finder path showing the file folders for your external drive.
Homework for Sept. 14
#1. Read Ch. 6, Chapter 6 The Truthful Art
Post two discussion questions on Blackboard
#2. Read “New Precision Journalism” Ch 1-2
Meyer writes: “Precision journalism threatened the twin traditions of journalistic passivity and journalistic innocence.” What does he mean by that? What are the implications of this? Write a paragraph to answer the questions.
#3: Construct chart from student loan data: Median Debt by Graduated Students. Post a .jpeg file (screen grab is fine) and two sentences with key findings or questions for further reporting. Due 11:59 pm Sept 14 on Blackboard
Week #4: Tableau
Basic Data Visualization principles
Reading data dictionary
Student Loan Data -Data Dictionary
Pivot Tables
Tableau
Review Homework Questions
Basic Data Visualization Principles
https://wordpressua.uark.edu/datareporting/data-visualization/
Tableau: https://wordpressua.uark.edu/datareporting/tableau-license/
Introduction to College Scorecard Data: https://collegescorecard.ed.gov/data/
Definitions:
https://collegescorecard.ed.gov/assets/FullDataDocumentation.pdf
1) Examine definitions on Full Data Documentation and CollegeScorecardDataDictionary.
INSTNM
CITY
STABBR
ZIP
UGDS
UGDS_WHITE
UGDS_BLACK
UGDS_HISP
UGDS_ASIAN
GRAD_DEBT_MDN
2) Build Tableau bar chart, enrollment by race, schools with 5,000 or more students.
Class Exercise on College Scorecard Data:
Review MERGED2017_18_PP-ARKONLY
–This comes from https://collegescorecard.ed.gov/data/
–Filtered Arkansas from National Data
–Question: How many columns? How many rows?
–Column headings defined in Data Dictionary
One bite at a time!
Review Data Dictionary.
–Filter dev-category on data-dictionary tab
–Review the categories.
–Tell us how many items per category
–Identify 1 or 2 items by VARIABLE NAME from each that you consider important for telling a story about student loans.
–Share with the class.
–Put categories on Sticky Notes.
–Build Filtered Spreadsheet
For example:
dev-category: school
–15 items
–TUITFTE is tuition revenue per fte. Looks useful to see the amount of money per staff person at school
Row 1: academics, admission
Row 2: aid, completion
Row 3: cost, earnings
Row 4: repayment, student
Create Tableau chart, top 10 schools by student race/ethnicity:
Chart 1: White schools
Chart 2: African-American schools
Chart 3: Hispanic schools
Chart 4: White, black, hispanic, asian
–Columns SUM(Ugds White) SUM(Ugds Black) etc
–Sort by individual columns
Issues:
Format Labels from “Sum of Ugds White” to White
Ditto for Black, Hispanic, Asian
Wrap the labels: Mouse between rows, expand the spacing – make the rows fatter
Format | Wrap On
Create Tableau chart, create ratio Grad_Debt_Mdn/Enrollment per school
Create Excel Sheet, ARDebt9-17, with the Following Fields
UNITID
INSTNM
CITY
STABBR
ZIP
CONTROL
(Enrollment and Demographics)
UGDS
UGDS_WHITE
UGDS_BLACK
UGDS_HISP
UGDS_ASIAN
(Debt and Income and Gender)
GRAD_DEBT_MDN
LO_INC_DEBT_MDN
MD_INC_DEBT_MDN
HI_INC_DEBT_MDN
FEMALE_DEBT_MDN
MALE_DEBT_MDN
FIRSTGEN_DEBT_MDN
NOTFIRSTGEN_DEBT_MDN
GRAD_DEBT_N
WDRAW_DEBT_N
PELL_DEBT_MDN
NOPELL_DEBT_MDN
LOAN_EVER
PELL_EVER
Part 3:
Class Exercise: Student Loans – Pivot Table
Analyze Student Loan Data
Sort the Data:
-Sort by Schools with Largest Enrollment. Write a text answer with the top five schools by enrollment.
-Sort by Schools with Highest Median Debt for Graduates. Write a text answer with the top five schools by Median Debt for Graduates.
-Sort by Schools with Highest Median Debt for Student Who Withdrew. Write a text answer with the top five schools byHighest Median Debt for Student Who Withdrew.
Homework for Sept 18
Finish class exercise for College Scorecard Data
Homework for Sept. 21
New data table.
1. Build the new Excel sheet, ARDebt9-17, with the columns as described above. Create a data dictionary. Upload to Blackboard.
Create the following charts in Tableau:
2. Top 10 schools with the most low income debtors and high income debtors. Create jpg, upload to Blackboard
3. Top 10 schools with highest median debt for females, highest for males. Create jpg, upload to Blackboard
4. Write 250 words with your analysis of this data and propose one story idea.
Answers due 11:59 pm Sept. 21 on Blackboard
Week #5: Online Class – Tableau
Week #6: Tableau – Assignment #1
DataViz
Tableau Basics
Student Loan Data / Tableau
Homework: Tableau
Pivot Tables, Data Cleaning: =Trim, Paste Special, Values, Transpose, Find and Replace
Tasks for Tuesday’s Class
1) Build a spreadsheet from the 2015-16 data.https://wordpressua.uark.edu/datareporting/files/2019/09/ARDebt2015-16.xlsx
2) Follow tutorial on joining 2015-16 to 2016-17 data
3) Review comments on draft stories.
4) Read the Assignment #1 on Blackboard carefully and the rubric.
5) Meet with your team to discuss reporting and writing.
6) Check out lesson on dual axis graphics.
Relational Databases: How They Work
Link on Common Fields
Inner, Left, Right joins
http://www.tableau.com/learn/tutorials/on-demand/join-types-union
Joining the 2015-16 data to the 2016-17 data
1) Open Tableau Workbook ARDebt9-17.twbx
2) New Sheet
3) Data | New Data Source
4) Import ARDebt2015-16.xlsx
5) Add New
6) Import ARDebt9-17
7) Inner Join on Unitid
8) Rename as AR2015-17MERGED
9) New sheet, CONVERT TO measures. CAREFUL! DO THIS ONE AT A TIME. CONVERT 2015-16, THEN CONVERT 2016-17
You now have two sets of measures. One for 2015-16 and one for 2016-17
Build a chart contrasting Grad Debt Mdn changes
1) from 2016-17, Instm to Rows
2) Find Grad_Debt_Mdn for 2015-16. First Rename it GRADDEBT15-16. Then drag to columns
3) Find Grad_Debt_Mdn for 2016-17. Rename it GRADDEBT16-17. Drag to columns.
4) Sort by GRADDEBT16-17. Which ones increased?
Build a chart with calculated field Grad Debt Mdn changes
subtract GRADDEBT16-17 from GRADDEBT15-16
2-Oct Facebook Training
The data class will convene on Wednesday, Oct. 2 for a special Facebook for Journalists training. The Oct 3 class will be taken by Prof. Jordan’s editing course.
Project Part 1:
Introduction to the Scale of Student Loan Debt in Arkansas.
—Static graphics.
—Focus on topline details: debt by race, sex, income at Arkansas schools
—Students will quote one or two experts to provide context
—Short stories explaining the findings and putting it within context of government reports on student loans.
—This is published as a special page on Razorback Reporter
—Social media distribution for the finished work
Assignment #1:
The assignment is due Oct. 4 11:59 p.m. on Blackboard.
Arkansas Student Loan Debt Trend
See Blackboard for details
Week #7: Tableau
8-Oct Maps
Review Assignment #1
Basic Mapping
Exploratory data analysis with Tableau
Importing, continue with charts
Student Loan Data
16-Oct Mapping in Tableau
Update on Assignment #1: Photos, headlines. Build shell for stories on Razorbackreporter
–Do not upload text. Final edits pending.
–Upload photos, selected graphics.
–When ready, “For Review.”
–Have WordPress shells with headline, graphics and photos ready by 11:59 p.m. Sat Oct 19.
–Each student will post the link to your group’s story shell on Blackboard.
Create new Student Loan Data with Default Rates
–Using R to Build Tables
New Data:
https://wordpressua.uark.edu/datareporting/files/2019/10/ARDebt17_10_15.zip
Using Tableau Public to Host Graphics
–Create Tableau Public account if you haven’t already
–Load your student loan graphic to Tableau Public.
Using WordPress
–Author powers
–To access back end of datareporting:
https://wordpressua.uark.edu/datareporting/wp-admin
Login with UARK credentials.
Quick tips on Gutenberg editor
https://wordpressua.uark.edu/datareporting/wordpress/
Embed Tableau in WordPress
–Post on WordPress.
Create a new post
Use Divi Builder, the Purple box above the formatting bar
Insert columns, pick a full row
Insert module, pick </> Code
Paste your Tableau Public embed code in the Content box
Scroll down, change the Admin Label to My Mind-Blowing Tableau Graphic (or something more humble). Save and Exit
Change Page Layout (upper right corner) to Fullwidth. Publish
Revel in your nerd powers
Default Map
Build a chart with the Arkansas schools with the highest default rates
Now map that data
–Longitude to Columns, Latitude to Rows. Don’t use Longitude (generated). Generates a blank Arkansas map
–Instnm to Labels. Your map now has all colleges
–CDR3 to Color. Green-Red Diverging, with Red as highest default
–Filter by CDR3 for top 10 default rates in state
Telling a Story With Data: Interactive Dashboards.
Search for Dashboard:
https://wordpressua.uark.edu/datareporting/tableau-license/
Wells dashboard
https://public.tableau.com/profile/rob.wells#!/vizhome/IRE19_GDPVisualizingtheStateLocalEconomy/ArkansasEconomyinDetail
Class Exercise:
–Build A Dashboard Using Existing Maps and Graphics
Pane #1: Map
Pane #2: Graphic
Pane #3: Graphic with a slider to let readers interact with data (sort by most low-income student debt. sort by highest enrollment by race. sort by highest median debt. etc)
Dashboards
Create a Dashboard With The Following Elements
–Abbi and Parker:
Pane #1: Map of Default rates for colleges with more than statewide average of White enrollment.
Pane #2: Map of Default rates for colleges with more than statewide average of Black enrollment.
Pane #3: Map of Default rates for colleges with more than statewide average of Hispanic enrollment.
–The Marys and Elena:
Pane #1: Map of Default rates for colleges with more than statewide average first generation student debt.
Pane #2: Map of colleges with top 10 first generation student debt
Pane #3: Chart of first generation student debt for public, private colleges (see “control” column, check College Scorecard data dictionary)
–Hanna, Sophie, Kate:
Pane #1: Default rates for colleges with more than statewide average low-income student debt.
Pane #2: Chart of colleges with more than statewide average Pell Grant Debt
Pane #3: Map of top 10 colleges showing most students with Pell Grants (PELL_EVER)
–Kirsten, Coleman, Abby:
Pane #1: Map of the female-male debt gap, the top 10 universities with the biggest gap.
Pane #2: Map of total female debt by school statewide
Pane #3: Chart of Male-Female Debt, statewide
–Brooke and Emily:
Pane #1: Map of top 10 default rates for public universities, plus describe average default rate for all public universities. (See data dictionary on College Scorecard for control)
Pane #2: Map of top 10 default rates for private universities. (See data dictionary on College Scorecard for control)
Pane #3: Chart of top 15 universities by Grad_Debt_Mdn, colored by private vs public institutions
Each team creates a single dashboard.
Post dashboard on Tableau Public.
On datareporting WordPress, create a post, embed the dashboard using the Tableau Public embed code. Write a two-paragraph analysis of your findings (200 words) on that blog post.
Each student submits a link with the WordPress post for this assignment. Due Saturday, 11:59 p.m.
Week #9: Tableau
22-Oct Fall Break!
24-Oct
Fix Tableau Dashboards. Charts and Formatting
Tableau Analytics
Multimedia, headlines in Dashboards
Discuss Assign #2
Dow Jones News Fund Test: Tomorrow
https://wordpressua.uark.edu/datareporting/dj-news-fund/
Tableau Analytics:
https://help.tableau.com/current/pro/desktop/en-gb/environ_workspace_analytics_pane.htm
Report about racial disparities with student loans.
It will really help you all understand the broader context of the student loan problem. Please read it and bring questions or observations so we can discuss this on Tuesday.
Goldrick-Rab, Sara, Robert Kelchen, and Jason Houle. “The Color of Student Debt: Implications of Federal Loan Program Reforms for Black Students and Historically Black Colleges and Universities.” University of Wisconsin: Wisconsin Hope Lab, School of Education, September 2014.
https://news.education.wisc.edu/docs/WebDispenser/news-connections-pdf/thecolorofstudentdebt-draft.pdf?sfvrsn=4
Beware of the Infographic
https://www.cjr.org/the_media_today/alberto-cairo-infographics.php
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).
Week #10: Data Viz
Higher Resolution Graphics in Tableau
–Embed with Tableau Public
Question: “a problem with the map titled “First-Generation Debt Higher than State Average.” We are seeing asterisks in areas where schools are being averaged together because of the same zip codes.”
https://public.tableau.com/profile/mary.hennigan#!/vizhome/Top10ArkCollegeswHighestFirst-GenDebt/ArkFirst-Gen
Solution: Drag the College Name (INSTNM) to Tooltip again. That clears up the asterisk problem.
https://kb.tableau.com/articles/Issue/asterisks-display-in-tooltip?_ga=2.54541547.179450172.1572394665-1129705566.1555298785
Question: no titles for each graphic,
Solution: Drag your graphics into a Dashboard. Then drag the Dashboard into a story. Your headlines will appear that way.
Question: fat bars for the chart
Solution: Tell the bars to stop eating at Pizza Hut.
Question: really, what about the fat bars for the chart
Solution: See the attached video.
Project Part 2:
Nov. 4: Racial Disparity in Arkansas Student Loan Debt
—Beginning interactive web graphics, include photos or short videos
—Maps of debt burdens
—Details on the debt discrepancy by race.
—Stories explaining the context.
—A small photo gallery or short video clips.
–A few interviews with actual students who have debt
—This is published as a special page on Razorback Reporter, before Thanksgiving
—Social media distribution for the finished work
Assignments will follow AP Style and Razorback Reporter style:
Tableau Can Be Dangerous, Part 1
Inner Joins. Outer Joins.
–The evils of the inner-join and how it can mess up your math.
Relational Databases: How They Work
Link on Common Fields
Inner, Left, Right joins
http://www.tableau.com/learn/tutorials/on-demand/join-types-union
https://help.tableau.com/current/pro/desktop/en-us/joining_tables.htm
Exercise on Inner Joins.
Spreadsheet at this link
1) Do the four corners test. How Many in Violent 2013? In Violent 2017?
2) Load data into Tableau
3) Inner join Violent 2013 and Violent 2017 on zip code
4) Build bar graph that visualizes 2017 Violent crime by City.
6) From Analytics, drag total and average line to view
7) Display the totals with labels
Question:
Totals and Average for Inner Join?
Totals and Average for Right Join?
Why are we getting different numbers?
Week #11: Project #2
Grouping:
–Group on sheet for specific view
–Grouping in dimensions pane is problematic
Exercise: Show the average graduate debt for HBCUs vs Public, Private Non-Profit, Private For-Profit
1) Build basic schools and Grad Debt Mdn graphic. Set to Average. Add Control to Filter
2) Group HBCUs
3) Filter Public schools, group them
4) Unfilter
5) Filter Private non profits, group them
6) Unfilter
7) Filter Private for profits, group them
8) Unfilter
Solution to Exporting Low Quality Images from Tableau
1) Worksheet | Copy | Image
2) Select Title & View
3) Open Preview
4) File | New From Clipboard
–Your Tableau graphic has been pasted into Preview.
5) Export. Change Format to JPEG. Increase Quality to Best. Option: Boost Resolution to 1000 pixels/inch
Bins and Groups
Bins and Groups
Create Bins: https://onlinehelp.tableau.com/current/pro/desktop/en-us/calculations_bins.htm
Other options besides bins:
Use parameters to organize data: https://onlinehelp.tableau.com/current/pro/desktop/en-us/parameters_create.htm
Use sets to organize data: https://onlinehelp.tableau.com/current/pro/desktop/en-us/sortgroup_sets_create.htm#Use
Census Data
Census Data
https://wordpressua.uark.edu/datareporting/census-data-download-and-cleaning/
Filtering
Reading Data Dictionaries
Data Cleaning in Excel:
=Trim, Paste Special, Values, Transpose, Find and Replace
Student Loan Explainer: See Blackboard for assignment details
Homework: Reading on Racial Disparity in Loans
Student loans and Morehouse
https://www.wsj.com/articles/paths-of-2018-grads-show-potential-impact-of-billionaires-gift-11559655146
$1.5 trillion of student loan debt has transformed the American dream
https://qz.com/1367412/1-5-trillion-of-us-student-loan-debt-has-transformed-the-american-dream/
Black-White Disparity in Student Loan Debt More Than Triples After Graduation
https://ccrc.tc.columbia.edu/publications/black-white-disparity-in-student-loan-debt-more-than-triples-after-graduation.html
Young, Black, and (Still) in the Red: Parental Wealth, Race, and Student Loan Debt
https://www.ncbi.nlm.nih.gov/pmc/articles/PMC6049093/#R35
Black women have most debt
http://www.newsweek.com/student-loans-pay-gap-college-debt-black-women-white-men-women-gender-gap-1016776
Presentation at Investigative Reporters and Editors on Student Loans, Higher Ed Beat
https://docs.google.com/presentation/d/1l1nQ7Yged8cUwRtPONToJQyCV1GZdHnTowSDH1H_EIQ/edit#slide=id.p
Higher Resolution Graphics in Tableau
https://www.dataplusscience.com/HighResolution.html
Discuss Assignment #2 Proposals
https://docs.google.com/document/d/1ZXXjcigvKZBVgJD8VeZOWAZuxereRZeOw89KitCU7Bs/edit
Discuss student loans and race
Goldrick-Rab, Sara, Robert Kelchen, and Jason Houle. “The Color of Student Debt: Implications of Federal Loan Program Reforms for Black Students and Historically Black Colleges and Universities.” University of Wisconsin: Wisconsin Hope Lab, School of Education, September 2014.
Higher Resolution Photos: at least 72 DPI. Practically, should be higher.
–500k or more is a safe bet
–Cropping reduces file size. Grainy
Guidance: https://cft.vanderbilt.edu/wp-content/uploads/sites/59/Image_resolutions.pdf
Higher Resolution Graphics in Tableau
https://www.dataplusscience.com/HighResolution.html
Tableau Can Be Dangerous, Part 1
–The evils of the inner-join and how it can mess up your math.
Need to produce higher resolution graphics in Tableau
https://www.dataplusscience.com/HighResolution.html
Tableau Can Be Dangerous, Part 1
–The evils of the inner-join and how it can mess up your math.
Research – Data on Race and Lending
College Scorecard draws from multiple databases.
It provides details about student race/ethnicity by enrollment.
It provides details about defaults and median debt by institution.
It does not provide details about race/ethnicity by loan amount per institution.
But it does provide details about race/ethnicity by loan amount and defaults statewide.
It provides details about percentage of low-income students
It provides details about percentage of Pell grant recipients.
Question: What are some strategies to tell the stories about student loan debt by race and ethnicity given these limitations?
Jot down your ideas on this document:
https://docs.google.com/document/d/1Lux5x4kd4hIK22LbbWICfsSVfkU4aIRogenvPEAJcMM/edit
Suggestion: Look at data dictionary for source of this information. All 1,826 columns explained here.
https://collegescorecard.ed.gov/assets/FullDataDocumentation.pdf
It does not provide details about race/ethnicity by loan amount per institution.
But it does provide details about race/ethnicity by loan amount and defaults statewide
Question: What are some strategies to tell the stories about student loan debt by race and ethnicity given these limitations?
Suggestion: Look at data dictionary for source of this information. All 1,826 columns explained here.
https://collegescorecard.ed.gov/assets/FullDataDocumentation.pdf
Discuss student loans and race
Goldrick-Rab, Sara, Robert Kelchen, and Jason Houle. “The Color of Student Debt: Implications of Federal Loan Program Reforms for Black Students and Historically Black Colleges and Universities.” University of Wisconsin: Wisconsin Hope Lab, School of Education, September 2014.
Key points:
Brief History of Federal Student Loans
Loan amounts white-black students were about the same. So what’s the big deal?
Key differences between HBCUs and majority white institutions
For Your Background: More Student Loan Readings
Week #12: Data Cleaning, Analysis
14-Nov Data Analysis
Student Loan Calculator
Census Data
Student Loan Explainer
Student Loan Explainer
—What did you learn from this and how will it shape your interview questions?
Hennigan: No co-signer!
The maximum an undergraduate can borrow from federal student loans is $31,000 and most don’t require a credit check or co-signer.
Brooke: This would not be correct since a person’s credit score would limit private borrowing.
“Any amount of private loans can be taken out at banks and credit unions regardless of a student’s financial situation. “
If you are, say, a New York-based real estate developer who borrowed excessively and then filed for bankruptcy six times, you might have trouble getting a loan. Just to pick a random example…
Student Loan Calculator:
The current interest rate for subsidized loans for undergraduate students is 5.05% and is subject to change July, 1, 2019, according to Arkansas Student Loan Authority.
https://wallethub.com/student-loan-calculator/#calculator
Super basic compounding interest formula
https://www.ablebits.com/office-addins-blog/2015/01/21/compound-interest-formula-excel/
Monthly payment formula
https://exceljet.net/formula/calculate-payment-for-a-loan
Future value
https://exceljet.net/formula/calculate-compound-interest
College Loan Calculator from Excel
https://templates.office.com/en-us/college-loan-calculator-tm00000035
Census Data
Census Data
https://wordpressua.uark.edu/datareporting/census-data-download-and-cleaning/
Filtering
Reading Data Dictionaries
Data will meet Monday, Nov. 18, 1:30 pm-2:45 pm. Jordan will take the data time slot on Tuesday, Nov. 19, 9:30 a-10:45 a
Data will have an online class Thursday, Nov. 21. There will be no class meeting that day.
18-Nov Basic Animation
Follow this tutorial and build a basic animation of a graphic in Tableau
https://www.absentdata.com/animation-tableau/
Week #13: Census Data – Visualization
Story Pitches Assignment #3
Loan Data By Race – Statewide
https://wordpressua.uark.edu/datareporting/files/2019/11/Ar-US-Student-Loan-Data-by-Race-2016.xlsx
https://wordpressua.uark.edu/datareporting/files/2019/11/NCES-Race-percent-with-Multiple-Loans.xlsx
https://wordpressua.uark.edu/datareporting/files/2019/11/HBCU-students-Loans-and-Income.xlsx
Animation
–How data is organized for animation
–Demonstration with R
–Use one of your previous visualizations and animate it
–Tableau playback issue
Revisions to Assignment #2
Animation Issue
Tableau Public doesn’t allow the play button to display.
Play button missing from Published Dashboard |Tableau Community Forums
https://community.tableau.com/thread/116407
https://community.tableau.com/thread/202785
What is a workaround you would employ to achieve the same end?
Week #14: Tableau Interactives
26-Nov DataViz Multimedia Production – WordPress Final Project: Visualize in Tableau “Basic of Coding, Data Analysis “
Media Future
Read and post for class discussion: Future Today Institute report on media trends
–Bring one question or observation to class on Wednesday
FTI_Journalism_Trends_2019_Final-1kcrlh3
