All posts by : chebby

Exp22_Excel_Ch03_Cumulative_Patient

Project Description:

You work as a nurse in a health clinic. You record each patient’s 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’s blood pressure and heart rate. You are ready to create charts that you can use when discussing a patient’s blood pressure.

Start Excel. Download and open   the file named Exp22_Excel_Ch03_Cumulative_Patient.xlsx.   Grader has automatically added your last name to the beginning of the   filename.

Weekly blood pressure readings   have been entered for a sample patient. You want to create a clustered column   chart to compare the readings for the month. After you create the chart, you   will move it to a Charts sheet that will be used to contain several charts   for easy reference.
 

  Create a clustered column chart using the range A2:C7 on the April worksheet.   Move the chart to cell A1 in the Charts sheet.

The chart needs a descriptive,   easy-to-read title.
 

  Change the chart title to Blood Pressure Readings in April and bold the title.

You realize the chart might be   easier to read as a bar chart.
 

  Change the chart type to Clustered Bar.

You will increase the chart size   to make it easier to read on a display screen.
 

  Set 4″ height. 

You want to remove the   additional dates displayed on the category axis.
 

  Select the dates on the axis and display the Format Axis task pane. In the   Axis Options category, select Text axis to remove the extra dates from the   chart.

You want to arrange the dates   with the oldest date at the top.
 

  Display the dates in reverse order on the category axis so that 4/1/2024 is   at the top of the vertical axis.

Next, you will create a line   chart depicting the heart rate readings for the month. This chart will help   the patient see trends over time.
 

  Create a line chart using the ranges A3:A7 and D3:D7 on the April worksheet.   Move the line chart to start in cell I1 in the Charts sheet.

You decide to adjust the size of   the line chart.
 

  Set 3.5″ height and 5″ width.

Change the line chart title to Heart Rates   in April and   bold the title.

Select the dates and select Text   axis to remove the extra dates from the line chart.

You will change the font color   for the axes to make the chart easier to read.
 

  Apply Black, Text 1 font color to the value axis and to the category axis on   the line chart.

Now you want to apply a gradient   fill color to the plot area to soften the image.
 

  Apply Light Gradient – Accent 1 gradient fill color to the plot area on the   line chart.

Data labels provide exact   details. In this case, adding data labels will provide exact heart rates.
 

  Add data labels in the above position on the line chart.

The April worksheet contains a   range that identifies how many times in the month the patient had normal and   high blood pressures. You decide a pie chart will help the patient visualize   the data better.
 

  Create a 2-D pie chart using the ranges F3:F4 and H3:H4 in the April   worksheet. Move the chart to start in cell A22 in the Charts sheet. 

Change the chart title to Percentage of   Normal and High Blood Pressure and apply Black, Text 1 font color to the title.

Removing the legend can reduce   extraneous elements in the chart. Adding data labels keep descriptions within   each slice.
 

  Remove the legend. Add Category Name and Percentage data labels in the Best   Fit position. Remove the Value data labels.

Changing the color of the high   blood pressure slice and exploding it away from the other slice will   emphasize it.
 

  Apply Red solid fill color to the High (Hypertension) slice and explode the   slice by 6%.

The last chart you want to   create is a combo chart to depict the blood pressure readings with the   overlay of heart rates.
 

  Create a Clustered Column – Line on Secondary Axis combo chart using the   range A2:D7 in the April worksheet. Move the chart to a chart sheet named Combo Chart.

After creating the chart, you   will apply a chart style.
 

  Apply Style 4 chart style to the combo chart.

Change the chart title to Blood   Pressure/Heart Rates.

Select the dates and select Text   axis to remove the extra dates from the chart

Apply Black, Text 1 font color   and 11 pt font size to the two value axes and the category axis.

You decide to add a title to   each axis to describe the data being plotted.
 

  Add a primary vertical axis title Blood Pressure and a secondary vertical axis title Heart Rate.

Move the legend to the top   position.

You decide to remove one of the   data series.
 

  Edit the data source to remove the 4/1/2024 data series.

Now you are ready to add Alt   Text to the chart.
 

  Display the combo chart and add the Alt Text Shows blood pressure and heart rate for   the last four weeks.

Finally, you add sparklines to   the blood pressure readings and heart rates below the respective columns.
 

  Select range B8:D8 on the April worksheet. Insert Column Sparklines using   data from the range B3:D7.

You want to customize the   sparklines.
 

  Apply Blue sparkline color and display the high points for the sparklines.

Save and close Exp22_Excel_Ch03_Cumulative_Patient.xlsx.   Exit Excel. Submit the file as directed.

Assignment 1:

Assignment Requirements

Please answer the questions mentioned in “Chapter 2 Assignment” and “Chapter 3 Assignment” attached documents. 

