weighted averages from different columns

More
7 months 1 week ago #10483 by Janinem
Replied by Janinem on topic weighted averages from different columns
Thank you. I will continue to play over the next few days, and will get back to you with any issues or questions.

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

More
7 months 1 week ago #10484 by Janinem
Replied by Janinem on topic weighted averages from different columns
Hello again. I am having an issue with the total grade within the responding tab. Most of the values have totaled correctly however there are a few, where values have been entered into tab D and E and nothing in the rest, the grade that has been calculated as an A, where is clearly needs to be an E, not sure where I have gone wrong. Happy to email it again, if you don't mind looking into it

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

More
7 months 1 week ago #10485 by Janinem
Replied by Janinem on topic weighted averages from different columns
Sorry another one, but it seems like the converstion I have is not calculating correctly. This is what I have:
A 90%
B 70%
C 50%
D 49%
E 24%

My uncderstanding if that if any value if above this then that grade will apply, however I have columns where 25 is an A, 18 is a B, 43 is a B, 68 is an A, and there are a few more.

What am I doing wrong :(

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

More
7 months 1 week ago #10486 by Janinem
Replied by Janinem on topic weighted averages from different columns
So I think this is happening because there is no value in the main columns , Is there a way that I can say if there is no data in the cell to either put a 0 or ignore

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

More
7 months 6 days ago - 7 months 6 days ago #10488 by Munay
Replied by Munay on topic weighted averages from different columns
Hello Janinem,

I am Munay from iDoceo support, I have read your comments and will like to help you set up your iDoceo as you need it.

Please send me a template of you class, so I can see exactly what you have now and how it is configured and also attach some screenshot as well, so I can reproduce what you are experiencing.

With that I will be able to know what is happening and advice what you need to correct or change to obtain the results you need.

You can send the template to karla.idoceolabs @ gmail.com

When creating the template make sure to have the option Gradebook and Include all tabs selected, as in the image I am attaching here.


Attachments:
Last edit: 7 months 6 days ago by Munay.

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

More
7 months 6 days ago - 7 months 6 days ago #10490 by Janinem
Replied by Janinem on topic weighted averages from different columns
So I have managed to sort that out, can anyone help with a code that allows me to do the following.

There are 3 cells in the row, with a total point value of 3:
I still want to add cell 1 + 2+3 together to get a result
However I also want to say that if cell 1 and 3 = 2 return a result of 3

Each cell only gets a value of either 1 or 0

I hope this makes sense
Last edit: 7 months 6 days ago by Janinem. Reason: Changed the information I am needing help with

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

More
7 months 6 days ago #10491 by bert
Replied by bert on topic weighted averages from different columns
It would look like this:
If the condition is met, yields a 3 (first section after condition) , if not (second section after condition) CELL1 + CELL2 + CELL3

Attachments:

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

More
7 months 6 days ago #10492 by Janinem
Replied by Janinem on topic weighted averages from different columns
ok, so going back to the email I sent the other day, if I added a new column into C, There is the overall value and the 3 tabs within.
what I am trying to do is say:
if [1C with added column + Q1B 3 correct(even thought the result is 2) return a result of 3 (in the overall column- green)
as well as saying that if [1C no assed response + Q1B 3 correct(even thought the result is 2) return a result of 2.

I would also like to be able to say that if there is a value of 1 in either of the columns with the other being 0 then return a 1.

Sorry, this sounds better in my head, hard to try and explain what I am wanting to do



Attachments:

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

More
7 months 6 days ago #10493 by Janinem
Replied by Janinem on topic weighted averages from different columns
I guess what I am trying to achieve is (looking at C-green and the columns within that)
if there is only a 1 in one of the columns they get a score of 1.
if there is a 1 in column 2 and 3 they get a score of 2.
if there is a 1 in column 1 and 3 they get a score of 3

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

More
7 months 6 days ago #10494 by bert
Replied by bert on topic weighted averages from different columns
Is it possible for Column 1 and Column 2 to hold a 1 and column 3 a 0?

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