Section outline

  • Lecture: Data Tables--Rows=Records, Columns=Fields; Data Dictionaries=Metadata; Excel--a great tool, but not for data entry, storage, and management

    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 "meta-data".  What is great about Excel and why you can't use it for data entry, storage, and management.  Data table structure -- Wide ("short-fat") vs. Long ("tall-skinny").

    IMPORTANT: The course assignments require a MyResearch and REDCap account from UCSF Academic Research Systems (ARS).  We will submit the initial account request for all registered students in EPI 218. You should receive an email from ARS (or DocuSign) asking you to fill out an online attestation form in order to activate your MyResearch and REDCap account.

    Faculty:  Michael Kohn

    • Lecture Slides:

    • DBMSLecture1_2020.ppt File

      We updated the PPT file from 2019 to show this year's section leaders and due dates.

      8/23/2020 -- We have edited the Lecture 1 video and divided it into two segments to make for easier viewing.  The first segment is the course introduction by Josh Senyak, and the second segment is an introduction to the Infant Jaundice Study and to data management in Excel by Michael Kohn.  We recommend that you re-watch the Lecture 1 videos at 1.6x or 2x playback speed.

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

    • Lecture 1 Segment 1 -- Introduction to the Epi 218 (20:11) Josh Senyak Media Resource
      Not available unless: You belong to Registered Students Only
    • Lecture 1 Segment 2 -- Infant Jaundice Study, Data Management in Excel (30:08) Michael Kohn Media Resource
      Not available unless: You belong to Registered Students Only

    • Required Reading:

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

    • Assignment 0 to be completed prior to Lecture 1 on 7/30/2020:

      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).

      Do not confuse this with Assignment 1, which is due on 8/6/2020.

    • MyResearch Windows 10 Installation URL
    • MyResearch - Mac Instructions File

    • Assignment Due Date: Complete Assignment 1 Quiz and upload your Assignment 1 Excel xlsx file, LASTNAME_Epi218ExcelLab1.xlsx, below by 8/6/20 at midnight.

    • Assignment 1 Instructions (updated 7/29/20). Due 8/6/2020. File

      Previous versions had some typographical errors.

    • Assignment 1 Quiz
      Not available unless: You belong to a group in Registered Students Only
    • Assignment 1 Upload

      Upload LastName_Epi218Lab1Data.xlsx by clicking on the "Assignment 1 Upload" link above.  The link won't work unless you are logged into the CLE syllabus site.

    • Datasets:

    • Epi218ExcelLab1Data.xlsx File