Section outline

  • Questionnaires, Data Collection Forms and Data Management

    Development of paper and online questionnaires and data collection forms. The limitations of spreadsheet programs (e.g. Excel) for database management. Alternative software platforms for data collection and management.

    Faculty: Michael Kohn

    Faculty Bio:  Dr. Michael Kohn is an attending emergency physician at Mills-Peninsula in Burlingame and a professor in UCSF’s Department of Epidemiology and Biostatistics, where he has taught research methods, clinical epidemiology, and database management for the past 17 years.  He also provides consultations to clinical investigators who need help with study design, sample size calculations, data management, and statistical analysis.  His primary research interest is diagnostic testing in the ED.  He co-authored (with Thomas Newman) the clinical epidemiology textbook “Evidence-Based Diagnosis,” is a contributing author to Hulley et al, “Designing Clinical Research,” and created the UCSF CTSI’s online sample size calculators (www.sample-size.net).

    Faculty: Alison Huang

    Faculty Bio:  Dr. Alison Huang is general internal medicine physician and a professor in the UCSF Departments of Medicine, Urology, and Epidemiology & Biostatistics, where she conducts patient-reported outcomes research related to women's health, genitourinary health, and aging.  She directs several UCSF research training programs directed at UCSF residents, postdoctoral fellows, and junior faculty, and she also teaches clinical research methods in other UCSF courses such as the Clinical Trials course (Epidemiology 205).

    • Lecture Slides:

    • Lecture 6 (Michael Kohn) Slides File
    • Lecture 6 (Alison Huang) Slides File

    • Lecture Audio/Video Recording (Access restricted to registered students):

    • Lecture 6 (Michael Kohn): Data Collection Forms Media Resource
      Not available unless: You belong to a group in Registered Students Only
    • Lecture 6 (Alison Huang): Questionnaires - selecting and evaluating self-reported measures Media Resource
      Not available unless: You belong to Registered Students Only

    • Large Group Discussion (Access restricted to registered students): Brief formal review of lecture followed by question and answer discussion. Recorded lecture should be viewed prior to this session.

    • Lecture 6 Discussion Recording Media Resource
      Not available unless: You belong to a group in Registered Students Only

    • Assignment 6:

    • Assignment 6 File
    • Assignment 6 Example File

    • Materials:

    • NHAMCS Files (for Lecture 6 demonstrations) Folder
    • HOW TO GET A REDCap ACCOUNT 2015-0824 File
    • Field Name and Response Code Conventions File