1 / 18

Building a Key Performance Indicator Report Using MS Excel

Building a Key Performance Indicator Report Using MS Excel. Texas Association for Institutional Research Annual Conference March 03, 2009. Bao Huynh, Director of Institutional Research Richland College Dallas, Texas. Thunion Report. 2. 2008-2009 Target Range 90% – 100%.

hollie
Download Presentation

Building a Key Performance Indicator Report Using MS Excel

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Building a Key Performance Indicator ReportUsing MS Excel Texas Association for Institutional Research Annual ConferenceMarch 03, 2009 Bao Huynh, Director of Institutional ResearchRichland CollegeDallas, Texas

  2. Thunion Report 2

  3. 2008-2009 Target Range 90% – 100% Performance as of January 2009 Score Adjusted Score 379,390 – 421,544 345,296 10.24 10.00 Thunion Report – Raw Data 1.1.1 Contact hours from dual credit and tech-prep 3

  4. Thunion Report – Layer 3

  5. Thunion Report – Layer 2

  6. Thunion Report – Dashboard

  7. Thunion Report – Raw Data 7

  8. Performance Score SCORE = (Monthly Performance/(Target * Prorating)) * 10 ADJUSTED SCORE = MIN (ADJUSTED SCORE,MAX SCORE) 8

  9. Thunion Report – Calculations

  10. Paste Special & Paste Link

  11. Weighted Score Weighted SCORE = Measure Score * Weighting Factor KPI SCORE = Sum of Measure Scores * KPI Weighting 11

  12. Thunion Report – Calculations

  13. Stoplights • Camera Tool • CHOOSE Function • Define Name

  14. Lessons Learned • Strategic Framework is Key • Definitions Document • KPI Meeting Action Items • Rubber Meets the Road

  15. Rubber Meets The Road

  16. Rubber Meets The Road • There are two reasons to submit a Departmental Action plan: • to support an Organizational Action, or • to address a performance issue or initiative in your department.

  17. Rubber Meets The Road PIIPs document process changes in two ways-- • record the initiation of a new process; • document changes in an existing process.

  18. Rubber Meets The Road The Benchmarking Process form provides a standardized institutional process for benchmarking.

More Related