8
PubHlth 691F - Fall 2012
Practical Data Management & Statistical Computing, Section 2
Biostatistics and Epidemiology
UMass Amherst
Instructor: Carol Bigelow

Return to HOME page


For Students

Syllabus

Announcements

This Week

Lecture Notes


Homework and Exams


Computer Illustrations


Other Resources







Links, by Topic

1. Principles of Data Management

2. Ethical Management of Human Subjects Information

3. MS Excel for Epidemiology


4. Introduction to MS Access


5. Introduction to STATA

6. STATA for Data Description

7. STATA for Graphs

8. STATA for Analysis of One and Two Samples

9. STATA for Normal Theory Regression


10. STATA for Categorical Data Analysis


11. STATA for Logistic Regression

Syllabus




download adober reader

Download pdf of 2012 syllabus (pdf, 11 pp)

Instructor:
Carol Bigelow, PhD
School of Public Health
402 Arnold House
University of Massachusetts
Amherst, MA 01003
tel: 413/545-1319
email: cbigelow@schoolph.umass.edu


Teaching Assistant:
To be named
School of Public Health
Arnold House
University of Massachusetts
Amherst, MA 01003


TOP

 

Course Description
PubHlth 691F, Practical Data Management and Statistical Computing, Section 2, is an introduction to the design, maintenance and use of data management systems for the collection and analysis of research data, especially epidemiologic research data on humans. MS Excel, MS Access, and Stata are emphasized. Topics include: database development, Health Insurance Portability Accountability Act (HIPAA) compliance, data manipulation and cleaning, data summarization, and selected topics in statistical analysis programming. This course is designed for the UMass SPHHS student who has completed PubHlth 540 - Introduction to Biostatistics and PubHlth 640 - Intermediate Biostatistics and who seeks training in data management and the use of STATA.

Prerequisites:
PubHlth 540 and PubHlth 640; or previous or concurrent PubHlth 540 plus permission of instructor.


Course Objectives and Outcome Competencies

Course Objectives:
The overall goal of this course is to develop a working knowledge of data manipulation, best practices for the ethical maintenance of human subjects data, data summarization and its communication to lay and professsional audiences and use of Stata for selected data management and statistical analysis. This course has three parts:

 
I -

Database Development and Maintenance

 
II -

Data Summarization and Reporting

 
III -

Statistical Computing for Epidemiology


Outcome Competencies:
The specific outcome competencies include, but are not limited to the following:

1. The use of MS Access for the collection and maintenance of public health research data – You will acquire hand on experience in the design and use of a data entry system.

2. The organization and documentation of a data management systemYou will learn how to design and document a data management system that includes, but is not limited to, specification of directory structure, file naming, and backup.

3. Best practices for the ethical maintenance of human subjects data – You will gain knowledge of the Health Insurance Portability Accountabililty Act (HIPAA) and will incorporate its understanding into the structure of a data management system.

4. The prepration of data that is ready for statistical analysis – You will gain experience in several steps related to compiling data that is ready for statistical analysis: error checking, audit trail creation, formatting, labeling, etc. You will also learn how to merge files.

5. Data summarization for presentation to professional and lay audiences –
You will gain experience in using MS Word, MS excel and STATA for the production of tabular and graphical summaries of public health data. You will also write brief descriptions of these summaries.

6. STATA for basic statistical analysis of epidemiologic data –
You will acquire hands on experience in using STATA for selected basic statistical analyses of public health data: multiple linear regression, stratified analysis of rates, and logistic regression. Time permitting, we all also explore the use of STATA for other types of analyses that might be of interest to you.

TOP

Required Text:
Acock AC
A Gentle Introduction to STATA, Third Edition
Stata Press
2010
ISBN13: 978-1-59718-075-7 (Soft cover)

TOP


How to Obtain Stata

You may purchase Stata online at a student discount any time between July 26, 2012 and December 31, 2012. Follow the instructions on pages 3-5 of the pdf of the course syllabus (click here)


Office Hours:
By appointment.
Please call for an appointment (tel. 413-545-1319) or email your request to me at cbigelow@schoolph.umass.edu.

