Today you will use information you learned from the Developed/Developing PowerPoint. You also will learn the basics of how to use Microsoft Excel. Excel is used to make spreadsheets, charts, and graphs.

The first thing I want you to do is to watch the tutorial video that I made. Go to the Video (V) Drive. Inside the Video Drive, I want you to click the following: Video>Osborne>Computer Tutorials>Semester 2 Excel Basics.

After you watch the video, you need to open Microsoft Excel. It opens the same way as Word and PowerPoint. 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 18 font for the headings and make them bold.

2. In the countries column there are 15 countries I want you to include. They are: United States, China, Japan, India, Iraq, Afghanistan, Egypt, Brazil, Mexico, Guatemala, Russia, South Africa, Germany, France, and United Kingdom.

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.

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.

6. For the Classification column, I want you to look at the data to determine whether you believe they are a developed country or a developing country. Write which one you believe each country is.

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	$15,000 – $30,000 or higher	$5,000 – $14,000	Below $5,000

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.

After you finish save it.  hr-last name-last name-Excel

Turn it in.