iDoceo 8 for iPhone,iPad and Mac now available!

You will find all the details explained here
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

TOPIC: weighted averages from different columns

weighted averages from different columns 2 months 4 days ago #10483

  • Janinem
  • Janinem's Avatar
  • OFFLINE
  • Skilled member
  • Posts: 20
Thank you. I will continue to play over the next few days, and will get back to you with any issues or questions.
The administrator has disabled public write access.

weighted averages from different columns 2 months 3 days ago #10484

  • Janinem
  • Janinem's Avatar
  • OFFLINE
  • Skilled member
  • Posts: 20
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
The administrator has disabled public write access.

weighted averages from different columns 2 months 3 days ago #10485

  • Janinem
  • Janinem's Avatar
  • OFFLINE
  • Skilled member
  • Posts: 20
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 :(
The administrator has disabled public write access.

weighted averages from different columns 2 months 3 days ago #10486

  • Janinem
  • Janinem's Avatar
  • OFFLINE
  • Skilled member
  • Posts: 20
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
The administrator has disabled public write access.

weighted averages from different columns 2 months 2 days ago #10488

  • Munay
  • Munay's Avatar
  • OFFLINE
  • Skilled member
  • Posts: 26
  • Thank you received: 10
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.


Template.jpg
Last Edit: 2 months 2 days ago by Munay.
The administrator has disabled public write access.

weighted averages from different columns 2 months 2 days ago #10490

  • Janinem
  • Janinem's Avatar
  • OFFLINE
  • Skilled member
  • Posts: 20
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: 2 months 2 days ago by Janinem. Reason: Changed the information I am needing help with
The administrator has disabled public write access.

weighted averages from different columns 2 months 2 days ago #10491

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 3485
  • Thank you received: 686
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

Screenshot2022-05-04at06.14.50.png
Please take a moment to add or update your rating for iDoceo 7 teacher gradebook so that we can continue working on it. Thanks!
Here is the link
apps.apple.com/app/apple-store/id4771209...&action=write-review
The administrator has disabled public write access.

weighted averages from different columns 2 months 2 days ago #10492

  • Janinem
  • Janinem's Avatar
  • OFFLINE
  • Skilled member
  • Posts: 20
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



c.png
The administrator has disabled public write access.

weighted averages from different columns 2 months 2 days ago #10493

  • Janinem
  • Janinem's Avatar
  • OFFLINE
  • Skilled member
  • Posts: 20
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
The administrator has disabled public write access.

weighted averages from different columns 2 months 2 days ago #10494

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 3485
  • Thank you received: 686
Is it possible for Column 1 and Column 2 to hold a 1 and column 3 a 0?
Please take a moment to add or update your rating for iDoceo 7 teacher gradebook so that we can continue working on it. Thanks!
Here is the link
apps.apple.com/app/apple-store/id4771209...&action=write-review
The administrator has disabled public write access.

weighted averages from different columns 2 months 2 days ago #10495

  • Janinem
  • Janinem's Avatar
  • OFFLINE
  • Skilled member
  • Posts: 20
no it is not - it is basically either column 1 or 2 but not both
The administrator has disabled public write access.

weighted averages from different columns 2 months 2 days ago #10496

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 3485
  • Thank you received: 686
A sort of table of truth of that formula would look like this.


Screenshot2022-05-04at06.51.26copy.png
Please take a moment to add or update your rating for iDoceo 7 teacher gradebook so that we can continue working on it. Thanks!
Here is the link
apps.apple.com/app/apple-store/id4771209...&action=write-review
Last Edit: 2 months 2 days ago by bert.
The administrator has disabled public write access.

weighted averages from different columns 2 months 2 days ago #10497

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 3485
  • Thank you received: 686
There are three sections in it, separated by a + sign.
The first one counts the number of 1s in C1,C2,C3. If the number of 1s equals 1, then yields a 1
The second section, takes into account C2 and C3' condition
The third section, takes into account C1 and C3' condition


Screenshot2022-05-04at07.00.50.png



There is probably a more elegant solution to this formula but I did not have my morning coffee yet and this one is hopefully easier to follow.
Let me know if it works for you. Just be careful with the parentheses.
Please take a moment to add or update your rating for iDoceo 7 teacher gradebook so that we can continue working on it. Thanks!
Here is the link
apps.apple.com/app/apple-store/id4771209...&action=write-review
Last Edit: 2 months 2 days ago by bert.
The administrator has disabled public write access.

weighted averages from different columns 2 months 2 days ago #10498

  • Janinem
  • Janinem's Avatar
  • OFFLINE
  • Skilled member
  • Posts: 20
Yay that has seemed to do the trick. Thank you thank you thank you.
The administrator has disabled public write access.
  • Page:
  • 1
  • 2
Time to create page: 0.111 seconds
21 AUG

iDoceo 7 for iPad and Mac now available!

A huge update with tons of new features and a new interface

Read more

6 JUN

Create Multiple-choice tests with iDoceo Connect!

In addition to self-evaluation rubrics, your students can now fill exams online. Supports text and images - in answers and questions - and can easily be imported from an XLS template

Read more

Cookies policy

This website uses cookies to make it easier for you to use the forum. We do not track you for any kind of advertising or statistics. Cookies are only used to keep you logged in the forum in case you would like to post and to keep your language selection in case you use the automatic translation offered by Google. If you continue to use our offer and have activated this technology in your browser, you consent to the use of cookies.