This course has 11 units
1. Principles of Data Management
2. Ethical Management of Human Subjects Information
3. MS Excel for Epidemiology
4. Introduction to MS Access
5. Introduction to STATA
6. STATA for Data Description
7. STATA for Graphs
8. STATA for Analysis of One and Two Samples
9. STATA for Normal Theory Regression
10. STATA for Categorical Data Analysis
11. STATA for Logistic Regression


Examination Schedule

Note - There will be no examination of units 4 and 9-11.

Exam Posting Date Due Date Units Covered
1
Monday October 8, 2012
Monday October 29, 2012
1- Principles of Data Management
2- Ethical Management of Human Subjects Info.
3- MS Excel for Epidemiology
2
Monday November 5, 2012
Monday November 26, 2012
5 - Introduction to STATA
6- STATA for Data Description
7 - STATA for Graphs
3
Monday December 3, 2012
Friday December 14, 2012
8- STATA for Analysis of One and Two Samples

TOP


Grading Policy:

Your course grade will be based on completion of 10 out of 14 practice sets and three examinations, as follows:

 
Percent of Course Grade
Practice Sets (Choose 10 out of 14)
25%
Examination 1
25%
Examination 2
25%
Examination 3
25%

Policy on Late Submissions of Practice Problems and Examinations
Sometimes, it is not possible to meet a class deadline. To accomodate this, I will accept late submissions for up to one week. Please be aware that, in consideration of your fellow classmates, a late submission carries a 20 point penalty. Thus, if you know you cannot meet a deadline, I encourage you to use the full week's grace time!

On Time
Full Credit for points scored
1-7 Days Late
Points scored - 20 points
8+ Days Late
0 points (no credit)

TOP

Posting Schedule Policies
Sorry .... In general, course materials and examinations will not be posted ahead of schedule

Letter Grade Determination:

A
95 and over
A -
90 - 94
B +
87-89
B
83-86
B -
80-82
C +
77-79
C
70-76
F
Below 70

TOP

Important Dates to Remember

First Week of Class:
Week 1 of the course is September 3-7, 2012

Last Day to Drop with no record - Monday September 17, 2012

Last Day to Drop with “DR”- Monday October 15, 2012

Last Day to Drop with “W”- Thursday October 18, 2012

Last Week of Class
December 3-7, 2012

Exam 3 Due - Friday December 14, 2012

TOP

Schedule of Lectures and Examinations

Week Date Unit - Lecture Postings and Due Dates
Course Opens
August 27-31, 2012
Course Website open - Welcome!
Monday August 27, 2012

Posting
(1) Course Introduction
1
September 3-7, 2012
Unit 1 - Principles of Data Management Monday September 3, 2012

Posting
(1) Notes 1. Principles of Data Management
(2) Practice Set 1. (Unit 1 - Principles of ...)
2
September 10-14, 2012
Unit 2 - Ethical Management of Human Subjects Information Monday September 10, 2012

Posting
(1) Notes 2. Ethical Manag. of Human Subj.
(2) Practice Set 2. (Unit 2 -Ethical Manag. )


DUE

(1) Practice Set 1. (Unit 1 - Principles of ).


3
September 17-21, 2012
Unit 3 - MS Excel for Epidemiologists Monday September 17, 2012

Posting
(1) Notes 3. MS Excel for Epidemiology
(2) Practice Set 3. (Unit 3 - MS Excel)


DUE

(1) Practice Set 2. (Unit 2 - Ethical Manag. of)
4
September 24-28, 2012
Unit 4 - Introduction to MS Access Monday September 24, 2012

Posting
(1) Notes 4. MS Access
(2) Practice Set 4. (Unit 4 - MS Access)


DUE

(1) Practice Set 3. (Unit 3 - MS Excel)
5
October 1-5, 2012
Unit 4 - Introduction to MS Access Monday October 1, 2012

Posting
(1) Practice Set 5. (Unit 4 - MS Access)


DUE

(1) Practice Set 4 (Unit 4 - MS Access)
6
October 8-12, 2012
Unit 5 - Introduction to STATA Monday October 8, 2012

Posting
(1) Notes 5. Introduction to Stata
(2) Practice Set 6 (Unit 5 - Intro to Stata)
(3) EXAMINATION 1 (Units 1-3, NOT 4)


DUE

(1) Practice Set 5 (Unit 4 - MS Access)
7
October 15-19, 2012
Unit 5 - Introduction to STATA Monday October 15, 2012

