Coursera Course Presentation

Developing Data Products

Amit Nagar
Final Project

Introduction

This presentation accompanies the Shiny applicaiton that was developed as part of the Coursera "Developing Data Products" course. The application depicts a simple scenario of eye-balling the school enrollment versus graduation rate data.

Scenario

The shiny application examines the school enrollment data to see the number of graduates coming out of each school listed in the data set. It allows the user to examine the dataset by dividing it into 3 pre-specified intervals for school enrollment:

  1. under 500
  2. between 501 and 1000
  3. over 1000

The school data is obtained from the open data portal of the San Jose Unified School District (SJUSD).

School Enrollment Quiz

Which HS school has the highest number of graduates?

  1. Gunderson HS
  2. Abraham Lincoln High
  3. Pioneer High
  4. Leland High

The slidify application can help answer the above question

Graduation Data

The table below shows the data for ALL the school under SJUSD who have had graduates in the reported period. It is notres tat the graduation data most likely pertains to ONLY the graduating class whereas the enrollment is likely shown for the entire school (9th - 12th grades). Please also note, r code snippet is not shown here.

##                                     School Enrollment Graduates
## 1                     Abraham Lincoln High       1826       328
## 7                            Broadway High        258        65
## 10 Community Career Academy (Continuation)         13         9
## 11            Downtown College Preparatory        430        58
## 17                          Gunderson High       1165       185
## 24                             Leland High       1754       415
## 26              Liberty High (Alternative)        316       131
## 27                       Lincoln Plus High         40         3
## 31                     Middle College High         31        22
## 33                            Pioneer High       1563       337
## 34             Pioneer Plus (Continuation)         40         4
## 40                           San José High       1126       214
## 51                        Willow Glen High       1659       330

Conclusion

  1. The SJUSD data provides graduation information only for high schools.
  2. The data set lists a number of elementary and middle schools which can virtuallybe ignored when answering the central question posed in this deck.
  3. It is interesting to note that the total enrollment in San Jose high school vary sharply with schools that have less than 500 and those that have more than a 1000 students.