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.

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