- ChiDramaAsked on June 25, 2015 at 03:33 PM
Why is Quiz Form only evaluating the last 100 entries/submissions? I need to be able to download this data for funder reports asap.
I have posted this on the App page... but this support is more extensive allowing for uploading files.
Your prompt response would be appreciated!
- JotForm SupportMikeAnswered on June 25, 2015 at 05:15 PM
Thank you for contacting us.
I have attached a bug report ticket to this thread and forwarded it to our Development Team for consideration.
We will keep you updated via this thread.
- ChiDramaAnswered on July 07, 2015 at 06:33 PM
Any updates? I really need to complete a report process by the end of this month and there are over 500 submissions in two different files.
- ChiDramaAnswered on July 07, 2015 at 06:38 PMIm looking for support on this issue posted requesting update on the
Otherwise, whats my work-around? How do I download all the test scores for
all the students?
- CharlieAnswered on July 08, 2015 at 01:09 AM
Apologies for the inconvenience. Upon checking the ticket report, it is still assigned to one of our developers and is still currently being investigated. We will you as soon as we hear any news on this.
For the workaround, it seems like this isn't possible for existing submissions, but I'll try to find something that we can work one. I'll get back to you when I find a workaround that we can use.
Again, apologies for the inconvenience.
- ChiDramaAnswered on July 14, 2015 at 02:33 PMCharlie,
While I still wait on a developer to respond, is there a way to select the
first 100, download results, archive them and then move to next 100?
- CharlieAnswered on July 14, 2015 at 03:11 PM
Have you tried opening the app and setting the answers again?
Currently, I'm unable to find a workaround on this.
But, I could suggest that you download your submissions as excel file and create a formula to manually check and calculate the scores of each submissions using Excel. Here's a sample tutorial link on how to make a quiz form in Excel. You can get an idea there on how to create a sheet for the list of answers to your question and use a formula to give them a value, let's say "1" if it's correct and "0" if not. then we will add all the "1"s and sum them.
This might be tricky but you can try it while our developers are still fixing the issue on the Quiz app.
I will notify them again to see if we can get any news.
Apologies for the inconvenience.
- CharlieAnswered on July 14, 2015 at 03:31 PM
If you would still like to evaluate or score your submissions using the excel file, here's an easy approach that I made:
1. First, create columns in your Excel file that corresponds to your questions that you need to add or assess. In this case I made Q15 to Q19 at the last columns and added also a "Total" column.
2. Now we will add the formula to check if the answer is correct. Here's my formula:
=IF(AS2="a. his/her death",1,0)
This formula tells that if the answer in the column "AS2" is equal to "a. his/her death" then output the value "1" (which means correct), if not output the value of "0" (which means incorrect) in our Q15 column. Now we want to apply the formula to the whole column, we can't manually type it repeatedly, but we can drag it easily. See the screencast below on how I did it. (To learn more about the "IF" function in Excel, you can check this link.)
After that, apply the same procedure on the other columns, but make sure that you are referencing the correct column. In my case, Question 15 is found at column AS.
You can now sum columns Q15 to Q19 to column "Total" easily using the SUM function in Excel. We will add all of the "1"s which gives us a total score.
I hope that somehow it helps.
- ChiDramaAnswered on July 14, 2015 at 06:23 PMThis is helpful. Im really disappointed Jotforms Quiz Form wasnt able to
return the data as I need it.
Would you happen to kjnow how to get the cacluation field to return the same
answer in the Quiz (e.g., 6/11 six out of eleven were correct); then as
percentage? I will also check online, but thats too much for me to figure
- JotForm SupportMikeAnswered on July 14, 2015 at 07:42 PM
We hope to get the Quiz App fixed at some point. We will let you know when we have any updates.
Please see the next post to get the idea about form calculation based solution.
We can also calculate the percentage, for example, it may be "(correct answers / total questions) * 100".
- ChiDramaAnswered on August 27, 2015 at 01:45 PMBefore deciding if we can use Jotform for the 2015-16 school year, we need
resolution on the Quiz App and the ability to download all answers to a CSV
file to assess our programs.
- JotForm SupportMikeAnswered on August 27, 2015 at 02:24 PM
We have sent a note to the developer in charge to check this.
Please note that you can download raw Excel/CSV submission data at any time from Submissions page.
Unfortunately, the 'Score' column provided by Quiz App will not be included in this case.
- ChiDramaAnswered on August 27, 2015 at 03:45 PMYes, we are aware that we can download all the files. Its the test scores
that we are wanting a solution for. In the meantime, we are looking at
other online surveys/test sites to see if theres another solution.
...nurturing new voices
- JotForm SupportNeilVicenteAnswered on June 21, 2017 at 11:29 AM
Apologies for the very late update, but in case you're still interested in using the app, we have increased the limit for the form submissions query, so all submissions will now be displayed.