A Spreadsheet Template for Forced Grading System
Surajit Ghosh Dastidar

Surajit Ghosh Dastidar, Associate Professor, IMT Hyderabad, India.

Manuscript received on February 12, 2020. | Revised Manuscript received on February 21, 2020. | Manuscript published on March 30, 2020. | PP: 267-272 | Volume-8 Issue-6, March 2020. | Retrieval Number: F7155038620/2020©BEIESP | DOI: 10.35940/ijrte.F7155.038620
Open Access | Ethics and Policies | Cite | Mendeley
© The Authors. Blue Eyes Intelligence Engineering and Sciences Publication (BEIESP). This is an open access article under the CC-BY-NC-ND license (http://creativecommons.org/licenses/by-nc-nd/4.0/)

Abstract: Forced Grading Systems are popular and accepted for evaluating students, particularly in business schools. Under such systems students’ numerical test scores are converted to letter grades (A, B, etc.) and awarded in mandated percentages. In common practice, schools mandate that 10% to 15% of students in a class receive As, 25% to 35% Bs, and 40% to 50% Cs. However, instructors must identify what numerical cutoffs satisfy mandated grade distributions, and that tedious effort might entail several solutions. This study introduces an Excel-based template with which instructors can establish numerical cutoffs that distribute students’ grades in accord with mandated standards. Results indicate that the spreadsheet template is an efficient tool to evaluate students following the Forced Grading System.
Keywords: Evaluation, Forced Grading, Distribution, Grading, Spreadsheet, Template.
Scope of the Article: Structural Evaluation of Panelized and Masonry Wall Systems