Section outline

  • 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 an RAE (formerly 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 RAE (MyResearch) and REDCap account.

    Faculty:  Michael Kohn

    • Lecture Slides:

    • DBMSLecture1_2021.ppt File

      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 these 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 (28:23) Michael Kohn Media Resource
      Not available unless: You belong to Registered Students Only

    • Required Reading:

      Chapter 19 -- "Data Management" in Designing Clinical Research (Browner et al), 5th Edition

    • Chapter 19 REVISED FINAL 2021.0507 for posting File

    • Assignment 0 to be completed prior to lab for Assignment 1 on 7/22/2021:

      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 7/29/2021.

    • Assignment Due Date: Complete Assignment 1 Quiz and upload your Assignment 1 Excel xlsx file, LASTNAME_Epi218ExcelLab1.xlsx, below by 7/29/21 at 11:59pm.

    • Assignment 1 Instructions. Assignment due 7/29/2021. File
    • 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