An Excel-Based Mean Weighted Discrepancy Score Calculator

Authors

• Billy R. McKim, Texas A&M Extension ServiceFollow
• P Ryan Saucier, Texas State University- San MarcosFollow

Volume

49

Issue

2

Abstract

The Borich (1980) needs assessment model requires that a mean weighted discrepancy score be calculated for each item, competency or activity included in the needs assessment. The two most common types of Borich-type discrepancy scores noted in the agricultural education literature are importance/ability or what is/what should be. An Excel-based mean weighted discrepancy score calculator provides a simplified process of calculating mean weighted discrepancy score and reduces opportunities for user error. The Excel-based mean weighted discrepancy score calculator is a free Microsoft Excel file that allows individuals to calculate discrepancy scores for importance/ability or what is/what should be scores.

Creative Commons License

This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 4.0 License.

Recommended Citation

McKim, B. R., & Saucier, P. (2011). An Excel-Based Mean Weighted Discrepancy Score Calculator. Journal of Extension, 49(2), Article 31. https://doi.org/10.34068/joe.49.02.31