Data Presentation Assignment (50 pts)

READ this entire assignment before starting

Use the following information from a hospital Cancer Registry and ask the students to create an annual report for the hospital's Cancer Committee.

Creation of 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 (use the current year) Annual Report for the Hospital Cancer Registry for presentation at the next Cancer Conference. You are using data from the previous year. See GENERAL INSTRUCTIONS (below data) for details of assignment

NOTE TO STUDENTS: Use this current year for this report, as it will be more realistic and the data presented here may be for specific years.

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

Number of Lung Cancer Case Accessioned over a Five Year period

Lung Cancer-Age at Diagnosis

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 describedbelow.
2. Each graph should beprinted on a separate page. Label each graph asinstructed.

Exercises

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, (current year)

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