MATH 101 Workplace Mathematics
CO #5 Assessment: Option #3 (Medical)

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 #3 (Medical):

Diabetes is a chronic disease that occurs when one’s body either cannot produce enough insulin or cannot use insulin properly.The risk of death for an adult with diabetes is 50% higher than an individual without diabetes.Medical costs are also twice as high for someone who has diabetes.The table below lists the percentage of people in the United States diagnosed with Diabetes from 1984 to 2014, by gender.

Percentage of U.S. Population with Diagnosed Diabetes by Gender

Gender	Male	Female
1984	2.6%	3.1%
1994	3.2%	3.2%
2004	5.6%	4.9%
2014	6.6%	5.9%

Source: CDC/NCHS, National Health and Nutrition Examination Survey.

Task #1: In Excel, create a clustered bar/column graph comparing the percentage of people in the United States diagnosed with Diabetes by gender from 1984 to 2014.

1)Open a new workbook in Excel.

2)In Sheet 1, create a table from the data above displaying the percentage of people in the United States diagnosed with Diabetes by gender from 1984 to 2014.Type ONLY the data needed for the graph in the cells.Resize the rows/columns to fit your data if necessary.Do not skip cells in the rows or columns.

Year	Male	Female
1984
1994
2004
2014

Example:

3)Apply borders to the entire table.You may also apply a design to the table.

4)Highlight the table you just created.

5)Click on the Insert tab, then on Recommended Charts.Select an appropriate bar/column graph to represent the data.The legend should give the years of data graphed.

6)A graph will appear displaying your data.You may apply a design to the graph.

7)With the graph selected, click the plus sign and add the following chart elements if necessary:

The graph should have an appropriate title.

The horizontal and vertical axes should have labels.

Each column should have a data label at the top.

8)After the title page, insert a page break and copy and paste the table and bar graph on page 2 of the Word document.Label the top of the page “PART 1.”

9)Below the table/graph, answer (in full sentences) question #1:

Question 1:Whose percentage increased more from 1984 to 2014, males or females? By how much more did it increase?

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 percent of females that have been diagnosed with diabetes and the percent of the females that haven’t been diagnosed with diabetes (slices) in the year 2014.

1)Open a new sheet (Sheet 2) in the Excel workbook.

2)In Sheet 2, create a table from the data above displaying the the percent of females that have been diagnosed with diabetes and the percent of the females that haven’t been diagnosed with diabetes in the year 2014.Type ONLY the data needed for the graph in the cells.Resize the rows/columns to fit your data if necessary.Do not skip cells in the rows or columns.

3)Apply borders to the entire table.You may also apply a design to the table.

4)Highlight the table you just created.

5)Click on the Insert tab, then on Recommended Charts.Select an appropriate pie chart to represent the data.

6)A graph will appear displaying your data.You may apply a design to the graph.

7)With the graph selected, click the plus sign and add the following chart elements if necessary:

The graph should have an appropriate title.

The slices should be named “Diagnosed with Diabetes” and “Not Diagnosed with Diabetes” and the percent of the total.

8)After part 1, insert a page break and copy and paste the table and pie chart on page 3 of the Word document.Label the top of the page “PART 2.”

9)Below the table/graph, answer (in full sentences) question #2:

Question 2:In 2014, there were 161,809,242 females in the U.S.How many females had diagnosed diabetes in 2014? How many females hadn’t been diagnosed with diabetes?Round to the nearest whole number.

Task #3: Being overweight increases your risk of diabetes type 2.The table below lists adult obesity rate in the United States from 1961 to 2011. In Excel, create a line graph with markers comparing the adult obesity rate in the United States from 1961 to 2011.

Year	1961	1971	1981	1991	2001	2011
Percentage	13.4%	14.5%	15%	23.2%	31.2%	35.3%

Source: CDC/NCHS, National Health and Nutrition Examination Survey.

