weighted averages from different columns

More
7 months 1 week ago #10473 by bert
Replied by bert on topic weighted averages from different columns
For instance, what is Q1b all correct. Is it a score out of a test?

Please Log in or Create an account to join the conversation.

More
7 months 1 week ago #10474 by Janinem
Replied by Janinem on topic weighted averages from different columns
ok, so overall within the responding tab, Blue A is worth 5 points so Q1b and the added response would each be 2.5. How would I add that?

Please Log in or Create an account to join the conversation.

More
7 months 1 week ago - 7 months 1 week ago #10475 by bert
Replied by bert on topic weighted averages from different columns
For the blue folder:
Double tap on header: (Column properties )
Calculation > Weighted average (equal weights)
Grade type Result > Generic 5. This will yield a result out of 5

If Q1b and 1b are scores out of 2.5: Double tap on each header > Grade type > Generic 2.5

PS: Q1b and 1b do not have to add 5 for this to work. They could be scores out of 1000 and 2000. The folder will still yield a result out of 5. The main thing is for each column to 'know' the kind of values it will hold.
Last edit: 7 months 1 week ago by bert.

Please Log in or Create an account to join the conversation.

More
7 months 1 week ago #10476 by Janinem
Replied by Janinem on topic weighted averages from different columns
I will change this now

Please Log in or Create an account to join the conversation.

More
7 months 1 week ago #10477 by bert
Replied by bert on topic weighted averages from different columns
Great. I've seen you've selected 'Counter' as the column's cell editor inside this blue folder
This will let you add points with a double tap on the cell but I'm not sure if this is the way you'd like to work. If you change the cell editor to automatic it will be a Keypad which may be faster to use.

Please Log in or Create an account to join the conversation.

More
7 months 1 week ago #10478 by Janinem
Replied by Janinem on topic weighted averages from different columns
So I changed that, now would I apply the same to the other sub tabs?

Would I be able to change the grade value in the Blue Tab, because if I remove a value, leaving the score of 2.5, the grade is an E (technically for this tab the grade should be a C)

Please Log in or Create an account to join the conversation.

More
7 months 1 week ago #10479 by Janinem
Replied by Janinem on topic weighted averages from different columns
I have just sent a new email, with an update, Can you please check and advise? Thank you

Please Log in or Create an account to join the conversation.

More
7 months 1 week ago #10480 by bert
Replied by bert on topic weighted averages from different columns
It depends on the percentages assigned in the A to F.
2.5 out of 5 is 50% and in the current configuration it is an E

You can change these percentages in Menu > Grade type > Text grades A to F
or if you let me know how that C should be calculated I'll look into it

Please Log in or Create an account to join the conversation.

More
7 months 1 week ago #10481 by Janinem
Replied by Janinem on topic weighted averages from different columns
Thank you. I have one last question for now please.

what formula would be needed to say that is a columns value is 1 then the result must be 0?

Please Log in or Create an account to join the conversation.

More
7 months 1 week ago #10482 by bert
Attachments:
The following user(s) said Thank You: Janinem

Please Log in or Create an account to join the conversation.