Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
lalewis
 
Posts: n/a
Default 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   Report Post  
Jason Morin
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
How do I isolate my Excel server (automation) from other Excel instances? Joseph Geretz Excel Discussion (Misc queries) 5 July 19th 13 03:18 PM
VB Automation is Whacking out my Excel Environment Joseph Geretz Excel Discussion (Misc queries) 2 December 29th 04 04:49 PM
Excel aficionado wants to learn Access Hari Excel Discussion (Misc queries) 0 December 3rd 04 06:47 AM
Excel aficionado wants to learn Access Hari Excel Discussion (Misc queries) 0 December 3rd 04 06:45 AM


All times are GMT +1. The time now is 04:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"