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.
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.