[For Assignment 3, Question number 1: You will find dataset at this location – https://archive.ics.uci.edu/ml/datasets/Car+Evaluation]

I have also attached text book for reference.

Requirement: 

· ****Separate word document for each assignment****

· Maintain brief answers

· Add references separately if required.

· Strictly follow APA style writing. 

· No plagiarized content please! Attach a plagiarized report.

· Check for spelling and grammar mistakes!

· $8 max. Please bid if you agree.

 2.1 Scholarly Abstract Assignment – Quantitative

Create a 1-2 page single-spaced Analysis of Research abstract published scholarly articles related to a topic you selected in Week 1. This article should reflect a quantitative research method.

Brevity and being concise are important as this analysis is intended to be a brief summation of the research.

Each abstract must therefore consist of the following in this order:

1. Bibliographic Citation – use the correctly formatted APA style citation for the work as the title of your abstract, displaying the full citation in bold font.

2. Author Qualifications – name the qualification of each author conducting the research

3. Research Concern – one paragraph summary of the reason for the overall research topic

4. Research Purpose Statement AND Research Questions or Hypotheses – specific focus of the research

5. Precedent Literature – key literature used in proposing the needed research (not the full bibliography or reference list)

6. Research Methodology – description of the population, sample, and data gathering techniques used in the research

7. Instrumentation – description of the tools used to gather data (surveys, tests,interviews, etc.)

8. Findings – summation of what the research discovered and the types of analysis that were used to describe the findings (tables, figures, and statistical measures)

9. Conclusions – what did the findings show and how does that relate to current research

10. Suggestions for further research – based on the conclusions of the study, what additional research is needed

2.2 Scholarly Abstract Assignment – Qualitative

Create a 1-2 page single-spaced Analysis of Research abstract published scholarly articles related to a topic you selected in Week 1. This article should reflect a qualitative research method.

Brevity and being concise are important as this analysis is intended to be a brief summation of the research.

Each abstract must therefore consist of the following in this order:

1. Bibliographic Citation – use the correctly formatted APA style citation for the work as the title of your abstract, displaying the full citation in bold font.

2. Author Qualifications – name and qualification of each author conducting the research

3. Research Concern – one paragraph summary of the reason for the overall research topic

4. Research Purpose Statement AND Research Questions or Hypotheses – specific focus of the research

5. Precedent Literature – key literature used in proposing the needed research (not the full bibliography or reference list)

6. Research Methodology – description of the population, sample, and data gathering techniques used in the research

7. Instrumentation – description of the tools used to gather data (surveys, tests,interviews, etc.)

8. Findings – summation of what the research discovered and the types of analysis that were used to describe the findings (tables, figures, and statistical measures)

9. Conclusions – what did the findings show and how does that relate to current research

10. Suggestions for further research – based on the conclusions of the study, what additional research is needed

Discussion 3.1

What is Python?  What are some of the attributes of Python?  Why is Python preferred over some other languages? 

Discussion 3.2 

You can use python for many reasons, what are some of the uses of Python outside of academia?  

Discussion 3.3

What did you learn during this week in regards to Python?  

Case Study 3.1

Using google scholar to find an article about Python3 and tell the class about what the article says, giving your personal views on the article and what it has to say about Python3. Remember to deploy your personal views into the case study not just what the article has to say. Remember, the below instructions about peer-reviewed material.Writing Requirements

• 3–4 pages in length  (excluding cover page, abstract, and reference list)
• Include at least 2-3 peer-reviewed sources that are properly cited
• APA format, Use the APA template located in the Student Resource Center to complete the assignment.
• Please use the Case Study Guide as a reference point for writing your case study.

Will send Question

Write a brief paper on the following topic: Dark Web

1. What is the Dark Web? 

2. How is it accessed? 

3. How is it used by criminals? 

4. How can it be used in a positive way? 

5. How can be used by law enforcement and intelligence services. 

6. How can be used by private individuals.

Write between 200 and 300 words.  

Linden Company manufactures and sells a single product. Cost data for the product follow:
Variable costs per unit:
Direct materials. . . . . . . . . . . . . . . . . . . . . . . . . $ 6
Direct labor . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12
Variable factory overhead . . . . . . . . . . . . . . . . . 4
Variable selling and administrative . . . . . . . . . . 3
Total variable costs per unit . . . . . . . . . . . . . . . . . $25
Fixed costs per month:
Fixed manufacturing overhead . . . . . . . . . . . . . $ 240,000
Fixed selling and administrative . . . . . . . . . . . . 180,000
Total fixed cost per month . . . . . . . . . . . . . . . . . . $420,000
The product sells for $40 per unit. Production and sales data for May and June, the first two months of operations, are as follows:
Units Units
Produced Sold
May. . . . . . . . . . . 30,000 26,000
June . . . . . . . . . . 30,000 34,000
Income statements prepared by the Accounting Department, using absorption costing, are presented below:

 Required:
1) Determine the unit product cost under:
a. Absorption costing
b. Variable costing
2) Prepare contribution format variable costing income statements for May and June.
3) Reconcile the variable costing and absorption costing net operating incomes.
4) The company’s Accounting department has determined the break-even point to be 28,000 units per month, computed as follows:
$420,000 / $15 per unit = 28,000 units

Module 02 Content

1. Now that you have seen that digital technology has affected sociology, it is time to try your sociological skills and knowledge on the concept of privacy.
   In a 3-4 page paper please do the following:
   • Explore how privacy has changed in response to digital technology and dataveillance;
   • Describe what the future of privacy looks like
   • Discuss whether or not there a need to rethink the concept of privacy in the digital age? Why or why not?
   • This paper will need to include both valid references and also some of your own thinking outside the box, just make sure to make a valid defense of what you develop from your own thoughts if there is no reference to back it up!
     Remember to follow APA formatting.

      

1. Please share your thoughts about DoS and DDos.(your own words)

2. Please define the role of DoS versus DDos.(detailed)

I want to know how to create signature in  gmail ?