Agenda for Monday, Oct. 8

–Context!

–Common Errors

Context #1

Add the Quick Facts for city population, demographics.
Little Rock: African American comprise 42 percent of Little Rock’s population. https://www.census.gov/quickfacts/fact/table/littlerockcityarkansas,US/PST045217

Add typical salary from Occupational Employment Statistics database for Arkansas
https://www.bls.gov/oes/current/oes_ar.htm

Common Errors – Math

Percent vs Percentage Point

At Lyon College, 67 percent of non-first-generation students paid back their loans within five years, while only 53 percent of first-generation students did the same, which results in a 14 percent POINT difference. The median debt for both types of students was the same though, at $12,000.

You mean “percentage point.” 14 percent of 67 is 9.4.

Steve Doig – MathCrib-Doig

Common Errors – AP Style on Numbers

AP Style on Numerals:

Numerals – AP Stylebook-2avrxtn

Common Error – Divi Library

Divi Builder. Do Not Save to Library.

Context #2: Build Charts for Context

First row: The overall median debt for Arkansas students; for men, for women.
Second row: The overall median debt for first generation students. And non-first generation
Third row: The overall statewide repayment rate, and the rate for men, for women
Fourth row: The overall median debt for white, black, asian, hispanic

Post on WordPress with the category Context

Research – Data Question

The Financial Aid department does not report loan repayment info to the Department of Education. “Once the students leave us we don’t track their information anymore,” he said.
Question: Look at data dictionary for source of this information. All 1,826 columns explained here.
https://collegescorecard.ed.gov/assets/FullDataDocumentation.pdf

https://collegescorecard.ed.gov/assets/CollegeScorecardDataDictionary.xlsx

Homework

#1: Read this report and compare to your work on context. Prepare to discuss it Wednesday

https://ticas.org/sites/default/files/pub_files/classof2016.pdf

#2: By 11:59 p.m. Tuesday, fix the issues with your charts and stories from Assignment #2. Post on WordPress, use the Context category for a tag

Nov. 14, Day 24

by Camilla Shumaker | Nov 14, 2018 | Fall2018_class, Tableau | 0 Comments

Agenda

Review R Studio Assignments

Tableau Dashboards

Example Map – Lots of Data – Popup Legends:

https://www.bls.gov/opub/ted/2018/employment-rose-9-percent-in-midland-texas-from-september-2017-to-september-2018.htm

Review R Studio Assignments:

Answer to GGPLOT Exercise

Two Measure Graphic Using Megan’s Super Tableau Tricks

Format the numbers once in the Measures:

Right Click – Default Properties | Number Format | Aggregation | Median

Right Click – Default Properties | Number Format | Aggregation | Percentage (or Currency …etc)

Build a graph with two measures, one by bar and the other by line.

Two measures. One Debt, one Default. Switch one to line

—Drag 3-year default rate to sheet

—Drag College Name to columns

—Drag Median Debt to far right hand column

—You have dots on view. Change median debt from Automatic to a line in Marks Card

—Change 3-year default rate from Automatic to bars in Marks Card

Format Legend Titles Correctly – Drag Legends to Bottom, Resize and Rename so words fit correctly

Post to WordPress

Formatting Filters in Tableau.

Easy Fix to An Annoying Issue

Example: Map with linked interactive filters and sliders

<div class='tableauPlaceholder' id='viz1542164046983' style='position: relative'><noscript><a href='#'><img alt=' ' src='https://public.tableau.com/static/images/K6/K6ZGPTZK3/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='path' value='shared/K6ZGPTZK3' /> <param name='toolbar' value='yes' /><param name='static_image' value='https://public.tableau.com/static/images/K6/K6ZGPTZK3/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('viz1542164046983'); 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>

Dashboard Workshop

Inspired by Megan Putney, we will continue forward on Tableau dashboards on Wednesday.

Here is some detailed guidance on your final assignment graphics and dashboards. I think these are good ideas. But if you have something better, let me know and edit this Google Doc. And we will discuss.

We will review some of Megan’s super Tableau tricks in class and then you will use a chunk of the remaining time to hammer out these dashboards and ask questions.

Create Bins: https://onlinehelp.tableau.com/current/pro/desktop/en-us/calculations_bins.htm
Format Filters – See video below
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

Let’s make good use of this time since the deadline is approaching fast.

King’s College Exchange Program – Interest?

We have been invited to partner with King’s College in New York, which offers a program that allows students to spend a semester there. They take a few courses, but the real incentive is that the program connects each student to a newsroom internship in New York, which would open doors for their careers that are difficult from Arkansas.

Participating newsrooms include CNBC, The New York Daily News, Brooklyn News, and Newsweek, and a host of others that is a mix of broadcast and digital and print. With tuition, housing, and credit hours, students would pay $12k for the semester — they would stay in the dorms on campus. It’s not a bad deal for a semester in NYC.

Informal poll – Anyone generally interested in this?

Nov. 7 Homework Halie Brown

by Camilla Shumaker | Nov 13, 2018 | Student_Work | 1 Comment

HBrown Least Increase Script-znetd6

HBrown Top Increase Script-1zwqc8r

Nov. 5 Homework – Halie Brown

by Camilla Shumaker | Nov 13, 2018 | Student_Work | 1 Comment

Halie Brown First Student Loan Data Table Nov. 5-xdktln

AR2011_16JOINED-ploc59

Megan’s updated Nov. 6 R-Studio

by Camilla Shumaker | Nov 12, 2018 | Student_Work | 1 Comment

First Student Loan R Studio-19lg1xt

ar2012_16joint-1y6fd0f

Nov. 12, Day 23

by Camilla Shumaker | Nov 12, 2018 | Fall2018_class, Tableau | 0 Comments

Monday No. 12

Guest Speaker: Megan Putney

Megan Putney, Category Development Manager for Mike’s Hard Lemonade and head of the Northwest Arkansas Tableau User’s Group, will skate and sled down the freeway to be our guest speaker today. She’ll discuss dashboard and design in Tableau.

https://community.tableau.com/groups/northwest-arkansas

https://www.linkedin.com/in/megan-putney-21432839/

<div class='tableauPlaceholder' id='viz1542040512599' style='position: relative'><noscript><a href='#'><img alt=' ' src='https://public.tableau.com/static/images/AR/ARDebt_Sept26/testDashboard/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='ARDebt_Sept26/testDashboard' /><param name='tabs' value='no' /><param name='toolbar' value='yes' /><param name='static_image' value='https://public.tableau.com/static/images/AR/ARDebt_Sept26/testDashboard/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('viz1542040512599'); var vizElement = divElement.getElementsByTagName('object')[0]; vizElement.style.width='1000px';vizElement.style.height='827px'; var scriptElement = document.createElement('script'); scriptElement.src = 'https://public.tableau.com/javascripts/api/viz_v1.js'; vizElement.parentNode.insertBefore(scriptElement, vizElement); </script>