Creating Weighted Scoring Questions in An Evaluation

Written by Hanna Smith

Last published at: September 9th, 2020

There is no exact weighting that can be done within the form itself, but there are other options. 

The scoring questions allow you to choose a minimum and a maximum and the range is sequential or in other words, you can't skip numbers. This means you cannot have a scoring question with the options being 2, 4, and 6 but you can have one with the options as 1, 2, and 3. 

  • You could set up your scoring questions to have different ranges altogether. For example, some of your questions could have a 1-5 scale and others could have a 5-10 scale.
  • The most common option is to use the reporting tool to weight questions.
    • Using formulas you can,
      • Multiply the score by a number to make it worth that much more
        • Example: Multiply a score by 2 to make that score have twice the weight it originally had
      • Multiply by a number less than 1 to show a score that is worth X% of the total score
        • Example: Multiply a score of 0.20 to make that score worth 20% of the overall score
    • Each formula will create a new column. You can then use those new columns to add and/or average the new, weighted score.

As always, contact Foundant Support if you have additional questions.