Practical Data Management and Statistical Computing (BioEp691F)


Contacts

Outline
Assignments

Resources


Course Outline and Schedule
Last update: 20OCT2011 (subject to change)
Class Session: Topic
Tu 09/06/11

Introduction / Course Overview: Expectations and Management
Introduction to the Computer: Hardware and Software

Th 09/08/11 Complete Hardware and Software / Introduction to Dreamweaver
Tu 09/13/11

Dreamweaver / Website Design and Management
Site definition in CS5.5

Th 09/15/11

Data Management Systems
Case Studies -- Examples
Design of Data Collection Instruments

Tu 09/20/11 Review of class websites
Design of Data Collection Instruments / Introduction to Case Studies
Th 09/22/11 The Butterfly Ballot: Anatomy of a Disaster
Managing Data Collection, Coding and Entry / Introduction to Databases / MS Access
Tu 09/27/11 Data Management Systems
Th 09/29/11 Data Management Systems / Preparing forms for data entry
Tu 10/04/11

MS Access:  Database Development Notes:
Access 2000-2003 Notes
Access 2003 Illustration
Access 2007-2010 Notes

Access 2010 Illustration v2

Th 10/06/11 Quality Control and Documentation -- Introduce GROUP PROJECT
Tu 10/11/11 NO Class -- UMass is following Monday schedule
Th 10/13/11

Privacy and Protection of Data / GROUP PROJECT Time
Cyber Security Awareness Month

Tu 10/18/11 Privacy and Protection of Data -- GROUP PROJECT time
Th 10/20/11 Privacy and Protection of Data -- Group Project Time
Example Data Use Agreement
Example Authorization
Tu 10/25/11 Privacy and Protection of Data: Security / GROUP PROJECT time - Part I due in class
Th 10/27/11

GROUP PROJECT time
Introduction to SASGetting Started in SAS for Windows / Introduction to the DATA step

Tu 11/01/11

SAS: More on the DATA step -- lengths;  set vs. merge;  computation of new variables
Group Project -- Part II due in class

Th 11/03/11

More on the DATA step -- input, infile, file, put;  missing values; formats, labels

Tu 11/08/11 More on the DATA step -- lengths;  set vs. merge;  computation of new variables
Th 11/10/11

Unit 3:  Data set restructuring;

Tu 11/15/11

Unit 3:  multiple operations  (arrays)

Th 11/17/11

Unit 4:  PUT statement;  Date/Time values
Tu 11/22/11 Unit 4:   SAS Data step Functions
Th 11/24/11 Thanksgiving Holiday - No class
Tu 11/29/11

Unit 5: Summary Statistics and Frequency Tables
Example Data Cleaning Report

Th 12/01/11 Unit 5: Reporting Procedures
FINAL EXAM POSTED

Tu 12/06/11

Unit 6:  Procedures for Managing Data

Th 12/08/11

Last Class
Unit 7: Introduction to Macros

   
Th 12/16/11 FINAL EXAM DUE by noon!

 

Produced and maintained by the Dept of BioEpi at UMASS
Send comments or questions about this web site to Penny Pekow
Email: ppekow@schoolph.umass.edu
\bepi691f\\outline11.html
Last Update10/13/2011