230 likes | 354 Views
C P M E C. 2010 Data Collectors Workshop Friday 6 th August 2010 Grace Hotel, Sydney. MEDICAL SCHOOLS OUTCOMES DATABASE (MSOD) & LONGITUDINAL TRACKING PROJECT. ,. Welcome. MSOD Project Team members Reimbursements Facilities. What’s On Today. MSOD Project: The Big Picture.
E N D
C P M E C 2010 Data Collectors Workshop Friday 6th August 2010 Grace Hotel, Sydney MEDICAL SCHOOLS OUTCOMES DATABASE (MSOD) & LONGITUDINAL TRACKING PROJECT ,
Welcome • MSOD Project Team members • Reimbursements • Facilities
MSOD Project: The Big Picture • To design and initiate a national process to collect reliable demographic and educational data on medical students across all medical schools • To establish a national database that will provide the basis for short and long-term monitoring and reporting on outcomes of medical education programs and medical workforce planning Handout
Some research questions What factors influence medical students to take up rural practice? What are the long-term outcomes of Australian Government medical education initiatives? Where and how long is students’ training actually occurring (eg. rural vs. urban) as they progress through their degrees? What are the career plans of medical students and junior doctors, and how do these change as they move through the education/continuum?
2009 Data Collectors Workshop Outcomes Reasons for Under-reporting to MSOD Sourcing Data Privacy Matters Record Management of Special Cases Feedback on Templates Complexity & Increasing Volume of Data
MSOD Data Collection - What, How & When • Commencing Students Questionnaire(CMSQ) - demographic, rurality, career intentions (location & specialty), previous tertiary education, income, scholarships • Annual Medical Schools Data (MSD) - enrolment status, rural club membership, placements (discipline/ specialty, location, duration, type, infrastructure resourcing), electives (location, duration, type) • Exit Questionnaire(EQ) - internship location, career intentions (location & specialty), further tertiary education, contact details, updated demographics • Postgraduate Year 1 Questionnaire(PGY1Q) - status of current work, internship rotations, career intentions (location & specialty), contact details, updated demographics
During medical program (Annually) First year of medical program Final year of medical program At end of internship Medical Schools Data CMSQ Exit Q PGY1Q Scanned Excel Templates Scanned Raw ‘Unprocessed’ Data Files Raw ‘Unprocessed’ Templates Raw ‘Unprocessed’ Data Files Data Cleaning Data Cleaning Data Cleaning ID/ DOB/Gender Checks Blanks & Other Anomalies Scanning Errors Raw ‘Cleaned’ Templates Raw ‘Cleaned’ Data Files Raw ‘Cleaned’ Data Files Data Reports • Individual Medical School Data Report • National Data Report
Scanned Raw data Raw data Raw data Raw data Raw data Raw ‘Unprocessed’ Data Files I.D./ D.O.B./ Gender Checks (Medical Schools) Blanks Anomalies Scanning Errors (MSOD Project Staff) MSOD PROJECT DATA PROCESSING FLOW CHART CMSQ Data Cleaning
Identity Checks - Excel Template I.D D.O.B Gender 21341379 4/2/85 female 22415678 15/3/90 male Medical Schools Check for Incorrect & Missing Data & Validate Templates returned to MSOD Project Medical School Data – Excel Templates Produced Updated I.D. Medical School …… 21341379 University of Medicine 22415678 University of Medicine MSOD PROJECT DATA PROCESSING FLOW CHART
Discussion Topic 1: Data Inputs by Medical Schools Offline Facility: Spreadsheets for Identity Checks & Medical School Data b) Online Facility: Usability of Forms & Screens
Discussion Topic 2: Data Outputs from Database Data from database to spreadsheets any point Online form view of your school’s data Selected records and reports from the system - do we need any - standardised reports - ethics restrictions