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
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies