Transcript REDCap at UVM

REDCap at UVM
Presented by Diantha Howard,
CCTS Biomedical Informatics
September 2011
What is REDCap
• Software and methodology for electronic data
collection and management
• REDCap database and REDCap Survey
• http://project-redcap.org/
• https://apollo.pantheon.fletcherallen.org/redcap
– (REDCap database)
• https://ccts.uvm.edu/redcap
– (REDCap survey only)
REDCap History
• 2004:
• 2006:
• 2011:
Started at Vanderbilt GCRC
Consortium started
250 Institutional Partners
– World-wide
– From CTSA, GCRC, RCMI and other institutions
– Over 20,000 studies with over 29,000 end-users
Advantages of REDCap
• Secure, web-based, with authentication and datalogging
• Free to REDCap Consortium members (UVM CCTS
is a member)
• Fast and flexible to design and implement
• Multi-site access (here through FAHC gateway)
• Exports data & syntax to common stat packages
(SPSS, SAS, Stata, R/S-Plus)
• 21 CFR Part 11 Capable
REDCap Home Screen
Databases you have access to:
Example of Data Entry Form
REDCap Calendar
Data Export and Import
• Data Export Tool:
–
–
–
–
Select all or certain fields from all or certain forms
De-identification options
Export data to a .csv file or
Export data and syntax for SAS, SPSS, R, Stata
• Data Import Tool:
– Download template (.csv) once database created
– Enter data into template and upload back to REDCap
– For Longitudinal study, each event must be imported
separately
Data Comparison Tools
Data Logging (Audit trail)
More REDCap Applications
• File Repository
– Can upload and retrieve documents and files
– E.g. Consent forms; exported data & syntax
• Rights administration
– You can assign rights to users on your study
– Global rights: Import/ export / reporting / database design
– Read/ edit/ no access (on form-by-form basis)
• Data Access Groups
– For Multi-site trials; users can only see data entered by their access
group
• Report Builder
– Create and save simple queries/ reports
• “Send-It” (Secure File Transfer)
Report Builder – Creating Report
Report Builder - Result
REDCap Graphical View
REDCap Stats
Training Resources
• Videos and some examples
– Overview
– Creating data forms
– Scheduling Module
– Types of Databases
– Data access groups
– Locking records
• “General Help & FAQs”
Citing REDCap