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

 

Oct 31 Day 20

Oct 31, Day 20

Agenda:

–Continue with R: Importing Data, Making Charts, Building Tables, Data Structure


 

 

Your Tasks for Today

Introduction-to-R-Oct-31-2018

 

 

 

 


 

R – Why Are We Doing This Again?

 

BuzzFeed spy planes

The project includes examples of abstraction (in this case, filtering) and algorithms (in this case the random forest algorithm).

 

New York Times App Designer Speaking In Fayetteville on Friday

From our friend in Art, Tom Hapgood. Please spread the word to students.

New York Times Senior Mobile Product Manager Drew Cogbill (and UA alum) will present on user experience and design with apps in his position at the news organization.

All School of Art visiting designer lectures are free and open to the public with generous support provided by the Walton Family Charitable Support Foundation.

The event is at 9 a.m. Nov. 2, Brewer Family Entrepreneurship Hub, 123 W. Mountain Street. Fayetteville. 

Oct 29 Day 19

Agenda for Monday, Oct. 29

Introduction to R and R Studio

Announcement: Data Journalism will be online Monday, Nov. 5 and Wednesday, Nov. 7.
Prof. Wells will be in Maryland for a family matter. I will be reachable by cell and email during some periods next week
Class assignments will be posted on WordPress and Blackboard. You will post class work on Blackboard.

Impact of student journalism:

https://www.washingtonpost.com/local/maryland-settles-with-nursing-homes-that-discharged-patients/2018/10/26/64d28f76-d963-11e8-8384-bcc5492fef49_story.html?utm_term=.222ef1945d55

Why Do People End Up In Unlicensed Assisted Living Homes?

https://www.ire.org/resource-center/stories/?q=Maryland

https://twitter.com/baltbizmorgan?lang=en

https://twitter.com/thesagaofzoe?lang=en

 

 

Introducing R Studio

 

Open R Studio on Your Desktop.

Download this tutorial and open it in R Studio

*Updated*

Introduction-to-R-Oct-29-2018

AY17Disbursements-by-Location

Homework:

Read:

Introduction to R

First steps in R data analysis

 

RACEG Memo

RACEG – Data Memo.

Halie Brown and Kris Smith


For the stories on Historically Black Colleges and Universities we will continue to use the 2016 Arkansas Data that shows that three out of four Arkansas HBCUs have a higher median 3-year default rate than the average of 13 percent. Philander Smith College has a median 3-year default rate of 21 percent, Arkansas Baptist College had a median 3-year default rate of 23 percent and University of ARkansas at Pine Bluff has a median 3-year default rate of 26 percent.

Shorter College, the smallest of the four Arkansas HBCUs with 236 undergraduates in 2016, has not released its 2016 3-year default rate.

We will be using College Insight, Common Origination and Disbursement System and the Enterprise Data Warehouse’s data to give more context to the debt crisis as a whole, and to give a closer look to HBCUs in Arkansas.

College Insight gives us the average percent of graduates who are in debt for only one HBCU, Philander Smith College at 78 percent which has the highest of all listed. It is important to note that Philander Smith College is a private institution.

Common Origination and Disbursement (COD) System provides the amount of direct loans provided to students and the university, which will provide a more in-depth look to how many loans are given out and put default rates into perspective. The HBCU with the highest amount of direct loans disbursed is the University of Arkansas at Pine Bluff with around $2.8 million. The second highest HBCU is Philander Smith with $1.3 million.

The Enterprise Data Warehouse’s Portfolio by Borrower Location and Age while it does not directly relate to HBCU debt will provide a more in-depth look at the overall debt crisis in Arkansas. People in the age range of 25 – 34, or millenials, have the highest amount of borrowers at around 126,200 with around $3.9 billion in outstanding debt. Ages 24 and less have around 71,800 borrowers with around $1 billion in outstanding debt.

Hazel Dashboard

<div class='tableauPlaceholder' id='viz1540591485723' style='position: relative'><noscript><a href='#'><img alt=' ' src='https://public.tableau.com/static/images/Oc/Oct_20HWHazel/Dashboard1/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='Oct_20HWHazel/Dashboard1' /><param name='tabs' value='no' /><param name='toolbar' value='yes' /><param name='static_image' value='https://public.tableau.com/static/images/Oc/Oct_20HWHazel/Dashboard1/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('viz1540591485723'); 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>

Kris Smith- Default Rates 10.13

 

 

The institutions for both the top 10 and bottom 10 three-year cohort default rates showed some trends across the state. For starters, located in the northern or more central part of Arkansas are the institutions with the lowest three-year cohort default rate. The populations here are more predominately white, as opposed to having a larger minority community. There are also a large number of medical institutions in the bottom 10. It can be inferred that the graduates come out of college working jobs in the field that allow them to begin to comfortably make a living and pay down their student loans.

Secondly, all of the highest default rates showed a distinct trend. All of the institutions are located in the lower southern half of the state. The data shows that this area (or surrounding areas) have a highly saturated African-American population. Historically, these areas are more poverty-stricken than other parts of the state. Overall, these institutions are geographically located in a strikingly different position than the institutions with the lowest three-year cohort default rate. In addition, a large majority of the schools with high default rate are classified as beauty schools (Arkansas College of Barbering and Hair Design), or a historically black institution (the University of Arkansas at Pine Bluff).

Kris Smith- Story #2 EDITS

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

OVERVIEWG – Data Memo for K.B. & Haley Ruiz 10.24

The new data source we decided on was “New Disbursements by Location.” We thought this data set would show how Arkansas compares to other states through an interactive graphic that shows total disbursements by state and region. This data is more recent (old was from 2016) and it shows data for the entire nation, not just Arkansas.

https://www.studentaid.ed.gov/sa/about/data-center/student/title-iv

PROFIT – Data Memo

We are going to use the existing 2015-2016 College Scorecard data for Strayer University and the University of Phoenix. The data cannot be found anywhere else for more recent years. Using the available data we will make a comparison between for-profit universities.

BEAUTY-Data Memo

We will use College InSight to filter through all the beauty schools in the state to see beauty school debt. Also the College InSight data is updated to the 2017 fiscal year.

http://college-insight.org/#explore/go&h=6d38087e46818e79ac32f5fab17eea08

-Megan and Skylar

Katie Beth Nichols – Revised Dashboard

<div class='tableauPlaceholder' id='viz1540394161221' style='position: relative'><noscript><a href='#'><img alt=' ' src='https://public.tableau.com/static/images/Da/DashboardRevised/Dashboard1/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='DashboardRevised/Dashboard1' /><param name='tabs' value='no' /><param name='toolbar' value='yes' /><param name='static_image' value='https://public.tableau.com/static/images/Da/DashboardRevised/Dashboard1/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('viz1540394161221'); 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>