Syllabus
Registration via LPIS
Day | Date | Time | Room |
---|---|---|---|
Monday | 11/27/17 | 09:00 AM - 12:00 PM | LC.-1.038 |
Wednesday | 11/29/17 | 03:00 PM - 06:00 PM | LC.-1.038 |
Monday | 12/04/17 | 09:00 AM - 12:00 PM | LC.-1.038 |
Wednesday | 12/06/17 | 03:00 PM - 06:00 PM | LC.-1.038 |
Monday | 12/11/17 | 09:00 AM - 12:00 PM | LC.-1.038 |
Wednesday | 12/13/17 | 03:00 PM - 06:00 PM | LC.-1.038 |
Monday | 12/18/17 | 09:00 AM - 12:00 PM | LC.-1.038 |
Wednesday | 12/20/17 | 03:00 PM - 06:00 PM | LC.-1.038 |
Monday | 01/08/18 | 09:00 AM - 12:00 PM | LC.-1.038 |
Wednesday | 01/10/18 | 03:00 PM - 06:00 PM | LC.-1.038 |
Monday | 01/15/18 | 09:00 AM - 12:00 PM | LC.-1.038 |
Wednesday | 01/17/18 | 03:00 PM - 06:00 PM | TC.-1.61 |
Monday | 01/22/18 | 09:00 AM - 12:00 PM | LC.-1.038 |
Wednesday | 01/24/18 | 03:00 PM - 06:00 PM | LC.-1.038 |
Monday | 01/29/18 | 09:00 AM - 12:00 PM | LC.-1.038 |
Wednesday | 01/31/18 | 03:00 PM - 06:00 PM | LC.-1.038 |
In this hands-on programming course, participants will learn how to use basic and advanced spreadsheet techniques (in Excel and VBA) to present and analyze demographic data.
More specifically, students will embark on a journey to understand the evolution of population and human capital (with a specific focus on educational attainment) in a country of their choosing. We will then define future scenarios and project population and human capital into the future, first along the basic dimensions of age and sex, later by level of educational attainment. Once the model is ready, we will explore the policy implications of different assumptions.
- apply different demographic techniques using Excel and Visual Basic
- calculate and interpret life tables
- perform demographic projections applying cohort-component methodology
- learn how to work with and transform large demographic data sets
There will be a frequent back and forth between the instructor explaining a new concept or method followed by the students implementing this method on their computers. Students will be provided with input data, but will also have to search for their own data on the internet and download it for their calculations. In addition to the regular active participation in class and in group discussions, students will have to deliver reports in which they demonstrate how they could apply the new methods to new data.
Because of this style of intensive interactive teaching it is essential that all participants in the course attend all sessions.
1. Demographic country profile (30%); to be presented in class and submitted as a written report
2. Population projections (50%)
a. by age and sex (20%); replicating the UN projections for the country chosen, to be submitted in Excel-format, including a running VBA-macro (not a written report)
b. by age, sex, and education (30%); to be presented in class and submitted as a final report before the end of the semester
3. Classroom participation (20%)
Particiaption in Course I - Population, Human Capital and Policy
Prerequisites for Incoming Exchange Students nominated by WU partner universities:
Minimum requirements to attend this course:
• Economics (accumulated minimum of 16 ECTS credits) OR
• Social sciences (accumulated minimum of 16 ECTS credits) OR
• Mathematics / statistics / quantitative methods (accumulated minimum of 16 ECTS credits)
Proficiency in English is required. If you do not meet this requirement, we reserve the right to withdraw students from the course.
Back