|
Software Training Manual: |
|
To
learn Excel (the Microsoft spreadsheet program), you will use a
self-guided instruction manual, presented below
(click
). Please print the
manual and on your own, start learning Excel. You will need the
program for the Problem One handout to be distributed on January 16,
2007.
|
|
Session |
Date |
Printable Adobe PDF |
| Title and pages |
PDF |
|
1 |
1/8/08 |
Software Training Manual (35 pages) |
 |
|
|
|
|
|
|
Graded Problems: |
|
The
course features two problems and a final project to be done using MS Excel spreadsheet
and MS Word word-processing (or other equivalent software)
(click
).
|
|
Session |
Date |
Printable Adobe PDF |
| Title and pages |
PDF |
|
2 |
1/11/08 |
Problem One |
 |
|
10 |
2/7/08 |
Problem One -- Suggested Answers |
 |
|
11 |
2/12/08 |
| Problem Two |
 |
| Partially completed DHLL Spreadsheet for Problem
Two (see below) |
-- |
|
15 |
2/27/08 |
Problem Two -- Suggested Answers |
 |
|
16 |
2/28/08 |
Final Examination Problem |
 |
|
-- |
3/26/08 |
Final Examination Problem -- Suggested Answers |
 |
|
|
|
|
|
|
Excel Programs: |
|
The
course presents several MS Excel programs of use by epidemiologists.
To download the programs, click
.
|
|
Session |
Date |
Excel Spreadsheet Program XLS |
| Title and pages |
XLS |
|
11 |
2/12/08 |
Partially completed DHLL Spreadsheet for Problem
Two |
 |
|
14 |
2/21/08 |
Vaccine Effectiveness (VE) |
 |
|
18 |
3/6/08 |
Tetanus |
 |
|
19 |
3/11/08 |
ARI |
 |
| ARI-INT |
 |
|
Assigned Reading: |
|
The
assigned readings by lecture are shown below
(click
). Please print the
readings and bring them to class
for discussion. There will be no readings distributed in class.
|
|
Session |
Date |
Printable Adobe PDF |
| Author, title, source,
pages and date |
PDF |
|
1 |
1/8/08 |
Smith, R.D. and LMacKellar, L. Global public goods and
the global health agenda: problems, priorities and potential.
Globalization and Health 3(9), 1-7, 2007. |
 |
|
2 |
1/10/08 |
Delisle,
H., Roberts, J.H., Munro, M., Jones, L., Gyorkos, T.W. The role of NGOs
in global health research for development. Health Res Policy Systems
3(1), 3-24, 2005. |
 |
|
Labont, R., Speigel, J. Setting global health research
priorities. BMJ 326; 722-723, 2003.
|
 |
|
3 |
1/15/08 |
Murray, C.J.L. Towards good practice
for health statistics: lessons from the Millennium Development Goal
health indicators. Lancet 329, 862-873, 2007. |
 |
|
Victora, C.G. Measuring Progress Towards
Equitable Child Survival. Where are the Epidemiologists? Epidemiology
18,669–672, 2007. |
 |
|
4 |
1/17/08 |
Black, R.E., Morris, S.S., Bryce, J.
Where and why are 10 million children dying every year? Lancet
361, 2226–34, 2003. |
 |
|
Victora, C.G.,
Black, R.E., Bryce, J. Learning from new initiatives in maternal and
child health. Lancet 370, 1113-4, 2007. |
 |
|
5 |
1/22/08 |
Walsh, J.A.
and Warren, K.S.: Selective Primary Health Care: An Interim Strategy for
Disease Control in Developing Countries. Social Science and Medicine
14C (Medical Economics), 145-163, 1980. |
 |
|
Wibulpolprasert, Suwit, Tangcharoensathien, Viroj,
Kanchanachitra, Churnrurtai. Three decades of primary health care:
reviewing the past and defining the future. Bulletin of the World Health
Organization 86(1), 3, 2008. SUPPLEMENT |
 |
|
6 |
1/24/08 |
Chen, L.C.:
Primary health care in developing countries: Overcoming operational,
technical, and social barriers. The Lancet 2,1260-1265, 1986. |
 |
|
7 |
1/29/08 |
Cullen, J.R.,
Chitprarop, U., Doberstyn, E.B., and Sombatwattanangkul, K.: An
epidemiological early warning system for malaria control in northern
Thailand. Bulletin of the World Health Organization 62, 107-114,
1984. |
 |
|
Frerichs, R.R.:
Epidemiologic surveillance in developing countries. Annual Review of
Public Health 12, 257-80, 1991. |
 |
|
8 |
1/31/08 |
Stalioraityte, E., Pangonyte, D.,
Kazlauskaite, D. Reliability of cause-specific mortality rate
statistics: case of Lithuania. Public Health 119(9):799-807,
2005. |
 |
