16th ANNUAL EARLY HEARING DETECTION & INTERVENTION MEETING
February 26-28, 2017 • Atlanta, GA

<< BACK TO INSTRUCTIONAL SESSIONS

2/26/2017  |   12:30 PM - 4:30 PM   |  Data Mining Using Excel - How to Tell Your Story. Data Excavation Tips for EHDI Program Personnel   |  Grand Hall D

Data Mining Using Excel - How to Tell Your Story. Data Excavation Tips for EHDI Program Personnel

EHDI Coordinators are constantly being asked to tell the story of their programs. They are asked to respond to a variety of questions ranging from how many babies have been diagnosed as deaf or hard of hearing, which parts of the state have the highest loss to follow-up rate, how many children return for a screen after being discharged from the hospital, what is the state’s loss to follow-up rate, to who is reporting diagnostic outcomes. Local hospital administrators, audiology and early intervention providers, parents, state and federal agencies and other stakeholders invested in the work of EHDI programs want to know how a program is performing in order to continue to rally for additional support and resources. To that end, EHDI coordinators have to always be ready to tell their story and include those critical details that demonstrate their successes and challenges. In this session, the presenter will review a variety of analysis tools used in the reporting of performance measures critical to EHDI programs and for annual reporting to the CDC. The session will include details about the data elements needed and the Microsoft Excel tools used to expedite the analysis and reporting of EHDI measures.

  • Describe the framework needed for developing their own reporting tool
  • Describe how to use Excel’s pivot table feature
  • Identify the various data elements needed for reporting on specific performance measures

Presentation:
This presentation has not yet been uploaded or the speaker has opted not to make the presentation available online.

Handouts:
Handout is not Available

Transcripts:
5555.docx


Presenters/Authors

Mary Catherine Hess (), OZ Systems, mhess@oz-systems.com;
Mary Catherine Hess has worked with EHDI programs since 2002. Most recently she worked for OZ Systems as an Account Manager for the Texas EHDI Program and the USVI EHDI Program. Prior to that, she was the Program Administrator for Rhode Island’s EHDI Program from 2001-2008 and co-chair of the CDC EHDI Data Committee from 2007-2008. She has presented at local, regional and national EHDI events on topics related to newborn hearing screening, data management and data reporting, and most recently standards-based messaging for EHDI programs. She achieved her MA in Linguistics from Gallaudet University and holds a BS in Communication Disorders. She is a certified ASL/English interpreter. Her interests include communication access issues in health care settings, assistive technology and long-term outcomes for deaf and hard of hearing children identified through the EHDI process. She is a yogi, pug lover and fan of NPR and folk music.

ASHA DISCLOSURE:

Financial - Receives Salary for Employment from OZ Systems.   Receives Other financial benefit for Consulting,Other activities from Vendor for the Texas Department of State Health Services .   Receives Salary for Employment from OZ Systems.   Receives Salary for Employment from OZ Systems.   Receives Salary for Employment from OZ Systems.   Receives Salary for Employment from OZ Systems.   Receives Salary for Employment from OZ Systems.  

Nonfinancial - No relevant nonfinancial relationship exist.