Hi,
I've created a web form with 100 questions. Each question has 4 potential answers that are selected by clicking radio boxes. I can export the test answers into a csv file so that each participant is on his own row, and each column has the selected answer to that question.
For example, all on one row... column A has the participant name, B is his answer to question 1, C is his answer to question 2, and so on.
I have the answers to this quiz and would like to put the answers into a spreadsheet and then somehow have a formula/macro to mark the quiz so that I know which answers are wrong.
Is there a tool to do something like this, or can someone point me in the right direction on how to do it in excel? I am not an advanced excel user, so I don't know where to start. Any help would be appreciated.
Thank you!
I've created a web form with 100 questions. Each question has 4 potential answers that are selected by clicking radio boxes. I can export the test answers into a csv file so that each participant is on his own row, and each column has the selected answer to that question.
For example, all on one row... column A has the participant name, B is his answer to question 1, C is his answer to question 2, and so on.
I have the answers to this quiz and would like to put the answers into a spreadsheet and then somehow have a formula/macro to mark the quiz so that I know which answers are wrong.
Is there a tool to do something like this, or can someone point me in the right direction on how to do it in excel? I am not an advanced excel user, so I don't know where to start. Any help would be appreciated.
Thank you!