Section outline


    • Data Collection and Management Systems 

      for Clinical Research


      EPI 218 Summer 2018 (1 units).
      Course Director: Michael A. Kohn, MD, MPP.
      Associate Professor, Department of Epidemiology and Biostatistics

    • Introductory Material
    • These guidelines for naming fields and coding responses are mostly arbitrary, but if we all follow them, it will be easier to share our data with one another.
    • Final Project
    • Due 9/20/2018 by 23:59.

      See detailed requirements and FAQs in the Word document above.

      Part A: Data Collection System

      1. We prefer that your database be populated with real data (de-identified if appropriate), but at least make sure to test your data collection system by entering at least 5 realistic test records in each instrument

      2. Make sure your field types are appropriate (e.g. if you are collecting a date, you should be using a date field type).

      3. All data collection systems must include at least two on-screen data collection forms.

      4. Access databases should have at least one one-to-many relationship and a form/subform as in Lab 4.  REDCap projects should use at least two instruments having a one-to-many relationship, one of which is a repeatable event or repeatable instrument as in Labs 2 and 3. ("Longitudinal data collection" is NOT required.)

      Part B: Data collection and management plan

      Make sure to outline how you will meet reporting requirements such as creating an NIH Report (see Lab 5).

      Extra credit will also be awarded if you provide a budget with your data collection and management plan.


    • Upload Parts A and B of your final project by clicking on "Final Project" above.

      You need to be logged on to the CLE website in order to use this feature.

      If you are using REDCap for your final project, instead of uploading Part A, make your section leader a user with administrative privileges.

    • Example Final Projects
    • The HPV Cytology Final Project used a REDCap data collection system.  Your section leader will share the HPV Cytology REDCap project with you.  This Access database is an example of a back-end database that you would need to enable storage, management, querying, reporting, and analysis of the data collected via REDCap.  If your final project uses a REDCap data collection system, you do not need to turn in a back-end database to complete Part A; just share your REDCap project with your section leader.  In your Part B write-up, you should describe what you will use to store, manage, query, report on, and analyze your data.  REDCap does not have these capabilities.  A relational database like Access is best, but a set of Stata .dta files is acceptable.  While an Excel workbook might have been a reasonable choice before you took this course, you should have learned that an Excel workbook is not an acceptable back-end repository for research data.

    • This long version of the Infant Jaundice Study Protocol  represents a modification of the original R01  proposal and is not an example of the  kind of two-page protocol that we are  asking from you as Part B  of your Final Project.    The  Access database is included in this zip file.