Module 6 Intro to Microsoft
Ksellamgdame
module_6_isy_microsoft.rtf[INSERT TITLE HERE] 1
Running head: [INSERT TITLE HERE]
[INSERT TITLE HERE]
Student Name
Allied American University
Author Note
This paper was prepared for [INSERT COURSE NAME], [INSERT COURSE ASSIGNMENT] taught by [INSERT INSTRUCTOR’S NAME].
Directions: Please complete the following tasks. Be sure to read the directions carefully. When you have completed all parts of the Homework Assignment, create a zipped folder containing all files, then upload this .zip file to iBoard.
PART I: Projects
1. 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 an essay that summarizes what you have learned in this section of your textbook and lecture notes. Your paper should be at least 2 pages in length, utilize APA style, and include a cover page and a bibliography. Your paper should be written in your own words and not copied and pasted from the Internet or directly from the textbook and/or lecture notes. 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
