- Thank you received: 0
weighted averages from different columns
- Janinem
- Topic Author
- Offline
Less
More
1 year 7 months 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.
- Janinem
- Topic Author
- Offline
Less
More
- Thank you received: 0
1 year 7 months 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.
- Janinem
- Topic Author
- Offline
Less
More
- Thank you received: 0
1 year 7 months 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
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.
- Janinem
- Topic Author
- Offline
Less
More
- Thank you received: 0
1 year 7 months 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.
- Munay
-
- Offline
Less
More
- Thank you received: 16
1 year 6 months ago - 1 year 6 months 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.
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.
Last edit: 1 year 6 months ago by Munay.
Please Log in or Create an account to join the conversation.
- Janinem
- Topic Author
- Offline
Less
More
- Thank you received: 0
1 year 6 months ago - 1 year 6 months 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
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: 1 year 6 months ago by Janinem. Reason: Changed the information I am needing help with
Please Log in or Create an account to join the conversation.
- bert
- Offline
Less
More
- Thank you received: 746
1 year 6 months ago #10491
by bert
Replied by bert on topic weighted averages from different columns
Please Log in or Create an account to join the conversation.
- Janinem
- Topic Author
- Offline
Less
More
- Thank you received: 0
1 year 6 months 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
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
Please Log in or Create an account to join the conversation.
- Janinem
- Topic Author
- Offline
Less
More
- Thank you received: 0
1 year 6 months 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
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.
- bert
- Offline
Less
More
- Thank you received: 746
1 year 6 months 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.