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