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
Liz Green Basic Percent Change R HW Nov. 7
Nov. 7 Kris Smith Officially Reveling in Her Nerd Powers
Katie Beth Nichols Nov. 5 Assignment
Kris Smith’s FIRST ATTEMPT at Reveling in Her Coding Nerd Powers
Nov. 5 HW Samantha Van Dyke
Caitlin Lane 11.6.18 First R Homework
Nov. 5 HW GL
Liz Green 11-5 First R Homework
Nov 7 Day 22
Agenda for Wednesday, Nov. 7
-Building Basic Charts in R using your table from previous assignment
-Review R script
-Review video lecture
-Check Andrew Ba Tran video for reference
-Review reference materials
Class Assignment and Homework
Read this R Script and follow along with the video lecture
Task 1: Create an R script with the commands used to build these charts, including
loading of libraries, setting working directory, loading files
Task 2: Create a chart illustrating the percentage change for the top 10 schools, 2012-2016.
Export a .png file
Task 3: Create a chart illustrating the percentage change for the bottom 10 schools, 2012-2016
Do not chart Null Values! Your chart must have data for 10 schools
Export a .png file
Task 4: Upload the two charts in .png files and the R script to WordPress
by Thursday, 11:59 p.m. 30 points
Important Reference Materials
Nov 5 Day 21
Nov 5, Day 21 Agenda
–Joining Tables in R
–Read materials, view video
–Read the R script and follow instructions to build two tables using the CollegeScorecard data from 2011 and 2016.
JOINING Data Frames in R-11-5-18
Create and post your R script with the solution and the combined table in a .csv file on WordPress by 11:59 pm Tuesday. 30 points
Class Assignment and Homework for Monday, Nov. 5
JOINING Data Frames in R-11-5-18
Use these sample tables for exercise
Upload on WordPress by 11:59 p.m. Tuesday:
Your merged 2012-2016 data table as a .csv file with the percentage change calculation field
Your R script file used to create the table
For Reference, here is the script we used in class last week