External Resources

Research Electronic Data Capture (REDCap)
REDCap is a secure, web-based application for quickly building and managing online surveys, data collection forms and databases. 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.

Box
Box offers unlimited, HIPAA-compliant data storage that is free and easy to use. The intuitive cloud-based tool provides secure, 24/7 access to files from any location, on any device.

Qualtrics
Qualtrics makes it easy to generate surveys, process data, and create reports that help you share your findings.

CTSI Biostatistics, Epidemiology and Research Design (BERD) Program
The BERD Program provides integrated services and biostatistical support. Services include (1) contemporary data analysis methodology consultation, implementation and epidemiology expertise, (2) the best available clinical data management software, (3) study design assistance and (4) bioinformatics/computational biology data analysis.

CTSI Informatics Program
The Informatics Program provides access to electronic health record (EHR) data across multiple institutions, builds computation resources for data management, analysis and sharing, and formulates and implements coordinated plans for providing data security.

UCLA Institute for Digital Research and Education (IDRE)
The IDRE website is a rich repository of instructional materials for popular statistical software packages (including SPSS, SAS, Stata and R). Additionally, IDRE offers UCLA investigators hands-on courses covering varied topics in statistical programming, as well as a walk-in consulting service.

Office of the Human Research Protection Program (OHRPP)
HIPAA research guidelines and information, including a list of protected health information (PHI) identifiers.

Excel Tips and Tricks

Many investigators use Excel for data collection. We have prepared two example Excel datasets that highlight common data cleaning challenges. The tips and tricks described will help you save time when analyzing your data using statistical software.

Database Sample 1
Database Sample 2

Data Dictionary Sample 1
Data Dictionary Sample 2