Offline form with subsequent automatic analysis?

Question

Programming

Good afternoon.
There was such a problem - we are teaching children with disabilities and it is necessary to conduct periodic psychological testing /
Initially, it was carried out manually. I suggested automating, BUT:
1. It is required that children take offline testing at home, and then the questionnaires are collected and automatically analyzed /
2. While I am writing in Open Office Tables, but the appearance and speed of development do not suit me very much. It turns out clumsily and slowly.
What ideas does anyone have?

Answer 1

You can write a simple program that generates texts containing answers to questions in any convenient format.
It can upload questions from a remote database via the network and/or a local file.
Analyzer - a program on your side reads the format and processes it according to the logic of the tests.
You can use csv format with separators ";" for easy import into MS Office/OpenOffice

Answer 2

You can easily do this as a website using the Application Cache API.

Answer 3

It seems to me that the HTML + JS solution will be the most optimal. In fact, it is necessary to transfer to a person only a specially generated HTML page and some JSON with a list of questions (possibly already inside this HTML file). The results are also saved in JSON/XML.
The advantage of this solution is cross-platform, no need for third-party applications, as well as the ability to update the database of questions / send answers if suddenly someone has Internet at home, because even partially automated collection of results is already a bonus.
An almost similar, but slightly more complicated solution would be to use Flash, also in the browser, but if there is no need, I would still choose JS.

Answer 4

Google Docs has the ability to create a beautiful form for conducting questionnaires.
Inside, this is a fillable plate, all settings and answer options are configured in the form, after which it is enough to distribute a link to the questionnaire to the right people.
At the end of testing, upload it to yourself in excel / csv and some other formats and analyze it as you like.
the document is not available to users - they only have the opportunity to enter data into the form