REDCap (Research Electronic Data Capture)
REDCap is a secure web application for building and managing online databases for research.
Using REDCap's stream-lined process for rapidly developing projects, you may create and design projects by constructing a 'data dictionary' template file in Microsoft Excel, which can be later uploaded into REDCap. REDCap provides audit trails for tracking data manipulation and user activity, as well as automated export procedures for seamless data downloads to Excel, PDF, and common statistical packages (SPSS, SAS, Stata, R). Also included are a built-in project calendar, a scheduling module, ad hoc reporting tools, and advanced features, such as branching logic, file uploading, and calculated fields.
REDCap Training: Register here for REDCap training sessions.
Steps to Create a REDCap Project
Step 1. Submit Access Request(s) and CTSC Application for Resource Use
- Service Catalog instructions for Requesting REDCap Access (PDF)
- Complete the online CTSC Application for Resource Use to request "Biomedical Informatics/Data Collection and Management" resources
Step 2. Request a Project
- Submit Project Level Agreement: Download and complete the REDCap project level agreement (PDF)
- Register for a REDCap Training Session to learn how to create a Data Dictionary
- Review CTSC documentation to learn how to construct a data dictionary
- Watch a video about how to construct a data dictionary
- Review the example data dictionary (Excel) to learn about the required format
Step 3. Create your REDCap database and establish permissions
- Receive feedback from Biomedical Informatics staff and complete the data dictionary
- Review data dictionary with biostatistician
- Upload data dictionary to your REDCap study. Enter any number of test patients while in Development mode to make sure all fields work as intended.
- Specify the roles and permissions of your study team members. You will need to know their UC Davis emails and Kerberos IDs (no passwords)
Step 4. Finalize database
- Ensure REDCap Project Level Agreement has been signed by the Princpal Investigator
- Ensure the project has been approved by the IRB (we will need your IRB Approval/Exemption letter)
Step 5. Begin collecting data
- Once IRB Approval/Exemption letter and Project Level Agreement are on file with the Biomedical Informatics group and you have validated all forms and fields, the Biomedical Informatics group will move your project from Development mode into Production mode. At that point, you may start collecting real patient data.