make result sheet for pass/fail/compartment in two subjects

February 1, 2015 at 18:46:57
Specs: Windows 7
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


See More: make result sheet for pass/fail/compartment in two subjects

Report •

#1
February 2, 2015 at 10:19:21
OK, I am going to assume that we have a language difference here, so I am going to see if I can reword the parts of your question to see if I understand them:

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


Report •

#2
February 12, 2015 at 18:45:11
Thanks Derbydad,
there are six subjects :- 5 having 100 marks each (theaory only,no practical)and one subject ie science having 100 marks = 75 in theory +25 in practical.
gracing is
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.
compartment means if he failed in max two subjects can reappear in the exam called compartment exam .
help me please.
thanks

message edited by cutekumar


Report •

#3
February 27, 2015 at 18:16:28
dear
help me please


Report •

Related Solutions

#4
March 2, 2015 at 07:59:21
Unfortunately, I am still confused as to what you are trying to accomplish.

Perhaps some example data would help. Please click on the blue line at the end of this post and read the instructions on how to format example data in this forum. Then post some example data, including both the input data and the expected outcome based on that input. Don't forget to use Column letters and Row numbers as shown in the example.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Ask Question