Edit mode active
Demography

Excel simulation

Demography

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

Bookmark()
418 Page hits
Published on 28.05.2018
2–3 lessons
German, French, Italian
ABU
DH
KV
BM
GYM
Action-oriented
In-depth study using teacher’s notes, video tutorials or training recommended.
Not yet registered?
Discover advantages
Do you teach economics at upper secondary school level or are you training to be a teacher? Secure your access to exclusive content and additional functions now.
Register
Sign in

Overview

Basic demographic concepts 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.

Didactics

Commentary for teachers

 Download
Download

Simulation

Excel simulation

 Download
The Excel simulation allows students to test how factors such as life expectancy or immigration influence population distribution. They can see graphically how the population pyramid changes if, for example, the birth rate falls.
Download

Worksheet

You must be logged in to use the sample answers.

Do you teach economics at upper secondary school level or are you training to be a teacher? Secure your access to exclusive content and additional functions now.
Register now
Sign in

Worksheet 1

 Download

Worksheet 2

 Download

Short presentation for worksheets 1 and 2

 Download

Sample answers

 Download

Registered users can download files.

Register now

Sign in

Background Information

‘Demography’ presentation

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

Additional information

Links

Ageing trends go global

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

www.swissinfo.ch

Demographics and markets: The effects of ageing.

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

www.ft.com

Szenarien zur Bevölkerungsentwicklung der Schweiz 2015-2045

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

www.bfs.admin.ch

Videos
Population pyramids: Powerful predictors of the future

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

Your Feedback

This function is only available to registered users.
Register now
Sign in

Share unit