REDCap Training 101. Introduction to building project in REDCap.

 
REDCap Training 101
 
Introduction to building project in REDCap
 
Sui Tsang
REDCap@Yale Team
1/24/2022
 
Introduction and Learning Objective
 
Learn how to access training materials.
Understand how to set up a REDCap project.
Know how to manage user rights.
Find out how to export data to statistical
packages.
 
 
What is REDCap?
 
What are the advantages of REDCap?
 
How do I get set up in REDCap?
 
To request a new account, select
Request Study Account
 on the REDCap@
Yale portal website.
Two REDCap implementations available:
 
 
REDCap@Yale
 
Yale NetID and password is required for login
CANNOT reset password in REDCap.  Reset your Yale
NETID through Yale ITS.
 
Training Resources
 
23 training videos available in REDCap
 
List of Training Videos
 
1.
Brief Overview
2.
Detailed Overview
3.
Data Entry Overview
4.
Introduction to Instrument
Development
5.
Online Designer
6.
Data Dictionary
7.
Project Field Types
8.
Applications Overview
9.
The Calendar
10.
Scheduling Module
11.
Data Access Groups for multi-site
projects
12.
Types of Projects
 
13.
Traditional Project
14.
Single Survey Project
15.
Longitudinal Project
16.
Longitudinal Project + Scheduling
17.
Operations
18.
Defining Events in Longitudinal
Projects
19.
Designating Instruments for Events
in Longitudinal Projects
20.
Repeatable instruments and events
21.
REDCap Mobile App
22.
Locking Records
23.
Data Resolution Workflow
 
Training Resources
 
Where can you find help and answers?
HELP & FAQ in REDCap
This is also a good place to look up syntax for calculated field, branching
logics or piping.
 
Training Resources
 
‘How to’ links throughout REDCap. For
example, in online designer:
 
MORE Training Resources
 
Where can you find help and answers?
HELP & FAQ on the 
REDCap@Yale portal website
We also offer a library of step-by-step tutorials to address commonly
asked questions from our Yale end-users.
 
 
 
 
QUESTIONS?
 
 
 
SETTING UP YOUR PROJECT:
 
WHERE DO I BEGIN?
 
How do I create a new project in REDCap?
 
Click the 
‘+New Project
’ tab, fill in the form
  Remember to enter the PI and study information
Click ‘Send Request’.
 
 
 
 
 
 
 
After we verify you have an account, we will create the
project and notify you via email within 1-2 business days.
 
REDCap FAQ
Project Design
 
Decide What Type of Project is Needed
 
1.
Classic Database – Each form can only be
completed once. One record per subject.
2.
Longitudinal –
Data collected multiple times per subject
Fixed number of collection points that correspond to
pre-defined events (e.g. initial evaluation, 3mo. follow-
up, 6mo. follow-up, 1yr follow-up)
Optional scheduling via a project calendar
Can have multiple study arms
 
Decide How to Collect the Data
 
Data Entry
Data entered by REDCap users (i.e. research staff).
Offline data collection available via mobile app.
Survey
On-line survey completed by participants.
 Participants do 
not
 need to have a Yale NetID.
A project can have both
surveys and data entry forms.
 
How to Set Up your Project
 
Project Setup: Enable Settings
 
If applicable:
1.
Enable longitudinal setting
2.
Enable survey setting
 
How to Set Up your Project
 
Project Setup: Build your Design Instruments
 
Design the project instruments using either (a.)
online designer or (b.) data dictionary.
 
Project Set Up: Building with the On-line Designer
 
a.
On-line Designer
Allows you to create/modify/delete data collection
instruments and fields (questions) using your web browser.
Changes are made in real time and available immediately
for review and testing.
 
1. Edit field
 
2. Copy field
 
3. Specify branching logic
 
4. Move field (can move to other form)
 
5. Delete
field
 
Project Set Up: Building with the On-line Designer
 
Project Set Up: Building with the Data Dictionary
 
b. Data Dictionary
The Data Dictionary is a formatted spreadsheet in CSV
(comma separated format) containing the metadata used to
construct data collection instruments and fields.
 
 
 
 
This is recommended for
advanced users.
 
To use this feature, you will download the current dictionary,
make modifications, and THEN upload the modified data
dictionary on the data dictionary page.
 
Project Set Up: Building with the Data Dictionary
IMPORTANT
: Always upload the ENTIRE data
dictionary. Never upload a partial data dictionary.
 
Building Forms: Using the Online Designer
 
