Assess students' progress

I finished entering the latest assessment scores for the flight students and calculated the progress summary. Send the progress file to Claire, the lead instructor, and then to Karen in student affairs for their signatures, in that order, with comments due by Thursday. Before sending, confirm each student’s scores roll up correctly into the progress columns and that no cell shows a formula error or missing weight.

Before I send these student progress sheets to Claire, make them easy to review — put each student’s pass/fail status and trend over the last three assessments at the top, make the grading weights visible next to the totals, and highlight any declining trajectories or missing assessments. Also note anything that would make a reviewer hesitate about promotion recommendations.

After adjusting grading weights, Javier’s record moved from failing to passing and Claire will use this to decide promotion; Karen needs to sign off later this week. I’m worried the weight change may have been misapplied or that an assessment got double-counted. I can’t tell if the change is legitimate from the sheet alone. What targeted checks should I run to confirm the integrity of Javier’s history and what exact evidence should I present to Claire to justify the promotion decision?

We frequently make weight or grade tweaks in the final days that change promotion outcomes and force Claire and Karen into last-minute reviews. That erodes trust and creates extra paperwork. What single habit change would reduce these disruptive late changes — a locked pre-review snapshot, a mandatory change log, or a brief weekly calibration meeting — and how do I introduce it so instructors accept it without it becoming another bureaucratic task?