I have an evaluation scorecard that have two sections, each section has a weight, each section has a set of questions/criteria.
The scorecard works like this, I will explain with example :
- Scorecard Section $1$ has a weight of $74$
- Scorecard Section $2$ has a weight of $26$
- In each section, the total weight of questions are $100$.
- Section $2$ only becomes enabled if the overall score has exceeded or equal to specific score, in this example it is $64$.
The algorithm that I am trying to find/implement, is a one that can make section $2$ to be visible when section $1$ questions average result was $70/100$ but that won't convert to $64$ in our example, it is $70/100 \cdot 74 = 51.8$.
What algorithm I can use that can get me $70/100$ to be equal $64$ of total scorecard score, at the same time $100/100$ to be the $74$.
a detailed example :
scorecard $1$, wight $74$
- question $1$, weight $50$, rating $(1-10)$, if we assign $7$, then it is $35$
- question $2$, weight $50$, rating $(1-10)$, if we assign $7$, then it is $35$
- section total score is $70/100$ so the overall score is $51.8$ scorecard $2$, weight $26$ so the score here is $0$ total score is $51.8$
The result of the algo should make the $70/10$ to be equal $64$ of total score. so we can make section $2$ visible.
If the scorecard $1$ got full score, then it is $74$. so section $2$ will be visible.
Is there an an algo that can help with that ?
I welcome any recommendation to change how we assign weight and calculate the whole thing, the thing about this evaluation scorecard, that section $2$ is used for evaluating the 'creativity' of the submission, so we only show it when the section $1$ score matches the minimum score requirement to evaluate it as a creative submission.