Spreadsheet Activity: Developed vs. Developing Countries
Goal: After gathering the needed values on the topic, entering them into a spreadsheet and making the necessary calculation, students should be able to interpret the computed values into words in order to recognize the gap between developed and developing countries . This gap will be more clearly seen when students visualize the calculated value into pictures using charts and graphs.
Steps of the first activity:
1. I will introduce the spreadsheet to the students.
2. The spreadsheet contains the following columns:
Contry, Per Capita Income 2007, Total Personal Income (2007), Total Population (2007), Birth Rate (2007), Death Rate (2007) and Population Growth
3. We will choose the following countries to make our comparison: Egypt, Germany, Sudan and England.
4. You will have to compute the Per Captia Income of each country by doing the following steps:
* Go to this site where Country Profile and Demographics are presented
* Search for Total Personal Income, Total Population, Birth Rate and Death rate of the four give countries.
* Compute the per capita income in B3:B6 of each country by dividing "total income" by "total population"
* Compute the population growth rate in G3:G6 of each country by subtracting "birth rate" from "death rate"
5. After entering the collected and computed Data what can you tell about the numbers.
* What is difference between the Per Capita Income in the four countries?
* What do you expect the standard of living to be in those countries?
* What can you say about the population growth in those countries?
Making a Chart:
1. Copy the spreadsheet in another sheet and name it "chart".
2. Insert a chart by visualizing thePer Capita Income in the four countries.
3. What results did you get?
Steps of the second activity:
1. I will introduce the second spreadsheet to the students.
2. The spreadsheet contains the following columns:
Name of 4 Countries, two developing and two developed countries, Per Capita Income in Dollars, Price of one Starbucks Cup in local currency, Price of one Starbuck Cup in $, Number of Cups bought yearly in thos countries
4. You will have to convert the Price of one Starbucks Cup in $:
- You go to www.xe.com
- You give the local currency in the field
- You press "go"
- You get the equivelant amount in $.
- You give this value in Cell D3:D6
5. You will have to calculate the number of Starbucks Cups that can be bought yearly accoring to the Per Capita Income of those countries:
- You use the following formula: B3 (per capita income)/D3 (Price of a Starbucks Cup in $)
- You give the values in Cells D3:D6
6. After making the needed computations, what can you conclude from the calculated numbers?
Making a Chart:
1. Copy the spreadsheet in another sheet and name it "chart2".
2. Insert a chart by visualizing the Number of Starbucks Cups/year
3. What results did you get?
Goal: After gathering the needed values on the topic, entering them into a spreadsheet and making the necessary calculation, students should be able to interpret the computed values into words in order to recognize the gap between developed and developing countries . This gap will be more clearly seen when students visualize the calculated value into pictures using charts and graphs.
Steps of the first activity:
1. I will introduce the spreadsheet to the students.
2. The spreadsheet contains the following columns:
Contry, Per Capita Income 2007, Total Personal Income (2007), Total Population (2007), Birth Rate (2007), Death Rate (2007) and Population Growth
3. We will choose the following countries to make our comparison: Egypt, Germany, Sudan and England.
4. You will have to compute the Per Captia Income of each country by doing the following steps:
* Go to this site where Country Profile and Demographics are presented
* Search for Total Personal Income, Total Population, Birth Rate and Death rate of the four give countries.
* Compute the per capita income in B3:B6 of each country by dividing "total income" by "total population"
* Compute the population growth rate in G3:G6 of each country by subtracting "birth rate" from "death rate"
5. After entering the collected and computed Data what can you tell about the numbers.
* What is difference between the Per Capita Income in the four countries?
* What do you expect the standard of living to be in those countries?
* What can you say about the population growth in those countries?
Making a Chart:
1. Copy the spreadsheet in another sheet and name it "chart".
2. Insert a chart by visualizing thePer Capita Income in the four countries.
3. What results did you get?
Steps of the second activity:
1. I will introduce the second spreadsheet to the students.
2. The spreadsheet contains the following columns:
Name of 4 Countries, two developing and two developed countries, Per Capita Income in Dollars, Price of one Starbucks Cup in local currency, Price of one Starbuck Cup in $, Number of Cups bought yearly in thos countries
4. You will have to convert the Price of one Starbucks Cup in $:
- You go to www.xe.com
- You give the local currency in the field
- You press "go"
- You get the equivelant amount in $.
- You give this value in Cell D3:D6
5. You will have to calculate the number of Starbucks Cups that can be bought yearly accoring to the Per Capita Income of those countries:
- You use the following formula: B3 (per capita income)/D3 (Price of a Starbucks Cup in $)
- You give the values in Cells D3:D6
6. After making the needed computations, what can you conclude from the calculated numbers?
Making a Chart:
1. Copy the spreadsheet in another sheet and name it "chart2".
2. Insert a chart by visualizing the Number of Starbucks Cups/year
3. What results did you get?
