I am running a joomla website and consequently information is stored in a php database. The results of multiple surveys for a course are stored in the database and have a designated structure of how the information is presented (i.e. Level 1, then survey 1, question 1, Survey 2, question 1, etc...up to Level 7, X number of surveys, and y number of questions).
What is needed is a solution to take the information from the database and manipulate it and output to Microsoft Word, Openoffice Doc or notebook if the functionality exists but the solution must include generation of graphs and tables based upon question type versus audience type (type 1, type 2, type 3.....).
The question types are:
multiple choice (one answer) - a correct answer can be specified but is not always specified or needed: if a correct answer is specified - then simply a table (an example will be provided): if a correct answer is not specified - then a column chart is needed which identifies the audience type and value/percentage. For this question, the fields include: question, question category, 5 answers + other (open ended response), correct answer if applicable, and question level.
multiple choice (multiple answers) -- Here a pareto chart or pie chart should be used to graphically display results. For this question, the fields include: question, question category, 5 answers + other (open ended response) and question level.
Comment/Essay for this question, the fields include: question, question level, question category, response
Rating question: This is the most complicated: - There is a main question title, 5 responses, 5 labels and 5 weights as well as the question category and question level.
You should be able to leverage the data manipulation which has already been completed which generates real-time tables of the results of the data. I will be happy to provide a login in order to view the online reporting if your response to this rfp is sufficiently detailed to confirm you understand the scope of the project and identify your preferred solution to this project (i.e. web based joomla module/plugin whatever, MS access database, or some other solution you suggest).
Please ensure that your bid includes your experience in data manipulation into word or doc based programs. Do not suggest MS Excel.