This topic contains 1 reply, has 0 voices, and was last updated by Anonymous 11 years, 7 months ago.
- AuthorPosts
- July 30, 2009 at 11:32 pm #266
AnonymousHello,
Our questionnaire consists of 50 different questions. In order to get a summary of how well each person answered, we would like to have a “weigth” for each question.
For example:
Question 1: Do you have quality processes?
Yes = 1 point
No = 0 point
Question 2: Which quality standard do you have ?
ISO 9000-1 = 1 point if checkbox is checked, 0 if unchecked,
ISO 9000-2 = 1 point if checkbox is checked, 0 if unchecked,
ISO 14000-2 = 1 point if checkbox is checked, 0 if unchecked,
Question 3: Do you ship to the U.S?
Yes = 1 point
No = 0 point
and so on…
At the end the questionnaire, we would like to compile and report a total score. In the above example, if the person answered
Question 1: Yes = 1 point
Question 2: Checked ISO 9000-1 = 1 point
Unchecked ISO 9000-2 = 0 point
Unchecked ISO 14000 = 0 point
Question 3: No = 0 point
Total Score = 2 / 5 = 40%
Is that something that can be done? If not, I know it can be done in Excel.
Thanks,
July 31, 2009 at 9:22 am #4701If you use Radio Buttons for your responses (This allows just one answer) then the Radio Button Group (i.e. the question) can have a value attached to each answer.
The values can be added up at the end.
Be aware, however, that if a Radio Button Group is not answered at all then it will have the value of 0.
If you are using checkboxes for your responses (This allows multiple answers) then you need to add in some logic which is based on the responses. Each checkbox will need a corresponding input object. Then the behavior would be:
If ISO 9000 is checked then value = 1
If ISO 9000 is not checked then value = 0
- AuthorPosts
You must be logged in to reply to this topic.