Parallel Computing in the Computer Science Curriculum > Workshops > SIGCSE 2012 > SIGCSE 2012 > World Population Activity I: Excel

World Population Activity I: Excel

Activity and Starting Point page by R.M. MacKay. Clark College, Physics and Meteorology.

This resource received an Accept or Accept with minor revisions rating from a Panel Peer Review process

These materials were reviewed using face-to-face NSF-style review panel of geoscience and geoscience education experts to review groups of resources addressing a single theme. Panelists wrote reviews that addressed the criteria:

  1. scientific accuracy and currency
  2. usability and
  3. pedagogical effectiveness
Reviewers rated the resources:
  1. Accept
  2. Accept with minor revisions
  3. Accept with major revisions, or
  4. Reject.
They also singled out those resources they considered particularly exemplary, which are given a gold star rating.

Following the panel meetings, the conveners wrote summaries of the panel discussion for each resource; these were transmitted to the creator, along with anonymous versions of the reviews. Relatively few resources were accepted as is. In most cases, the majority of the resources were either designated as 1) Reject or 2) Accept with major revisions. Resources were most often rejected for their lack of completeness to be used in a classroom or they contained scientific inaccuracies.

This page first made public: Jul 19, 2005

This material was originally created for Starting Point:Introductory Geology
and is replicated here as part of the SERC Pedagogic Service.


In this introductory activity students use Excel to explore population dynamics using the Logistic equation for (S-shaped) population growth. This activity is primarily intended as an introductory tutorial on using Excel. As a follow-up, Activity II continues this tutorial and compares populations predicted by the Logistic equations with those from UNEP.

Learning Goals

In this first Activity students are carefully guided through using Excel to:

Context for Use

This is a generic introductory tutorial on using Excel with a focus on world population. This topic was chosen as it is appropriate for many introductory geoscience courses. This is a good activity to start with if you intend to use Excel in your introductory course as either a lab tool or for modeling activities.

Description and Teaching Materials

Here we give:

Figure 1. Predicted (modeled) populations for imaginary planet Xox for different initial growth rate values r.

Figure 2. Predicted (modeled) population growth for imaginary planet Xox for different initial growth rate values r.

Teaching Notes and Tips

This activity will take students about 2 hrs to complete. Students should be able to work through this activity at home or in a computer lab will no supervision. Students more familiar with Excel can work through this activity more quickly.


Grading the completed activity sheet provided can be used as an assessment of student understanding. The future success of students on other Excel related activities is also another useful assessment tool.

An Excel Answers Document is provided above with several sheets representing different levels of completion for this activity. This can help instructors:

References and Resources

In World Population Activity II, students compare actual data/projections of World Population from data files generated at UNEP.

The Resources for Earth Science and Geography Instruction site has several interesting links related to World population (more info) .

Resource for learning Excel

Other Background information The solution to the logistic differential equation




Not only is it of interest here but is very popular in beginning discussions related to Chaos theory. Measuring Chaos: a hypertextbook (more info)