Create your own score-based questionnaire
Besides different best-practice questionnaires available in our Content hub, you can also create your own questionnaire templates within 3rdRisk. The platform supports two types:
- Yes/no questionnaires
- Score-based questionnaires
This article will explain how you can easily create and upload your score-based questionnaire.
Download the score-based template
We have a predefined upload sheet, you can easily download the latest version within your 3rdRisk environment.
Content - Questionnaires - Create questionnaire
You can download the model's latest version of the score-based Excel import template:
Download and open the template.
Score-based assessment template
The spreadsheet contains 3 tabs:
- Answers
- Questions
- Adjusted answers
Tab 1. Answers
In this tab, you provide the different answer options and the scoring:
The scoring is used in the review module, whereby we will calculate:
<question_score> * <answer_score> = total score
Attention points:
- Do not alter the column titles and first row
- There is no limitation on the number of answers.
- Use rounded numbers in the score column
- Do not use negative scores in the score column
Tab 2. Questions
In the second tab, you can add all your assessment questions.
Attention points:
- Do not alter the column titles and first row
- All columns with a red header are required fields and need to have a value
- Per column, there is a short explanation which will be visible when you mouseover:
- The columns: purpose, evidence required, and references provide additional information for the receiving party. We integrate this information in the side panel within the assessment:
- The columns: CommentRequiredForAnswers and AttachmentRequiredForAnswers can be used to define per question when an attachment and/or comment is required. You can specify this per answer option.
- Simply select the row number from tab 1:
Example
- We expect an explanatory comment when the answers: Not applicable, No or Partial are answered for this question.
- If the answer is Yes, with evidence, we require an attachment to be uploaded by the third party.
- Use Semicolons (;) per answer key.
- Row 1 of the first tab is used by the column titles - take the exact row numbers as shown in the example.
Tab 3. AdjustedAnswers
The third tab is optional and can be used for defining differentiation reviewer answer options. Our partners that provide outsourced TPRM services primarily use this functionality.
