PROCEDURE: You are a climatologist studying the impacts of CO2 concentrations on Earth’s climate. Below is data you have collected showing historic CO2 emissions from fossil fuels. Your job is to enter the data into a MS Excel spreadsheet, sum up the total emissions since 1755, make a line graph for the data, print the graph out and answer the questions on page 2. Mr. Manskopf will give an introduction to Excel in class. Make sure you constantly save your work in your H:Drive so you don’t lose the data.
THE DATA:
Year / Total CO2 emissions from fossil-fuels (million metric tons of C)1755 / 3
1757 / 3
1759 / 3
1761 / 3
1763 / 3
1765 / 3
1767 / 3
1769 / 3
1771 / 4
1773 / 4
1775 / 4
1777 / 4
1779 / 4
1781 / 5
1783 / 5
1785 / 5
1787 / 5
1789 / 5
1791 / 6
1793 / 6
1795 / 6
1797 / 7
1799 / 7
1801 / 8
1803 / 9
1805 / 9
1807 / 10
1809 / 10
1811 / 11
1813 / 11
1815 / 12
1817 / 14
1819 / 14
1821 / 14
1823 / 16
1825 / 17
1827 / 18
1829 / 18
1831 / 23
1833 / 24
1835 / 25
1837 / 29
1839 / 31
1841 / 34
1843 / 37
1845 / 43
1847 / 46
1849 / 50
1851 / 54
1853 / 59
1855 / 71
1857 / 77
1859 / 83
1861 / 95
1863 / 104
1865 / 119
1867 / 130
1869 / 142
1871 / 156
1873 / 184
1875 / 188
1877 / 194
1879 / 210
1881 / 243
1883 / 272
1885 / 277
1887 / 295
1889 / 327
1891 / 372
1893 / 370
1895 / 406
1897 / 440
1899 / 507
1901 / 552
1903 / 617
1905 / 663
1907 / 784
1909 / 785
1911 / 836
1913 / 943
1915 / 838
1917 / 955
1919 / 806
1921 / 803
1923 / 970
1925 / 975
1927 / 1062
1929 / 1145
1931 / 940
1933 / 893
1935 / 1027
1937 / 1209
1939 / 1192
1941 / 1334
1943 / 1391
1945 / 1160
1947 / 1392
1949 / 1419
1951 / 1767
1953 / 1841
1955 / 2043
1957 / 2270
1959 / 2462
1961 / 2594
1963 / 2847
1965 / 3145
1967 / 3411
1969 / 3801
1971 / 4231
1973 / 4635
1975 / 4616
1977 / 5030
1979 / 5391
1981 / 5155
1983 / 5097
1985 / 5431
1987 / 5730
1989 / 6067
1991 / 6231
1993 / 6100
1995 / 6403
1997 / 6683
1999 / 6512
2001 / 6839
2002 / 6975
(Need to turn in, this paper with questions answered and print out of graph)
QUESTIONS:
1) What were the total emissions of CO2 from fossil fuels from 1755 to 2002? (in millions of metric tons)
2) Describe the overall trend in CO2 emissions from fossil fuels since the late 1700s. Why do you think that is the case?
3) Go to What does it say is the largest source of CO2 emissions globally?
4) Scroll down on that page to the section on “Fossil Fuel Consumption” and the Chart for 2006. In electricity production, which fossil fuel is the source of the most CO2?
5) Why do you think your chart of CO2 emissions looks the way it does? What historical events contributed to the great increases you see?