Finish Asia Scavenger Hunt
Very few groups have finished this yet. Today, I want you to finish the Asia Scavenger Hunt assignment before moving onto the Southeast Asia Economy assignment.
Southeast Asia Economy
In our next assignment we are going to look at the economy of Southeast Asia. You will use Google Sheets to complete the assignment.
Go to Google Classroom to access the template.
If you don’t remember how to use Google Sheets, you can watch the tutorial video that I made. Go to the Google Drive>Team Drives>Videos>Osborne>Computer Tutorials>Google Sheets
I want you to create a document that has:
1. 5 Headings- Countries, $GDP, Life Expectancy, Literacy Rate, and Classification. I want you to use size 20 font for the headings and make them bold.
2. In the countries column there are 15 countries I want you to include. They are: India, Pakistan, Nepal, Bhutan, Bangladesh, Sri Lanka, China, Mongolia, North Korea, South Korea, Philippines, Singapore, Thailand, Vietnam, and Japan.
3. In the $GDP column, you need to use this link to find the GDP per capita in each of the countries. Type the GDP for each country in the column. Make sure you use dollar signs. If you want to you can do what I did in the video and highlight the column and change the numbers to currency instead of typing the $ sign. I want whole numbers. I don’t want your decimal point to show cents. Ex. $32,ooo not $32,000.oo
4. Use this link to find the life expectancy rates for each country. Round each number so there aren’t any decimal points. They should all be whole numbers.
5. Use this link to find the literacy rates for each country. Use the literacy rates for the total population. Round each number so there aren’t any decimal points. They should all be whole numbers. If you have trouble finding some of the countries you can use this link as another resource. Just hover the mouse over the country you want to find out about and it will show you the literacy rate. Also make sure you change the column’s number type to “Percentage”.
**To make it easy on yourselves, highlight the cells and format them as a percentage and 0 decimal places BEFORE you type the numbers in the cells for Literacy Rate. If you type the numbers first, you will have to manually go in and delete extra zeros from your cells**
6. For the Classification column, I want you to look at the data to determine whether you believe they are a developed, developing, or a middle income country. Write which one you believe each country is.
7. After each column is finished, make a 2-D Column Chart for GDP. You will do it the exact same way that I did in the video.
8. Make a 2-D Bar Graph for Life Expectancy. You will do it the exact same way that I did in the video.
You can use this chart as a guide to help you determine the classification.
|
DEVELOPED (rich)
|
MIDDLE-INCOME
|
DEVELOPING (poor)
|
LIFE EXPECTANCY
|
M – 70 and above
F – 80 and above
|
M – 60’s & 70’s
F – 70’s
|
M – below 60
F – below 70
|
INFANT MORTALITY
|
Below 10
|
11 – 25
|
Above 25
|
LITERACY RATE
|
97% or above
|
80% – 96%
|
Below 80%
|
PER CAPITA GDP
|
Above $20,000
|
$8,000 – $19,999
|
Below $8,000
|
After you finish, turn it in.