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.

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

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.

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.

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?’

Additional information

Links

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.

Share unit