Forum Discussion
Creating a Rubric with Checkboxes and Auto Calculations
Hello all, I've been trying to figure this out on my own, but to no avail. I would like to make a scoring rubric for faculty to use on student projects that auto-calculates. If a certain box is c...
Basically the same solution but 'prettied up' to check multiple assessments and show an error against the criterion. The overall score takes the highest rating where more than one is given. Like JKPieterse I have used the scale in row 5 to provide the ratings but the numbers are formatted to display 'pts:'.
"Cell H7"
= LET(
error, BYROW(checkBoxes*1, SUM) > 1,
score, BYROW(checkBoxes*levels, MAX),
VSTACK(IF(error, "error", ""), SUM(score))
)
If you set up Data Validation using this custom rule:
=SUM(1*$B2:$E2)<=1
Excel will disallow checking more than one box. Nice!
=SUM(1*$B2:$E2)<=1
Excel will disallow checking more than one box. Nice!