dears,
I have been facing problems in creating a result sheet for six subjects (100 marks each,in which one sub theory 75 +practical 25) pass marks 33%. gracing max 5 marks can distribute in all getting less than 33 marks in theory also fail in max 2 sub. gets compartment.
help me please—-
regards
message edited by cutekumar
“ six subjects (100 marks each,in which one sub theory 75 +practical 25) pass marks 33%.“
6 Subjects
— 100 questions in each Subject
——– 75 Theory questions
———– Student must answer 25 questions correctly (75 * 33% = 24.75)
——– 25 Practical questions
———– Student must answer 9 questions correctly (25 * 33% = 8.25)
Is that part correct?
“gracing max 5 marks can distribute in all getting less than 33 marks in theory“
This are just 2 guesses, although there many other possibilities.
Guess # 1: 5 of the 600 marks can be “shared” across subjects to help a student reach 33% in the Theory or Practical portion of any other subject.
or
Guess # 2: 5 of the 100 marks in a given subject can be “shared” across Theory and Practical to help a student reach 33% in the Theory or Practical portion.
“fail in max 2 sub. gets compartment.“
I have no idea what “gets compartment” means and how failing up to 2 subjects relates to that.
Obviously we need some clarification related to your requirements.
Click Here Before Posting Data or VBA Code —> How To Post Data or Code.