Community
        
        
            
                
                    I am attempting to tabulate questions in a google form. The form is a survey. I need to tabulate & score individual sections, as well as a total. I would also like to add in section percentages and total percentages but am not sure if this is possible. I have watched countless videos but still need help. I appreciate any and all support.
                    
                 
                
             
         
     
    
        
        
     
Comments (1)
Oct 23, 2024
Hi Holly, you can use the Formfacade - Assign points addon to tabulate and score individual sections in your Google Form survey. Here’s how you can set it up: 1. Assign points: For each question, you can assign different point values based on the answers. In the Formfacade Edit page, click on the question to select it > click on the settings gear icon > Question settings page will be displayed > click Answer > assign the points for different answer choices and click Save. Repeat the steps for other questions in the form. 2. Calculate Section Scores: At the end of each section, add a short answer question with POINTS(SECTION) formula to calculate the section score. In the Formfacade Edit page, click on the last question in a section to select it > click on the + new question icon to add a question below the selected question > enter the title > click on the settings gear icon > Question settings page will be displayed > click Answer > enter the POINTS(SECTION) formula in the Calculate option and click Save. 3. Calculate Total Score: At the end of the form, add another short answer question with POINTS() formula to calculate the overall score. In the Formfacade Edit page, click on the last question at the end of the form to select it > click on the + new question icon to add a question below the selected question > enter the title "Overall score" > click on the settings gear icon > Question settings page will be displayed > click Answer > enter the POINTS() formula in the Calculate option and click Save. 4. Calculate Percentages: To calculate percentages, you can multiply the calculated section score by 100 and divide it by the total possible points for that section. In the Formfacade Edit page, click on the section score question in a section to select it > click on the + new question icon to add a question below the selected question > enter the title > click on the settings gear icon > Question settings page will be displayed > click Answer > enter the below formula in the Calculate option and click Save. If 60 is the total possible score for this section, then the formula would be: (Section Score / 60) * 100 where "Section Score" is the name of the short answer question with the calculated section score. You must type @ and select the question from the list when adding the formula in the Calculate option. Replace 60 with the total possible score. 5. Display Scores and Percentages: You can customize the confirmation message to display the calculated scores and percentages after submission. For detailed instructions, please refer to the demo video: https://youtu.be/zberDwRdLv8 Once you have setup your form, you must use the Formfacade share link to collect responses. Otherwise, the customization and calculations will not work. If you have any specific questions or need further assistance, feel free to ask!
Add your comment
Add photo