• We are pleased to announce that the winner of our Feedback Prize Draw for the Winter 2024-25 session and winning £150 of gift vouchers is Zhao Liang Tay. Congratulations to Zhao Liang. If you fancy winning £150 worth of gift vouchers (from a major UK store) for the Summer 2025 exam sitting for just a few minutes of your time throughout the session, please see our website at https://www.acted.co.uk/further-info.html?pat=feedback#feedback-prize for more information on how you can make sure your name is included in the draw at the end of the session.
  • Please be advised that the SP1, SP5 and SP7 X1 deadline is the 14th July and not the 17th June as first stated. Please accept out apologies for any confusion caused.

Conditional formatting as a check

  • Thread starter Logarithm n Blues
  • Start date
L

Logarithm n Blues

Member
One of the checks I've been using on the data is to apply conditional formatting.
I apply a graded colour scale to the cells with data in (green for high, amber for average, red for low) and then I can more easily visually check to see if there are any outlying values.
I can then call out in the audit trail that I have done this and mention that there are no suspicious outlying values
eg. suspicious single high score for a column/row/individual/team that otherwise has very poor scores.

so:
  • Is this an okay idea? (in combination with other checks of course.)
  • Could the fact that the cells are coloured be considered bad style?
    Perhaps some markers would think that colour should only be used as single block colours for eg. parameter values, cells that shouldn't be coppied down etc?
  • I'm guessing that this should be described as a reasonableness check in the audit trail since after the colouring, the human user still needs to check the data visually?
 
Yes, this approach will work. No question of style issues (unless you use non-standard colours instead of green/amber/red).

This won't count as a reasonableness check unless you can provide explanation of why the results come out the way they do - this normally wouldn't be the case for an auto-check like conditional formatting.
 
Back
Top