Need ASAPLab 8B: Excel & MLA
Essentials
LAB 8B: Excel & MLA
Task One:
1. The homelessness data that we are going to use to create charts was extracted from this
website: http://www.statisticbrain.com/homelessness-stats/
a. Create a MLA citation for the chart. Copy and paste the citation here:
Task Two:
1. Add the following information about people affected by homelessness into a spreadsheet and
then create a chart:
Single men comprise 44 percent of the homeless, single women 13 percent, families with
children 36 percent, and unaccompanied minors seven percent.
2. Embed the finished chart in the paper on page 2 of this document. This chart should be inserted
so the text flows around it somewhere after the sentence in blue that refers to the chart.
a. The chart should have a title, a primary horizontal and vertical axis title and legend if you
are creating a column chart.
b. The chart should have a title, data labels and legend if you are creating a pie chart.
3. Add a caption for the chart as well.
a. Please refer to the 5_Word PowerPoint presentation on how to text wrap as well as how
to add a caption for the chart.
4. Please resize the chart and ensure that the first chart starts with Figure1 in the caption.
Task Three:
1. Put the following information about the ethnic groups affected by homelessness into a
spreadsheet and then create a chart:
The homeless population is about 50 percent African-American, 35 percent white, 12
percent Hispanic, 2 percent Native American and 1 percent Asian.
2. Embed the finished chart in the paper on page 2. This chart should be inserted so the text flows
around it somewhere after the sentence in blue that refers to the chart.
a. The chart should have a title, a primary horizontal and vertical axis title and legend.
b. The chart should have a title, data labels and legend if you are creating a pie chart.
3. Add a caption for the chart as well.
a. Please refer to the 5_Word PowerPoint presentation on how to text wrap as well as how
to add a caption for the chart.
4. Please resize the chart and ensure the Figure# is continuous in the caption.
Task Four:
1. Resave this document as LastName_Lab8B.
1
Lastname 1
Submit
a.
the Excel spreadsheet that was used to create the two charts above and
b. this file (LastName_Lab8B.docx) into Blackboard.
Lab 8B: Excel & MLA
Essentials
3
Your Name
Instructor Name
INFO1001
5 May 2015
Homelessness In America
Homelessness throughout America has been on the rise. This is making many states as well as
the country as a whole look at the issue of homelessness. “From the last counts and estimates
nationwide, there has been at least a 35-45% increase in homelessness and poverty” (Shaft). Here are
two charts that shows the ethnicity as well as the different groups of people who are affected by
homelessness. Can you begin to imagine if one of your children or family members was faced with living
on the streets or in a homeless shelter? What a devastating fact to come to terms with. “It estimates
that 1.5 million children experience homelessness at least once that year, and says the problem is surely
worse now because of the foreclosures and job losses of the deepening recession” (Crary). This statistic
is evidence of the millions of innocent children in our country who are affected and suffering from
homelessness. Homelessness can also have another impact on children, affecting their academics, selfesteem, and relationships with their peer group. One report states children that are homeless are at a
much greater risk to go hungry, get sick, and do poorly when it comes to academics. This can have many
harmful long-term effects when it comes to family and the child’s peer group (Crary).
Purchase answer to see full
attachment
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.