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 24 Day 18
Agenda for Wednesday, Oct. 24
–Review New Data Sources
–Select updated data for your projects
Data Adventure
FY 2015 national cohort default rate is 10.8%, down from 11.5% in the previous year.
By comparison, Arkansas’ cohort default rates dropped from 12.2% to 11.2%, inching closer to the national average. Five years ago, when ASLA initiated efforts to lower the state’s default rate, Arkansas ranked near the bottom of all 50 states at 49th. During that period, Arkansas’ default rate had declined from 19% in 2010 to the more manageable 12.2% in 2014.
Arkansas’ 351,000 student loan borrowers carried more than $10.8 billion in debt at the end of 2017
According to USDE data, Arkansas’ 351,000 college tuition borrowers carried average of $26,799 in student loan debt per student, slightly less that the $27,857 average balanced held by the other 43.6 million Americans that are still paying for college.
By far, college-goers attending the University of Arkansas at Fayetteville received the largest portion of federal student loan proceeds in the 2017-2018 academic years, when $107.6 million was handed out to enrollees at the state’s largest university
Arkansas State University in Jonesboro received the second-largest share of federal student loans at nearly $91.9 million in the 2017-2018 academic year.
Question: Where would we find these numbers in our current dataset?
New Data – or Is It?
https://collegescorecard.ed.gov/data/changelog/
Fine Print:
1 NSLDS -derived data elements will also be updated in the fall of 2018
More Student Loan Data
Dept of Ed Release: Default Rate
Instructions in Default Rates
New Disbursements by Location – Title IV Data: 2016-2017 Totals By State
This report includes disbursements included in the Direct Loan and Grant Volume Reports only. Disbursements from the Campus-Based Programs (Federal Perkins, Federal Supplemental Opportunity Education Grant, and Federal Work-Study Programs) are not included in this report.
College InSight – Detailed Debt Data. Average Debt of Graduates, Percent of Grads With Debt
Details on Student Loan Delinquencies by Type of Loan
Federal Student Loan Portfolio: The office of Federal Student Aid is responsible for directly managing or overseeing an outstanding federal student loan portfolio comprised of billions of dollars in Title IV loans and representing millions of borrowers. This federal student loan portfolio includes Direct Loans, Federal Family Education Loans (FFEL), and Perkins Loans with outstanding balances. The reports below provide information about the federal student loan portfolio.
Total disbursements by institution:2017-2018 Award Year Direct Loan Volume by School
Portfolio-by-Location-by-Debt-Size
DL-by-Delinquency-Location
Portfolio-by-Location-by-Age***
Portfolio-by-Location
Question: Are there any common fields between this new data and the College Scorecard data?
| Story | Reporter | Editor | Deadline |
| BEAUTY | Wilson / Hazel | Jordan | Nov. 25 |
| FEMALE | Van Dyke / Lane | Bouchillon | Nov. 25 |
| OVERVIEW | Ruiz / Nichols | Wells | Nov. 25 |
| PROFIT | Lancaster / Green | Joran | Nov. 27 |
| RACE | Brown / Smith | Minor | Nov. 25 |
- Write a memo about the data sources you intend to use for your dashboard. Include links about any of the new data sources. Describe why you need to use the new data versus the version we have been using. Post the memo on WordPress, using your slug: RACEG – Data memo. etc…
2. Begin building graphics with this new data
- Compare Arkansas to other states by Loan and Grant and Total Disbursements by Location of Federal Student Aid Recipient
- Construct Average Debt of Graduates chart from the CollegeInsight data
- Examine 2017-2018 Award Year Direct Loan Volume by School, construct a basic visualization
Katie Beth Nichols – revised Dashboard
<div class='tableauPlaceholder' id='viz1540388088429' style='position: relative'><noscript><a href='#'><img alt=' ' src='https://public.tableau.com/static/images/fi/firstgenerationstudentdebtdashboard/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='firstgenerationstudentdebtdashboard/Dashboard1' /><param name='tabs' value='no' /><param name='toolbar' value='yes' /><param name='static_image' value='https://public.tableau.com/static/images/fi/firstgenerationstudentdebtdashboard/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('viz1540388088429'); 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>
Revised Dashboard HW – Haley Ruiz 10/23
<div class='tableauPlaceholder' id='viz1540313696750' style='position: relative'><noscript><a href='#'><img alt=' ' src='https://public.tableau.com/static/images/Re/RevisedDashboardHW10_17/Dashboard/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='RevisedDashboardHW10_17/Dashboard' /><param name='tabs' value='no' /><param name='toolbar' value='yes' /><param name='static_image' value='https://public.tableau.com/static/images/Re/RevisedDashboardHW10_17/Dashboard/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('viz1540313696750'); 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>
Dashboard Revision- Samantha Van Dyke
<div class='tableauPlaceholder' id='viz1540264971069' style='position: relative'><noscript><a href='#'><img alt=' ' src='https://public.tableau.com/static/images/DA/DASHBOARD_38/DASHBOARD/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='DASHBOARD_38/DASHBOARD' /><param name='tabs' value='no' /><param name='toolbar' value='yes' /><param name='static_image' value='https://public.tableau.com/static/images/DA/DASHBOARD_38/DASHBOARD/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('viz1540264971069'); 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>
Liz Green 10/22 Class Dashborad
<div class='tableauPlaceholder' id='viz1540235968499' style='position: relative'><noscript><a href='#'><img alt=' ' src='https://public.tableau.com/static/images/Be/BeautySchoolbyDemographics/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='BeautySchoolbyDemographics/Dashboard1' /><param name='tabs' value='no' /><param name='toolbar' value='yes' /><param name='static_image' value='https://public.tableau.com/static/images/Be/BeautySchoolbyDemographics/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('viz1540235968499'); 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 10.20 Homework Revisions
<div class='tableauPlaceholder' id='viz1540229522801' style='position: relative'><noscript><a href='#'><img alt=' ' src='https://public.tableau.com/static/images/RQ/RQC9FQ8DW/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/RQC9FQ8DW' /> <param name='toolbar' value='yes' /><param name='static_image' value='https://public.tableau.com/static/images/RQ/RQC9FQ8DW/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('viz1540229522801'); 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>
Megan Updated 10.20 Homework
<div class='tableauPlaceholder' id='viz1540229503272' style='position: relative'><noscript><a href='#'><img alt=' ' src='https://public.tableau.com/static/images/10/10_20Homework/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='10_20Homework/Dashboard1' /><param name='tabs' value='no' /><param name='toolbar' value='yes' /><param name='static_image' value='https://public.tableau.com/static/images/10/10_20Homework/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('viz1540229503272'); 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>
Caitlin Lane’s Revised Dashboard Assignment: Oct. 22
Revised Dashboard Data Assignment
<div class='tableauPlaceholder' id='viz1540229311010' style='position: relative'><noscript><a href='#'><img alt=' ' src='https://public.tableau.com/static/images/Da/DataDASHBOARDAssignment10_22_18/DashboardHWK10_20_18/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='DataDASHBOARDAssignment10_22_18/DashboardHWK10_20_18' /><param name='tabs' value='no' /><param name='toolbar' value='yes' /><param name='static_image' value='https://public.tableau.com/static/images/Da/DataDASHBOARDAssignment10_22_18/DashboardHWK10_20_18/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('viz1540229311010'); 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>
Halie Brown – Dashboard Revision
<div class='tableauPlaceholder' id='viz1540228226537' style='position: relative'><noscript><a href='#'><img alt=' ' src='https://public.tableau.com/static/images/Da/Dashboard_1389/Dashboard3/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='Dashboard_1389/Dashboard3' /><param name='tabs' value='no' /><param name='toolbar' value='yes' /><param name='static_image' value='https://public.tableau.com/static/images/Da/Dashboard_1389/Dashboard3/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('viz1540228226537'); 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>
Oct 22 Day 17
Oct 22 Agenda
–Dashboards
–Divi Builder
–New Data
–Dashboard Filters
–Dow Jones News Fund test is Friday, Oct 26
Dashboards
—Edit Tooltips. Labels, don’t repeat the same thing in tooltips
—Graphic has to tell a story
—Tell the readers what the slider is supposed to do.
—Interactive filter
Data Adventure
FY 2015 national cohort default rate is 10.8%, down from 11.5% in the previous year.
By comparison, Arkansas’ cohort default rates dropped from 12.2% to 11.2%, inching closer to the national average. Five years ago, when ASLA initiated efforts to lower the state’s default rate, Arkansas ranked near the bottom of all 50 states at 49th. During that period, Arkansas’ default rate had declined from 19% in 2010 to the more manageable 12.2% in 2014.
Arkansas’ 351,000 student loan borrowers carried more than $10.8 billion in debt at the end of 2017
According to USDE data, Arkansas’ 351,000 college tuition borrowers carried average of $26,799 in student loan debt per student, slightly less that the $27,857 average balanced held by the other 43.6 million Americans that are still paying for college.
By far, college-goers attending the University of Arkansas at Fayetteville received the largest portion of federal student loan proceeds in the 2017-2018 academic years, when $107.6 million was handed out to enrollees at the state’s largest university
Arkansas State University in Jonesboro received the second-largest share of federal student loans at nearly $91.9 million in the 2017-2018 academic year.
Question: Where would we find these numbers in our current dataset?
New Data – or Is It?
https://collegescorecard.ed.gov/data/changelog/
Fine Print:
1 NSLDS -derived data elements will also be updated in the fall of 2018
More Student Loan Data
Dept of Ed Release
Instructions in Default Rates
Title IV Data
College InSight – Detailed Debt Data
Details on Student Loan Delinquencies by Type of Loan
Federal Student Loan Portfolio: The office of Federal Student Aid is responsible for directly managing or overseeing an outstanding federal student loan portfolio comprised of billions of dollars in Title IV loans and representing millions of borrowers. This federal student loan portfolio includes Direct Loans, Federal Family Education Loans (FFEL), and Perkins Loans with outstanding balances. The reports below provide information about the federal student loan portfolio.
Total disbursements by institution
Portfolio-by-Location-by-Debt-Size
DL-by-Delinquency-Location
Portfolio-by-Location-by-Age***
Portfolio-by-Location