Agenda for Sept. 23, 2018

1. Continue on Private vs. Public Colleges:
   How Does The Debt Load Differ? 

2. Post interactive graphics on Tableau Public, Embed in WordPress.

3. Demographics and Default

The Private vs. Public Colleges Assignment, Continued

2) Build a new spreadsheet from this raw data: AR2016ALL-1jwseiw
Name your new sheet ARDebt9_19  
It will have these fields:
      A) The private / public colleges field
      B) Latitude and Longitude
      C) The 8 data fields we have used so far in ARDebt.
      D) A data dictionary

The ARDebt data has these fields:

Let’s Clean Up These Stupid Names in ARDebt9_19

3) Make Charts in Tableau

Import ARDebt9_19 into Tableau.

Create a chart of the overall median debt, median private college debt, median public college debt.

Create a chart median debt for graduates for public and private colleges

Create a chart median debt for discontinued students from public and private colleges

Revel in your nerd powers

Post Interactive Graphics to Tableau Public. 

–Post on Tableau Public the chart for median debt for graduates for public and private colleges 

–Copy embed code from Tableau Public from the Share icon in the lower right corner of your data visualization. Embed code looks something like this:

–Post on WordPress.

1. Create a new post
2. Use Divi Builder, the Purple box above the formatting bar
3. Insert columns, pick a full row
4. Insert module, pick </> Code
5. Paste your Tableau Public embed code in the Content box
6. Scroll down, change the Admin Label to My Mind-Blowing Tableau Graphic (or something more humble). Save and Exit
7. Change Page Layout (upper right corner) to Fullwidth. Publish

Revel in your nerd powers

Demographics and Default 

1. In addition to the fields we are already using (name, city, enrollment, median debt, student debt, graduate debt, private/public, etc) list the new fields you would use to build a new table that includes:

–Default
–Demographics
–SAT scores
–Special college designator (HBCU, Native American)
–First generation students

All 1,826 columns explained here.
https://collegescorecard.ed.gov/assets/FullDataDocumentation.pdf

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

Group Assignment:

Group 1: Demographics

Group 2: Default

Use this spreadsheet: ARDebt_Sept26-1dfz8ea

Compose your thoughts at the bottom of this Google Doc:

Homework, due 11:59 p.m. Saturday, Sept. 29.

Explore the demographic and default data. Two teams look at a new expanded spreadsheet: ARDebt_Sept26-1dfz8ea 

that has Demographic and Default data.

You will generate a graphic that explores some aspect of this demographic data. What are the default rates by women? What are the debt loads for men? How  do white, African-American and other students compare on debt loads? On Defaults?

Generate one chart to explore these questions. I want to have 10 different charts examining these questions.

Demographic Data:

Kris, Samantha, Katie Beth, Elizabeth, Grant

Default Data:

Caitlin, Haley, Hailey, Skylar, Megan

Post one chart on Blackboard by 11:59 pm Saturday and two paragraphs about what you found and what story you think should be explored with the data. 

Agenda for Sept. 23, 2018

1. Continue on Private vs. Public Colleges:
   How Does The Debt Load Differ? 

2. Group Exercise – Data Dictionary: Student Loan Dataset

3. Post interactive graphics on Tableau Public, Embed in WordPress.

Review Matching

ARDebt Data Match-1gjlov7

Group Exercise – Data Dictionary: Student Loan Dataset

https://collegescorecard.ed.gov/data/

All 1,826 columns explained here.
https://collegescorecard.ed.gov/assets/FullDataDocumentation.pdf

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

Group Assignment: Examine The Data Dictionary. Sketch out the broad categories describing the data. Hint: There’s a section on demographics – race, ethnicity. 

Consult this article for ideas about the types of data you can examine

http://libertystreeteconomics.newyorkfed.org/2016/09/the-changing-role-of-the-community-college-and-for-profit-college-borrowers.html

Questions:

What are the broad groupings?

What questions do you want to answer with this data and which data fields should we look at next?

Compose your thoughts at the bottom of this Google Doc:

The Private vs. Public Colleges Assignment, Continued

2) Build a new spreadsheet from this raw data: AR2016ALL-1jwseiw
Name your new sheet ARDebt9_19  
It will have these fields:
      A) The private / public colleges field
      B) Latitude and Longitude
      C) The 8 data fields we have used so far in ARDebt.
      D) A data dictionary

