# Calculate score

Hi all,

I am building an ODK excel sheet(xls form) from scratch and am at a point where I need the sheet to do a calculate score command. I have many questions and each question has its various answers where only one answer is the correct one (which means the right answer is the '1'). Let's say I have 10 questions which means 10 marks and all have various answers unlike the just YES ns No answers. If all are answered, what is the calculate command on how it can calculate so that it will pick only the right answer as 1 point (marks out of 10)?

In addition, I know the YES and NO questions can easily appear as a table-list. In the case of my dilemma, how will these questions with many answers appear. will they still appear as a table or differently? Please advise.

Kindly assist.

Short answer: experiment and play around to find a solution that works for
you.

Note that the choice values for a select one and select multiple question
are considered to be strings, not integers (i.e., the string "1", not the
integer number 1).

So you need to convert them to integers before adding them. See
https://opendatakit.org/help/form-design/binding/
for the various functions you can use.

You may find:

useful, and you might convert those right answers into 1's and wrong

ยทยทยท ------------ As for the various layouts, unless you explicitly group things, each question will appear on a separate screen. See https://opendatakit.org/help/form-design/examples/ for the available widgets.

On Tue, Jan 13, 2015 at 6:32 AM, kkarisah@gmail.com wrote:

Hi all,

I am building an ODK excel sheet(xls form) from scratch and am at a point
where I need the sheet to do a calculate score command. I have many
questions and each question has its various answers where only one answer
is the correct one (which means the right answer is the '1'). Let's say I
have 10 questions which means 10 marks and all have various answers unlike
the just YES ns No answers. If all are answered, what is the calculate
command on how it can calculate so that it will pick only the right answer
as 1 point (marks out of 10)?

In addition, I know the YES and NO questions can easily appear as a
table-list. In the case of my dilemma, how will these questions with many
answers appear. will they still appear as a table or differently? Please

Kindly assist.

## --

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an