MATH101 Week 7 Graphing Report Final Submission Assignment
MATH101 Week 7: Graphing Report Final Submission
Directions
Submit your rough draft of the Graphing Report. Make sure that you have reviewed the rubric and directions linked below to ensure you have all the elements to the report. After your submission, please refer back to your submission to review any feedback provided by your instructor which should be applied to your final submission.
MATH 101 Workplace Mathematics
CO #5 Assessment: Option #2 (Business)
CO #5: Students will be able to communicate workplace information accurately in the form of a chart and graph by checking for reasonableness.
Description of Assessment:
This report determines students’ ability to communicate workplace information in the form of a chart and graph.
Purpose of Assessment:
The purpose of this assessment is for students to demonstrate their understanding of charts and graphs in relation to the workplace environment. This assessment will enhance a student’s ability to read, interpret and create workplace information in the form of charts and graphs and check for reasonableness of the information depicted.
Directions for the Student:
Your final assessment will be a report created in Microsoft Word based on graphs created using Microsoft Excel. Using the information provided, you will create three graphs in Microsoft Excel. You will then copy and paste those graphs and answer questions about them in a Microsoft Word document. Finally, you will compose a short reflection and summary about the report and how the knowledge, skills, and capabilities are related to the workplace. The final Word document will be submitted to your ePortfolio.
Option #2 (Business):
Every year the U.S. Census Bureau conducts a survey that provides information on the spending habits of American citizens. This data is released on the Bureau of Labor Statistics (BLS) website. The table below lists the average household income and expenditures in the United States in the years 2000, 2007 and 2014.
Consumer Expenditures
Year |
Average Household Income (before taxes) |
Food |
Housing |
Transportation |
Entertainment |
2000 |
$44,649 |
$5,158 |
$12,319 |
$7,417 |
$1,863 |
2007 |
$63,091 |
$6,133 |
$16,920 |
$8,758 |
$2,698 |
2014 |
$66,877 |
$6,799 |
$17,798 |
$9,073 |
$2,728 |
Task #1: In Excel, create a clustered bar/column graph comparing the amount spent on Food, Housing, and Transportation for the years 2000, 2007, and 2014.
Task #2: We use pie charts to display the contribution of each value (slice) to a total (pie). In Excel, create a pie chart that compares the amount of money spent on each expenditure (slices) in the year 2014.
Task #3: The table below, compiled by the Census ACS survey, lists the median household income in the United States for the given years. In Excel, create a line chart with markers that displays the data in the table below.
Year |
2007 |
2008 |
2009 |
2010 |
2011 |
2012 |
2013 |
2014 |
Median Household Income |
$57,936 |
$57,211 |
$55,415 |
$54,343 |
$53,162 |
$52,970 |
$53,105 |
$53,657 |
Task #4: Project Reflection
Course: MATH101 – Workplace Mathematics
School: Bryant & Stratton College
- 22/04/2020
- 100