I enjoy your videos, Gary!
I’m creating a rubric in Numbers for grading my students’ projects.
For each topic on the rubric, I have a row of 5 checkboxes representing Excellent, Very Good, Good, Marginal, Weak and None. I have a score cell that follows the checkboxes that I want to automatically display a specific numerical grade based on the box checked.
Ideally, I’d like to include a “weight” cell for each row of checkboxes that I would keep hidden so I could adjust the final score for each topic as they would need to vary.
What is the best way to accomplish this?
Thanks in advance!