Differences

This shows you the differences between two versions of the page.

--- userdocs:data_manager_learning_tasks [2021/10/04 18:33] – babbagej
+++ userdocs:data_manager_learning_tasks [2021/11/13 00:04] (current) – babbagej
@@ Line 1: / Line 1: @@
+====== 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 |}}