Collecting Data via Redcap and Uploading It to Spss for Analysis

Data Access

……..User Rights

Clicking on "User Rights" in the toolbar on the left will bring y'all to a screen displaying the electric current users on the project, and the rights to which they have access. You may also add new users to your project with customized rights, or create "roles" (such as P.I., Data Manager, or Statistician) with specific rights so that you may assign new users to a role right away. For research teams of iv or more than people, creating roles is recommended.

Being able to customize the access that individuals take to your projection ensures that specific roles are going to be maintained, even if whatever breaches would exist accidental.

[TIPS AND TRICKS]: For multi-site studies and other special situations, information technology may exist advantageous to have entire groups of users blinded to unabridged sets of records. Utilizing the "Information Access Groups" (DAGs) tool is the easiest mode to accomplish this. Once the DAGs are created, you may but see records that have been created by another member of your DAG. This tightens security and prevents data overlap.

……..Logging

By clicking the "Logging" tool in the left-side toolbar, you can view the entire inspect trail throughout the life of the project. Each issue's category and specific change is listed along with the time/engagement and user's username. The logging box is easily filterable, and can even be downloaded to a atypical CSV file if need be.

……..Report Architect

In the Report Builder awarding accessible from the left-side toolbar, you may view the results of a specific field or fields for all records in your project. The purpose of various reports can be to isolate records, identify groups, study sure demographics of your participant population, and more. Permit'due south say I want to produce a full general demographic report of my participants along with their resting heart rate and BMI. To generate a new study, click the "Study Builder" tool in your left-side carte du jour.

Proper noun your report, and specify the variables you would similar to the report to display. You may choose to society the results in a specific manner to make data viewing easier. In this example, I take sorted by professional school, and and so within the groups of professional schools, I have sorted by gender. Once you are finished organizing the details, click "Save Report."

Clicking "View" adjacent to the championship of your report after you have saved it will present the electric current information report (come across below). This is updated in real fourth dimension equally your data is nerveless. You may export your reports to .CSV or .XML format; yous may besides merely print your report.

NOTE: Please notice the number in parentheses adjacent to certain variable names below. This number represents the encoded value of each multiple-selection variable option, and does Not represent the number of records with that result.

Let's say nosotros only want to view records for those enrolled in the UMKC School of Nursing. To practise this, we will utilize the "Limiters" in the initial "Create a New Report" folio.

Y'all will notice that this fourth dimension, I have specifically indicated that I want to come across only the records where [professional school] = Schoolhouse of Nursing. Below is the event when viewing the report:

Notice that although x total records were queried, only 4 records matched our atmospheric condition, and thus but 4 are shown.

You may have multiple reports that yous would similar to generate for your projection. This is easily tracked through REDCap. Each written report is even given its ain shortcut in the Reports Module (which will appear one time you take created your first report).

[TIPS AND TRICKS]:

In the Study Builder, filtering/sorting past fields is easiest for fields that are single-answer multiple choice (drop-downwardly, radio buttons, truthful/false, aye/no).

Each report changes in existent fourth dimension as new data records (or surveys) are created for the project. Once again records are completed, you can go dorsum to the aforementioned report and it will update accordingly.

……..Importing data

If you lot are conducting a report for which y'all already have some partial data, or if you are simply importing data from an additional source, using the Data Import Tool is 1 of the easiest ways to reach this chore. First, you will be prompted to download one of two .CSV templates: 1 arranging separate records into rows, and another into columns. Whichever you choose may depend on how your other data is already arranged, and/or whichever yous aesthetically prefer.

Once you have downloaded the template, use a plan (generally Excel) to make full in the records, ensuring that the correct variables are slotted into the correct places. Then, on the same Data Import application page, y'all may re-upload the .CSV file and import your new data records.

NOTE: This section deals with importing data records into your project. For more information on importing your information dictionary (i.east. your information forms), see the Data Dictionary section.

[TIPS AND TRICKS]: For ease of information transfer, ensure that the gild of the variables is the same on both your external source and your REDCap data forms.

……..Exporting data

When accessing the Data Export Tool, you can either cull the "Simple Data Consign" or "Advanced Information Export" option. If you only want to export sure fields or forms, or if you desire to de-place the data before exporting, select "Avant-garde Data Export." If you wish to consign all of the data you accept access to, "Simple Data Export" is the best route.

Exporting your information "Raw" volition consign coded values. For instance, in a yes/no field type, data coded in that column will either be "1" or "0" – not "yeah" or "no." In addition, field titles will be the coded versions of the variable names, rather than the field labels. The "Labeled" information selection is precisely the opposite – exporting articulate, labeled versions rather than coded values. For efficiency and compatibility with statistical analysis tools, we often recommend exporting raw values.

The Data Export Tool is compatible with many analysis programs: Excel, SPSS, SAS, R, and Stata.

[TIPS AND TRICKS]: Exporting data to programs other than Excel produce syntax files, which are not always the easiest to deal with. Frequently, exporting to .CSV and so using your preferred statistical analysis program to import the .CSV is the ideal option. If y'all do cull this choice, to ensure you are getting the data precisely the way y'all desire it, be certain to download 1 of the .CSV files listed next to "Excel" rather than the 1 listed next to your programme of option.

Beyond Development Fashion

……..Production Way

In one case your project has been created and tested fairly, you may be ready to move to Product mode and brainstorm collecting real data. Allow 48 – 72 hours after requesting for your project to be reviewed and canonical for Production. If your study requires IRB approving, your IRB number must be attached to your projection before nosotros volition corroborate the projection for Production status. For more information on what must be done in Development before moving to Production, come across the Evolution vs Production Modes department.

By default, moving to Production erases all existing practice records, calendar events, and all other associated exercise data. It is a very thorough way to flush all of the practise information out of your project before collecting existent data, however, it is optional. One time your project is approved for Production, you volition receive an electronic mail alerting you to its new status. At present, your projection is gear up for existent data to exist collected.

Specific Study Designs

……..Survey-based studies

In order to apply the survey features of REDCap, yous must take enabled the utilize of surveys in your "Main projection settings" options on your Project Setup domicile page.

In one case this is enabled, a new module in your left-side menu will exist available: "Manage Survey Participants." Upon entering this module for the kickoff time, you will be prompted to enable at least one of your existing information drove forms as a survey. There are many customizable survey settings that yous will be prompted to confirm, which you may edit later by clicking the "Survey settings" option next to the form on the front folio of your Online Designer.

One time yous have enabled a data class as a survey and yous have navigated to the Manage Survey Participants module, yous will come across iii tabs: Public Survey Link, Participant List, and Survey Invitation Log.

The Public Survey Link is a singular URL to your survey, which does not rail IP addresses, eastward-mail addresses, or any other identifying data. This means that any person with that survey link can take the survey multiple times if need be. While this is an optimal feature for some surveys, information technology is non the all-time option for projects in which we must ensure that no participant has taken the survey more than one fourth dimension. New records that are created by survey submissions announced in your existing records in automobile-numbered order and are labeled only by the appointment/time of submission.

The Participant List tab will enable y'all to send out a puddle of e-mails to participants from REDCap. Each e-mail volition comprise a unique URL that is only valid for one submission. To add the email addresses of your participants to the participant list, click "Add together participants" and type in the e-mail addresses, one per line. This will only create your pool of participant electronic mail addresses; no eastward-mails take been sent out past the completion of this footstep. This is in instance you lot would like to send the surveys out in batches rather than all at ane fourth dimension. To actually brainstorm sending out the survey e-mails, click the "Compose Survey Invitations" button.

Y'all may designate the time at which the east-mails are sent out, the subject of the electronic mail, any additional content or comments of the electronic mail invitation, and the checklist of participants to whom you would like to send the due east-mail.

Subsequently, once you return to the Manage Survey Participants module (seen beneath), yous will run across the list of participants along with a sent/unsent status regarding the electronic mail invitation, and a status checking whether or not the participant has responded. If Participant Identifiers are not enabled, there is no way to link an private's eastward-mail address to a particular record, maintaining survey anonymity. If necessary for your records, you may consign the participant list as a .CSV file.

The Survey Invitation Log (not pictured) allows you to sort your participant list with various filters and view some finer details (such equally the time at which a survey invitation was sent out to a participant). Individual times at which survey invitations should be sent out (if the invitation to a participant is not already sent) can be modified here.

[TIPS AND TRICKS]:

