Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excused assignment in the excel gradebook.
I am using the excel template for the teacher's gradebook based on points.
Sometimes when a student is absent, I would like to excuse them from an assignment and just average their grade without that assingment. The gradebook template divides by the total number of possible points to calculate the average. How can I omit an assignment from the calculation of the average? |
#2
|
|||
|
|||
One way:
=SUM(A:A)/SUMIF(A:A,"<",B:B) where column A is points received for each assignment and col. B is total possible points for each assignment. It assumes that if a student is absent and no points are given for the assignment, then the cell in A is left *empty*. HTH Jason Atlanta, GA -----Original Message----- I am using the excel template for the teacher's gradebook based on points. Sometimes when a student is absent, I would like to excuse them from an assignment and just average their grade without that assingment. The gradebook template divides by the total number of possible points to calculate the average. How can I omit an assignment from the calculation of the average? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
VB Automation is Whacking out my Excel Environment | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) |