emacs-orgmode
[Top][All Lists]

## Re: [Orgmode] Tables: Calculating cumulative and final grades

 From: Juri Krivov Subject: Re: [Orgmode] Tables: Calculating cumulative and final grades Date: Fri, 1 Aug 2008 23:05:40 -0700

On Fri, Aug 1, 2008 at 9:40 AM, Kene Meniru wrote:
Thanks to everyone who helped me with the letter grading and ranking formula for columns 17/Q and 18/R above. I wish to trouble you all again with two requests. After incorporating the two solutions above and entering my summer class grades, it was so sweet that I would like two other things automated.

|   |    | Total grades for   |   100 |  100 |   89 |  84 | 100 | 100 | 204 | 400 | 100 | 100 |         |         |         |   |    |    |
| ^ |    | each evaluation    |    DG |   EG |   FG |  GG |  HG |  IG |  JG |  KG |  LG |  MG |  Single | Overall | Overall |   |    |    |
|   |    | Percentage weights |     6 |   10 |   10 |  10 |   7 |   7 |  14 |  12 |   0 |  24 |     Now |     Now |   Final |   |    |    |
| ^ | SQ | Student Names      |   E01 |  E02 |  E03 | E04 | E05 | E06 | E07 | E08 | E09 | E10 | E-Grade | C-Grade | F-Grade | L | RK | SQ |
|---+----+--------------------+-------+------+------+-----+-----+-----+-----+-----+-----+-----+---------+---------+---------+---+----+----|
| # |  1 | lastA, first       | 95.23 | 87.7 |   76 |  75 | 100 | 100 | 204 |     |     |     |    0.00 |   93.67 |   59.95 | A |  1 |  1 |
| # |  2 | lastB, first       |   100 | 64.7 |   61 |  63 | 100 |  60 | 204 |     |     |     |    0.00 |   81.29 |   52.02 | B |  4 |  2 |
| # |  3 | lastC, first       | 85.69 | 60.2 |   66 |  68 | 100 |  90 | 130 |     |     |     |    0.00 |   76.40 |   48.89 | C |  7 |  3 |
| # |  4 | lastD, first       | 76.15 | 44.6 |   41 |  54 | 100 | 100 |  85 |     |     |     |    0.00 |   62.34 |   39.90 | D | 10 |  4 |
| # |  5 | lastE, first       | 80.92 | 43.6 |   68 |  63 | 100 |  70 | 173 |     |     |     |    0.00 |   75.20 |   48.13 | C |  8 |  5 |
| # |  6 | lastF, first       | 85.69 | 80.4 | 50.5 |  42 | 100 | 100 | 196 |     |     |     |    0.00 |   80.17 |   51.31 | B |  5 |  6 |
| # |  7 | lastG, first       | 95.23 | 56.6 |   55 |  65 | 100 |  60 | 157 |     |     |     |    0.00 |   73.85 |   47.27 | C |  9 |  7 |
| # |  8 | lastH, first       | 80.92 | 50.7 |   64 |  70 | 100 |  90 | 159 |     |     |     |    0.00 |   77.60 |   49.66 | C |  6 |  8 |
| # |  9 | lastI, first       | 95.23 | 73.2 |   88 |  73 | 100 |  70 | 183 |     |     |     |    0.00 |   87.61 |   56.07 | B |  2 |  9 |
| # | 10 | lastJ, first       | 85.69 | 47.2 |   28 |     | 100 |   0 |     |     |     |     |    0.00 |   31.26 |   20.01 | F | 11 | 10 |
| # | 11 | lastK, first       |   100 |   69 |   56 |  77 | 100 | 100 | 164 |     |     |     |    0.00 |   83.77 |   53.61 | B |  3 | 11 |
|---+----+--------------------+-------+------+------+-----+-----+-----+-----+-----+-----+-----+---------+---------+---------+---+----+----|
|   |    |                    |       |      |      |     |     |     |     |     |     |     |         |         |         |   |    |    |

First is the cumulative grade column 15/O.

To do automatically it seems quite hard, even in real spreadheet programs it require many if structures, checking if field is empty or no.  Maybe you make extra copy row with "percentage weights", but make zero weights of assignments not yet done, and use new weight row for column 15?  Then you put new weight in new row to make assignment active for "cumulative grade"?

The second problem is numbering the students in column 2/B.
I want to manage the number for each student so that it does not matter when I add or remove a student in the roster. Right now students are registering for the fall classes and I add their names according to their alphabetized last names. I have to re-sequence this column constantly. I appreciate all the help that anyone can throw at these problems.

This I do by using field formula for first field, then column formula for rest: