Expert answer:HIT 2040 Project

Expert answer:The project follows the presentation of the content in Chapter 11 Presentation of Data. Chapter 11 is a relatively standalone chapter and could be read out of chronological order. Read Chapter 11 first. The project is creating a Cancer Registry Report. The instruction document provides the information and data that you will need to complete the report.You will be designing graphs. If you need to review brush up on ‘how-to’ this website has some tutorials on how to make a chart or graph in using Excel. This is just one of MANY tutorials out there. Use what suits your learning best. https://blog.hubspot.com/marketing/how-to-build-excel-graphA rubric will be posted in this folder by Week 11.The project is worth 50 points. This document can be used as a resource and additional practice before completing the project. Additional Examples_HIT 2040 project resource.pdf Instructions: HT 2040 Project Cancer Registry Report v1.pdf Clarification: Some of the requirements state, ex: f. Page 9… ” (ask the student to choose an appropriate one)” this was a note for me (instructor) and I forgot to revise it on the final copy. My apologies. What it means is that the student should prepare an appropriate graph (bar, link, pie, scatter diagram, etc) that will best describe and display the information. Project Rubric HIT 2040 project rubric_2017(1).pdf
additional_examples_hit_2040_project_resource.pdf

hit_2040_project_rubric_2017_1_.pdf

ht_2040_project_cancer_registry_report_v1.pdf

Unformatted Attachment Preview

