23 Feb Below is table with the global population of humans over time. Use the two columns of data below and create a “Scatter chart” in Google Sheets. Make a plot of Population vs Time (Y-axis vs.
environmental science multi-part question and need a sample draft to help me learn.
[8 points] Below is table with the global population of humans over time. Use the two columns of data below and create a “Scatter chart” in Google Sheets. Make a plot of Population vs Time (Y-axis vs. X-Axis). Plots should always have a descriptive title, axis labels on the x and y axes, a reasonable scale (all data shown on plot, but plot is not tiny), units for labels (if necessary), and a legend (if necessary).
Year Population of People
200 190,000,000
600 200,000,000
700 210,000,000
800 220,000,000
900 240,000,000
1000 275,000,000
1100 320,000,000
1200 360,000,000
1400 350,000,000
1500 450,000,000
1600 500,000,000
1700 610,000,000
1760 770,000,000
1804 1,000,000,000
1850 1,200,000,000
1900 1,600,000,000
1927 2,000,000,000
1951 2,584,034,261
1952 2,630,861,562
1953 2,677,608,960
1954 2,724,846,741
1955 2,773,019,936
1956 2,822,443,282
1957 2,873,306,090
1958 2,925,686,705
1959 2,979,576,185
1960 3,034,949,748
1961 3,091,843,507
1962 3,150,420,795
1963 3,211,001,009
1964 3,273,978,338
1965 3,339,583,597
1966 3,407,922,630
1967 3,478,769,962
1968 3,551,599,127
1969 3,625,680,627
1970 3,700,437,046
1971 3,775,759,617
1972 3,851,650,245
1973 3,927,780,238
1974 4,003,794,172
1975 4,079,480,606
1976 4,154,666,864
1977 4,229,506,060
1978 4,304,533,501
1979 4,380,506,100
1980 4,458,003,514
1981 4,536,996,762
1982 4,617,386,542
1983 4,699,569,304
1984 4,784,011,621
1985 4,870,921,740
1986 4,960,567,912
1987 5,052,522,147
1988 5,145,426,008
1989 5,237,441,558
1990 5,327,231,061
1991 5,414,289,444
1992 5,498,919,809
1993 5,581,597,546
1994 5,663,150,427
1995 5,744,212,979
1996 5,824,891,951
1997 5,905,045,788
1998 5,984,793,942
1999 6,064,239,055
2000 6,143,493,823
2001 6,222,626,606
2002 6,301,773,188
2003 6,381,185,114
2004 6,461,159,389
2005 6,541,907,027
2006 6,623,517,833
2007 6,705,946,610
2008 6,789,088,686
2009 6,872,767,093
2010 6,956,823,603
2011 7,041,194,301
2012 7,125,828,059
2013 7,210,581,976
2014 7,295,290,765
2015 7,379,797,139
2016 7,464,022,049
2017 7,547,858,925
2018 7,631,091,040
2019 7,713,468,100
2020 7,794,798,739
You can copy and paste the table into Google Sheets
Data from: https://www.worldometers.info/world-population/world-population-by-year/Links to an external site.
How to make an informative graph
https://www.mit.edu/~mbarker/formula1/f1help/10-ch-c2.htmLinks to an external site.
How to submit your Google Sheet
In your Google Sheet click “Share” in the top right corner
Under “General access” click and set permission to “Anyone with link”
Change the role to “Viewer” if you see “Commenter” or “Editor”
Click “Copy Link”
Paste the link as your response to this question.
[8 points] Using the plot you created in 1 that shows human population over time and information from Populations and Communities, what is your prediction about how human population will change in the future? Explain your reasoning.
[8 points] Explain one negative impact of the Green Revolution in detail. (Why is it happening? How will this impact us in the future?)
[8 points] Environmental impact of humans depends on population, affluence, and technology (I=PAT). Explain how population, affluence, and technology each affect our environmental impact.
[8 points] One of the main concerns with a growing population is the availability and distribution of resources. Conferences on human population originally identified economic stability and availability of contraception as the main factors influencing total fertility rate, but have since developed this to include others. You are tasked with developing a plan to assist a nation in lowering their total fertility rate and completing the demographic transition. What would you plan be? (What factors would you focus on? How would you implement it?)
[10 points] Fossil fuels are created through complex processes after the burial of organic material (such as marine organisms and swamps) and take millions of years to form. Based on our rate of using fossil fuels, describe what is happening to our reserves (how much is left) of fossil fuels on Earth. What does this mean for technology and cities that rely on fossil fuels? What is one change we can make to address this?
Requirements: N/A
