I'm a HS teacher, and I'd like to set up an attendance worksheet that would allow me to keep tabs on students' classroom participation--for instance, something that I could mark each kid A or 0 (Absent), and then (assuming they are present) either a 1, 2, or 3 for their degree of participation in the class. The idea would be that at the end, I could tally each kid's score and come up with a good idea of how to grade them on the "class participation" portion of their overall grade. So, for instance, if there were 20 days of class in a particular block of lessons, someone who got a "3" each day would have the maximum score of 60, whereas someone who got a 2 each day would have only a 40.
Ideally, there might even be another table that converted that fraction (16/20) into a percentage rate, since usually the number of days in a given block is not as nicely "round-able" as 20.
I've looked at Roger's attendance worksheet (referenced in some other links on this discussion board), but that seems to be set up as a simpler "present/absent" binary option.
I should say, finally, that I'm an English/History teacher and decidedly not a "technie," so if you can put any response in relatively simple language, I'd appreciate it.
Thanks in advance!
If you mock-up a Numbers Sheet illustrating your needs, we can help you with the programming. Take a shot at it and then post a Screen Capture here for us to comment on.
To capture an area of your screen, type Shift-Command-4 and then drag the cross-hair cursor across the parts of interest. The graphic file will appear on your Desktop. You then use the Camera Icon in the discussions Toolbar to bring the screen graphic into the discussion's editor.