Copy All the Data Into a New Excel Spreadsheet

Procedure:

Go to the website

You should see data of Carbon Dioxide Emissions for a variety of sources (total fossil fuels, liquid fuel, solid fuel, cement production, gas flaring, and Per Capita CO2) over many years.

Year / Total CO2 emissions from fossil-fuels (million metric tons of C) / CO2 emissions from gas fuel consumption / CO2 emissions from liquid fuel consumption / CO2 emissions from solid fuel consumption / CO2 emissions from cement production / CO2 emissions from gas flaring / Per capita CO2 emissions (metric tons of carbon; after 1949 only)
1751 / 3 / 0 / 0 / 3 / 0 / 0
1752 / 3 / 0 / 0 / 3 / 0 / 0
1753 / 3 / 0 / 0 / 3 / 0 / 0
1754 / 3 / 0 / 0 / 3 / 0 / 0
1755 / 3 / 0 / 0 / 3 / 0 / 0
1756 / 3 / 0 / 0 / 3 / 0 / 0
1757 / 3 / 0 / 0 / 3 / 0 / 0
1758 / 3 / 0 / 0 / 3 / 0 / 0
1759 / 3 / 0 / 0 / 3 / 0 / 0

This data should go up to the year 2003.

Copy all the data into a new Excel spreadsheet.

Make a graph of the data as follows:

1.Select the chart wizard

2.Drag the area with your data till all the data is highlighted (don’t forget the per capita use column, it will not have any numbers till 1949).

3.Select the chart type

4.Check that data is in columms

And see that the print range is okay!

5.Click “Next” and fill in Title and X&Y axis labels

6.Click on the legend box and change the font to a smaller size like 9 pt font.

7.Double click the Per Capita Carbon Dioxide line (blue) . Locate the axis tab at the top and click on secondary axis and click “OK”

8.You may want to double click on the X axis numbers and resize them too.

9.Bask in the glory of your graph (you may want to resize the graph by dragging the corner?)

10.Use your graph to help you answer some of the questions below after saving your excel file! Print a copy of your graph!!!!

Answer the questions below, and refer to the provided web links to help you answer the questions.

World fuel use (question #1)

1. How do your plots reflect the history of fuel use in the world?

Question #2 You have already plotted, refer to your graph to answer the question!!!!

2. Now plot the per capita data. What do the data points imply? Why does the shape of this plotted data look the way it does?

3. Suppose the total mass of the Earth’s atmosphere is about 5.1 x 1018kg and is about 0.037% CO2. What was the percent increase in CO2 as a result of the 2000 emissions? Show all your calculations and work. Refer to your graph for 2000 emissions!

______

4a. Identify and describe some of the carbon dioxide sinks in the world.

4b. Describe how humans may be interfering with or inhibiting the sinks.

Where does CO2 go / Carbon Sinks (question 4a &4b)

4c. What is meant by anthropogenic sources of carbon?

Sites with information on Anthropogennic Carbon (question 4c)

5a. Identify and describe the source of two other greenhouse gases.

5b. What are their effects on the ability of the atmosphere to hold heat?

5c. Compare their (the gasses) heat holding capacities or global warming potentials.

5d. How have the gas concentrations varied over time

Greenhouse Gasses / Global warming potential (heat holding capacity) / Greenhouse gas levels

Review the sites below.

6a Describe how temperature has varied with the increase in global carbon dioxide levels.

6b. Do you think the data show a direct cause and effect relationship? Why or why not?

Temperature change in relation to atmospheric global carbon dioxide concentration