Schweizerische Nationalbank
Edit mode active
Demography
New

Demography

«Excel simulation»

What impact will an ageing population have on Switzerland’s future ?

Basic demographic concepts, structural developments and pension funding are explained.

  • The topic is introduced in an initial worksheet.
  • Various population development scenarios are simulated in an Excel file; the second worksheet contains instructions for each simulation.
  • A computer with internet access is required for each group, as well as a projector.

0 Comments 23 Page hits
Other languages
German, French, Italian
Prior knowledge of teacher
Training recommended
Lesson duration
2–3 lessons
Updated
28.05.2018

Keywords
AHV, Baby boom, Life expectancy, Net migration, Old-age dependency ratio, Pension, Population pyramid

Credits

Concept
iconomix, in cooperation with Swiss Federal Statistical Office (SFSO)

Author of simulation and presentation
Jacqueline Kucera und Raymond Kohli, Swiss Federal Statistical Office (SFSO)

Author of task sets and commentary for teachers
iconomix

Design of printed material
clearbrand gmbh, Zurich

Translation of simulation and presentation
Swiss Federal Statistical Office (SFSO)

Translation & proofreading
SNB Language Services

Commentary for teachers (PDF, 54 KB)
Unit information

Documents

Excel simulation
Excel simulation
     
Short presentation for worksheets 1 and 2
Short presentation for worksheets 1 and 2
     
Worksheet 1
Worksheet 1
     
Worksheet 2
Worksheet 2
     

Background information

‘Demography’ presentation

Presentation by Jacqueline Kucera and Raymond Kohli (SFSO) on ‘What impact will the ageing of the population have on Switzerland’s future?’

‘Demography’ presentation

Presentation by Jacqueline Kucera and Raymond Kohli (SFSO) on ‘What impact will the ageing of the population have on Switzerland’s future?’

     

Video zum Thema

Video
Ted ED. Population pyramids: Powerful predictors of the future - Kim Preshoff
()

Additional information

Ageing trends go global - www.swissinfo.ch/

Swissinfo. A series of graphics helps to explain the global phenomenon of aging population and its many implications. (08.07.2018)

Demographics and markets: The effects of ageing. - www.ft.com/

Financial Times. Will the rising number of retirees cause inflation and help lift the economy? (25.10.2016)

Szenarien zur Bevölkerungsentwicklung der Schweiz 2015-2045 - www.bfs.admin.ch/

Swiss Federal Statistical Office. An overview of the scenarios for population development in Switzerland from 2015-2045. Only available in German or French.

× Thank you for your comment. It is awaiting moderation.

Comments

Write comment (login required)

This page has not yet been commented on.

Write the first comment.