Archive for quantitative methods

I’m Great at Math(s) — What Does SIPA Have for Me?

Thanks to David Wickland MIA ’19 for this post in response to a topic submitted by Nicole H. Submit your idea for a blog post here.

Taking a more quantitative focus at SIPA can mean a lot of different things: There’s the underlying conceptualization of quantitative analysis taught in Quant I and Quant II, the more direct applications covered in Evaluation and Economic Development classes, the academic literature analysis of the various Quant III classes, and the programming focus of others.

They’re all important. They’re all interesting. You might not want or need to do all of them, but there’s a lot to choose from at Columbia.

I’m a 2019 SIPA grad who obtained an MIA with a Concentration in Economic and Political Development and a Specialization in Advanced Policy and Economic Analysis. I studied electrical engineering in undergrad and had worked as a data analyst prior to SIPA, so I came in with a decent quantitative background. But I had little-to-no knowledge of how quant could be applied in the social sciences.

One of my goals at SIPA was to figure out how to go about using any of this stuff, and taking as many quantitative courses as possible seemed like a good way to explore different applications.

Quant I

I never took Quant I, so I’m going to gloss over it a bit, apart from noting that regardless of how you feel about it, don’t let it play too much into your decisions on other quantitative classes. It covers a lot of ground and can be a bit overwhelming, but the later courses tend to take a milder pace and help drive home the topics covered in the first semester.

Quant II

This brings me to Quant II, which I cannot recommend enough. This is probably the second quant class most people will take (although exactly what constitutes a quant class is debatable). Quant II essentially picks up where Quant I leaves off, delving into the most widely used regression methodologies to give enough understanding to follow most papers and studies one would come across. I don’t want to claim that everyone loves Quant II, but a lot of people who thought they would hate it wound up loving it, and I think it’s probably the best course to judge if this is something you like. It gives a more practical understanding of the material and helps reaffirm everything in Quant I.

(Just to note, there are currently two Quant II professors, Alan Yang and Cristian Kiki Pop-Eleches. They’re both great, and their classes are structured slightly differently. In Alan Yang’s, the last month is spent on a data analysis project that helps ground some of methods in more practical usage, while Kiki’s ends by covering some additional methodologies which are also useful. If you take Alan Yang’s, the skipped methodologies are covered in Applied Econometrics and Economics of Education Policy;  if you take Kiki’s, Harold Stolper’s Data Analysis for Policy Research and Program Evaluation is essentially a full semester version of the data project you would have done, so neither is entirely a missed opportunity.)

Quant III

While the Quant I – Quant II track has clear continuity, classes after these focus more topically and can mostly be taken in whichever order one likes. The term “Quant III” gets thrown around a lot, and it refers to a group of topically different classes which require Quant II, not a single specific class. In no particular order, these are some thoughts on the Quant III classes available:

  • Applied Econometrics: This covers a lot of the loose ends and more in-depth examinations coming out of Quant II, and is probably the most direct follow-up to that class. It is very technical compared to Quant II and less immediately practical. Quantitative Methods in Program Evaluation and Policy Research, which was not offered during my second year, is supposedly similar but more applied.
  • Economics of Education Policy: If you are interested in education you will love this class. It explores different aspects of education and the research surrounding them, with general open discussion of the papers, their relative merits, and their implications. Very highly recommended.
  • Time Series Analysis: This is perhaps the most technical Quant III class, and it has a fairly narrow focus on financial markets and predictions. For students with good quantitative and programming skills and are interested in how markets can be tracked and the underlying principles of time series’, this class is for you. If that’s not your cup of tea try one of the other classes instead. (Note: This class is taught in R, and is the only class at SIPA to do so to my knowledge. The basics are explained and the coding is not particularly intensive, but it can make things difficult. At the same time R is wonderful and everyone should learn R.)
  • Data Analysis for Policy Research and Program Evaluation: Whether or not this is a Quant III class is debated, but it does require Quant II and covers quantitative material, so it’s at least related. Full disclosure, I never took this class, but I generally heard positive things about it. The course is a semester long data analysis project, and works to build a deeper understanding of STATA both in the data analysis and data visualization fronts. I generally heard excellent things about it, and would recommend for anyone who wants to learn more applied STATA.