First field of the first form
must be the record key
(e.g. Participant ID).
This field cannot be
deleted or moved.
Data in this field must be
unique.
This field can be auto-
assigned by REDCap
 
(Project Setup 
 Enable optional
modules
 Enable auto-
numbering for records)
 
 
Building Forms: Field Name
 
Each field name must be
:
Unique
Lowercase
Contain fewer than 26 characters
Contain only letters, numbers, and underscores.
In general, field names should be as short in
length as possible 
and
 maintain meaning.
 
Building Forms: Field Types
 
Building Forms: Using Validations
Validation is an important
tool that can be used to
prevent errors.  It also helps
when exporting data to
statistical packages.
 
Building Forms: Drop Down Field
 
Building Forms: Action Tags
 
Action tags allow you to perform special actions within
REDCap.  Each action tag has a corresponding action
that is performed for the field.
In REDCap, action tags begin with the '@' sign
Placed inside a field’s “Field Annotation”.
 
REDCap FAQ
Features-Basic
 
Building Forms: Action Tags
Refer to REDCap
on-line designer
for description of
each action tag
 
Building Forms: Smart Variables
 
Allow reference information other than data fields
(e.g., event, repeat instance, DAG or users)
Example: Set the default value of a field to be the value of the
previous event.
 
 
Building Forms: Smart Variables
 
Building Forms: Smart Variables Examples
 
Other examples
:
1.
Branching logics based on event name
 
    
[event-name]=‘baseline_arm_1’
2. Branching logics based on arm number
 
     [arm-number]=‘1’
3. Age at first instance of repeating instrument
[age][first-instance]
 
Building Forms: Tagging Identifiers
 
Fields that constitute protected health
information (PHI) can be marked as an
“Identifier”
These fields can then be excluded on data
export, allowing for analysis of “de-identified”
data
Users can also be restricted in their ability to
export Identifier fields based on access rights
 
Building Forms: Calculated Fields
 
 
 
Calculations can only result in numbers (i.e., cannot use
calculated field to concatenate strings or return a date).
Examples:
     
Age calculation: rounddown((datediff([dob],[hosp_date],"y")),0)
       Sum of scores: sum([field1], [field2], [field3])
Refer to ‘Help and FAQ’ for more examples or click
 
in the online designer.
Best practice: Do not use calculated fields excessively on data
collection instruments.
 
Building Forms: Branching Logic
 
You can use a 
Drag-N-Drop Logic Builder 
or 
Advanced Branching
Logic Syntax
You can use fields on the current data entry form OR other forms
If fields from different events are used in branching logic, the
field name needs to be preceded by an event name, e.g.
[screening_arm_1][field1]
Event names can be found in ‘Define My Events’ page
 
Building Forms: Piping
 
Without Piping:
 
With Piping:
 
Building Forms: Piping
 
How to use piping:
 
REDCap FAQ
Features-Basic
 
Building Forms: Field Embedding
 
No field embedding:
 
 
 
 
 
 
 
With field embedding:
 
 
 
 
QUESTIONS?
 
How to Set Up your Project
 
Defining Events
Longitudinal Projects
 
Defining Events allows you to:
Use data collection forms multiple
times for any given project record.
Generate new schedules to display
on the Calendar.
 
REDCap FAQ
Project Design
 
How to Define Events
Unique event
name is auto-
generated.
This is where you
will find the event
names for use in
branching logic.
 
How to Designate Instruments to Events
 
The event list and instrument mappings can be downloaded from one
project and uploaded to another project.
 
How to Set Up a Survey
 
Enable any form as a survey in On-line Designer
1.
Open survey setting
2.
Configure the survey
 
Survey features:
Schedule automated survey invitations
Set up a survey queue
Create unique login code for survey respondents
Set up researcher notifications upon survey
completion
 
 
How to Send Surveys to Participants
 
1.
Public link: survey must be the first form.
Record will be created as each survey is
completed
2.
Designate an email field for sending survey
(recommended method)
3.
Add participants to ‘Manage survey
participants’ page
REDCap has many advanced features that can be used
for setting up surveys.
This will be covered in the survey training.
 
REDCap FAQ
Surveys
 
How to Set Up your Project
 
Optional Modules: Repeatable Instruments
REDCap can
repeat a data
collection
instrument or an
entire event an
unlimited
number of times
without having
to pre-specify
the frequency.
 
Optional Modules: Repeatable Instruments
 
Repeatable instruments shown on record
home page:
 
REDCap FAQ
Project Design
 
 
 
 
QUESTIONS?
 
 
 
FINAL STEPS BEFORE IMPLEMENTATION:
 
USER RIGHTS AND TESTING
 
Granting User Rights in REDCap:
Individual Users
 
User access can be set up by  “Custom Right” or “Role
Based” access
Best Practice
: “Role Based” access
 
REDCap FAQ
Data Security
& Protection
 
Granting User Rights in REDCap:
Individual Users
Basic Rights =  Access
to the Project
 
Data Viewing Rights =
Access to Individual
Forms
Exporting data is NOT linked to Data
Entry Rights. User with Full Export
Rights can export ALL data from the
data collection instruments.
 
Granting User Rights in REDCap:
Data Access Groups (DAGs)
 
“Data Access Group” is an advanced feature that is useful
for multi-center trials and collaborations, especially for
HIPAA compliance.
Users in a particular Data Access Group can only see
records entered by other users in that Data Access Group
 
 
 
REDCap FAQ
Data Security
& Protection
 
Granting User Rights in REDCap:
Assigning Users to multiple DAGs
 
Users can be assigned to more than one DAG using the DAG
Switcher setting.
 
 
Testing your Project
 
Testing, Testing, Testing!
Make sure you test your project thoroughly by entering test data.
Have other users enter data or complete surveys. Also export the
test data to make sure the format can be used for data analysis.
 
Moving your Project to Production
 
 
 
 
QUESTIONS?
 
Using Data Exports, Reports and Stats
 
Exporting Data
 
You can export the entire dataset or select forms/fields
 
REDCap FAQ
Data Security
& Protection
 
Exporting Data
 
Setting Up Reports in REDCap
REDCap has many
advanced features
that can be used
for exports and
reports.
This will be
covered in the
Data Report,
Export and Import
training.
 
Stats and Charts
 
Data Dictionary Codebook
 
The Data Dictionary Codebook is a ‘human’ readable, read-only version of the
project data dictionary.
You can find the Codebook link on the left menu.
 
 
 
 
QUESTIONS?
 
Thank You!
 
Further Questions: Contact us at
REDCap@yale.edu
Slide Note
Embed
Share

Learn how to access training materials, set up a REDCap project, manage user rights, and export data to statistical packages. Understand the advantages of REDCap including remote access, multi-site collaborations, customization, accuracy, and security measures. Discover how to request a new account, login with Yale NetID, and access training resources and videos within REDCap.

  • REDCap
  • training materials
  • data management
  • research databases
  • user rights

Uploaded on Mar 13, 2024 | 1 Views


Download Presentation

Please find below an Image/Link to download the presentation.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.

E N D

