Hi.
Just wanted to say that this formula doesn't work as you expect.
Look bellow.
2008/10/22 Michael D. Roush <[EMAIL PROTECTED]>
> 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)
>
Lets give a numeric example, where an 8 scored homework was submitted ONE
day late.
That would give us a final grade of 8*(1-0.05)=7.6 (right?)
A=Oct 10, 2008
B=Oct 11, 2008
C=8
D=IF("Oct 11, 2008">"Oct 10, 2008";8-(("Oct 10, 2008"-"Oct 11,
2008")*0.05);8)
D=IF(true;8-((1)*0.05);8)
D=8-((1)*0.05)
D=8-(0.05)
D=7.95
Wrong... it should have multiplied the grade by the percentage, not
subtracted it
Hope it helps.
>
> 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]
>
>
