"I have 40 questions, 4 categories of 10 questions."- Google Docs Editors Community
This is a common question: 77 people on Google's forum have asked how to score one questionnaire in several categories. A Google Forms quiz gives one total for the whole form, so the category scores end up in a Google Sheet, with a FILTER or SUM for each category, worked out after the response is in. The person who answered sees none of it. With Formfacade, you add a Short answer question for each category and add up that category's questions with the POINTS formula. Each person sees a score for every category on the form, and each score gets its own column when you sync the responses to Google Sheets, so you can compare people one category at a time.
Let's start. Import your Google Form and follow the steps below.
Give your Google Form a score for each category.
Import your questionnaire, add a score question for each category and total its questions with POINTS. People see every category's score as they answer.