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? |
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? . |
All times are GMT +1. The time now is 06:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com