Yes, it is possible since a test is a test, the main difference seems to be how you calculate the result.
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?
Please or to participate in this conversation.