1)Open a new sheet (Sheet 3) in the Excel workbook.

2)In Sheet 3, create a table from the data above.Resize the rows/columns to fit your data if necessary.Do not skip cells in the rows or columns.

3)Apply borders to the entire table.You may also apply a design to the table.

4)Highlight the table you just created.

5)Click on the Insert tab, then on Recommended Charts.Select an appropriate line graph to represent the data.

6)A graph will appear displaying your data.You may apply a design to the graph.

7)With the graph selected, click the plus sign and add the following chart elements if necessary:

The graph should have an appropriate title.

The horizontal and vertical axes should have labels.

There should not be a legend.

8)After part 2, insert a page break and copy and paste the table and pie chart on page 4 of the Word document.Label the top of the page “PART 3.”

9)Below the table/graph, answer (in full sentences) question #3:

Question 3: What is the change (difference) in the adult obesity rate in the U.S. from 1971 to 2011?Was it an increase or decrease?

Task #4: Project Reflection

1)After part 3, insert a page break and write a 200 – 300-word paragraph addressing these questions:

List 3 things that you’ve learned through working on this report.

How could these knowledge, skills, and capabilities be used in the workplace?

Explain a specific workplace example where reading, analyzing, or creating a table or graph could be used in your field.

2)Label the top of the page “PART 4.”

3)Insert the Header and Footer.

Click on the Insert tab, then on Header.Select Edit Header.

Make sure “Different First Page” is checked.

Click on Page Number and choose any style from the “Top of Page” options.

Scroll down to the footer.Type “Your Name – MATH 101 Report” in the footer.

4)Save the Word Document as [lastname] Math101.docx

5)To Submit:Upload the Word Document to ePortfolio under the Institutional Outcome:

Follow established methods of inquiry and mathematical reasoning to form conclusions and make decisions.

MATH 101 Workplace Mathematics
CO #5 Assessment Checklist

Document Formatting Requirements
Cover Page (title, name, college, class, & date)
Footer with your name and course number
Header with page numbers
Double Spaced
1 Inch Margins
12-point Times New Roman font
Parts are numbered and each on a new page

Document Contents Requirements
Part 1 (Table and Cluster Column/Bar Chart)
The data table & cluster column/bar chart are copied from Excel
Graph has an appropriate title
Horizontal & vertical axes are labeled correctly
Each column has a data label at the top
Question 1 is answered correctly
Question 1 is thoroughly answered in complete sentences
Table and graph accurately represents data from the data given
Part 2 (Table and Pie Chart)
The data table & the pie chart are copied from Excel
Graph has an appropriate title
Each slice should be labeled and the percent of the total should be displayed
Question 2 is answered correctly
Question 2 is thoroughly answered in complete sentences
Table and graph accurately represents data from the data given
Part 3 (Table and Line Graph)
The data table and the line chart are copied from Excel
Graph has an appropriate title
Horizontal & vertical axes are labeled correctly
Question 3 is answered correctly
Question 3 is thoroughly answered in complete sentences
Table and graph accurately represents data from the data given
Part 4 (Project Reflection)
What have you learned through working on this report? (Tables/Graphs, Excel, etc.)
How could these knowledge, skills, and capabilities be used in the workplace?
Discuss a specific workplace example from the chosen career field.

MATH 101 Workplace Mathematics
CO #5 Assessment Rubric

Document Formatting Requirements
	Points	Earned
Cover Page (title, name, college, class, & date)	3
Footer with your name and course number & Header with page numbers	2
Double Spaced, 1 Inch Margins, & 12-point Times New Roman font	2
Organization: Parts are numbered and each on a new page	2

Document Contents Requirements
Part 1 (Table and Cluster Column/Bar Chart)	Points	Earned
The data table & cluster column/bar chart are copied from Excel	2
Graph has an appropriate title	2
Horizontal & vertical axes are labeled correctly	4
Each column has a data label at the top	2