Raw scores into percent

More
11 years 2 months ago #3843 by Joff405
Raw scores into percent was created by Joff405
Is it possible to use the calculation function to convert raw scores into percent having entered the maximum mark.

Ps a sort function on independent columns would be useful
More
11 years 2 months ago #3847 by bert
Replied by bert on topic Raw scores into percent
Yes, here the steps:
- Add a calculation column, set 0-100 as its Grade Type, and 'Calculation' as its editor.
- Once you have that calculation on screen, double tap on any cell of it to select which columns take into account.
Here an image



And here the final result


Attachments:
  • Anonymous
11 years 2 months ago #3897 by Anonymous
Replied by Anonymous on topic Raw scores into percent
obviously doing something wrong; all i get is the raw score multiplied by 100. does the initial data need to be in any format. somewhere i must need to include the max mark on that particular assessment
More
11 years 2 months ago #3899 by bert
Replied by bert on topic Raw scores into percent
Yes, the Grade type has to include the max score.

Attachments:
More
11 years 2 months ago #3904 by Joff405
Replied by Joff405 on topic Raw scores into percent
Got it