weighted averages from different columns

2 years 3 weeks ago - 2 years 3 weeks 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: 2 years 3 weeks ago by Janinem.

2 years 3 weeks 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

2 years 3 weeks 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.

2 years 3 weeks ago #10466 by Janinem
Replied by Janinem on topic weighted averages from different columns
I am looking at the GTMJ Tab

2 years 3 weeks 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:

2 years 3 weeks 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%

2 years 3 weeks 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

2 years 3 weeks 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

2 years 3 weeks 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?