Classifying USA Country & Capital Names 

    Code   Region      
1   north america  
2   central america
3   south america  
4   northern europe
5   eastern europe 
6   western europe 
7   southern europe
8   north africa   
9   west africa    
10  central africa 
11  south africa   
12  east africa    
13  west asia      
14  south asia     
15  se asia        
16  east asia      
17  oceania
Use these numbers to classify countries into their respective world region.

 Use this map to classify the countries into their respective world regions.
Can you find an error?!

Procedure:
1) Look at the USA country and capital data and then return to this page to see how to proceed.

You can use the procedure below OR use the method that PALS suggests.

2) These data appear as three columns; but in fact are really only one column in a spreadsheet. What to do to get the data ready for a spreadsheet, such as EXCEL?
EASIEST METHOD (A) When you are back on USA country and capital data web page, look at on the top menu of Microsoft Explorer:
to find this icon: , which is to the right of the printer icon. Click on the black down arrow () and you will see this: 

Select Excel and when a new window appears, click on Import and then OK. The data are automatically imported into Excel. Make sure that everything looks good and start analyzing the data! Go to Step 3) below

 

OLD METHOD: Place the cursor at the top left-hand corner of the table, click and hold down while you drag all the way down to the bottom of the table. Open WORD, a word processing program, and paste what you just copied into a new file.
Under Edit, select Replace and in the Find What box put two spaces (use the space bar at the bottom of the keyboard).
In the Replace With box, type: ^t (which stands for a tab which will separate the name column from the import data column).
Now hit the Replace All button.
Now in the Replace type in the Find What box ^t ^t and in the Replace With box, type: ^t.  Hit the Replace All button; repeat this until only one tab remains between each of the columns of information.
Copy the whole table.

Open EXCEL, a spreadsheet program, and click on one cell  in the top left-hand corner and paste what you just copied into a new file.
Under the Region Code add the unique world region number for each country.
Select all the columns with data at the top of the menu, shown as A, B, etc.

3) Select all the columns and under Data, select Sort and sort ascending by column A: region code. Now all the countries are grouped into their respective regions!
In a new column, label Region Total, to the right of the capital #, create formulas to add up the total number of countries and capitals by region.
Adding: e.g. =SUM(C2:C32) -- where SUM adds numbers from cell C2 to C32.
To make your tables, you will need to use this procedure:
Percent: e.g. =(G4/G$21)*100 -- where cell G4 is divided (/) by cell G21 (the $ assures that when you paste this formula into other cells, G21 will always be used) and divides (*) by 100.
If you don't know how to do these procedures and to create good-looking tables, learn how by getting help well before the project is due!.

Now, use this classified information to construct the two tables.