From: Kene Meniru <kemeniru@gmail.com>
To: Orglist <emacs-orgmode@gnu.org>
Subject: Tables: Calculating cumulative and final grades
Date: Fri, 01 Aug 2008 12:40:20 -0400 [thread overview]
Message-ID: <48933C74.3060208@gmail.com> (raw)
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 |
|---+----+--------------------+-------+------+------+-----+-----+-----+-----+-----+-----+-----+---------+---------+---------+---+----+----|
| | | | | | | | | | | | | | | | | | | |
#+TBLFM:
$14=($13/$MG)*100;%.2f::$15=(((($E01/$DG)*$4)+(($E02/$EG)*$5)+(($E03/$FG)*$6)+(($E04/$GG)*$7)+(($E05/$HG)*$8)+(($E06/$IG)*$9)+(($E07/$JG)*$10))/($E01+$E02+$E03+$E04+$E05+$E06+$E07))*100;%.2f::$16=((($E01/$DG)*$4)+(($E02/$EG)*$5)+(($E03/$FG)*$6)+(($E04/$GG)*$7)+(($E05/$HG)*$8)+(($E06/$IG)*$9)+(($E07/$JG)*$10)+(($E08/$KG)*$11)+(($E09/$LG)*$12)+(($E10/$MG)*$13);%.2f::$17=if($15<60,F,if($15<70,D,if($15<80,C,if($15<90,B,A))))::$18=find(rsort(@I$15..@II$15),$15)::$19=$2
First is the cumulative grade column 15/O.
Presently, I add the available grades divided by the available total. When I grade each additional assignment, I add that to the total in this
column's formula manually which gives me the cumulative. Is there a way to automatically do this or am I expecting too much? I have removed
grades in column K, L, M so I can show the difference in calculation between column O and P. Assuming there are 10 assessments for the class in
the semester and 7 have been graded. Column O shows the grade for each student as 100% of the total grade. Column P shows the appropriate
fraction of the total grade for the assessments as a fraction of the overall knowing that there are 3 more assignments ungraded. Column O gives
me a better snapshot of each students performance at any point in time.
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.
--
Kene Meniru
::::::::::::::::::::::::::::
keMeniru@gmail.com
next reply other threads:[~2008-08-01 16:40 UTC|newest]
Thread overview: 3+ messages / expand[flat|nested] mbox.gz Atom feed top
2008-08-01 16:40 Kene Meniru [this message]
2008-08-02 6:05 ` Tables: Calculating cumulative and final grades Juri Krivov
2008-08-02 17:33 ` Kene Meniru
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
List information: https://www.orgmode.org/
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=48933C74.3060208@gmail.com \
--to=kemeniru@gmail.com \
--cc=emacs-orgmode@gnu.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).