We do not recommend enabling multiple data collection forms as surveys if all surveys will exist sent to all participants. If there is concern about survey length, the best solution is to divide groups of questions into sections with section headers (a field blazon) in the Online Designer and setting the Question Brandish Format equally "One section per page" in your Survey Settings.

If you have a long list of e-mail service addresses separated by some punctuation other than line breaks, using the "Supervene upon" feature (Windows shortcut Ctrl-H) in a program such as Word or Notepad++ volition easily fix this formatting so that you can paste the list into REDCap. For instance, if your east-mail addresses are separated by "; " (semicolon space), in the Replace window of Microsoft Word, simply have the program notice "; " and supersede with "^l" (carat lowercase-Fifty). (In Notepad++, line breaks are specified with "\n" rather than "^l".)

If there is some other e-mail accost you would like to accept the survey due east-mails come up from (besides the main e-mail address associated with your account), you may click the "From:" drop-downwards box in the "Compose Survey Invitations" window and add an additional email address to your account. This e-mail address must exist verified via a verification e-mail before it can be utilized in this manner.

If a survey contains study-qualifying information in a multiple-choice field, you may choose to end a survey prematurely when certain qualifications are (or are not) met by using the Finish Activeness icon in the Online Designer (the cerise end sign). This will preclude you from gathering unnecessary data, and save time for the survey-taker. For instance, if your question is "What is your role at UMKC?" and you want the survey to proceed for everyone who isn't a student, you may click the Stop Actions icon and select to stop the survey at that bespeak for the "Pupil" response.

……..Longitudinal studies

Projects that utilize a longitudinal design may track records over a series of multiple events. Different data drove forms can be associated with different events; in addition, the same course tin can be utilized over multiple events. For instance, a Demographics form may just need to be completed at the very first event, while a Lab Results form may be required at each event.

In order to utilize the longitudinal written report features of REDCap, you must have enabled the utilise of longitudinal data collection in your "Principal project settings" options on your Projection Setup abode folio.

Once you accept enabled the user of longitudinal data drove, a new module will appear in your main Project Setup folio and so that you may define your events.

When defining your events, be sure to title each outcome and specify the "Days First" from the initial effect. Y'all first event's "Days Showtime" should exist 0.

This page is besides where you are able to ascertain your written report'south Arms. If y'all take multiple treatment groups or multiple sample populations, you may desire to utilize this feature. Arms tin can exist custom-named, and exercise not necessarily need to take the aforementioned forms/events as other Arms. This tin let y'all to easily grouping/cake records. A single tape may not belong to more one Arm.

Once you lot accept divers your events (and Arms, if applicative), you must now designate forms for your events. To do this, click the "Designate Instruments for My Events" tab and "Begin Editing" to assign forms to your defined events. In a longitudinal design, each form must be attached to at least one issue. If there are information entry forms which take been created within your project merely are non attached to any events whatsoever, your REDCap administrator will assume this is an mistake and volition not approve the project for Production status until information technology is corrected.

[TIPS AND TRICKS]: See the Agenda/Scheduling section for data on how to automatically add scheduled Events to the Calendar module.

……..Multiple handling groups (Arms)

When you have multiple handling groups in your study, there are two primary means to handle this in REDCap:

1. Create a field in your data form which identifies which handling group the record belongs to and utilize the Report Builder to organize the data groups accordingly.

2. Enable longitudinal data collection methods, even if the report is not longitudinal, then that you may apply the "Arms" feature. This specific use of the "Arms" feature is discussed beneath. See the Longitudinal studies section for more than full general information on Arms.

You can see in this example that we just take one event, significant that in technical terms, this is not considered an actual longitudinal written report. However, nosotros are able to use the Arms feature of the longitudinal pattern to easily group records. Even in the Manage Survey Participants module, Arms are fully taken into consideration. View the screencaps below for examples of REDCap's Arm sorting and distinguishing.

Note that when exporting data, information technology is not possible to export each Arm's data separately, however, a record'southward Arm is listed as the second-cavalcade variable (immediately after Record ID), making information technology very piece of cake to distinguish between the groups and separate the initial .CSV file into multiple files.

bouchertheirth.blogspot.com

Source: https://chi.umkc.edu/redcap-collecting-data/

Share this post