Additional Examples
Exercise 1: Prepare a table displaying the data shown below. A hospital’s administration wants
to investigate the number of discharges by the four common hospital services: January–
December 20XX
Medicine
2,224
Surgery
1,555
Obstetrics
946
Newborn
938
Answer:
Community Hospital
Annual Discharges
January–December 20XX
Medicine
2,224
Surgery
1,555
Obstetrics
946
Newborn
938
Totals
5,663
Exercise 2: Prepare a table displaying the data shown below. The hospital administration would
like a breakdown of the discharges shown above by payer classification. For example, Medicare,
Medicaid, Blue Cross/Blue Shield, other third party and self-pay
Medicine: 2,224
Medicare = 1,503
Medicaid = 244
Blue Cross/Blue Shield = 142
Other Third Party = 250
Self Pay = 85
Surgery: 1,555
Medicare = 755
Medicaid = 345
Blue Cross/Blue Shield = 230
Other Third Party = 200
Self Pay = 25
Obstetrics: 946
Medicare = 0
Medicaid = 205
Blue Cross/Blue Shield = 165
Other Third Party = 505
Self Pay = 71
Newborn: 938
Medicare = 0
Medicaid = 205
Blue Cross/Blue Shield = 165
Other Third Party = 505
Self Pay = 63
Answer:
Medicare
Medicaid
BC/BC
Other 3rd Party
Self Pay
Totals
Community Hospital
Annual Discharges
Payer Category
January–December 20XX
Medicine
Surgery
Obstetrics
Newborn Totals
1,503
755
0
0
2,258
244
345
205
205
999
142
230
165
165
702
250
200
505
505
1,460
85
25
71
63
244
2,224
1,555
946
938
5,663
Exercise 3: Prepare a bar graph displaying the data shown above in Exercise 1.
Answer:
Community Hospital
Annual Discharges
January – December 20XX
2,500
Number of Discharges
2,000
1,500
1,000
500
0
Medicine
Surgery
Obstetrics
Hospital Service
Newborn
Exercise 4: Prepare a comparison bar chart of the data shown in Exercise 2
Answer:
Community Hospital
Annual Discharges
January – December 20XX
1,600
1,400
Number of Discharges
1,200
1,000
Medicine
Surgery
Obstetrics
Newborn
800
600
400
200
0
Medicare
Medicaid
BC/BC
Other 3rd Party
Self Pay
Payor Category
Exercise 5: Your county public health department shows the following number of patients who
had an abortion during the past ten years who were under the age of 21. Construct a table of the
data then create a line graph.
Year
Number
Year
Number
2002
2003
2004
2005
2006
775
872
945
1,095
1,150
2007
2008
2009
2010
2011
1,156
1,306
1,458
1,546
1,945
Answer:
Your County Public
Health Department
Abortions 2002–2011
2002
775
2003
872
2004
849
2005
1,095
2006
2007
2008
2009
2010
2011
1,150
1,156
1,306
1,458
1,546
1,945
Answer:
Your Public Health Department
2002 – 2011
Abortions Under Age 21
2500
1945
2000
Number of Abortions
1546
1458
1306
1500
1150 1156
1095
872
1000
849
775
500
0
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
Years
Exercise 6: Community Hospital’s cancer registry reports the following lung cancer deaths due
to smoking cigarettes in the following years. Construct a line graph of the data.
2011 101
2012 90
2014
2015
102
104
2013 103
Answer:
Community Hospital
Lung Cancer Deaths Due to
Cigarette Smoking
110
Number of Deaths
105
104
103
101
100
102
95
90
90
85
80
2011
2012
2013
2014
2015
Years
Exercise 7: Your state reported dissolutions of marriage for 20XX as follows. Construct two pie
graphs of the data. Use Marriage Dissolutions—Male (or Female) as the title.
Males
No. 3 + 11%
No. 2 25%
No. 1 64%
Answer:
Females
No. 3 + 12%
No. 2 26%
No. 1 62%
Your State
Marriage Dissolutions
20XX
Males
11%
25%
No. 3 +
No. 2
No. 1
64%
Your State
Marriage Dissolutions
20XX
Females
12%
No. 3 +
No. 2
No. 1
26%
62%
Exercise 8: Your community mental health center has surveyed adult patients to determine their
perception of the quality of their treatment. The following data represent the patients’
perceptions of helpfulness. Construct a pie graph of the data.
Helped greatly
Not helped
Helped somewhat
Uncertain
Answer:
58.2%
4.2%
27.3%
10.3%
Community Health Center
Patient Perceptions of Helpfulness
20XX
10%
4%
27%
59%
Helped greatly
Helped somewhat
Not helped
Not certain
Exercise 9: Your state reported the top five leading causes of death for the following years:
Per 100,000 population. Construct a table and a line graph.
Year
1995 Heart Disease = 370 Cancer = 160 Cerebrovascular Dis = 110 Accidents = 50 Lower
Respiratory Diseases = 40
2000 Heart Disease = 360 Cancer = 160 Cerebrovascular Dis = 100 Accidents = 50
Lower Respiratory Diseases = 42
2005 Heart Disease = 340 Cancer = 165 Cerebrovascular Dis = 90 Accidents = 50
Lower Respiratory Diseases = 35
2010 Heart Disease = 330 Cancer = 170 Cerebrovascular Dis = 70 Accidents = 60
Lower Respiratory Diseases = 45
2015 Heart Disease = 300 Cancer = 200 Cerebrovascular Dis = 60 Accidents = 60
Lower Respiratory Diseases = 50
Answer:
Your State
Top Five Leading Causes of Deaths
Year
Heart Disease
Cancer
1995
2000
2005
2010
2015
300
330
340
360
370
160
160
165
170
200
1995‒2015
Cerebrovasc
Dis
60
70
90
100
110
Accidents
50
50
50
60
60
Your State
Top Five Causes of Death
1995 – 2015
400
Number per 100,000 Population
350
300
250
Heart Disease
Cancer
200
Cerebrovasc Dis
150
Accidents
Lower Resp Dis
100
50
0
1995
2000
2005
Years
2010
2015
Lower Resp
Dis
40
42
35
45
50
HIT 2040 project rubric
50 points
2.5 points Format – report follows all prescribed requirements – title page, page 2, pages 3-12.
2.5 points Grammar – there are no grammatical or spelling errors throughout the report.
5 points Page 2 alphabetical list is correct and components of Cancer Program are listed in correct
alphabetical order.
40 points Student presents appropriate graphs with correct information – 4 points each (2 pt. correct
graph is selected and used, 2 pt. information is correct and appropriately interprets the data.
page 3 pie graph of total cases
Page 4 column graph indicating age distribution
Page 5 pie chart indicating the state at diagnosis
Page 6 bar graph of males by site
Page 7 bar graph of females by site
Page 8 line graph incidence of lung cancer +5 years
Page 9 selection of an appropriate graph with age at diagnosis for lung cancer
Page 10 selection of an appropriate graph of how the diagnosis of lunch cancer was made
Page 11 selection of an appropriate graph of the histology of lung cancer
Page 12 bar graph of lung cancer treatment
Project Instructions: Create an Annual Report for the
Cancer Registry
PURPOSE: This exercise is designed to provide the student with experience in preparing
statistical presentations and to give the student practice designing graphs in a spreadsheet
software program.
PROCEDURE: You are preparing the 20XX Annual Report for the Hospital Cancer Registry for
presentation at the next Cancer Conference. You are using data from the previous year.
DATA: There were 547 new cases accessioned in the previous year.
Site
Number
Males
Females
Lung
77
67
10
Larynx
11
5
6
Colon
55
47
8
Stomach
16
8
8
Rectum
23
17
6
Uterus
27
0
27
Bladder
27
13
14
Prostate
23
23
0
Cervix
38
0
38
Breast
55
2
53
Others
195
98
97
Stage at Diagnosis
Number
In Situ
36
Localized
257
Regional
216
Distant
38
Age Distribution
Number
11–25
55
26–40
59
41–60
208
61–75
141
76+
84
Number of Lung Cancer Case Accessioned over a Five Year period
Year
Number
1998
33
1999
46
2000
40
2001
68
2002
77
Lung Cancer–Age at Diagnosis
Age
Number
0–44
0
45–54
3
55–64
18
65–74
52
75+
4
Diagnosis of Lung Cancer Made By:
How Dx Made
Number
Excision of lesion
2
Percutaneous biopsy
22
Bronchoscopy
49
Mediastinoscopy
4
Histology of Lung Cancer
Histology
Number
Squamous Cell
10
Adenocarcinoma
62
Undifferentiated
5
Lung Cancer Treatment
Type of Treatment
Number
Lobectomy
38
Pneumonectomy
19
Radiation only
4
Chemotherapy only
1
Combination
13
No treatment
2
GENERAL INSTRUCTIONS:
1. Prepare graphs as described below.
2. Each graph should be printed on a separate page. Label each graph as instructed.
Your report must have the following format:
1. Page 1
a. Prepare a title page for this Annual Report (in Word). The name of this report is:
Annual Report of the Cancer Program, 200X
Your school name Hospital
Your City, State
2. Page 2
a. Prepare an alphabetical listing of the Cancer Committee members. They include:
A. F. Catherson, M.D.
C. P. Tomeko, M.D.
A. B. Nichols, M.D.
L. E. Smith, D.O.
C. D. Seagram, D.O.
B.W. Ye, M.D.
b. Include also the Cancer Program Components in alphabetical order:
Home Health
Hospice
Multidisciplinary Cancer Committee
Cancer Registry
Radiation Oncology
Chemotherapy
Tumor Conference
Surgery
Diagnostic Radiology
Respite Care
Oncology Nursing Unit
Social Services
Chaplain Services
Nutrition Services
Laboratory and Histology
Pharmacy
Patient Support Group
American Cancer Society Support Group
3.
Page 3 and Subsequent pages (in this order)
a. Page 3: Prepare a pie graph of total cases.
b. Page 4: Prepare a column graph indicating the age distribution.
c. Page 5: Prepare a pie chart indicating the stage at diagnosis.
d. Pages 6 and 7: Prepare a bar graph of males by site and females by site.
e. Page 8: Prepare a line graph indicating the incidence of lung cancer cases over a five year
period.
f. Page 9: Prepare a graph (ask the student to choose an appropriate one) for age at diagnosis for
lung cancer.
g. Page 10: Prepare a graph (ask the student to choose an appropriate one) of how the diagnosis
of lung cancer was made.
h. Page 11: Prepare a graph (ask the student to choose an appropriate one) of the histology of
lung cancer.
i. Page 12: Prepare a bar graph of lung cancer treatment.
…
Purchase answer to see full
attachment

How it works

1. Paste your instructions in the instructions box. You can also attach an instructions file
2. Select the writer category, deadline, education level and review the instructions 
3. Make a payment for the order to be assignment to a writer
4.  Download the paper after the writer uploads it 

Will the writer plagiarize my essay?

You will get a plagiarism-free paper and you can get an originality report upon request.

Is this service safe?

All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades