SYNCHRONOUS SESSION DEMO
Assignment: WEEK 5 REDCAP ECRF DESIGN
Aim
To understand basic design principles for data capture forms and how to interact with the REDCap
system.
Instructions
In Part A, you will implement a data collection form in REDCap (hosted at
https://www.datacourse.org). You will build a form in REDCap and then export the Data Dictionary
of that form.
In Part B, you will design your own REDCap survey form.
PART A
To begin the assignment, you will need to log into the Coursera training version of REDCap.
For access, 1) Make sure you are logged into Coursera website;
2) Navigate to the REDCap site: https://www.datacourse.org ; then
3) Click on the Log In Using Coursera button.
Part A The first part of this assignment (Part A) is to create a single case report form in a single study
database.
Start by creating a new empty project titled: Coursera – First REDCap Exercise.
This will give you a new project with a single case report form called “My First Instrument.” Rename
“My First Instrument” to say “Baseline Information.”
Your starter form already contains one field called “Record ID.”
The field is set up like this:
Starter Field:
Field Name = record_id
Field Label = Record ID
Field Type = Text Box (Short Text)
No Validation
Field 1:
Variable Name = first_name
Field Label = First Name
Field Type = Text Box (Short Text)
No Validation
Identifier = Yes
Field 2:
Variable Name = dob
Field Label = Date of Birth
Field Type = Text Box (Short Text)
Validation = Date (Y-M-D)
Identifier = Yes
Field 3:
Variable Name = gender
Field Label = Gender
Field Type = Multiple Choice – Radio Buttons (Single Answer)
Field Coding = 1, Female 2, Male
Field 4:
Variable Name = weight
Field Label = Weight (kg)
Field Type = Text Box (Short Text)
Validation = Number
Field 5:
Variable Name = travels_past_3 months
Field Label = Where has study participant lived or traveled in last year?
Field Note = check all that apply
Field Type = Checkboxes (Multiple Answers)
Field Coding = 1, China
2, Italy
3, Australia
4, Europe
5, North America
6, South America
7, Other
Field 6:
Variable Name = travels_past_year_other
Field Label = Please specify
Field Type = Notes Box (Paragraph Text)
** There are additional special instructions for this field. We do not want Field 6 to display unless the
user checks “Other” in Field 5. Your task is to use branching logic to display Field 6 only when a user
selects “Other” for Field 5 (travels_past_year).
To access the branching logic options, click the two-headed green arrow icon for Field 6 (Figure 1).
This functionality is described in more detail in the demonstration videos for this week.
When you’ve added Fields 1-6, test the form to ensure everything looks good and branching logic is
working. Remember that you cannot use the Online Designer to test your form. The Online Designer
is only a visual aid for forms design.
Click “Add/Edit Records” and create a new record to test your form using fake data (Figure 2). Make
sure the branching logic is working for the “Other” field. When you’re done testing, click “Edit
instruments” to return to the Online Designer.
Once you have tested your form, return to the “Project Setup” page and download the current Data
Dictionary for your project.
This will produce a *.csv file similar to the one shown in Figure 4. Save this file to your computer.
PART B
1. Create a project in REDCap consisting of a single de-identified survey designed to
collect health-related information around traditional holidays and celebrations in your
country or region.
2. Ask as many friends or colleagues to complete the survey as needed to ensure you
receive at least 10 responses.
3. Write a short, structured report detailing the topic of your survey, population
characteristics of your respondents, survey findings and lessons learned from conducting
the survey and reporting your findings
Your data collection survey should meet the following requirements:
It should be short and concise – with 8-15 total question/answer pairs. Your
respondents should be able to complete the survey in <2 minutes.
The survey should be de-identified. Do not include any HIPAA identifiers
(http://cphs.berkeley.edu/hipaa/hipaa18.html)
Include questions that will allow you to describe your survey population (see
requirements for Survey Report, below.)
Include at least one numeric data collection field (with range validation).
Include at least one categorical field (i.e., choose one [or more] answer among several
options).
Include at least one branching logic field. The branching logic option should not be so
obscure that your classmates cannot find it when grading the assignment.
