| | | names | grade 1 | grade 2 | grade 3 | Total | | Letter grade |

|---+---+------------+---------+---------+---------+-------+---+--------------|
| # | 1 | student 01 | 91.80 | 96.40 | 97.00 | 95.07 | 1 | C | | # | 2 | student 02 | 88.78 | 89.15 | 98.00 | 91.98 | 2 | B | | # | 3 | student 03 | 92.00 | 95.14 | 97.00 | 94.71 | 3 | B | | # | 4 | student 04 | 84.00 | 74.62 | 88.00 | 82.21 | 4 | B |
#+TBLFM: $7=($4+$5+$6)/3;%.2f

Sample letter grade calculation:
90-100 = A
80-89  = B
70-79  = C
60-69  = D
 0-59  = F

I am deeply sorry if this has been addressed before here. I have searched but could not find any reference. I am a teacher and have been using org-mode in combination with noweb as a class manager. I also use moodle and blackboard but I like to keep my lecture notes and student grades local on my machine. I typically have the above table for student grades (usually substantially more than that). I am able to calculate many things like averages, etc., but would like to have letter grades and "best performing" comments by the students doing as well.

Starting with letter grades, is there a way I can evaluate the Total column and assign letter grades as shown above? Thanks


--

Kene Meniru
::::::::::::::::::::::::::::
[EMAIL PROTECTED]


_______________________________________________
Emacs-orgmode mailing list
Remember: use `Reply All' to send replies to the list.
Emacs-orgmode@gnu.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode

Reply via email to