|
Soleman, N. , Chandramohan, D., Shibuya,
K. Verbal autopsy: current practices and challenges. Bulletin of the
World Health Organization 84(3), 239-45, 2006. |
 |
|
Baiden, F., Baiden F, Bawah A, Biai
S, Binka F, Boerma T, Byass P, Chandramohan D, Chatterji S, Engmann C,
Greet D, Jakob R, Kahn K, Kunii O, Lopez AD, Murray CJ, Nahlen B, Rao C,
Sankoh O, Setel PW, Shibuya K, Soleman N, Wright L, Yang G. Setting
international standards for verbal autopsy. Bulletin of the World
Health Organization 85(8):570-1, 2007. |
 |
|
9-10 |
2/5&7/08 |
Bennett, K.J., Tugwell, P., Sackett, D.,
and Haynes, B.: Chapter 27: Relative Risks, Benefits, and Cost of
Intervention. in Warren, K.S. and Mahmoud, A.A.F. (eds):
Tropical and Geographical Medicine, McGraw-Hill Book Co., New York,
1990, pp. 205-228. |
 |
|
11 |
2/12/08 |
Romeder, J-M and McWhinnie, J.R.:
Potential Years of Life Lost between Ages 1 and 70: An Indicator of
Premature Mortality for Health Planning. International Journal of
Epidemiology 6, 143-151, 1977. |
 |
|
12 |
2/14/08 |
Ghana Health
Assessment Project Team. A Quantitative Method of Assessing the Health
Impact of Different Diseases in Less Developed Countries.
International Journal of Epidemiology 10, 73-80, 1981. |
 |
|
13 |
2/19/08 |
Meltzer, M.I.
Introduction to health economics for physicians. Lancet 358,
993-998, 2001. |
 |
|
WER. Anonymous. Cost effectiveness of
rotavirus vaccines and other interventions for diarrhoeal diseases:
meeting report 2006. Weekly Epidemiological Record 81 (37),
350-353, 2006. |
 |
|
14 |
2/21/08 |
Chen, R.T. and Orenstein, W.A.
Epidemiologic methods in immunization programs. Epidemiologic Reviews
18(2), 99-117, 1996.
|
 |
|
Torvaldsen, S., McIntyre, P.B.
Observational methods in epidemiologic assessment of vaccine
effectiveness. Communicable Disease Intelligence. 26(3), 451-7,
2002. |
 |
|
15 |
2/26/08 |
Vijayaraghavan, M., Lievano, F., Cairns,
L., Wolfson, L., Nandy, R., Ansari, A., Golaz, A., Mashal, T., Salama,
P. Economic evaluation of measles catch-up and follow-up campaigns in
Afghanistan in 2002 and 2003. Disasters 30(2), 256-69, 2006. |
 |
|
16 |
2/28/08 |
Lopez, A.D.
The evolution of the Global Burden of Disease framework for disease,
injury and risk factor quantification: developing the evidence base for
national, regional and global public health action. Globalization and
Health 1(1), 5 (22 Apr) 2005. |
 |
|
17 |
3/4/08 |
McKenna, M.T.,
Michaud, C.M., Murray, C.J., Marks, J.S. Assessing the burden of disease
in the United States using disability-adjusted life years. American J
Preventive Medicine 28(5), 415-23, 2005. |
 |
|
Chapman, G., Hansen, K.S., Jelsma, J.,
Ndhlovu, C., Piotti, B., Byskov, J., and Vos, T. The burden of disease
in Zimbabwe in 1997 as measured by disability-adjusted life years lost.
Tropical Medicine and International Health 11(5), 660-671, 2006.
|
 |
|
18 |
3/6/08 |
Enarson, P.M.,
Enarson, D.A., Gie, R. Management of the child with cough or difficult
breathing. International J Tuberculosis Lung Diseases
9(10):1083-1087, 2005. |
 |
|
Frerichs, R.R.,
Miller, R.A. and Sutrisna, B. Epidemiologic model for focusing research
on ARI intervention strategies among Indonesian children. Presented at
the American Public Health Association Meeting, Chicago,
Illinois, October 25, 1989. |
 |
|
19 |
3/11/08 |
Miller, R.A.
and Frerichs, R.R.: An integrated approach to operations research for
strengthening family planning programs: a case example in Kenya.
International Journal of Community Health Education 13(3): 183-199,
1993. |
 |
|
20 |
3/13/08 |
Mathers, C.D., Loncar, D. Projections of
global mortality and burden of disease from 2002 to 2030. PLoS
Medicine 3(11), 2011-2030, 2006. |
 |