1 / 11

EPI 218 REDCap: Basic functions, advantages, and limitations

EPI 218 REDCap: Basic functions, advantages, and limitations. Josh Senyak, Database Developer, Quicksilver Consulting 22 August 2013. Review: Advantages of MS Access. Fully relational Full control of software and data Advanced data validation

sharlene-barbier
Download Presentation

EPI 218 REDCap: Basic functions, advantages, and limitations

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. EPI 218REDCap: Basic functions, advantages, and limitations Josh Senyak, Database Developer, Quicksilver Consulting 22 August 2013

  2. Review: Advantages of MS Access • Fully relational • Full control of software and data • Advanced data validation • Built-in tools for query, data manipulation, reporting, analysis • Transportable • Vast “ecosystem” of users, training materials, assistance, templates, etc.

  3. Review: Limitations of MS Access • Network rather than Internet • Advanced features require training • A full-featured application requires a competent developer • User is responsible for backups and security

  4. Introducing REDCap • REDCap=“Research Electronic Data Capture” • Developed at Vanderbilt University • Designed specifically for clinical research • Web-based infrastructure • A basic data collection tool is very fast and easy to set up

  5. The REDCap model • Deployed within a collaborative, international network (725 institutional partners, 103K end users reported) • Licensing is limited to non-commercial research • Available free to UCSF researchers through UCSF Academic Research Systems

  6. Advantages of REDCap • Web-based – data entry anywhere • Extremely easy to set up and manage • Back-up and security are managed by REDCap • No cost for institutional partners

  7. Limitations of REDCap • Not relational but flat file… • …lacks flexibility and power for subsidiary records, medication lists, lab results, etc. • Limited tools for data viewing, querying, manipulation, or analysis. • Limited data validation. • No advanced programming or custom features. • Rigid navigation (i.e., can’t view subject’s visits within a subform).

  8. Setting up a REDCap database • Set up database by online form OR by uploading a data dictionary • Data entry via “instruments” (=both table and form) • Relate data via “events” • Development status vs production status

  9. Would you use REDCap or Access….? • For trauma patients in ED, results of voluntary drug and alcohol screening • Add: score overall injury severity • Add: chart review of all future trauma-related ED visits for two years, with location of injuries • Add: data collected from five hospitals nationwide

  10. REDCap Lab • Create your own database (Infant Jaundice Study) – enter three subjects, five exams • NEXT WEEK: Work with an existing database; export and analyze data

  11. REDCap Lab – things to notice • Ease of use (point, click, drag) • Searching for existing records is relatively difficult • Many tables, fields, forms are pre-designed for research use • Some vocabulary & concepts (“arms,” “events,” etc.) are REDCap-specific and take a little while to learn

More Related