Hedley Finger wrote:
I can do most of it if I drink a gin or two. But the tricky bit is "So
I want to subtract the deadline date from the actual submission date,
and if the answer is positive". Can anyone tell me how to do a
conditional branch on the result of the subtraction (or take-away, for
those of you who only understand the higher maths)?
My suggestion would be to start with the following four columns (plus
additional columns for other information not necessary for this
calculation). Those four columns are:
(A) Date Due
(B) Date Submitted
(C) Assignment Score
(D) Actual Grade
Date Due and Date Submitted cells should be formatted as Date (with
whatever format you prefer).
"Assignment Score" should be formatted for whatever the grading point
scale is. This doesn't have to be a percent, but you might use that for
consistency.
Assuming the column letters I've given above, and that the data starts
in row 2, the formula for "Actual Grade" would look like this:
=IF(B4>A4;C4-((B4-A4)*0.05);C4)
What this does is... "If the Data Submitted is higher than (after) the
Date Due, subtract five percent from the assignment score for each day
the assignment is past the due date."
You have to use the IF function if you allow yourself to record an
assignment turned in before the due date. Without the IF condition,
there would be a 5% bonus for every day early an assignment was turned in.
Also, this formula does not take into account whether a day is a "school
day" for purposes of calculating the penalty. In other words, an
assignment turned in one week late is penalized for seven days, not
five. This means an assignment due on Friday and turned in the
following Monday gets docked 15%, not 5%.
A slightly more complex formula could remove penalties for Saturdays and
Sundays.
Michael
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
