Edit table content

On slide 5 update the table with the latest assessment data: replace ‘Unit 1’ row with Unit 2 numbers, change average score to 78, and mark the pass rate column as 84 percent. Keep existing font and colors. After editing, run the spell check and confirm no cell text is truncated before I share with the head of year on Thursday morning.

Before I hand this table to the head of year, make the assessment table easier to approve: surface the average and pass-rate figures at the top of the right column, flag any drops of five points or more in red, and add a one-line footnote explaining that scores are from the week ending July 10. Tell me anything that will make a reviewer pause.

I updated the assessment table with Unit 2 scores and the pass rate, but the formatting is inconsistent—some rows use bold and others don’t—and the pass rate cell shows 0.84 instead of 84%. The head of year expects a clear table for Friday. What likely formatting mistakes did I make and what’s the fastest reliable fix?

Each term I manually tweak tables with assessment updates and waste time correcting number formats, alignment and notes before every review. It erodes trust because early drafts look rushed. What two simple habits or a slide-template tweak will stop me repeating this cleanup every term?