weighted averages from different columns

More
7 months 1 week ago - 7 months 1 week ago #10463 by Janinem
Hello. First time on the forum, so I hope that what I am about to ask makes sense, and someone can help me.

I have created a gradebook where I have a Folder (Responding) and within this folder I have 5 sub folders (Please see attached picture), And subsub folders within these. I have a formula within each of the sub folders that creates a value from the sub sub folder, and I get a score. Within the main (Responding) Folder, I have a formula that gives me a total from the sub folders. I now need to create a new column with the A-F grade, based on the value in the Responding Folder. However when I add a weighted average and select the folder it returns a 0 result. (Sorry this make much more sense in my head :silly: )

I am really hoping that someone can help me


Attachments:
Last edit: 7 months 1 week ago by Janinem.

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

More
7 months 1 week ago #10464 by bert
Replied by bert on topic weighted averages from different columns
Welcome Janinem,
When you have a chance, send me a template of that gradebook and I'll give it a look:
Export > Share > All tabs, no students.
Send it to support @ idoceo.net

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

More
7 months 1 week ago #10465 by Janinem
Replied by Janinem on topic weighted averages from different columns
Thank you, I will send it now. PS, I have started a new folder section called Making, This folder and contents can be ignored for now.

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

More
7 months 1 week ago #10466 by Janinem
Replied by Janinem on topic weighted averages from different columns
I am looking at the GTMJ Tab

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

More
7 months 1 week ago #10467 by bert
Replied by bert on topic weighted averages from different columns
Let's focus first on the formulas you are using. There is an easier way to configure it other than a formula. but let's keep them if you are familiar with that.

On this folder, Q1b and 1B. What kind of score do you have on each. Are they based on 100 points?
Attachments:

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

More
7 months 1 week ago #10468 by Janinem
Replied by Janinem on topic weighted averages from different columns
eventually I will be adding the Making folder, to get an overall grade from Responding 50% and Making 50%

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

More
7 months 1 week ago #10469 by Janinem
Replied by Janinem on topic weighted averages from different columns
if these were based on 100 points, that they would be 50 each

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

More
7 months 1 week ago #10470 by bert
Replied by bert on topic weighted averages from different columns
Ok, but with iDoceo you do not have to worry about assigning that weight in each folder with a formula. You only have to worry about assigning the score/grade type on each column and the weighting is done afterwards.
You could add a third category afterwards and all the folders inside would not need to be changed at all.

Let's keep focussing on this A blue folder.
Double tap on the header > Grade type > and set here the Numeric grade (Generic) and type
the max points that could be achieved with the formula.
Then in the same column properties > Quick conversion > A to F

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

More
7 months 1 week ago #10471 by Janinem
Replied by Janinem on topic weighted averages from different columns
Done, would I be correct in saying 100 for the max points?

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

More
7 months 1 week ago #10472 by bert
Replied by bert on topic weighted averages from different columns
It depends on what kind of scores you will be inserting in Q1b and 'Added responses in 1b'
This score is what iDoceo understands as 100% success.
If Q1b and 1b are only 10 points each for example, the 100% success would be 50 (as per your formula)
It is only a matter of knowing what kind of score/grade you will be using in your gradebook

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