Student Late Work Tracker

Occasional Visitor

Hello Excel Gurus,

I have taken on a course as an instructor with the following late work policy:

Late Work Policy

Over the course of the semester, you will be afforded 72 hours of “grace time” on your submitted assignments. You can choose to use this all on a single assignment, or spread it out over the course of the semester. If you run out of grace time, the following guidelines apply:

Any assignments received after the deadline will be assessed a late penalty of 10%.

An additional 10% penalty will be assessed for each additional day the assignment is late. If an assignment is more than 10 days late, you cannot submit the assignment for credit.


How would I set up an Excel spreadsheet for columns and calculations to keep track of the 1. due date, 2. the date the assignment was submitted late, 3. the assignment score w/o penalty 4. the penalty score based on number of days submitted late (10%) score, 4. the balance left of the grace period hours. TIA

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies