Keep track of the fail rate for each question

[EndBug]

Proposal author: @Mattysal
It would be nice to have some stats on the most failed questions, in order to better focus on those topics.

[lorenzocorallo]

Regarding this one, do we already have some sort of database to store such informations?
My idea is to add two counters for each question (using id reference), one storing how many times is shown and the other one storing how many times is answered wrong, so that we can calculate the error percentage.

[zagbc]

Nope. Or not a real RDBMS, so far.

Please also take a look at the attached proposal, which is an extension of your nice idea.

These informations could be used to set the Project Team's priorities regarding development of freshman support materials.

I can assure you that we will discuss this improvement action in the near future ;)

[lorenzocorallo]

Your proposal is great.
Our IT team should discuss on which DB to choose and how to run it.

The frontend part is just a call to the DB at the end, so it would not need much time.

I also thought to set a test score threshold (like 20%) to identify correctly done tests and avoid false positives in our data; in this way we also avoid dirtying the stats during our tests.