STOP 20 DM Training

September 8, 9, 12, 13, 21--2005

Trainers: Louie Rosencrans, Raoul Kamadjieu, Karen Wilkins, Jinghong Ma

NOTE: Break from 10:00-10:15 am and 3:00-3:15 pm every day. Lunch from12 to 1 pm.

Day 1:Introduction, Overview and Setting up

Thursday, September 8th

8:30-9:00am: Welcome and staff introductions

9:00 – 10:00am: Intro to STOP data management(Louie)

10:00 – 10:15am: Break

10:15-11:00am: Surveillance and data management strategies (Louie)

11:00am-12:00 pm: Role of data management in Routine Immunization (Karen Wilkins)

12-1:00pm: Lunch break

1-2:00pm: Visit to CDC Federal Credit Union to cash checks (see Felicia Betancourt)

2-3:00 pm: Loaned Equipment Process & Procedures(Felicia Betancourt)

3-3:15pm: Break

3:15-4:00pm: Overview of Epi Info based surveillance applications (Raoul and Louie)

4-5:00pm :Setting up laptops

  • Installing Epi Info for Windows
  • Setting up databases and initializing systems
  • Questions and answers

Day 2: Epi Inforeview

Friday, September 9th

(Louie, Raoul)

8:30-10:00am Make View and data entry (Louie/Raoul)

  • Make view and data entry; Rearranging data entry screens; check programs
  • Check code, tab order, etc.
  • Data entry tips, deleting data tables, database tools to clean up .mdb

10-10:15am: Break

10:00-12:00 pm: Analysis (Raoul)

  • Common ad hoc analyses including functions reading, importing, exporting, select, sort, freq, summarize, tables, graphs etc.

12-1:00pm: Lunch

1-1:45 pm: Data cleaning (Keith Shaba, WHO Africa Regional Office)

1:45-3:00pm: Epi Map (Louie)

  • Intro to GIS mapping
  • Preparing data for mapping
  • Mapping case-based and aggregate data

3-3:15pm: Break

3:15-5:00 pm: Epi Map, cont’d (Louie)

  • Formatting and saving maps; templates

WEEKEND ASSIGNMENT

To be announced--

Day 3Epi Info Applications Architecture

Monday, September 12th (Raoul, Jinghong)

8:30-9:00am: Review of weekend assignment; Questions/answers

9: 00-9:30: Intro to Epi Info applications architecture (Raoul)

10-10:15am: Break

10:15-12pm: SAFE method - Structured Approach For Epi Info development (Jinghong)

  • Why – AFRO background and surveillance system characteristics
  • What- Code reusability for…

–Different types of analysis (Graph, Map…)

–Different types of disease (Measles, PMTCT…)

–Different levels of the system (District, Province…)

  • How

–Folder Structure

–Separate GUI and Process Menu

–Standard Process

  • Permanent variables
  • .src(s) -> .pgm
  • Smart names design
  • CALL sub function
  • Simplify

•Output

•Temporary table inside MDB

•PGM

12-1:00 pm: Lunch

1-5:00 pm: SAFE, cont’d and Tutorial: Measles example

DAY 4

Tuesday, September 13th

8:30-10:00 am: Troubleshooting data management systems (Raoul/Louie)

  • Error messages, system settings, formats, reinstalling, screen resolution, etc.

10-10:15 am: Break

10:15-12:00pm: Hands-on exercises with country data: ad hoc analysis (Raoul/Louie)

12-1:00 pm: Lunch

1-3:00 pm: Epi Map shapefiles: editing, merging, dividing

3-3:15 pm: Break

3:15-5:00pm:Epi Map shapefiles: editing, merging, dividing, cont’d

DAY 5

Wednesday, September 21st

8:30 – 10:00am: Review and Q&A

10-10:15 am: Break

10:15-12:00pm: Mapping review: mapping data, updating shapefiles, changing DBFs, etc.

12-1:00 pm: Lunch

1:00-3:00pm: Steps to take once arrive in country; things to remember

3-3:15 pm: Break

3:15-5pm: Former STOP Data Management experiences; closure