Results 1 to 3 of 3

calculating a penalty for late submited coursework for students

Threaded View

  1. #1
    Registered User
    Join Date
    11-30-2009
    Location
    uk
    MS-Off Ver
    Excel 2007
    Posts
    10

    calculating a penalty for late submited coursework for students

    i am making a spread sheet table to auto decide whether a piece of coursework is late and who to decide how much penalty to allocate

    i have got the total mar in percentage

    the submission date for each student

    deadline date which is 05/05/2009 located in cell G1

    each student is allowed up to 3 weeks to be late each week being a 10% penalty and a total mark of 0 after the 3rd week.

    i have attached a copy of the table pre filled with dummy data

    thank you
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1