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 checked, it will assign a value and the section total will be tallied up at the end. I have the Sum function no problem. What I cannot figure out is how to get the check boxes formatted so they will create a certain value for that rubric item.

For example, if B7 is checked, that should return a value of 4. If unchecked, a value of 0. If D8 is checked, that should return a value of 2 (if unchecked, then 0).

Everything would be tallied up in H11 so the instructors do not have to manually calculate the overall score. They simply check a box for each criteria listed in 7-10 and get the sum total. (I have the SUM function inserted and working properly)

Any help on how to format the check boxes to return values is much appreciated. I’ve spent hours using tutorials and articles and am stumped! Thank you.

​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 checked, it will assign a value and the section total will be tallied up at the end. I have the Sum function no problem. What I cannot figure out is how to get the check boxes formatted so they will create a certain value for that rubric item. For example, if B7 is checked, that should return a value of 4. If unchecked, a value of 0. If D8 is checked, that should return a value of 2 (if unchecked, then 0).Everything would be tallied up in H11 so the instructors do not have to manually calculate the overall score. They simply check a box for each criteria listed in 7-10 and get the sum total. (I have the SUM function inserted and working properly) Any help on how to format the check boxes to return values is much appreciated. I’ve spent hours using tutorials and articles and am stumped! Thank you.   Read More

​