iDoceo 8 for iPhone,iPad and Mac now available!

You will find all the details explained here
 Page:12

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

 Janinem 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 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 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 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 #10490

 Janinem 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 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 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 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 The administrator has disabled public write access.

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

 Janinem 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 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 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 OFFLINE Admin Posts: 3485 Thank you received: 686 A sort of table of truth of that formula would look like this. 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 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 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 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:12
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

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