{"id":108118,"date":"2022-12-04T10:20:12","date_gmt":"2022-12-04T10:20:12","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/exp22_excel_ch03_cumulative_patient-computer-science-homework-help\/"},"modified":"2022-12-04T10:20:12","modified_gmt":"2022-12-04T10:20:12","slug":"exp22_excel_ch03_cumulative_patient-computer-science-homework-help","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/exp22_excel_ch03_cumulative_patient-computer-science-homework-help\/","title":{"rendered":"Exp22_excel_ch03_cumulative_patient | Computer Science homework help"},"content":{"rendered":"
\n

Exp22_Excel_Ch03_Cumulative_Patient<\/strong><\/p>\n

Exp22 Excel Ch03 Cumulative Patient<\/strong><\/p>\n

Excel Chapter 3 Cumulative – Blood Pressure Monitoring<\/strong>\u00a0<\/p>\n

\u00a0\u00a0<\/p>\n

Project Description:<\/strong><\/h2>\n

You work as a nurse in a health clinic. You record each patient\u2019s systolic and diastolic blood pressures each week. A number of patients have requested blood pressure data and charts. This information helps patients know if they have hypertension, caused by high blood pressure. You prepared a spreadsheet that can be used as a template to track a patient\u2019s blood pressure and heart rate. You are ready to create charts that you can use when discussing a patient\u2019s blood pressure.<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

Start Excel. Download and open \u00a0\u00a0the file named Exp22_Excel_Ch03_Cumulative_Patient.xlsx<\/em>. \u00a0\u00a0Grader has automatically added your last name to the beginning of the \u00a0\u00a0filename.<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

Weekly blood pressure readings \u00a0\u00a0have been entered for a sample patient. You want to create a clustered column \u00a0\u00a0chart to compare the readings for the month. After you create the chart, you \u00a0\u00a0will move it to a Charts sheet that will be used to contain several charts \u00a0\u00a0for easy reference.
\u00a0<\/p>\n

\u00a0\u00a0Create a clustered column chart using the range A2:C7 on the April worksheet. \u00a0\u00a0Move the chart to cell A1 in the Charts sheet.<\/p>\n

\u00a0<\/p>\n

The chart needs a descriptive, \u00a0\u00a0easy-to-read title.
\u00a0<\/p>\n

\u00a0\u00a0Change the chart title to Blood Pressure Readings in April<\/strong> and bold the title.<\/p>\n

\u00a0<\/p>\n

You realize the chart might be \u00a0\u00a0easier to read as a bar chart.
\u00a0<\/p>\n

\u00a0\u00a0Change the chart type to Clustered Bar.<\/p>\n

\u00a0<\/p>\n

You will increase the chart size \u00a0\u00a0to make it easier to read on a display screen.
\u00a0<\/p>\n

\u00a0\u00a0Set 4″<\/strong> height.\u00a0<\/p>\n

\u00a0<\/p>\n

You want to remove the \u00a0\u00a0additional dates displayed on the category axis.
\u00a0<\/p>\n

\u00a0\u00a0Select the dates on the axis and display the Format Axis task pane. In the \u00a0\u00a0Axis Options category, select Text axis to remove the extra dates from the \u00a0\u00a0chart.<\/p>\n

\u00a0<\/p>\n

You want to arrange the dates \u00a0\u00a0with the oldest date at the top.
\u00a0<\/p>\n

\u00a0\u00a0Display the dates in reverse order on the category axis so that 4\/1\/2024 is \u00a0\u00a0at the top of the vertical axis.<\/p>\n

\u00a0<\/p>\n

Next, you will create a line \u00a0\u00a0chart depicting the heart rate readings for the month. This chart will help \u00a0\u00a0the patient see trends over time.
\u00a0<\/p>\n

\u00a0\u00a0Create a line chart using the ranges A3:A7 and D3:D7 on the April worksheet. \u00a0\u00a0Move the line chart to start in cell I1 in the Charts sheet.<\/p>\n

\u00a0<\/p>\n

You decide to adjust the size of \u00a0\u00a0the line chart.
\u00a0<\/p>\n

\u00a0\u00a0Set 3.5″<\/strong> height and 5″<\/strong> width.<\/p>\n

\u00a0<\/p>\n

Change the line chart title to Heart Rates \u00a0\u00a0in April<\/strong> and \u00a0\u00a0bold the title.<\/p>\n

\u00a0<\/p>\n

Select the dates and select Text \u00a0\u00a0axis to remove the extra dates from the line chart.<\/p>\n

\u00a0<\/p>\n

You will change the font color \u00a0\u00a0for the axes to make the chart easier to read.
\u00a0<\/p>\n

\u00a0\u00a0Apply Black, Text 1 font color to the value axis and to the category axis on \u00a0\u00a0the line chart.<\/p>\n

\u00a0<\/p>\n

Now you want to apply a gradient \u00a0\u00a0fill color to the plot area to soften the image.
\u00a0<\/p>\n

\u00a0\u00a0Apply Light Gradient \u2013 Accent 1 gradient fill color to the plot area on the \u00a0\u00a0line chart.<\/p>\n

\u00a0<\/p>\n

Data labels provide exact \u00a0\u00a0details. In this case, adding data labels will provide exact heart rates.
\u00a0<\/p>\n

\u00a0\u00a0Add data labels in the above position on the line chart.<\/p>\n

\u00a0<\/p>\n

The April worksheet contains a \u00a0\u00a0range that identifies how many times in the month the patient had normal and \u00a0\u00a0high blood pressures. You decide a pie chart will help the patient visualize \u00a0\u00a0the data better.
\u00a0<\/p>\n

\u00a0\u00a0Create a 2-D pie chart using the ranges F3:F4 and H3:H4 in the April \u00a0\u00a0worksheet. Move the chart to start in cell A22 in the Charts sheet.\u00a0<\/p>\n

\u00a0<\/p>\n

Change the chart title to Percentage of \u00a0\u00a0Normal and High Blood Pressure<\/strong> and apply Black, Text 1 font color to the title.<\/p>\n

\u00a0<\/p>\n

Removing the legend can reduce \u00a0\u00a0extraneous elements in the chart. Adding data labels keep descriptions within \u00a0\u00a0each slice.
\u00a0<\/p>\n

\u00a0\u00a0Remove the legend. Add Category Name and Percentage data labels in the Best \u00a0\u00a0Fit position. Remove the Value data labels.<\/p>\n

\u00a0<\/p>\n

Changing the color of the high \u00a0\u00a0blood pressure slice and exploding it away from the other slice will \u00a0\u00a0emphasize it.
\u00a0<\/p>\n

\u00a0\u00a0Apply Red solid fill color to the High (Hypertension) slice and explode the \u00a0\u00a0slice by 6%.<\/p>\n

\u00a0<\/p>\n

The last chart you want to \u00a0\u00a0create is a combo chart to depict the blood pressure readings with the \u00a0\u00a0overlay of heart rates.
\u00a0<\/p>\n

\u00a0\u00a0Create a Clustered Column \u2013 Line on Secondary Axis combo chart using the \u00a0\u00a0range A2:D7 in the April worksheet. Move the chart to a chart sheet named Combo Chart<\/strong>.<\/p>\n

\u00a0<\/p>\n

After creating the chart, you \u00a0\u00a0will apply a chart style.
\u00a0<\/p>\n

\u00a0\u00a0Apply Style 4 chart style to the combo chart.<\/p>\n

\u00a0<\/p>\n

Change the chart title to Blood \u00a0\u00a0Pressure\/Heart Rates<\/strong>.<\/p>\n

\u00a0<\/p>\n

Select the dates and select Text \u00a0\u00a0axis to remove the extra dates from the chart<\/p>\n

\u00a0<\/p>\n

Apply Black, Text 1 font color \u00a0\u00a0and 11 pt font size to the two value axes and the category axis.<\/p>\n

\u00a0<\/p>\n

You decide to add a title to \u00a0\u00a0each axis to describe the data being plotted.
\u00a0<\/p>\n

\u00a0\u00a0Add a primary vertical axis title Blood Pressure<\/strong> and a secondary vertical axis title Heart Rate<\/strong>.<\/p>\n

\u00a0<\/p>\n

Move the legend to the top \u00a0\u00a0position.<\/p>\n

\u00a0<\/p>\n

You decide to remove one of the \u00a0\u00a0data series.
\u00a0<\/p>\n

\u00a0\u00a0Edit the data source to remove the 4\/1\/2024 data series.<\/p>\n

\u00a0<\/p>\n

Now you are ready to add Alt \u00a0\u00a0Text to the chart.
\u00a0<\/p>\n

\u00a0\u00a0Display the combo chart and add the Alt Text Shows blood pressure and heart rate for \u00a0\u00a0the last four weeks<\/strong>.<\/p>\n

\u00a0<\/p>\n

Finally, you add sparklines to \u00a0\u00a0the blood pressure readings and heart rates below the respective columns.
\u00a0<\/p>\n

\u00a0\u00a0Select range B8:D8 on the April worksheet. Insert Column Sparklines using \u00a0\u00a0data from the range B3:D7.<\/p>\n

\u00a0<\/p>\n

You want to customize the \u00a0\u00a0sparklines.
\u00a0<\/p>\n

\u00a0\u00a0Apply Blue sparkline color and display the high points for the sparklines.<\/p>\n

\u00a0<\/p>\n

Save and close Exp22_Excel_Ch03_Cumulative_Patient.xlsx<\/em>. \u00a0\u00a0Exit Excel. Submit the file as directed.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Exp22_Excel_Ch03_Cumulative_Patient Exp22 Excel Ch03 Cumulative Patient Excel Chapter 3 Cumulative – Blood Pressure Monitoring\u00a0 \u00a0\u00a0 Project Description: You work as a nurse in a health clinic. You record each patient\u2019s systolic and diastolic blood pressures each week. A number of patients have requested blood pressure data and charts. This information helps patients know if they […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-108118","post","type-post","status-publish","format-standard","hentry","category-education"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/108118","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=108118"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/108118\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=108118"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=108118"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=108118"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}