Posting
(1) Practice Set 7 (Unit 5 - Intro to Stata)


DUE

(1)Practice Set 6 (Unit 5 - Intro to Stata)
8
October 22-26, 2012
Unit 6 - STATA for Data Description Monday October 22, 2012

Posting
(1) Notes 6. Stata for Data Description
(2) Practice Set 8 (Unit 6 - Stata for Description)


DUE

(1) Practice Set 7 (UNit 5 - Intro to Stata)
9
October 29 - November 2, 2012
Unit 7 - STATA for Graphs Monday October 29, 2012

Posting
(1) Notes 7. Stata for Graphs
(2) Practice Set 9 (Unit 7 - Stata for Graphs)


DUE

(1) EXAMINATION 1 (Units 1-3, NOT 4)
(2) Practice Set 8 (Unit 6 - Stata for Description)
10
November 5-9, 2012
Unit 8 - STATA for Analysis of 1 and 2 Samples

Monday November 5, 2012

Posting
(1) EXAMINATION 2 (Units 5-7)
(2) Notes 8. Stata for 1 & 2 Samples
(2) Practice Set 10 (Unit 8 - 1 & 2 Samples)

DUE
(1) Practice Set 9 (Unit 7 - Stata for Graphs)

11
November 12-16, 2012
Unit 9 - STATA for Normal Theory Regression

Monday November 12, 2012

Posting
(1) Notes 9. Stata for Normal Theory Reg.
(2) Practice Set 11 (Unit 9 - Stata for Reg. )


DUE

(1) Practice set 10 (Unit 8 - 1 & 2 Samples)

12
November 19-23, 2012
Unit 9- STATA for Normal Theory Regression Monday November 12, 2012

Posting
(1) Practice Set 12 (Unit 9 - Stata for Reg.)

DUE

(1) Practice Set 11 (Unit 9 - Stata for Reg.)
13
November 26-30, 2012
Unit 10 - STATA for Categorical Data Analysis Monday November 26, 2012

Posting
(1) Notes 10. Stata for Categorical
(2) Practice Set 13 (Unit 10 - Stata for Categ.)

DUE

(1) EXAMINATION 2 (Units 5-7)
(2) Practice Set 12 (Unit 9 - Stata for Reg.)

14
December 3-7, 2012
Unit 11 - STATA for Logistic Regression Monday December 3, 2012

Posting
(1) Notes 11. Stata for Logistic Regression
(2) Practice Set 14 (Unit 11 - Stata for Logistic) (3) EXAMINATION 3 (Unit 8 )


DUE

(1) Practice Set 13 (Unit 10 - Stata for Categ.)
Course Closes
December 10-14, 2012
Course Close out

FRIDAY DECEMBER 14, 2012


DUE

(1) EXAMINATION 3 (Unit 8 )

TOP

 

TOP

ADA Accommodation Policy

Any student who, because of a disability, may require special arrangements in order to meet course requirements should contact me as soon as possible to make necessary arrangements.

Carol Bigelow, PhD
tel: 413/545-1319
fax: 413/545-1645
email: cbigelow@schoolph.umass.edu

Policy on Academic Dishonesty
The University of Massachusetts/Amherst Senate Document 89-026 defines academic dishonesty as including but not limited to:

a) Cheating – intentional deceit, trickery, or breach of confidence, used to gain some unfair or dishonest advantage in one’s academic work.
b) Fabrication – intentional falsification or invention of any information or citation in any academic exercise.
c) Facilitating dishonesty – knowingly helping or attempting to help someone else commit an act of academic dishonesty.
d) Plagiarism – knowingly representing the words or ideas of another as one’s own work in any academic exercise.
e) Submitting in whole or in part, without citation, prewritten term papers of another or the research of another (including but not limited to such materials sold or distributed commercially).

 

Visit the University of Massachusetts Website
Policy on Academic Dishonesty
.

TOP

 


 

TOP


University of Massachusetts at Amherst
Copyright 2012 University of Massachusetts, Amherst.
This is the course web site for PubHlth 691F Section 2, Biostatistics and Epidemiology.
Produced and maintained by the School of Public Health and Health Sciences.
Send comments or questions about this web site to cbigelow@schoolph.umass.edu.
Page updated: September 24, 2012