0
$\begingroup$

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.

$\endgroup$
1
$\begingroup$

I found your explanation very confusing, to be honest, but as far as I understand, you meant something like the following, where $s_1$ and $s_2$ denote the scores from sections 1 and 2, respectively.

  1. If $s_1<70$, let the final score be $(64/70)s_1$, not evaluating section 2 at all.
  2. If $s_1\ge 70$, you have $100-64=36$ more points to assign, 26 of which are based on section 2, and the remaining 10 on section 1. So, the final score in that case is $64+(10/30)(s_1-70)+(26/100)s_2$.
$\endgroup$
3
  • $\begingroup$ I just did some testing and these formula seem exactly what I am looking for. One question: what does (10/30) mean in the 2nd formula ? $\endgroup$ – Ahmad Alkhawaja Jan 5 '18 at 12:32
  • $\begingroup$ The 10 comes from the max 10 points that can be received from section 1 above the 64, and $30=100-70$, that is, the maximum value minus the threshold value of $s_1$. $\endgroup$ – Taneli Huuskonen Jan 5 '18 at 18:36
  • $\begingroup$ Thank you! exactly what I need. $\endgroup$ – Ahmad Alkhawaja Jan 6 '18 at 16:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.