Module 1.7
Task 3 - Analysing Information


A.M.D.G.


You must carry out at least three of the following tasks but you may do more depending on time and your teacher's instructions.


Task 3A

Enter the following information in a new worksheet.

Country

Population Area Population Density

Enter formulae to calculate the population density for each country by dividing population by area.

Produce a chart to illustrate this information.


Task 3B

Enter the following information in a new worksheet with countries arranged by continent.

Continent Country Infant Mortality Birth Rate

Enter formulae to calculate Average Infant Mortality for each continent and Average Birth rate for each continent

Produce a chart to illustrate this information.


Task 3C

Enter the following headings in a new worksheet with countries arranged by continent.

Continent Country External Debt

Enter statistics for each country in your sample.

Enter formulae to calculate the average External Debt per continent

Produce a chart showing the average external debt Europe, Asia, Africa, South America and Others


Task 3D

Enter the following headings in a new worksheet with countries arranged by continent.

Continent Country Life Expectancy

Enter formulae to calculate the average life expectancy in each continent

Produce a chart showing the average life expectancy for Europe, Asia, Africa, South America and Others


Task 3E

Enter the following information in a new worksheet.

Continent Country Imports($) Exports($) Trade Gap

Enter formulae to calculate the Trade Gap for each country by subtracting Imports from Exports

Produce a chart to illustrate this information.


Task 3F

Enter the following information in a new worksheet.

Country Gross Domestic Product Military Expenditure % of GDP Spent on Military

Enter formulae to calculate percentage of GDP spent on Military by dividing Military Expenditure by GDP and formatting as a percentage.

Produce a chart to illustrate this information.


Task 3G

Enter the following information in a new worksheet.

Continent Country Literacy Rate Population Below Poverty Line Unemployment Rate

Enter a formula to calculate the average literacy rate and unemployment rate for each continent.

Produce a chart to illustrate this information.


Task 3H

Produce any other appropriate worksheet and chart based on the data collected previously.