Jim Whitney Economics 311

Friday, March 30, 2012

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:

  1. Insert a new worksheet into your country spreadsheet.
  2. Right-click the tab at the bottom of your new worksheet and rename it "task3" (lower case, with no spaces).
  3. Open the file aa_template.xls in the S:\Economics\Ec311\countries\2012_spring folder -- the same folder your country file is located in.
  4. 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.
  5. Select "Copy".
  6. Go to your country spreadsheet, and right-click the top-left cell in your "task3" worksheet --this should shade your entire "task3: spreadsheet"
  7. 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.
  8. Click any cell of your worksheet, then Select "Edit > Replace"
  9. 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.
  10. 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.)
  11. Select "Replace All".
    --Result: The worksheet numerical values in the yellow cells should now display values calculated with your own country's data.
  12. Now close the "aa_template.xls" spreadsheet file. (do not save any changes to the template file).
  13. Complete the remaining information in the blank yellow cells in the "task3" worksheet.
  14. Save your file back to the S drive.

Part 2: WTO status

  1. 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
  2. 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.
  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.