Thoughts on other Quant classes of interest:

  • Computing in Context: This was good introduction to Python as a language. The applications aren’t particularly quant-oriented, but if you’re looking to learn Python this is probably the best way to go about it.
  • Program Evaluation and Design: Not a quant class per se, but I feel that most quant classes at SIPA are focused on research and evaluatory studies. This class (which I did not take but have heard great things about) can help fill in more around how data was collected and why that specific question was asked or that specific information was gathered.
  • Machine Learning for Social Sciences: Taught in Python, this Quantitative Methods in the Social Sciences (“QMSS”)** class goes into the fundamentals of machine learning and its applications. For any SIPA students interested in ML or AI, this is probably one of the most directly applicable courses available, although QMSS students get priority and it tends to fill quickly.
  • Data Mining for Social Science: Taught in R, this QMSS course is the main Columbia class on data mining and it’s supposedly fairly good as an introduction. This is another class I never took, but what I heard from other SIPA students is that it was interesting, though not particularly in depth.
  • Statistical Computing with SAS: This is a Mailman School of Public Health course on SAS. I knew one person who took this and they seemed satisfied. It sounds similar to Computing in Context except for SAS and with more of a public health focus. SAS as a language isn’t nearly as common as STATA/R/Python, but it’s still useful to know. It’s also quite different from the other stats languages and can be harder to learn on your own.
  • Research Techniques and Applications in Health Services Administration: This is somewhat similar in design to Economics of Education Policy except it is at Mailman, a bit less technical, and focused on Public Health. If health is a particular interest area and you want to know more about the quantitative studies surrounding different aspects of it, definitely try to get into this.

If you’re interested in SIPA’s quantitative program, I recommend researching and asking around about the courses you want to take. For example, talk to current students who may have taken the courses you’re interested in, speak with faculty members such as Kiki and Yang, and take a look at the course evaluations on a specific class as well as old syllabi.

I talked a lot with Kiki about what courses I was looking for, and he gave me a holistic view of the Quantitative program and an overview of the course’s strengths and weaknesses. I found his guidance valuable, and coupled with my research on the courses I wanted to take, I was able to craft the quantitative experience I was looking for at SIPA.

**QMSS is housed in the Graduate School of Arts and Sciences. SIPA students can take courses through QMSS by cross-registering, as well as obtain a dual-degree through its program. For more information about QMSS please visit their website here. For information about Columbia Dual-Degrees, visit our website here.

Top 10 Application Tips #4 – Résumés

This is the fourth entry in our “Top 10″ list to assist you with understanding the process of submitting your admission application to SIPA.  This entry is focused on advice regarding our résumé requirements.

The first thing to take note of is that we require applicants to submit two separate résumés.  This may seem strange at first but I believe this entry will clear things up.

Traditional Résumé

The first résumé is no surprise.  You could refer to this as your “traditional” résumé and everyone applying probably has had a working résumé for some time.  A traditional résumé includes, but is not limited to, information such as:

  • Positions held (employment and internships)
  • Academic degrees and other academic achievements
  • Volunteer, public service, political work completed
  • Memberships in honorary societies and awards for service or leadership
  • Extracurricular activities and particularly if an MIA applicant – foreign travel undertaken, including purpose and length of stay.

As has always been the case, with this traditional résumé we do not recommend trying to keep it to a single page in length.  A one page résumé is more aligned with applying for a job.  This résumé is for graduate school consideration and the Committee encourages applicants to list all relevant information and to not use a small font or extended margins in an attempt to cram a great deal of information into a very small space.  A typical résumé in this format submitted to SIPA is three to four pages in length.

Put another way – we like white space.  Committee members have to read several hundred applications and small fonts and cramped formats are very difficult on the eyes.  When it doubt, use 12 point font and normal margins – the Committee will thank you for it.

On a final note, we do not recommend that applicants use graphics or non-standard fonts.  Let the content of your résumé speak for you.  The font chosen should be easy to read and graphics (other than bullets and bold face) do not enhance the readability of a résumé.  Common fonts that are easy to read include Arial, Calibri, and Tahoma.

Quantitative/Language Résumé

The second résumé will focus exclusively on an applicant’s background with quantitative methods and language learning/ability.

Quantitative Methods