The ARDebt data has these fields:

Let’s Clean Up These Stupid Names in ARDebt9_19

3) Make Charts in Tableau

Import ARDebt9_19 into Tableau.

Create a chart of the overall median debt, median private college debt, median public college debt.

Create a chart median debt for graduates for public and private colleges

Create a chart median debt for discontinued students from public and private colleges

Revel in your nerd powers

Post Interactive Graphics to Tableau Public. 

–Post on Tableau Public the chart for median debt for graduates for public and private colleges 

–Copy embed code from Tableau Public from the Share icon in the lower right corner of your data visualization. Embed code looks something like this:

<div class=’tableauPlaceholder’ id=’viz1537795242033′ style=’position: relative’><noscript><a href=’#’><img alt=’Median Debt of Graduated Students in Arkansas, 2016Source: CollegeScorecard ‘ src=’https:&#47;&#47;public.tableau.com&#47;static&#47;images&#47;St&#47;StudentLoans-ARK20168-19-18&#47;Sheet1&#47;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&#47;Sheet1′ /><param name=’tabs’ value=’no’ /><param name=’toolbar’ value=’yes’ /><param name=’static_image’ value=’https:&#47;&#47;public.tableau.com&#47;static&#47;images&#47;St&#47;StudentLoans-ARK20168-19-18&#47;Sheet1&#47;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’ /></object></div> <script type=’text/javascript’> var divElement = document.getElementById(‘viz1537795242033’); 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>

–Post on WordPress.

1. Create a new post
2. Use Divi Builder, the Purple box above the formatting bar
3. Insert columns, pick a full row
4. Insert module, pick </> Code
5. Paste your Tableau Public embed code in the Content box
6. Scroll down, change the Admin Label to My Mind-Blowing Tableau Graphic (or something more humble). Save and Exit
7. Change Page Layout (upper right corner) to Fullwidth. Publish

Revel in your nerd powers

Homework, due 11:59 p.m. Tuesday, Sept. 25.

New data table: Examine the 2016 data and the data dictionary.

1. In addition to the fields we are already using (name, city, enrollment, median debt, student debt, graduate debt, private/public, etc) list the new fields you would use to build a new table that includes:

–Default
–Demographics
–SAT scores
–Special college designator (HBCU, Native American)
–First generation students

2. Build a new spreadsheet with these fields. Upload to Blackboard.

Assignment link

Agenda for Sept. 19, 2018

Private vs. Public Colleges: How Does The Debt Load Differ? 

Return of the Data Dictionary: Student Loan Dataset

https://collegescorecard.ed.gov/data/

All 1,826 columns explained here.
1) Find the field that distinguishes between public and private colleges:

https://collegescorecard.ed.gov/assets/FullDataDocumentation.pdf

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

2) Build a new spreadsheet from this raw data: AR2016ALL-1jwseiw
Name your new sheet ARDebt9_19  
It will have these fields:
      A) The private / public colleges field
      B) Latitude and Longitude
      C) The 8 data fields we have used so far in ARDebt.
      D) A data dictionary

The ARDebt data has these fields:

Let’s Clean Up These Stupid Names in ARDebt9_19

3) Make Charts in Tableau

Import ARDebt9_19 into Tableau.

Create a chart of the overall median debt, median private, median public college debt.

Create another one, public, private for graduates and discontinued students.

Revel in your nerd powers

Agenda for Monday, Sept. 17

Silicon Valley bails out big media

From Axios AM

In the latest legacy-media life preserver from West Coast billionaires, TIME magazine was bought by Marc Benioff — chairman, co-CEO and founder of Salesforce, the business software juggernaut — and his wife, Lynne.

“Time’s parent company, Meredith Corporation, announced … that it had agreed to sell the flagship publication of once-mighty Time Inc. to the Benioffs for $190 million in cash.” (N.Y. Times)
Spot the trend:

Jeff Bezos buys The Washington Post.
Laurene Powell Jobs’ Emerson Collective (an investor in Axios) takes a majority stake in The Atlantic.
Dr. Patrick Soon-Shiong, a biotech billionaire who is considered the richest man in L.A., buys the L.A. Times.
P.S. Edward Felsenthal, who’ll remain TIME editor in chief, said in a note to staff:

