====== 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 {{ :userdocs:form_table_example.png?600 |}}