# [Quiz App] Only evaluating 100 first submissions

**ChiDrama**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 Support
**Mike**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.

**ChiDrama**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.

**ChiDrama**Im looking for support on this issue posted requesting update on the

thread.

Otherwise, whats my work-around? How do I download all the test scores for

all the students?

Thank you,

...**Charlie**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.

**ChiDrama**Charlie,

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?

Thanks,

Ilesa

...**Charlie**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.

**Charlie**Hi,

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.

**ChiDrama**This 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

out.

Thanks,

...- JotForm Support
**Mike**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.

How to create a Quiz form with a number of correct answers on a Thank You page

We can also calculate the percentage, for example, it may be "(correct answers / total questions) * 100".

**ChiDrama**Before 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 Support
**Mike**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.

Download Form Submissions as Excel/CSV/PDF

Unfortunately, the 'Score' column provided by Quiz App will not be included in this case.

**ChiDrama**Yes, 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.

Best always,

Ilesa Duncan

Education Director

Chicago Dramatists

...nurturing new voices

cc:

...- JotForm Support
**NeilVicente**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.

Cheers!