J
John
I am making a gradebook and I am having trouble. I am
trying average out the grades for the class by units in
our book (i.e. So I know what the class average was in
comprehension for unit 1). I have a box above each story
that I use to put which unit that story is in (d1-gz1). I
have the total number of comprehension points accumulated
by the class that starts in cell E45 and are entered
every five cells to the left after that (E45,J45,O45
etc.). Then I have the total number of comprehension
points possible for these tests starting in cell e46 and
then in every 5 cells to the right (E46,J46,O46).
I am wondering if there is a formula that will average
the total number of class points that were given by the
number of class points possible based on what number is
up on the cell above the story 1-6, depending on what
unit the story is in? I want to get an average for all
of the scores in each unit. Is there a way to do this???
Thanks for any help
trying average out the grades for the class by units in
our book (i.e. So I know what the class average was in
comprehension for unit 1). I have a box above each story
that I use to put which unit that story is in (d1-gz1). I
have the total number of comprehension points accumulated
by the class that starts in cell E45 and are entered
every five cells to the left after that (E45,J45,O45
etc.). Then I have the total number of comprehension
points possible for these tests starting in cell e46 and
then in every 5 cells to the right (E46,J46,O46).
I am wondering if there is a formula that will average
the total number of class points that were given by the
number of class points possible based on what number is
up on the cell above the story 1-6, depending on what
unit the story is in? I want to get an average for all
of the scores in each unit. Is there a way to do this???
Thanks for any help