Have a question if someone would be nice to help me:
I am a teacher.
Swedish grading system (secondary upper grade) uses the grades A-F.
To get the grade A on a course (a course that has for example 5 criterias to live up to), the course's ALL 5 criterias have to be full filled up to level A. Only then is the final grade A.
In a course that have 5 criterias to live up to I have a student who has lived up to let's say A, C, A, C and C on the 5 criterias.
I want excel to calculate the final grade.
The grading system works like this: to get an A in a course, ALL 5 criterias must have reached A.
To get the grade B however, a MAJORITY of the criterias of A must have been reached (in this case 3 A's)
The student must then of course also have full filled all E (5) and all C (5 of them as well).
So if I in the first column in a spread sheet on the first row have the first criteria, second column I have the 2nd criteria (and so forth) and in row 2 puts A (for grade A) under first criteria, C (the grade C) under the 2nd criteria and so forth –*how do I then in the end column get excel to calculate how many A's the student have reached? And how many C's and E's?
I would also like excel to give me a nice diagram that shows graphically (with bars or something like that) that for example this student (in the example above) has reached the final grade C (which is the total in this case as the student have met all criterias of E, all criterias of C but not a majority of the A criterias (which if he had would have resulted in the final grade B.
Bookmarks