Users take a personality test on our Joomla site and get scores on ten variables. This test is set up and functioning on our site. The display of the scores at the end contains ten numbers, one for each variable. These scores are reported to the user upon completion of the test. They are also stored in the site DB and can be accessed by users under a tab on their My Page in Joomla’s Community Builder.
We want to begin aggregating the scores in our database and make it possible for users to see how their scores compare to other people’s scores.
1. Write a script that adds each user’s scores into an aggregate data base.
2. Write a script that displays an additional feature in our existing report for users. The existing report shows only a user’s scores. The new element will show how the user compares to other users. Specifically, for each of the ten variables, it will report: “Your score on this variable was X. When compared to others who have taken this test, Y percent of other users scored lower than this.”