Presentation Transcript


  1. REDCap Training 101 Introduction to building project in REDCap Sui Tsang REDCap@Yale Team 1/24/2022 S L I D E 0

  2. Introduction and Learning Objective Learn how to access training materials. Understand how to set up a REDCap project. Know how to manage user rights. Find out how to export data to statistical packages. S L I D E 1

  3. What is REDCap? Web-based software used to create and manage research databases and participant surveys. Developed as a tool to help researchers collect and manage data effectively and responsibly. S L I D E 2

  4. What are the advantages of REDCap? Accessible remote web-based access (on and off campus) access for multi-site collaborations Customizable fast and flexible to design modifications at anytime Accurate ensures consistent and accurate data entry data quality checks to look for errors Secure multi-factor user authentication using Yale Active Directory data stored on secure cloud servers protected by firewalls S L I D E 3

  5. How do I get set up in REDCap? To request a new account, select Request Study Account on the REDCap@ Yale portal website. Two REDCap implementations available: S L I D E 4

  6. REDCap@Yale Yale NetID and password is required for login CANNOT reset password in REDCap. Reset your Yale NETID through Yale ITS. S L I D E 5

  7. Training Resources 23 training videos available in REDCap S L I D E 6

  8. List of Training Videos 1. Brief Overview 13. Traditional Project 2. Detailed Overview 14. Single Survey Project 3. Data Entry Overview 15. Longitudinal Project 4. Introduction to Instrument Development 16. Longitudinal Project + Scheduling 17. Operations 5. Online Designer 18. Defining Events in Longitudinal Projects 6. Data Dictionary 7. Project Field Types 19. Designating Instruments for Events in Longitudinal Projects 8. Applications Overview 9. The Calendar 20. Repeatable instruments and events 10. Scheduling Module 21. REDCap Mobile App 11. Data Access Groups for multi-site projects 22. Locking Records 23. Data Resolution Workflow 12. Types of Projects S L I D E 7

  9. Training Resources Where can you find help and answers? HELP & FAQ in REDCap This is also a good place to look up syntax for calculated field, branching logics or piping. S L I D E 8

  10. Training Resources How to links throughout REDCap. For example, in online designer: S L I D E 9

  11. MORE Training Resources Where can you find help and answers? HELP & FAQ on the REDCap@Yale portal website We also offer a library of step-by-step tutorials to address commonly asked questions from our Yale end-users. S L I D E 10

  12. QUESTIONS? S L I D E 11

  13. SETTING UP YOUR PROJECT: WHERE DO I BEGIN? S L I D E 12

  14. How do I create a new project in REDCap? Click the +New Project tab, fill in the form Remember to enter the PI and study information Click Send Request . REDCap FAQ Project Design After we verify you have an account, we will create the project and notify you via email within 1-2 business days. S L I D E 13

  15. Decide What Type of Project is Needed 1. Classic Database Each form can only be completed once. One record per subject. 2. Longitudinal Data collected multiple times per subject Fixed number of collection points that correspond to pre-defined events (e.g. initial evaluation, 3mo. follow- up, 6mo. follow-up, 1yr follow-up) Optional scheduling via a project calendar Can have multiple study arms S L I D E 14

  16. Decide How to Collect the Data Data Entry Data entered by REDCap users (i.e. research staff). Offline data collection available via mobile app. Survey On-line survey completed by participants. Participants do not need to have a Yale NetID. A project can have both surveys and data entry forms. S L I D E 15

  17. How to Set Up your Project S L I D E 16

  18. Project Setup: Enable Settings If applicable: 1. Enable longitudinal setting 2. Enable survey setting S L I D E 17

  19. How to Set Up your Project S L I D E 18

  20. Project Setup: Build your Design Instruments Design the project instruments using either (a.) online designer or (b.) data dictionary. S L I D E 19

  21. Project Set Up: Building with the On-line Designer a. On-line Designer Allows you to create/modify/delete data collection instruments and fields (questions) using your web browser. Changes are made in real time and available immediately for review and testing. S L I D E 20

  22. Project Set Up: Building with the On-line Designer 3. Specify branching logic 4. Move field (can move to other form) 2. Copy field 1. Edit field 5. Delete field S L I D E 21

  23. Project Set Up: Building with the Data Dictionary b. Data Dictionary The Data Dictionary is a formatted spreadsheet in CSV (comma separated format) containing the metadata used to construct data collection instruments and fields. This is recommended for advanced users. S L I D E 22

  24. Project Set Up: Building with the Data Dictionary To use this feature, you will download the current dictionary, make modifications, and THEN upload the modified data dictionary on the data dictionary page. IMPORTANT: Always upload the ENTIRE data dictionary. Never upload a partial data dictionary. S L I D E 23

  25. Building Forms: Using the Online Designer First field of the first form must be the record key (e.g. Participant ID). This field cannot be deleted or moved. Data in this field must be unique. This field can be auto- assigned by REDCap (Project Setup Enable optional modules Enable auto- numbering for records) S L I D E 24

  26. Building Forms: Field Name Each field name must be: Unique Lowercase Contain fewer than 26 characters Contain only letters, numbers, and underscores. In general, field names should be as short in length as possible and maintain meaning. S L I D E 25

  27. Building Forms: Field Types TEXT - single-line text box (for text, numbers and dates etc.) NOTES - large text box for multiple lines of text DROPDOWN - dropdown menu with options RADIO - radio buttons with options CHECKBOX - checkboxes to allow selection of more than one option FILE - upload a document CALC - perform real-time calculations SQL - select query statement to populate dropdown choices DESCRIPTIVE SLIDER - text displayed with no data entry and optional image/file attachment - visual analogue scale; YESNO - radio buttons with yes and no options; coded as 1, Yes | 0, No TRUEFALSE - radio buttons with true and false options; coded as 1, True | 0, False - display a group of similar multiple-choice fields in a very compact area on a page MATRIX SIGNATURE - draw signature with mouse or finger S L I D E 26

  28. Building Forms: Using Validations Validation is an important tool that can be used to prevent errors. It also helps when exporting data to statistical packages. S L I D E 27

  29. Building Forms: Drop Down Field S L I D E 28

  30. Building Forms: Action Tags Action tags allow you to perform special actions within REDCap. Each action tag has a corresponding action that is performed for the field. In REDCap, action tags begin with the '@' sign Placed inside a field s Field Annotation . REDCap FAQ Features-Basic S L I D E 29

  31. Building Forms: Action Tags Currently available action tags @APPUSERNAME-APP @INLINE @READONLY Refer to REDCap on-line designer for description of each action tag @BARCODE-APP @LATITUDE @READONLY-APP @CALCDATE @LONGITUDE @READONLY-FORM @CALCTEXT @MAXCHECKED @READONLY-SURVEY @CHARLIMIT @MAXCHOICE @SETVALUE @DEFAULT @NOMISSING @SYNC-APP @HIDDEN @NONEOFTHEABOVE @TODAY @HIDDEN-APP @NOW @TODAY-SERVER @HIDDEN-FORM @NOW-SERVER @TODAY-UTC @HIDDEN-PDF @NOW-UTC @USERNAME @HIDDEN-SURVEY @PASSWORDMASK @WORDLIMIT @HIDEBUTTON @PLACEHOLDER @HIDECHOICE @RANDOMORDER S L I D E 30

  32. Building Forms: Smart Variables Allow reference information other than data fields (e.g., event, repeat instance, DAG or users) Example: Set the default value of a field to be the value of the previous event. S L I D E 31

  33. Building Forms: Smart Variables S L I D E 32

  34. Building Forms: Smart Variables Examples Other examples: 1. Branching logics based on event name [event-name]= baseline_arm_1 2. Branching logics based on arm number [arm-number]= 1 3. Age at first instance of repeating instrument [age][first-instance] S L I D E 33

  35. Building Forms: Tagging Identifiers Fields that constitute protected health information (PHI) can be marked as an Identifier These fields can then be excluded on data export, allowing for analysis of de-identified data Users can also be restricted in their ability to export Identifier fields based on access rights S L I D E 34

  36. Building Forms: Calculated Fields Best practice: Do not use calculated fields excessively on data collection instruments. Calculations can only result in numbers (i.e., cannot use calculated field to concatenate strings or return a date). Examples: Age calculation: rounddown((datediff([dob],[hosp_date],"y")),0) Sum of scores: sum([field1], [field2], [field3]) Refer to Help and FAQ for more examples or click in the online designer. S L I D E 35

  37. Building Forms: Branching Logic You can use a Drag-N-Drop Logic Builder or Advanced Branching Logic Syntax You can use fields on the current data entry form OR other forms If fields from different events are used in branching logic, the field name needs to be preceded by an event name, e.g. [screening_arm_1][field1] Event names can be found in Define My Events page S L I D E 36

  38. Building Forms: Piping Without Piping: With Piping: S L I D E 37

  39. Building Forms: Piping How to use piping: REDCap FAQ Features-Basic S L I D E 38

  40. Building Forms: Field Embedding No field embedding: With field embedding: S L I D E 39

  41. QUESTIONS? S L I D E 40

  42. How to Set Up your Project S L I D E 41

  43. Defining Events Longitudinal Projects Defining Events allows you to: Use data collection forms multiple times for any given project record. Generate new schedules to display on the Calendar. REDCap FAQ Project Design S L I D E 42

  44. How to Define Events Unique event name is auto- generated. This is where you will find the event names for use in branching logic. S L I D E 43

  45. How to Designate Instruments to Events The event list and instrument mappings can be downloaded from one project and uploaded to another project. S L I D E 44

  46. How to Set Up a Survey Enable any form as a survey in On-line Designer 1. Open survey setting 2. Configure the survey Survey features: Schedule automated survey invitations Set up a survey queue Create unique login code for survey respondents Set up researcher notifications upon survey completion S L I D E 45

  47. How to Send Surveys to Participants 1. Public link: survey must be the first form. Record will be created as each survey is completed 2. Designate an email field for sending survey (recommended method) 3. Add participants to Manage survey participants page REDCap FAQ Surveys REDCap has many advanced features that can be used for setting up surveys. This will be covered in the survey training. S L I D E 46

  48. How to Set Up your Project S L I D E 47

  49. Optional Modules: Repeatable Instruments REDCap can repeat a data collection instrument or an entire event an unlimited number of times without having to pre-specify the frequency. S L I D E 48

  50. Optional Modules: Repeatable Instruments Repeatable instruments shown on record home page: REDCap FAQ Project Design S L I D E 49

More Related Content

giItT1WQy@!-/#giItT1WQy@!-/#giItT1WQy@!-/#giItT1WQy@!-/#giItT1WQy@!-/#giItT1WQy@!-/#giItT1WQy@!-/#giItT1WQy@!-/#