Exploring your Country: Extra Credit Task 3
Trade policy information
Basic goal: Gather information about your country's trade policy status
and progress.
Details:
Part 1: Tariff rates:
- Insert a new worksheet into your country spreadsheet.
- Right-click the tab at the bottom of your new worksheet and rename it
"task3" (lower case, with no spaces).
- Open the file
aa_template.xls in the
S:\Economics\Ec311\countries\2012_spring folder -- the same folder your
country file is located in.
- Right-click the top-left cell of the "task3_template" worksheet (the
cell above Row 1 and left of Column A)
--this should select and shade the entire worksheet.
- Select "Copy".
- Go to your country spreadsheet, and right-click the top-left cell in
your "task3" worksheet
--this should shade your entire "task3: spreadsheet"
- Select "Paste"
--the worksheet from the "task3_template" worksheet should now appear in
your own country's "task3" worksheet. Note: Do not close the "aa_template.xls"
spreadsheet yet.
- Click any cell of your worksheet, then Select "Edit > Replace"
- Copy the following string, including the brackets, into the "Find what" window: [aa_template.xls]
Note1: You can also just copy and paste cell E3 into the "Find what"
window.
Note2: Be sure that the "Replace with" window is blank.
Note3: Be sure that either none of the cells or all of the cells of the
worksheet are selected.
- Select "Find next" and then "Replace" to be sure that the find/replace works. (If not, let me
know before proceeding to the next step. Just save your file back to the S
drive for now.)
- Select "Replace All".
--Result: The worksheet numerical values in the yellow cells should now
display values calculated with your own country's data.
- Now close the "aa_template.xls" spreadsheet file. (do not save any changes
to the template file).
- Complete the remaining information in the blank yellow cells in the
"task3" worksheet.
- Save your file back to the S drive.
Part 2: WTO status
- Open the course "Task3"
worksheet for the course spreadsheet which you can access at the following link:
https://docs.google.com/a/oxy.edu/spreadsheet/ccc?key=0Aid1zCqWD19_dFczcXJESWNTR1lDeEVVMWt6Q2djd2c#gid=5
- Go to the WTO Members and Observers web site at:
http://www.wto.org/english/thewto_e/whatis_e/tif_e/org6_e.htm
and enter the membership date for your country in column D of the course
worksheet. If you country is not a WTO member, note that in column D and
skip step 3.
- Click your country's name on the Members and Observers web page and
enter the number of "Dispute cases involving..." your country in columns E,F,
and G of the course worksheet.