للي طلبو البروجكت
Excel Project
Name: ______________________________ Student #________________________
1. Start an Excel file and save as your 1st name followed by your student ID.
Example: Amna-200222484.xls
2. Create four worksheets named: Task1, Task2, Task3 and Task4.
Task 1:
The Population of the UAE has been growing over time.
A. Use the data below to create a Column chart for the population growth in the UAE growth between 1970 and 2003. Use “Year” as the Category (X) axis title and “Number of People” as the Value (Y) Axis title. Give the chart an appropriate title.
Year
Population
1970
248,000
1975
557,900
1980
1,042,000
1985
1,379,000
1990
1,773,000
1995
2,411,000
2000
3,247,000
2001
3,488,000
2002
3,754,000
2003
4,041,000
B. Do the following changes to your graph:
Remove the legend
Add a textured background to the chart area and a picture background to the plot area.
Insert Category (X) axis major grid lines on your graph.
Change the color of the all the grid lines including the Category (X) and Value (Y) axes lines.
Increase the weight and color of the data series border.
Change the area color of data series to an appropriate color..
Increase the font of the title, the X axis title and the Y axis title to Comic Sans MS.
Make sure that the choices you made result in an attractive and informative chart.
Make sure that the Value Axis data has the comma format like 1,000,000.
C. Paste a copy of your graph here.
D. From your chart make a rough estimate the population of the UAE in 2004:
_______________
Task 2:
The distribution of population is different for different Emirates.
A. Use the data below to create a Pie chart showing the population in each Emirate. Give an appropriate title to the Chart. Show percent and category name as data labels for each Emirate.
Emirate
Population
(2003)
Abu Dhabi
1,591,000
Dubai
1,204,000
Sharjah
636,000
Ajman
235,000
Ras Al Khaimah
195,000
Fujairah
118,000
Umm Al Quwain
62,000
B. Do the following changes to your graph:
Remove the legend
Add a picture background of something relevant to the UAE in the Chart Area (NOTE: You may have to do something with the picture or the data labels so that everything is clearly visible.)
Change the color of the Emirate you live in to red and explode your emirate.
Change the percentages show they show one decimal place (to a tenth of a percent.)
Increase the font size of the chart title and change its color.
Make sure your chart is visually attractive and informative.
C. Copy your chart here.
D. On your excel worksheet add an additional column (see table below). Use excel formulas and proper cell references to calculate the percent population for each Emirate.
Emirate
Population
(2003)
Population Percent
Abu Dhabi
1,591,000
Dubai
1,204,000
Sharjah
636,000
Ajman
235,000
Ras Al Khaimah
195,000
Fujairah
118,000
Umm Al Quwain
62,000
Total
Note: Your answers must agree with the percent values shown on the pie chart.
E. Use AutoFormat… to make your new table attractive and informative. Paste a copy of your table here. Use the Paste link option.
Task 3:
The population of the world has changed over time.
A.Use the data below to create an XY (Scatter) graph in Excel of human population growth on the earth between 1600 and 1998. Provide good titles for the Chart, the Category (X) axis and the Value (Y) axis.
Year
Population
0
0.15 billion
1300
0.3 billion
1600
0.5 billion
1800
1 billion
1930
2 billion
1960
3 billion
1975
4 billion
1987
5 billion
1998
6 billion
B. Do the following changes to your graph:
Remove the legend
Remove the border around the chart area
Make the background of your plot area light green
Scale your Category (X) axis so it goes from year 0 to 2200.
Change the alignment on the Category (X) axis so that the years are at a 45% angle.
Insert an exponential Trendline for the data series.
Extend the Trendline so that it goes beyond the 8 billion gridline.
Estimate the year when the earth’s population will reach 8 billion. (You may do this in one of two ways. If you introduce more gridlines and appropriate Category (X) axis scales you will be able to see the intersection of the year and 8 billion. If you like mathematics, excel can provide the equation for the exponential curve and you can solve for the year.) Show the answer on the chart with a text box. Remember that this is just an estimate as the actual human population growth is not exactly exponential.
C. Paste a copy of your graph as a link here.
Task 4:
The Rate of Natural Increase (RNI) in population of a given country depends on Crude Birth Rate (# of births per 1000 people each year) and Crude Death Rate ((# of deaths per 1000 people each year).
The Rate of Natural Increase is related to Crude Birth Rate and Crude Death Rate by the following formula:
A. Use the site: http://www.cia.gov/cia/publications/factbook/geos/ae.html#People and the above formula to fill the table below. Do this in excel and as always use excel formulas.
Country
name
Crude Birth Rate(CBR)
Crude Death Rate(CDR)
Rate of Natural Increase (RNI)
India
UAE
Your Choice
Thailand
Norway
B. Make the following changes.
Sort the table by decreasing RNI
Create a column chart showing simultaneously the CBR and CDR of each country.
Create a bar chart showing the RNI for each country.
Make both charts visually attractive and informative. Choose your colors and titles carefully.
Which country has the highest population growth?
Which country has the least population growth?
Suggest reasons why this is the case?
C. Copy your charts here..
Submit electronic copies of this completed word document and your Excel workbook.
