Data Manager Learning Tasks

Copy full project to a sandbox to do testing
Take one form from a sandbox project and add it to a production project
Create a survey queue that will skip a pregnancy form for respondents that marked sex as male.
Move data from one variable into a new one with a different name
Design a project with control featuring intake and one year, intervention with intake, 3, 6, and 9 month, as well as one year. All non-intake events should feature an event date and repeating medication forms.
Recode the answer options for a question and update the data to match the new values (ex. multiple options being grouped together)
Convert checkbox options to yes/no questions and migrate existing data
Create dashboard with a histogram of something like case/control numbers over a categorical (site) for a filtered set (ex. non-duplicate)
Create a form that calculates expected event dates
- Using the dates form, create report of upcoming events that need action
- Create alerts that remind subjects of a day before upcoming events (visits) using their reported SMS/Email preference
Extract data for a stats package and find duplicate records (same first name, last name, and DOB)
- Create a REDCap configuration that will prevent against these duplicate records (tricky: need @calctext and some other features)
Training in analytic software like SAS or R for basic data management tasks, such as: prepping datasets for analysis, renaming variables, identifying missing or erroneous data, etc.
Create a longitudinal form that will give feedback if a measure increased or decreased across events. (ex. a descriptive field that says 'Depression score has increased since the previous event, Ask followup question.')
For a project with hundreds of date fields with the same minimum date, update them all to a new date
Create a new calculated variable and populate it for all existing records (including a datediff calculation)
Create an import template
Use the log to pull data for a project to determine what record has the most updates for the project
- Determine what field for what subject has the most updates (can be done using any tool, but is likely complicated)
Create a project that randomizes based on stratification by age (<18, and >=18) and sex
For a project that has and multiple arms, and enrollment and exit event in each, and enrollment and exit date variable in each respective event, create a report that will show the subjects that were active during a calendar year.
- If subjects can be in multiple arms over the course of the study, create a report with an accurate count of the subjects active in a year
Create a the following table as a form