Jump to content
  • 0

Test and Quiz development


Question

12 answers to this question

Recommended Posts

  • 0

jnordsrand,

I have created several apps successfully that score a test or quiz. Before the advent of calculated fields in update datapages, I had to rely on javascript to achieve this. But now with the recent Caspio release you can make use of the calculated values in virtual fields to calculate a score. Or you can score it directly in the table by creating formulas in your table that have case statements checking each answer and returning a count of 1 for Yes and 0 for No. Just string your case statement together to create a total score. I can explain in more detail if needed.

Link to post
Share on other sites
  • 0
On 5/2/2019 at 1:14 PM, Carlson said:

jnordsrand,

I have created several apps successfully that score a test or quiz. Before the advent of calculated fields in update datapages, I had to rely on javascript to achieve this. But now with the recent Caspio release you can make use of the calculated values in virtual fields to calculate a score. Or you can score it directly in the table by creating formulas in your table that have case statements checking each answer and returning a count of 1 for Yes and 0 for No. Just string your case statement together to create a total score. I can explain in more detail if needed.

Hi Carlson,

 

Please explain your quiz set up for me.  How are the quizzes created?  Forms?  Is each quiz a separate data page?  I am very much looking forward to seeing what you have done. Is this something you can sell to me or explain how to do. 

 

Thank you very much.

 

Jeff

 

 

Link to post
Share on other sites
  • 0
18 hours ago, smsnyus1 said:

Hello Jnordstrand,  Did you ever get the quiz app setup, if so can you send me any tips on how you did it.  I'm trying to setup one as well and seems harder than I thought it would be.  Thanks for any help.

Are you creating a short quiz/test ? Generally, for quiz form, you will have to create one field in your table for each question so you may store the answer individually.

If you have 10 questions, that will translate to 10 fields in a table (i.e question1-10)

Then on your form, you can use Text Fields or Radio Buttons depending on what type of test it is. I will not recommend multiple answers in one question (i.e. A, B) as that you may encounter issues. What you can do for that is use one option (i.e. D.) Both A and B))

 

If you want to reveal their test results after they submit, you can do so using a Details Page DataPage.

Using Calculated Values you can set that if it's not the correct answer, it will show 'incorrect' . For Calculated Values, you may check this HowTo Article: https://howto.caspio.com/datapages/datapage-components/calculated-values/

and for the conditional formula you may refer to the Case Function under  MISCELLANEOUS FUNCTIONS AND EXPRESSIONS section of this How to Article:

https://howto.caspio.com/function-reference/

Link to post
Share on other sites
  • 0

Hi @smsnyus1, this is a very good workflow. What I would like to suggest is to create a submission form, then your choices should be a radio button(you can simply use a text(255) field). Then in creating reports, you may use a formula field in your table or a calculated field in your DataPage/s with CASE WHEN  condition. For example:

CASE WHEN [@field:Answer1] = 'A' THEN 'CORRECT'

WHEN [@field:Answer2] = 'B' THEN 'CORRECT'

WHEN [@field:Answer3] = 'C' THEN 'CORRECT'

ELSE 'WRONG'

END

You may try that in your end if that works for you.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...