lm23
May 29, 2025, 5:33am
1
How do you design this kind of questions in xls form?
Question: How would you rate your knowledge and use of:
(Rate: 1 = No knowledge, 5 = Expert knowledge)
|Topic* *|1 |2 |3 |4 |5 |
|Sphere Standards | ☐ | ☐ | ☐ | ☐ | ☐ |
|Core Humanitarian Standard (CHS) | ☐ | ☐ | ☐ | ☐ | ☐ |
|IASC gender and inclusion guidelines | ☐ | ☐ | ☐ | ☐ | ☐ |
|Accountability to Affected Persons | ☐ | ☐| ☐ | ☐ | ☐ |
Welcome to the community, @lm23 ! You should be able to do it by following this support article Rating vs Ranking Question Types . This community post discussed previously should also help you design a rating question by using an XLSForm:
@Malgorzata , you may not be able to control the form on how it looks as most of the control is made by the system. You should however, be able to display it vertically, as shown in a post shared below:
In the survey tab of your XLSForm:
[image]
Data entry screen as seen in Enketo:
[image]
Reference XLSForm:
Range Question Type.xlsx (9.7 KB)
1 Like
lm23
June 9, 2025, 12:22pm
3
@Kal_Lam how do I design this question in Excel. My questions are all designed in execel from which I upload xls form.