Overview
[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).
YearPopulation of People200190,000,000600200,000,000700210,000,000800220,000,000900240,000,0001000275,000,0001100320,000,0001200360,000,0001400350,000,0001500450,000,0001600500,000,0001700610,000,0001760770,000,00018041,000,000,00018501,200,000,00019001,600,000,00019272,000,000,00019512,584,034,26119522,630,861,56219532,677,608,96019542,724,846,74119552,773,019,93619562,822,443,28219572,873,306,09019582,925,686,70519592,979,576,18519603,034,949,74819613,091,843,50719623,150,420,79519633,211,001,00919643,273,978,33819653,339,583,59719663,407,922,63019673,478,769,96219683,551,599,12719693,625,680,62719703,700,437,04619713,775,759,61719723,851,650,24519733,927,780,23819744,003,794,17219754,079,480,60619764,154,666,86419774,229,506,06019784,304,533,50119794,380,506,10019804,458,003,51419814,536,996,76219824,617,386,54219834,699,569,30419844,784,011,62119854,870,921,74019864,960,567,91219875,052,522,14719885,145,426,00819895,237,441,55819905,327,231,06119915,414,289,44419925,498,919,80919935,581,597,54619945,663,150,42719955,744,212,97919965,824,891,95119975,905,045,78819985,984,793,94219996,064,239,05520006,143,493,82320016,222,626,60620026,301,773,18820036,381,185,11420046,461,159,38920056,541,907,02720066,623,517,83320076,705,946,61020086,789,088,68620096,872,767,09320106,956,823,60320117,041,194,30120127,125,828,05920137,210,581,97620147,295,290,76520157,379,797,13920167,464,022,04920177,547,858,92520187,631,091,04020197,713,468,10020207,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?