Congratulations on taking the leap toward becoming a professional software developer by applying to Ada Developers Academy. Writing code is a fun and ever-changing career, and you'll enjoy the benefits of being in one of the most sought-after fields (job flexibility, choice of employers, better pay - the list goes on).
|February 20, 2018||Admissions opens at noon PST.|
|March 13, 2018||Admissions closes. Only applications submitted by 5 pm PST will be considered.|
|March - April 2018||If you are invited past Phase 1, interviews will occur from March through April.|
|May 21, 2018||Decision release.|
|July 16, 2018||Jumpstart live sessions for admitted students begins.|
|August 5, 2018||Class instruction begins.|
Note: you're not expected to have previous experience with Markdown or GitHub. Part of the application process is demonstrating your ability to learn and apply new technologies.
For this portion of the application, you will answer 4 or 5 short essay questions about yourself.
NOTE: You must limit your answers to 250 words for each question.
For this portion of the application, you will analyze some raw, publicly-available data.
The data set that you will need to analyze come from the Federal Student Aid office's Title IV Program Volume Reports. Specifically, you will examine the Loan Volume from the Direct Loan Program from Quarter 4 of academic years 2016-2017.
The dataset, in CSV format, along with a README file that includes definitions for each field can be downloaded from our Google Drive. To open these files you are welcome to use Excel, the free alternative LibreOffice, or any other program that opens CSV files.
If you prefer to work with Google Sheets, please use this link. You will need to make your own copy in order to edit and organize the data to answer the questions below. You’ll be working with the “Quarterly Activity” sheet. The “Field Definitions” are provided in the third sheet.
If you cannot open the file on your computer, you should try a local public library. If you have exhausted all options, please email email@example.com.
There are five questions related to the above datasets, in order of increasing complexity and ambiguity. For each of the five questions you will need to provide both your answer and an explanation of your process, assumptions, choices, and reasoning.
For each question, we are looking for logical argument to support your answer and to understand your approach. For all questions we ask that you keep your explanation concise (under 700 words) as our reviewers have a large number of applications to process. Please specify which tools and resources (Google Sheets, Wikipedia, search) you used when working through these questions.
Your answers must be provided in numerical form.
Before beginning to work on any of the following questions first exclude all rows where:
What was the maximum number of loans originated for DL Grad Plus?
How many schools had disbursed a total of greater than or equal to $707,300 and less than $800,895 in loans for the time period reported on the spreadsheet provided (“Quarterly Activity” only)?
Consider the sum of expected total loan amount if the loans were fully disbursed for each school in this Quarter. For how many schools was this amount greater than $20,000,000?
Amongst the schools that are considered part of Bellevue, WA (according to zip codes on http://zipcode.org), what was the largest number of recipients within a school for either DL Unsubsidized Undergraduate or DL Unsubsidized Graduate loans? Ignore unavailable data i.e. data with ‘-’ value.
Consider the state in which the last Olympics was hosted in the USA. What is the sum of the expected total loan amount if the loan is fully disbursed for DL Subsidized loans in the public schools in this state in Q4 of 2016-2017, based on the data provided?
Consider all the private nonprofit schools in WA state where the name of the school starts with either “s”, “u”, “v” or “w”. For these schools, consider the expected total loan amount if the loan is fully disbursed for unsubsidized undergraduate studies. Exclude all schools where the unsubsidized undergraduate loan amount is not available i.e. “-” or 0. What was the median value?
Note on median: Median is defined as the middle value among all the values being considered. E.g. if the values being considered were 2, 9, 5, 7 and 15. Then, the median of these values will be 7. This is because there are exactly two values smaller than 7 - these are 2 and 5, and exactly two values greater than 7 - these are 9 and 15.