Forum Discussion
Preparation of student result
In column X, I want values return as Passed, Simple Passed, Promoted or Failed. Pass criterion (Pass in all subjects) - column C to column G must have scores greater than or equal to 26, column I to ...
| Point | from | to | ||
| PASS | ? | ? | ||
| FAIL | ? | ? | ||
| SIMPLE PASS | ? | ? | ||
| PROMOTED | ? | ? | ||
| PASS | FAIL | SIMPLE PASS | PROMOTED | |
| E | ? | ? | ? | ? |
| MIL | ||||
| H | ||||
| Ed | ||||
| Hs | ||||
| Hc |
Please enter numbers so I can bypass all possible translation errors.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
- Thank you for the reply, but, your table is not appropriate to my needs.
The pass mark for the external exam for each subject is 26 (column c to g) while for internal exam is 7 (column i to m). So, a student must attain pass mark in all subjects both for the external and internal exams to be Passed.
If a student fails in only one subject overall (either in the external i.e. from column c to g or internal exam i.e. from column i to m), he is to be considered Simple Passed.
If a student fails in two subjects in the external exam or two subjects in the internal exam or one each from the external and internal exam, but secures a grand total of 165 marks and also securing at least 16 marks in the external exam in each subject and at least 4 marks in the internal exam in each subject will be promoted.
If above conditions are not met, then, Failed.
