EPI 218: Data Collection and Management Systems for Clinical Research (Summer 2020)
Section outline
-
-
Data Collection and Management Systems for Clinical Research
EPI 218 Summer 2020 (1 unit)
.
Course Director: Michael A. Kohn, MD, MPP.
Associate Professor, Department of Epidemiology and Biostatistics
-
-
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
-
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 1 Segment 1 -- Introduction to the Epi 218 (20:11) Josh Senyak Media Resource
-
Lecture 1 Segment 2 -- Infant Jaundice Study, Data Management in Excel (30:08) Michael Kohn Media Resource
-
Previous versions had some typographical errors.
-
Assignment 1 Quiz
-
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.
-
Computer Lab: Excel: Good, Bad, and Ugly
Live online session in which students have access to course faculty for questions on current or prior curriculum, assignments and software implementation.
Faculty: Michael Kohn, Josh Senyak, Elizabeth Black, Hillary Braun, Chandana Gowdara, Hunter Holt, Leslie Suen
Location: Zoom URL -
Lecture: REDCap: Browser-based data collection
REDCap features; advantages/limitations; the relational limits of REDCap; instruments, events and repeating events; other features. We may cover coding conventions as well.
Faculty: Josh Senyak
-
Computer Lab: REDCap -- Creating a Web-Based Research Data Collection System
Live online session in which students have access to course faculty for questions on current or prior curriculum, assignments and software implementation.
Faculty: Michael Kohn, Josh Senyak, Elizabeth Black, Hillary Braun, Chandana Gowdara, Hunter Holt, Leslie Suen
Location: Zoom URL -
Lecture: REDCap Reporting and data exchange
More on REDCap: Reporting, exporting, and exchanging data with other systems
Faculty: Josh Senyak
-
REQUIRED: Watch 2020 Lecture 3 Recording: REDCap Reporting and data exchange Media Resource
-
[OPTIONAL: The 2019 version of Lecture 3. Contains additional information on interrater reliability] URL
-
-
Computer Lab: REDCap -- Monitoring, Reporting, Exporting
Live online session in which students have access to course faculty for questions on current or prior curriculum, assignments and software implementation.
Faculty: Michael Kohn, Josh Senyak, Elizabeth Black, Hillary Braun, Chandana Gowdara, Hunter Holt, Leslie Suen
Location: Zoom URL -
Lecture: The Relational Model
Primary Key; Foreign Key; One-to-Many relationships; Entity-Relationship Diagrams; Normalization.
Faculty: Michael Kohn
-
Epi 218 2020 Lecture 4 Segment 1 -- Intro / Data Dictionaries and Data Types Media Resource
-
Epi 218 2020 Lecture 4 Segment 2 -- Normalization, One-to-Many Relationships, Primary/Foreign Keys Media Resource
-
Epi 218 2020 Lecture 4 Segment 3 -- Exporting to Stata Media Resource
-
Upload Assignment 4 on the "Assignment 4" link above.
You must be logged in to use the link.
-
Computer Lab: First Access/SQL Lab
Live online session in which students have access to course faculty for questions on current or prior curriculum, assignments and software implementation.
Faculty: Michael Kohn, Josh Senyak, Elizabeth Black, Hillary Braun, Chandana Gowdara, Hunter Holt, Leslie Suen
Location: Zoom URL -
Lecture: More on normalized relational databases
Faculty: Michael Kohn
-
Lecture 5 Segment 1 -- Front End vs Back End, Splitting (22:21) Media Resource
-
Lecture 5 Segment 2 -- Advice About Final Project (10:00) Media Resource
-
Lecture 5 Segment 3 -- Relational Model, Normalization (10:32) Media Resource
-
Lecture 5 -- REDCap Data Entry Audits (3:11) Media Resource
-
8/30/2020 -- Compacted to make it slightly smaller. Some of the (fictional) names changed to eliminate duplicates. No changes will affect answers to Assignment 5.
-
8/30/2020 -- Updates some of the fictional names and addresses. No affect on answers to Assignment 5.
-
Computer Lab: Second Access SQL Lab, Filtering by Form, Queries, and Reports
Live online session in which students have access to course faculty for questions on current or prior curriculum, assignments and software implementation.
Faculty: Michael Kohn, Josh Senyak, Elizabeth Black, Hillary Braun, Chandana Gowdara, Hunter Holt, Leslie Suen
Location: Zoom URL -
Lecture: Wrap-Up of Relational Database Concepts ; Data Management Plan
Faculty: Josh Senyak
-
Lecture 6 - Part A: Wrap-up of Relational Database Concepts Media Resource
-
Lecture 6 - Part B: Final Project: Database Management Plan Media Resource
-
8/31/2020 -- Updated. No two included subjects have the same (fictional) name.
-
Computer Lab: Creating SQL Queries to Summarize Results and Export to Stata (or another statistical package)
Live online session in which students have access to course faculty for questions on current or prior curriculum, assignments and software implementation.
Faculty: Michael Kohn, Josh Senyak, Elizabeth Black, Hillary Braun, Chandana Gowdara, Hunter Holt, Leslie Suen
Location: Zoom URL -
Lecture: Research Database Demonstrations
Faculty: Michael Kohn, Josh Senyak and Elizabeth Black
-
Final Project Demo 1 (13:22)-- Michael Kohn, FLiPCUP Media Resource
-
This utility converts REDCap data exports to normalized Access data tables. (This utility is still in development; use caution and judgment in confirming that data is fully and correctly converted!)
More information: http://www.quicksilverconsulting.com/redwrap/
-
Due 9/18/2020 by 23:59.
See detailed requirements and FAQs in the Word document above.
-
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.
-
The FLiPCUP Study uses REDCap to collect data and an Access back-end database for storage, management, querying, reporting, and analysis of the data collected via REDCap. To review the FLiPCUP REDCap project, download the XML file here and use it to create a new REDCap project (see instructions, available below).
-
Computer Lab: Final project consultation
Live online session in which students have access to course faculty for questions on current or prior curriculum, assignments and software implementation.
Faculty: Michael Kohn, Josh Senyak, Elizabeth Black, Hillary Braun, Chandana Gowdara, Hunter Holt, Leslie Suen
Location: Zoom URL