ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Name __________________ Per __
2
Graph the following information of Global air CO2 levels
3
****IF YOU WANT TO, MAKE A COPY OF THIS AND USE THAT AS YOUR ASSIGNMENT BY CLICKING 'FILE' AND 'MAKE A COPY'****
4
1. Open Google Sheets "Blank Sheet"
5
2. Title your Document
6
3. Copy and paste the data on your blank sheet, highlight columns A and B and go to "Insert" and Click "Chart"
7
YearCO2 Level
4. Double click the graph that shows up to open your variables
8
1/1/1965320
5. Make sure that the data range is correct for the cells that have data in them.
9
7/1/1965295
"Year" should be X-axis and "CO2 Level" should be Y-axis.
10
1/1/1970326
6. Click on "Customize"
11
7/1/1970305
7. Check each variable to make sure you have the following:
12
1/1/1975331
a. Labels on each axis
13
7/1/1975315b. Title to graph
14
1/1/1980339
8. Go to https://www.esrl.noaa.gov/gmd/ccgg/trends/ to research the latest data to add to your data chart from 2014-2019.
15
7/1/1980320
Use the red graph on the website, you must have a Winter and Summer number for each CO2 level for each year.
16
1/1/1985346
9. Answer the analysis questions on your spreadsheet graph.
17
7/1/1985325
10. See teacher for instructions on how to turn it in. Mr. Thomas' classes use JEFFCOSCHOOLOGY!
18
1/1/1990354
19
7/1/1990330
20
1/1/1995361
Analysis Questions:
21
7/1/1995335
1. What does your graph indicate about the general change in CO2 levels since 1960?
22
1/1/2000369
23
7/1/2000341
2. Based on your extrapolation, predict the CO2 levels in ppm for
24
1/1/2002377
A. This year _____________
25
7/1/2002353
26
1/1/2004384
B. The year 2025 _____________
27
7/2/2004363
28
1/1/2006390
C. The year 2050 _____________
29
7/1/2006370
30
1/1/2008395
3. A. Which of your predictions from Question 2 is likely to be the most accurate?
31
7/1/2008378
32
1/1/2015
B. Explain your answer.
33
7/1/2015
34
1/1/2016
4. A. Does your graph predict a doubling of the 1960 CO2 level? _______________
35
7/1/2016
36
1/1/2017
B. Regardless of your answer, in what year will this doubling presumably occur? _________________
37
7/1/2017
38
1/1/2018
5. A. What assumptions (or inferences) can you make when extrapolating data trends in this graph?
39
7/1/2018
40
1/1/2019
41
B. How may these assumptions affect the accuracy of your predictions above?
42
43
C. Describe factors that might cause these extrapolations to be incorrect.
44
45
6. Why might present CO2 data for air samples collected at Mauna Loa Observatory in Hawaii be different
46
from data collected at other locations around the planet?
47
48
7. At the beginning of this unit, a student was quoted as claiming that the "CO2 added to the atmosphere
49
by auto exhaust should not be problematic because it is already a natural component of
50
the atmosphere." Based on your graph, how would you respond to this comment?
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100