Secure Medical Data Collection - Best Practices with Excel, and Leveling Up to REDCap & CollaboratoR
Channel: R Consortium
Date: 2021-08-31

The R/Medicine presentation covers Best practices for Secure Medical Data Collection with demonstrations provided by Peter Higgins, Will Beasley, Amanda Miller, and Kenneth McLean. Peter Higgins covers ‘Best Practices for Excel’, and Amanda Miller gives an introduction and demonstration to REDCap. Will Beasly then follows the presentation with ``Getting your data out of REDCap with {REDCapR’}. Kenneth McLean closes with ‘Managing multicenter data with REDCap and {collaborator}.’ 

Originally presented at R/Medicine 2021 by Peter Higgins, Amanda Miller, Will Beasley, and Kenneth McLean
https://r-medicine.org

Main Sections 

1:03 Best practices for clinical research data entry in Excel & spreadsheets
2:24 Goals for the first hour 
2:58 Pitfalls of Excel
4:00 What tools do you actually need for reproducible medical research data management?
8:04 Spreadsheets pain points
11:22 Better data entry
12:16 Security and Privacy
15:22 Why do good (research) people do bad (data) things?
16:36 Recommended medical data entry tool
17:43 Tidy data as a data standard 
19:19 Examining untidy data
22:31 Building datasets with 14 good data practices  
29:04 How to set up dropdown values in excel demon
37:33 Be consistent with dates with demo
44:34 Be careful with text strings
45:05 What is a Codebook?
45:34 Do no calculations
45:57 Record raw granular data
46:31 Use data validation
47:56 Exercise - Numeric variable validation 
50:52 Protect your raw data 
51:35 Putting it all together: Starting a new data project with exercise
55:12 Summary of best practices 1,2,3 
56:57 Further resources and Questions
58:18 Part 2: REDCap overview
59:37 What can you do with it?
1:00:04 Creating a project database in REDCap
1:03:40 How do you know if you have a REDCap?
1:06:40 Demo 
1:29:00 Will Beasley demo
2:13:29 Kenneth McLean - Scalable multi-centre research using R and REDCap applications
2:20:08 Demo 
2:38:44 Closing 

More Resources 

Main Site: https://www.r-consortium.org/ 
News: https://www.r-consortium.org/news 
Blog: https://www.r-consortium.org/news/blog 
Join: https://www.r-consortium.org/about/join 
Twitter: https://twitter.com/Rconsortium 
LinkedIn: https://www.linkedin.com/company/r-consortium/