2.3. Data Extraction (Part 1) | Dr. Ahmed Adel | Cohort 2

Topic: Data Extraction Instructor: Dr. Ahmed Adel Description: After studies are screened and selected, the next critical step is pulling accurate, structured data out of them. In this session, Dr. Ahmed Adel guides participants through designing extraction forms and handling real-world data challenges. Participants will learn: Designing a clear, structured data extraction form Charting continuous vs. dichotomous data correctly Handling missing or incomplete data Managing the extraction workflow in RevMan and Excel An overview of PROSPERO registration for review projects By the end of this session, learners will be able to extract and organize data accurately and consistently for a systematic review. Materials & Resources: All shared materials are available on Telegram: search for @Qabas00000 00:00:00 Introduction & Welcome 00:02:12 WHY Data Extraction 00:05:32 Three Core DE Tables 00:09:47 Why Standardization Matters 00:12:35 Designing the Summary Table 00:21:49 Ordering & Formatting Studies in the Table 00:22:42 The Inclusion & Exclusion Criteria Table (Supplementary Material) 00:24:40 Live Practical Application: Building a Summary Table in Excel 00:37:45 Reviewing Published Examples of Summary Tables 00:39:19 Locating Inclusion/Exclusion Criteria 00:46:29 Designing Baseline Characteristics Table 00:49:01 Understanding Data Types: Quantitative vs. Qualitative 00:51:50 Ordinal vs. Nominal vs. Dichotomous Data 00:55:35 How Variables are Reported (Means, Medians, and Frequencies) 01:03:32 Live Practical Application: Building a Baseline Table in Excel 01:14:03 Reviewing Published Examples of Baseline Tables 01:16:10 Q&A Session Begins 01:16:42 Q&A: Handling studies that do not report specific baseline variables 01:19:33 Q&A: Handling arms with combined interventions (Active vs. Standard Therapy) 01:23:09 Q&A: Categorizing baseline data by age groups (Pediatrics vs. Adults) 01:25:24 Q&A: Do I need to read the entire paper during data extraction? 01:28:19 Q&A: Representing Nominal/Dichotomous data in extraction sheets 01:32:53 Converting Median & Range to Mean & SD (Using Dr. El-Zakareya's Tool) 01:35:21 Do I need advanced Excel skills to be a researcher? 01:35:55 Overview of the Adel Global Academy for Research Program 01:38:00 Q&A: Can we use AI (ChatGPT/Gemini) to extract data automatically? 01:41:11 Q&A: Why create an Inclusion/Exclusion table for all studies? 01:46:54 Q&A: What is an NCT number and where do I find it? (ClinicalTrials.gov) 01:50:16 Q&A: Does standard background therapy affect the intervention results? 01:52:43 Q&A: Do I determine baseline items myself, or are they standard? 01:53:50 Q&A: Handling Patient Withdrawals (Intention-to-Treat vs. Per-Protocol) 01:58:42 Conclusion & Final Wrap-up