Section outline

  • Collapse all Expand all

  • Thursday, July 31, 2014; 8:30 AM - 9:20 AM

    Lecture: Tables and relationships, normalization, data types, and data dictionaries.

    Going from data collection forms to data tables in which rows correspond to records/entities and columns correspond to fields/attributes. The concept of a data dictionary or so-called "meta-data". Multi-table relational database and data normalization. Primary and foreign keys. One-to-Many, Many-to-Many, and One-to-One relationships.

    IMPORTANT: The course labs require a Department of Epidemiology and Biostatistics (DEB) Terminal Server account and a UCSF REDCap account. See the "Prospectus" memo below.

    Faculty:  Michael Kohn

    Location:      China Basin 6702

    • Prospectus:

    • Welcome to Epi 218 File
    • Lecture 1 Powerpoint File

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

    • Required Reading:

      Chapter 16 -- "Data Management" in Designing Clinical Research (Hulley et al), 4th Edition

    • Assignment:

      Work through the Chapter 16 ("Data Management") Exercises starting on page 301 of Designing Clinical Research (Hulley et al), 4th Edition.

      These are not to turn in (especially since the answers are in the book).

       

    • Final Project Due Date:  Early Warning - EPI 218 Final Project is due by midnight on 9/17/2014.

       

    • Final Project File

  • Thursday, July 31, 2014; 9:30 AM - 10:30 AM

    Computer Lab: Access: creating tables, relationships, and data entry forms

    Creating a table in design or “data dictionary” view. Field names, types, and descriptions; validation rules, primary and foreign keys, lookup tables, and relationships between tables. Creating data entry forms/subforms.

    Faculty:  Michael Kohn, Valerie French, Amy Gelfand, Susan Lee, Meghan McGarry, Varun Saxena, Frederick Wang

    Location:      CB 6702/CB 6704

    • Optional Reading:

    • Assignment:

      Complete Lab 1 on creating tables, relationships, and data entry forms in Access.

    • Epi 218 Lab 1 Instructions File
    • Data Collection Forms for Lab 1 File

    • Assignment Due Date:  Email the completed Access mdb or accdb file, LASTNAMElab1.mdb or LASTNAMElab1.accdb, to ucsfdbclass@yahoo.com by 8/7/2014 at midnight.

  • Thursday, August 7, 2014; 8:30 AM - 9:20 AM

    Lecture: Queries and on-screen forms

    Views/Select Queries; Action Queries: Update, Append, Delete; On-screen forms.

    Faculty: Michael Kohn


    Location:      CB 6702

    • Session Slides:

    • Lecture 2: Queries and Forms File

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

  • Thursday, August 7, 2014; 9:30 AM - 10:30 AM

    Computer Lab: Filtering by form, queries, reports, and importing data

    Filtering by form. Writing select queries and reports for monitoring study progress. Importing data and appending and updating records.

    Faculty:  Michael Kohn, Valerie French, Amy Gelfand, Susan Lee, Meghan McGarry, Varun Saxena, Frederick Wang

    Location:      CB 6702/CB 6704

    • Assignment: Optional narrative description

    • Lab 2 Instructions File

    • Assignment Due Date:  Make sure that you send the completed "Treasure Hunt" worksheet and both of the rtf files, “LastnameCountsByRace1.rtf” made prior to importing the new 2007 records and “LastnameCountsByRace2.rtf” made after importing the new records, to ucsfdbclass@yahoo.com as email attachments by 8/15/2014 at midnight.

    • Datasets:

    • Infant Jandice DB for Lab 2 File
    • Baby2012-13.xlsx File

  • Thursday, August 14, 2014; 8:30 AM - 9:20 AM

    Lecture: Wrap-Up of Relational Database Concepts

    Q&A: Execution and Results of the JIFee Study

    Faculty: Josh Senyak, Michael Kohn, and Tom Newman

    Location:  CB 6702

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

    • Required Reading:

    • Newman TB, et al. -- NEJM Infant Jaundice Study URL
      Not available unless: Your ID number contains 02

  • Thursday, August 14, 2014; 9:30 AM - 10:30 AM

    Computer Lab: Creating queries, calculating derived fields, and exporting to Stata

    Faculty:  Michael Kohn, Valerie French, Amy Gelfand, Susan Lee, Meghan McGarry, Varun Saxena, Frederick Wang

    Location:      CB 6702/CB 6704

    • Optional Reading:

    • Assignment: Optional narrative description

    • Lab 3 Instructions File

    • Assignment Due Date: 
      Send Lab 3 Worksheet to ucsfdbclass@yahoo.com by 8/21/2014 at midnight. See assignment file for details.

    • Datasets:

    • Infant Jaundice Database (Complete) File

  • Thursday, August 21, 2014; 8:30 AM - 9:20 AM

    Lecture: Web-based data entry forms: REDCap

    Faculty: Jennifer Creasman

    Location:  CB 6702

    • REDCap Powerpoint Presentation File

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

  • Thursday, August 21, 2014; 9:30 AM - 10:30 AM

    Computer Lab: REDCap: basic functions, advantages and limitations

    Faculty:  Michael Kohn, Valerie French, Amy Gelfand, Susan Lee, Meghan McGarry, Varun Saxena, Frederick Wang

    Location:      CB 6702/CB 6704

    • Assignment: Lab 4 on REDCap is due by 23:59 on 8/28/2014. You will need to add your section leader as a user to your REDCap project. See the lab instructions for details.

    • Lab 4 Instructions File

  • Thursday, August 28, 2014; 8:30 AM - 9:20 AM

    Lecture: REDCap (continued): Importing and Exporting Data

    Faculty: Jennifer Creasman

    Location:  CB 6702

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

    • Resources:

    • redCapSharedLibraryFromWithinYourStudy File

  • Thursday, August 28, 2014; 9:30 AM - 10:30 AM

    Computer Lab: REDCap: monitoring, reporting and exporting to Stata

    Faculty:  Michael Kohn, Valerie French, Amy Gelfand, Susan Lee, Meghan McGarry, Varun Saxena, Frederick Wang

    Location:      CB 6702/CB 6704

    • Assignment Due Date:  Lab 5 on REDCap is due at 23:59 on 9/4/2014. You will need to send a Word document containing an "NIH Report" and a treasure hunt worksheet to the course email address. See the lab instructions for details.

    • EPI 218 Lab 5 Instructions File

    • Datasets:

    • DataDictionaryForREDCapIJSLab5.csv File
    • DataForREDCapIJSLab5.csv File

  • Thursday, September 4, 2014; 8:30 AM - 9:20 AM

    Lecture: Oncore Demonstration

    Faculty: Sorena Nadaf, Lindsey Watt

    Location:  CB 6702

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

    • Example Final Project Part A -- CT Syndesmosis Study File

    • Resources:

  • Thursday, September 4, 2014; 9:30 AM - 10:30 AM

    Computer Lab: CANCELLED QuesGen: capabilities of a full-featured web-enabled platform
    This lab will be replaced with a Final Project consultation session.

    Faculty:  Michael Kohn, Valerie French, Amy Gelfand, Susan Lee, Meghan McGarry, Varun Saxena, Frederick Wang

    Location:      CB 6702/CB 6704

    • Assignment Due Date: 
      Lab 6 on QuesGen has been replaced by a Final Project consultation session.

    • Datasets:

  • Thursday, September 11, 2014; 8:30 AM - 9:20 AM

    Lecture: Web-Enabled Research Data Management with QuesGen;

    "Clinical Data Management" for Pharma Trials.

     

    Faculty: Michael Kohn

    Location:  CB 6702

  • Thursday, September 11, 2014; 9:30 AM - 10:30 AM

    Computer Lab: Final project consultation

    Faculty:  Michael Kohn, Valerie French, Amy Gelfand, Susan Lee, Meghan McGarry, Varun Saxena, Frederick Wang

    Location:      CB 6702/CB 6704