Work in Excel for a project that needs to be finished
Order ID 53563633773 Type Essay Writer Level Masters Style APA Sources/References 4 Perfect Number of Pages to Order 5-10 Pages Description/Paper Instructions
Question Description
You are developing a demographic analysis of Miami-Dade Countys population. Follow the steps to produce the results Figures near the end of the document demonstrate this.
Notes: There are two worksheets in this workbook: the Documentation worksheet (for the workbook’s history) and the Population worksheet. Later in the project, you’ll build a third spreadsheet called Selected Demographics. Make sure you’re working on the right worksheet according to the instructions.In all formulas, you should use cell references rather than re-entering data.
Use the photos at the conclusion of this document to check that your work is right.
1. Create a Line Chart with Markers, as illustrated in Figure 2, that shows the entire population by age groups. Place this graph at B19:G35. The following is the format:
a. Rename the graph Total Population by Age Segments.
c. Rotate the text 270 degrees on the horizontal axis. (Hint: For this, use the Text direction dropdown selection.)
c. Use Orange Accent 2 Darker 25% for the line and marker colors.
d. Set the main units to 50,000 and minor units to 25,000 in the vertical axis choices.
e. Add Primary Major Vertical and Primary Minor Horizontal gridlines to the drawing.
f. Remove the border from the plot area. Set the fill to be a gradient using the Light Gradient Accent 2 preset gradient.
f. Use the color Orange Access 2 Darker 50 percent to create a border around the entire chart.
2. Change the page orientation to Landscape and narrow the margins. Open the Custom Margins setting and change the top and bottom margins to 0.25 using the settings offered by the Narrow option. Col. A should be repeated on each page. Data until age 30-34 and a chart should be on the first page, followed by data from age 35-39 to 65-69 on the second page, and the rest of the data on the third page. For printing, there should be no scaling.
3. Create a page footer with your name in the right-hand section and the date this worksheet was finished in the right-hand section. To confirm that your print settings on the Population worksheet are set up appropriately, use Page Break Preview.
4. Make a new Selected Demographics worksheet. In the tabs, move it to the last position.
5. Go back to the Population worksheet and make a Line Chart with all of the racial and age groups, as shown in Figure 3. The following is the format:
a. Copy and paste this chart into the Selected Demographics worksheet, where it should be positioned at B3:M26.
b. Rename the graph to Population by Race and Age Groups.
d. Using the Custom angle option, rotate the text in the horizontal axis to -45 percent.
d. On the vertical axis, set the Maximum Bounds to 60000. Set the Major and Minor units to 10,000 and 5,000, respectively.
e. Add Primary Major Vertical and Primary Minor Horizontal gridlines to the drawing.
6. Return to the Population worksheet and build a Clustered Column Chart, as shown in Figure 4, to represent the black population by age segment. This chart should be formatted as follows:
a. Copy and paste this chart into the Selected Demographics worksheet, where it should be positioned at B28:M42.
c. Move the legend to the top of the page.
d. Rename the chart to Black Population by Age Group.
d. On the vertical axis, set the Maximum Bounds to 25000. Set the Major and Minor units to 5,000 and 2,500, respectively.
e. Add Primary Major Vertical and Primary Minor Horizontal gridlines to the drawing.
7. Return to the Population worksheet and build a 3-D pie chart, as shown in Figure 5, that shows the total number of senior persons by age segment. Ages 60 and up are included. This chart should be formatted as follows:
a. Copy and paste this chart into the Selected Demographics worksheet, where it should be positioned at O3:U18.
b. Rename the graph to Senior Citizens by Age Group.
d. Select Style 4 as the chart style.
d. Move the legend to the top of the page.
a. Attach data labels to the outside ends of the wires.
f. Format data labels to include the legend key and percentages.
g. Extend the slice for 65-69 years old.
8. In cell B1 of the Selected Demographics worksheet, type Selected Demographics. B1 should be merged and centered across B1:U1, and the title should be formatted with the Title style.
9. Change the page orientation to Landscape and narrow the margins.
10. On the Selected Demographics worksheet, use Page Break Preview to erase any page breaks.
11. Use File Print to see if you need to do any custom scaling to get all of the charts to fit on one page.Save your file, close Excel, and sub
RUBRIC
QUALITY OF RESPONSE NO RESPONSE POOR / UNSATISFACTORY SATISFACTORY GOOD EXCELLENT Content (worth a maximum of 50% of the total points) Zero points: Student failed to submit the final paper. 20 points out of 50: The essay illustrates poor understanding of the relevant material by failing to address or incorrectly addressing the relevant content; failing to identify or inaccurately explaining/defining key concepts/ideas; ignoring or incorrectly explaining key points/claims and the reasoning behind them; and/or incorrectly or inappropriately using terminology; and elements of the response are lacking. 30 points out of 50: The essay illustrates a rudimentary understanding of the relevant material by mentioning but not full explaining the relevant content; identifying some of the key concepts/ideas though failing to fully or accurately explain many of them; using terminology, though sometimes inaccurately or inappropriately; and/or incorporating some key claims/points but failing to explain the reasoning behind them or doing so inaccurately. Elements of the required response may also be lacking. 40 points out of 50: The essay illustrates solid understanding of the relevant material by correctly addressing most of the relevant content; identifying and explaining most of the key concepts/ideas; using correct terminology; explaining the reasoning behind most of the key points/claims; and/or where necessary or useful, substantiating some points with accurate examples. The answer is complete. 50 points: The essay illustrates exemplary understanding of the relevant material by thoroughly and correctly addressing the relevant content; identifying and explaining all of the key concepts/ideas; using correct terminology explaining the reasoning behind key points/claims and substantiating, as necessary/useful, points with several accurate and illuminating examples. No aspects of the required answer are missing. Use of Sources (worth a maximum of 20% of the total points). Zero points: Student failed to include citations and/or references. Or the student failed to submit a final paper. 5 out 20 points: Sources are seldom cited to support statements and/or format of citations are not recognizable as APA 6th Edition format. There are major errors in the formation of the references and citations. And/or there is a major reliance on highly questionable. The Student fails to provide an adequate synthesis of research collected for the paper. 10 out 20 points: References to scholarly sources are occasionally given; many statements seem unsubstantiated. Frequent errors in APA 6th Edition format, leaving the reader confused about the source of the information. There are significant errors of the formation in the references and citations. And/or there is a significant use of highly questionable sources. 15 out 20 points: Credible Scholarly sources are used effectively support claims and are, for the most part, clear and fairly represented. APA 6th Edition is used with only a few minor errors. There are minor errors in reference and/or citations. And/or there is some use of questionable sources. 20 points: Credible scholarly sources are used to give compelling evidence to support claims and are clearly and fairly represented. APA 6th Edition format is used accurately and consistently. The student uses above the maximum required references in the development of the assignment. Grammar (worth maximum of 20% of total points) Zero points: Student failed to submit the final paper. 5 points out of 20: The paper does not communicate ideas/points clearly due to inappropriate use of terminology and vague language; thoughts and sentences are disjointed or incomprehensible; organization lacking; and/or numerous grammatical, spelling/punctuation errors 10 points out 20: The paper is often unclear and difficult to follow due to some inappropriate terminology and/or vague language; ideas may be fragmented, wandering and/or repetitive; poor organization; and/or some grammatical, spelling, punctuation errors 15 points out of 20: The paper is mostly clear as a result of appropriate use of terminology and minimal vagueness; no tangents and no repetition; fairly good organization; almost perfect grammar, spelling, punctuation, and word usage. 20 points: The paper is clear, concise, and a pleasure to read as a result of appropriate and precise use of terminology; total coherence of thoughts and presentation and logical organization; and the essay is error free. Structure of the Paper (worth 10% of total points) Zero points: Student failed to submit the final paper. 3 points out of 10: Student needs to develop better formatting skills. The paper omits significant structural elements required for and APA 6th edition paper. Formatting of the paper has major flaws. The paper does not conform to APA 6th edition requirements whatsoever. 5 points out of 10: Appearance of final paper demonstrates the student’s limited ability to format the paper. There are significant errors in formatting and/or the total omission of major components of an APA 6th edition paper. They can include the omission of the cover page, abstract, and page numbers. Additionally the page has major formatting issues with spacing or paragraph formation. Font size might not conform to size requirements. The student also significantly writes too large or too short of and paper 7 points out of 10: Research paper presents an above-average use of formatting skills. The paper has slight errors within the paper. This can include small errors or omissions with the cover page, abstract, page number, and headers. There could be also slight formatting issues with the document spacing or the font Additionally the paper might slightly exceed or undershoot the specific number of required written pages for the assignment. 10 points: Student provides a high-caliber, formatted paper. This includes an APA 6th edition cover page, abstract, page number, headers and is double spaced in 12’ Times Roman Font. Additionally, the paper conforms to the specific number of required written pages and neither goes over or under the specified length of the paper. GET THIS PROJECT NOW BY CLICKING ON THIS LINK TO PLACE THE ORDER
CLICK ON THE LINK HERE: https://www.perfectacademic.com/orders/ordernow
Also, you can place the order at www.collegepaper.us/orders/ordernow / www.phdwriters.us/orders/ordernow
Do You Have Any Other Essay/Assignment/Class Project/Homework Related to this? Click Here Now [CLICK ME]and Have It Done by Our PhD Qualified Writers!!