“The Benioffs will hold TIME as a family investment. It will have no connection to Salesforce.”
“One of the first challenges Marc and Lynne gave us is to think big, really big. Beyond the five-year plan, what will TIME look like in 2040? What will it mean to people decades from now?

Story Ideas

Discuss your ideas, post the best one for the group on this Google Doc.

A runner-up idea is ok.

Cleveland McGill Scale

Data Visualization Key Points

“Our limited brains are incapable of grasping reality in all its glorious complexity.”

What you design is never exactly what your audience ends up interpreting so reducing the chances for misinterpretation becomes crucial.

Dataviz Catalog

FT Visual Vocabulary

Dual Axis Chart

Institutions to Rows
Graduate Debt to Columns
Withdrawal Debt to Columns
Dual Axis Chart for the two debts
Display in Side by Side Bar Chart.

Edit Chart Title
Edit Labels – left click, edit alias
Rotate School Labels – left click, rotate label
Edit Y Axis Legend – left click, format. Scale. Numbers, Custom. No decimals

Comparing Data from Previous Years

FBI-2013-2014-Crime FOR CLASS 9-17-18-14d5xjv

Tips for Covering A Disaster

My friends in South Carolina and North Carolina are getting prepared to cover Hurricane Florence, which could be a major disaster (40 inches of rain expected in some places…). Read this checklist on how to prepare for covering such a disaster – lots of good tips in general for field reporting, ie, use pen and paper since you need to preserve your iPhone battery. Have a paper map because downed cell towers will render Google Maps useless. Etc. Bring a mobile power supply to plug into your car’s cigarette lighter to power your laptop. Basically, prepare to live in your car (pro tip, rent a car so you are destroying someone else’s ride, not your own, in the disaster zone).

https://www.poynter.org/news/heres-what-you-need-help-you-cover-hurricanes

This is a good mindset for field reporting in general – prepare for stuff to blow up and go wrong.

Resources: 

Continue with Tableau

 Resume with Student Loan Data

Chart: Schools with Student Loan Debt

–Add and format headlines

–Add annotations

–Add a Filter to Control All Cities on Worksheet

–Drag Cities to Filter

–Format Data in Dollars. Axis and Pane. Format. Currency Custom.

–Interactive Filter. Format as a drop down

…

Tableau Calculations

Calculations sample workbook

Calculations video

Introduction to Calculations Transcript

Table Calculation: Add a new column divides graduate debt into enrollment

–In Measures Data Tab, Left Click on GRAD_DEBT_MDN, Create Calculated Field

–Put in this formula: sum[GRAD_DEBT_MDN]/[UGDS]

–Rename This as: Grad Debt Per Capita Enrollment

Drag INSTNM to Rows
#Grad Debt Per Capita Enrollment to Columns

Format with a Title, add appropriate annotations.
Color the graphic, include labels.

Dual Axis Chart

Institutions to Rows
Graduate Debt to Columns
Withdrawal Debt to Columns
Dual Axis Chart for the two debts
Display in Side by Side Bar Chart.

Edit Chart Title
Edit Labels – left click, edit alias
Rotate School Labels – left click, rotate label
Edit Y Axis Legend – left click, format. Scale. Numbers, Custom. No decimals

Homework Due Saturday, Sept. 15, 11:59 p.m.

1. Build a chart with a new calculated field dividing graduate debt into enrollment

Visualize by school 
Format the X and Y axes, Label the rows with specific debt to enrollment (UofA is $xxxx),
Provide a headline and source.

2. Build a chart with a new calculated field dividing dropout debt into enrollment

Visualize by school 
Format the X and Y axes, Label the rows with specific debt to enrollment (UofA is $xxxx),
Provide a headline and source.

3. Build a Dual Axis Chart the Calculated Fields, Graduate Debt / Enrollment and Dropout Debt / Enrollment

Filter by Beauty Schools
Visualize by school 
Format the X and Y axes, Label the rows with specific debt to enrollment (UofA is $xxxx),
Provide a headline and source.

Export and upload the three image files and load to Blackboard. 
Write two story ideas to come from this data work in a Word file.