Allow differnt weighting for questions in questiionnaire
In creating a survey, I would like the option to place weighting to the various answers in order to tabulate the results automatically. This weighting option is only available for the quiz option where one right question is chosen, in the questionnaire requesting feedback on control issues it would be desirable to have each question separately weighted.
Anthony Martin commented
This would be amazing - I've just attended a showcase session on the ETF and the scholl transformation assessment - it would be great to replicate some of that weighted question analysis directly in forms without having to venture into PowerApps etc. (bearing in mind not everyone has PowerApps or can afford a PowerBI license.
To be able to apply weighting to question responses, and then on the results / responses page, show the weighted average against each likert response
Chua Choon Hian commented
I have the same requirements to create weighted score for each option selected as the response in each question. It is not possible using forms alone. What I did as a workaround is to use power automate to flow the response data into sharepoint list, and using calculated columns to auto-calculate the scores. Eventually will still need to to use PowerBI to publish this scores into a dashboard.
I really need an option to assign a value to each choice option. We don't live in a black and white world :)
At the moment, a question with multiple right answers gives "all or nothing", like 0 out of 4 when one option is wrong.
We really would need the option to give points for each option. Could you offer a "points for each right answer". If I enter "1", and options 2,3,4 are right and the student ticks options 3 and 4, he will get 3 points for 3 right choices.
Alternatively, assing points to each option.