Process

Become the expert for petroleum supply and demand data

1. You will create an EXCEL workbook with two separate spreadsheets within that workbook. You will produce two graphs, one will be a line graph and one will be a bar graph.
2. Make sure each spreadsheet has a title that refers to the function inside the sheet. Each tab should be a different color.
3. Print out each graph you produce. Make sure they have titles, legends and that each variable is identified.
4. You will research pertinent data from links provided and copy some of it into the EXCEL spreadsheets to use as raw data for your graphs. The instructions appear below:
   
   1. The US Energy Information Administration has provided a table of International Supply and Demand for Petroleum from 2004 to 2006.
      Click on link: http://www.eia.doe.gov/emeu/steo/pub/3tab.html to access this table.
      
   2. Copy this data using the copy function and paste it into an EXCEL spreadsheet. This spreadsheet will be for reference use only.
      Title this sheet 2004-2006 Supply and Demand Raw Data.
      
   3. Using the worksheet / cell reference function, use the data in the first spreadsheet to create a second summary spreadheet in the workbook to cut down all the detail to:
      
      1. Columns: Totals for Years 2004, 2005, 2006
      2. Rows: TOTAL Supply for US including territories, TOTAL Supply for OPEC and TOTAL World Supply , Demand for US, World Demand
      3. Format row 1 and column A to have descriptive titles. Use font size and color, shading and boxes to delineate between supply and demand, and the different years.
         
   4. Title this spreadsheet 2004-2006 Supply and Demand Summary. Produce a line graph on sheet two which depicts US demand vs US supply for each of the three years.
      
   5. Produce a bar graph on sheet two which depicts US demand vs. how much we purchased from OPEC to meet the past, current and proposed (future) demand.

1. Read two important articles which take opposing positions on the future of the world oil supply.
   
   1. Click on the following link for the Business Week article The New Economics of Oil
   2. Click on the following link for the National Geographic article The End of Cheap Oil
      
2. Create a graphic organizer on Inspiration that summarizes each article's main points. Make sure you include factual data sources. Use your judgement as to how creative you want to get with color and images that you may wish to import into your organizer. Reveiw concepts of supply and demand so you can put what you have read into perspective.

1. Read three of the following articles which explain geopolitical impacts on oil prices and delivery.

The Oil Card

Oil Market Analyses

Reuters - Why Are Oil Prices So High?

Roots of High Oil Prices

Persian Gulf Oil and Gas Export Fact Sheet

1. Create a graphic organizer on Inspiration that summarizes each of the three articles' main points. Make sure you include factual data sources. Use your judgement as to how creative you want to get with color and images that you may wish to import into your organizer. Reveiw concepts of supply and demand so you can put what you have read into perspective.