mdev11's avatar

Creating a structure for multiple tests

There are around 6 academic MCQ tests. Each test has its questions, answers, and a guide to calculate the results. For example: Test 1 has 36 questions divided into 3 sections(groups) with answers [Never (0), Sometimes (1), Most times (2)] each group's total score is used to get the percentile score from pivot tables:

Raw score | gender | age | percentile score

 0        | male   | 3-7 | 83.56
 1        | male   | 3-7 | 78.23
 2        | male   | 3-7 | 80.08
..etc

We then compare the percentile scores with a range to get one of these results "Low", "Average", or "High".

Test 2 has 20 questions with the following answers [Never (1) Sometimes (2) Always (3)] only "Always" answers are combined to calculate the mean if the mean is below 1.5 the result is "Low" and if it's between 1.6 - 1.9 the result is "Moderate" ..etc.

Test 3 has 50 questions with answers [definitely agree (0) slightly agree (1) slightly disagree (2) definitely disagree (3)] but sometimes the answers are reversed [definitely agree (3) slightly agree (2) slightly disagree (1) definitely disagree (0)] then the percentage is calculated with (total raw score / 150 * 100) that percentage is compared to 72% to give a result.

As you see most of the tests are not similar to each other and sometimes answers change (reverse).

Would it be possible to combine these 6 tests in the same tables with one controller and maybe one function to generate a report for each test or it's better to separate each test with its data and create multiple controllers for each test?

0 likes
2 replies
Tray2's avatar

Yes, it is possible since a test is a test, the main difference seems to be how you calculate the result.

mdev11's avatar

It could be the same tables but a different function to generate each test report. I'm not sure if it's possible to do the calculations using MYSQL tables and queries.

Please or to participate in this conversation.