Everyday AI · Module 6

Propose clean values without losing the originals

Suggested time: 6 minutes.

Data cleaning means identifying and handling problems that make records hard to use. It should leave an explanation of what changed and why. Keep the original pack unchanged. Make a separate review copy rather than quietly replacing source values.

Three common issues are:

1. Duplicate: The same record appears more than once.
2. Blank: A field contains no value.
3. Inconsistent label: The same meaning is written in different permitted ways.

Similar wording does not prove duplication. Two tasks called “Review handout” might involve different reviewers or stages. Compare task IDs and all material fields. If repeated IDs contain conflicting owners or statuses, flag the conflict instead of choosing whichever appears last. You need evidence of which version applies.

W6.4 explicitly says it is a copy of W6.1, and every task field matches. Keep one W01 in the review register with both source labels, while retaining both original notes and recording why one mention was excluded from the count.

Status mapping for all exercises in this module

The following dictionary is supplied as part of the fictional exercise. It is permission to standardise these labels in the review copy, not a universal rule for every workplace.

Original status Proposed review status ----------------------------------- ------------------------ Complete, complete, Done, done Complete In progress, in-progress, working In progress Not started, not started Not started Blocked, blocked Blocked A blank status field Not provided

Anything not in this dictionary needs clarification. Do not force “waiting,” “nearly done” or another unfamiliar value into one of these groups by guesswork.

Worked change log

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Source or task Original issue or value Proposed handling Reason -------------------- ------------------------------- --------------------------------------------------------------- -------------------------------------------------------- W01, W6.1 and W6.4 Same task appears twice Keep one register row; retain both source labels W6.4 explicitly identifies a copy and all fields match

W01 Done Review status Complete; retain Done in original-status column Supplied status dictionary

W03 Owner and status fields blank Display Not provided; flag for clarification No owner or status is supplied -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Do not fill a missing owner with the meeting organiser’s name. Do not convert a blank status to “Not started,” and do not delete the task just because it is incomplete.