Gradebook problems!

Originally Posted by snyderra

I'm using the Excel gradebook template for middle/high school from the Microsoft site. There are some assignments from which the students are excused or were absent, and I need those cells to not factor into the student's grade. Right now, my only option is to put the full point value in the cell to keep their grade correct---otherwise, if I put "ex" or "ab" in the cell, it gives them a zero and brings the grade down.

Is there a code for this?

Hi,

I would say that column C and D of that form were not the most recommended for, of writing a formula, however, in B4 you could put something like

=SUM(E4:V4)+(COUNTIF(E4:V4,"ex")*5)+(COUNTIF(E4:V4,"ab")*4)

which would allow 5 for each 'ex' and 4 for each 'ab', however, it would be more difficult to allocate the Row 3 points relative to the column.

Does this help?
---

Originally Posted by snyderra

What I really want is for "ex" and "ab" to not be included in the scoring---and not worth zero. Making them worth four or five would still give them an "F" on the assignment if the total point value for the assignment is 30. So I need those cells not to factor into the final grade at all!

in W4 enter

=SUM(E4:V4)/(SUMIF(E4:V4,"<>ab",E$3:V$3)-SUMIF(E4:V4,"ex",E$3:V$3))

CSE (CTRL/Shift/Enter) (not just Enter)

will do the 'ab' and 'ex' entries, is this the idea you are looking for?

---

Originally Posted by koda86

Hi Bryan, I have seens several Times people saying that we must CSE and not simply enter: Can you tell me the difference or give me a link for an explanation?

Thanks

Hi,

It's where an array is used that is not (really) expected by Excel.

It was not required in the formula that I gave to you, I had experimented with a few formats, some of which required CSE, however in the final formula the 'SumIf' naturally uses arrays, thus the CSE is not required.

http://www.ozgrid.com/Excel/arrays.htm might help to explain.

Did the formula provide all that was needed ?

---