Introduction to Demography, Research Paper

paper is 5-6 pages: 1-2 pages are for graph and chart 
Overview
The purpose of this paper is to analyze the demographic experience of two countries, one “more developed” and one “less developed,” from 1950 to 2015, in order to describe demographic data trends, assess various demographic measures of population change, and analyze the theory of the demographic transition. The assignment has several goals: 
1. To gain familiarity with an online demographic data source 
2. To learn about recent demographic trends in two countries of your choosing 
3. To practice creating figures and tables displaying demographic data
4. To practice writing about demographic trends 
5. To become better versed in the demographic transition theory
6. To use data to assess the demographic transition theory
7. To think critically about standard demographic measures of population change
Step 1: Choose your countries
Choose one “more developed” and one “less developed” country. You may use the UN definitions of “more” and “less”/“least” developed (see definitions in reading by Lee) or you may use other measures of development to categorize two countries as “more” or “less” developed.
Step 2: Gather data & create a graph and a table
Find demographic data for your countries at http://esa(dot)un(dot)org/wpp/unpp/panel_indicators.htm (google un population data detailed indicators and go to the first site, “Detailed Indicators”). On the website under “Detailed indicators,” highlight the population growth rate, the crude death rate, the crude birth rate, the total fertility (rate), and life expectancy at birth. Select your two countries from the countries list. Be sure the “medium variant” is selected, and limit the years to 1950 to 2015. Hit “display” or “download as a .csv file” to see your data online or in Excel.
Using the data you found online, create one graph displaying the population growth rate, the crude death rate, and the crude birth rate from 1950 to 2010 for each of your countries. The rates should be charted on the y axis and year on the x axis, and the graph will display six lines of data, one for each rate in each country. 
Create one table displaying the total fertility rate and the life expectancy in each country for each five-year period from 1950-2010. 
Clearly label, title, and identify the data sources for the graph and table. 
Step 3: Write a demographic analysis of your data
In 4-6 double-spaced pages APA format, describe and analyze the demographic trends of the two countries. The text should focus on three central tasks: 
1. Describe the trends in order to convey what the graphs and tables say about demographic change in the two countries. The text should suggest how large and/or important the two countries’ trends are by comparing them to each other and to global and historical trends. 
2. Assess the usefulness and limitations of the measures included in your graph and table. Assess whether there is any bias in the crude measures, especially the crude death rate, by comparing trends in the crude death rate to trends in life expectancy at birth.
3. Analyze the theory of the demographic transition using the data in your graph and table. Be sure to explain what the demographic transition theory says. Consider whether the demographic trends follow the order of the stages, whether the difference between the two countries corresponds to their relative levels of socioeconomic development, and what might account for discrepancies between the theory and the data, if there are any. 
Do not use outside materials to give background, history, or social explanations for the trends observed in your countries. Stick to the data, the measures, and the theory. You may use course materials to compare the trends in your countries to trends in other countries or the world. Any sources you use should be cited with full bibliographic information included in a references section at the end of the paper. 
Grading rubric: you will be graded according to the following criteria
Formal demography: describe the data and discuss the measures
• Describes the data accurately
• Uses proper units when describing the data 
• Interprets the data to give the trends meaning and relevance
• Explains the measures precisely 
• Shows clear understanding of the issue of age bias for crude measures of fertility and mortality
Social demography
• Explains the demographic transition theory clearly 
• Relates the data trends to the theory 
• Assesses whether the data support the theory
Graph and table
• Data appear correctly presented
• Figures are titled, labeled, and sourced
• Figures are presented clearly and are easy to read
Writing
• Writing is clear and without errors
• Writing assumes a formal tone, appropriate for a demographic report
• Sources are cited and full bibliographic information is included 
In general:
The text should be minimum 3 pages, maximum 5 pages. Describe the excel graph data numbers into words, talk about the articles and lectures.
Create excel graphs data --> please check "paper" word doc. And excel doc. Examples.