The core curriculum at SIPA includes required coursework in economics, statistics, and financial management.  The Committee is therefore quite interested in the quantitative aptitude of applicants to our program.  This most typically includes coursework and/or professional experience related to mathematics, statistics, and economics.  Also of note  can be quantitative experience as it pertains to areas such as science or engineering.

Unfortunately, academic transcripts rarely provide in depth descriptions of the actual content of coursework completed.  For example, a class labeled as “Principles of Economics” on a transcript provides little detail on how much focus was placed on the use of quantitative methods.  And with the large number of international applicants to SIPA, often times transcripts translated into English will just list a class as “Mathematics” thus giving the Committee little information on the actual content/level of math studied.

Providing the opportunity for applicants to list detailed information pertaining to quantitative preparation/experience will allow for better explanations of past academic and professional experience.  The goal is to be able to allow applicants to list full descriptions of courses included in a course catalog or in the syllabus used in a class.

Language Learning/Ability

Proficiency in a second language is a graduation requirement of the MIA program but is not a requirement of the MPA program.  Proficiency is defined as the ability to use a second language at an intermediate level.  Academically this is defined as the ability to achieve a grade of “B” or better in an intermediate level 2 language course.

Incoming  MIA students who speak English as a native language will be tested in a second language of their choice upon entering into the program.  Due to the intensity of the MIA program at SIPA, it would be quite difficult for an applicant with no previous language study to achieve intermediate level proficiency in two years of study.  The Committee therefore wishes to see at least elementary level proficiency in a second language when evaluating an MIA applicant for admission.

If an incoming native English speaker passes the proficiency exam administered shortly after beginning the program, no additional language study is required.  If the grade achieved on the exam is not sufficient, to prove proficiency a grade of “B” or better must be achieved in an intermediate level 2 language course during the time at SIPA in order to graduate.

For MPA students that speak English as a native language, second language learning is optional so it is not required to include language learning information in the second résumé.  However, if an MPA applicant does have experience in a second language we encourage them to provide this information because it provides us with additional information on your background. 

Please do note that there is one exception to the language requirement for the MPA program.  If an MPA applicant chooses the Economic and Political Development concentration, second language proficiency is a requirement just like in the MIA program.

For applicants that do not speak English as a native language, the second résumé will provide an opportunity to elaborate further on time spent studying English and other languages.  This can of course include academic study but can also include additional information not included in transcripts or test scores such as time spent living in English speaking environments.

Details on Quantitative/Language Learning

The second résumé is meant to provide applicants with the ability to provide detailed information which can include:

  • Name/level/grade/institution pertaining to classroom courses.
  • For classroom courses, a description of the course and specific learning objectives (best done by providing a description from a course catalog or a syllabus that was used for the class).  If it has been a number of years since you graduated, a description from a current course catalog found on your school web site can suffice.
  • Examples of working knowledge of the subject matter as demonstrated in academic or professional settings.
  • Tests taken and grades/scores achieved.
  • Specific certificates earned.
  • In the case of second language learning, the following information is useful:
  1. Information on time spent in a foreign country where the language is spoken.  Or, if the second language was spoken in your home country please provide the context (i.e. did you grow up in a home where a second language was spoken but your academic training was in another language?).
  2. Details regarding professional/volunteer/personal use of the language.
  3. Specific details/examples regarding writing, reading, speaking, and listening ability.

One question you might have is, “If the course is listed on my transcripts or noted in another part of my application, is it necessary to include it in the Quantitative/Language  résumé?”

The answer is yes.  It is okay to be redundant or to include the same information that might be listed in another part of the application in this section.  Seeing the information twice, but in more detailed format in the résumé portion, is what the Committee is seeking to achieve.

You can view samples of this résumé by clicking here.  Do note that the sample is only a guide.  The level of detail you wish to include is entirely up to you.

If you have been out of school for a while, do not feel compelled to spend hours and hours trying to search for old syllabus or text book titles/authors.  The point of the résumé is not to put you through some sort of time trial, it is meant to provide information on the core learning from the course/experience.  The example résumé was borrowed from an applicant that applied to SIPA while still in college, and is meant to only be a sample.  Simply provide as much information as you can and you will be fine.

"The most global public policy school, where an international community of students and faculty address world challenges."

—Merit E. Janow, Dean, SIPA, Professor of Practice, International and Economic Law and International Affairs

Boiler Image