Create two charts for each urban area that show the immigration distribution.

see attchments

For a school project, you are studying the history of immigration in the urban areas of the U.S.  You used census data to learn that in the years 1980 through 1990, immigration in urban U.S. areas grew.  The following tables list urban areas in the United States that grew the most and the origin of immigrants.  Use this data to illustrate immigration distribution in each of these urban areas.  Open a new workbook and save it as Immigration.xlsx in the drive and folder where your Data Files are stored.

 

Los Angeles area

Mexico

866,088

El Salvador

169,077

Philippines

114,123

Vietnam

91,442

Korea

91,385

San Francisco area

Mexico

113,919

Philippines

81,575

China

56,837

Vietnam

56,803

El Salvador

26,093

New York City area

Dominican Republic 145,153
China 74,959
Jamaica 74,168
Colombia 66,685
Korea 58,456

 

  • ·         Enter the data shown in the tables above.
  • ·         Create two charts for each urban area that show the immigration distribution.
  • ·         Change the color of a data series in at least one of the charts.
  • ·         Resize and move the charts for an attractive presentation.
  • ·         Preview your work so you will know what the printed charts will look like.
  • ·         Enter your name in a cell and save your work.

 

2.      As the head of the multicultural task force for your school, you are leading a campaign to keep the school community informed of the cultures represented at your school.  To illustrate the school’s population, you have decided to create charts of the demographic background of the student body.  Utilize the demographic data that appears below.

 

Ethnicity

Native American

15725

Afro-American

12457

White

22998

Asian

16255

Age

Under 15

15

16-20

7921

21-30

17325

31-40

12555

41-50

10235

Course Popularity

English

14525

Computers

28955

Fine Arts

9695

Science

12544

 

Open a new workbook and save it as School Statistics.xlsx in the drive and folder where your Data Files are stored.

 

  • ·         Enter demographic data that appears above.
  • ·         Create charts that show the following: ethnic origin of students, age distribution of students, and most popular courses (by attendance figures, if possible).
  • ·         Preview your work so you will know what the printed charts will look like.
  • ·         Enter your name in a cell and save your work.

 

 

PART II: Essay

 

Directions: Write a 500 word essay that summarizes what you have learned include a bibliography.  .Your summary must include all of the following topics:

  • ·         Plan a chart
  • ·         Create a chart
  • ·         Move and resize a chart
  • ·         Change the chart design
  • ·         Change the chart layout
  • ·         Format a chart
  • ·         Annotate and draw on a chart
  • ·         Create a pie chart
Type of paper Academic level Subject area
Number of pages Paper urgency Cost per page:
 Total: