Remove the repeated entry
R04 repeats R02: the same member, club and attendance. Keep one copy.
Not reviewed
The data detective
A cleaning assistant has three suggestions for a club table. Which changes make the data more trustworthy?
Builder · Year 7Data cleaning, review and undo
Check the assistant’s suggestions
These sample records count sessions attended out of five. Review the suggested changes before treating the edited table as evidence.
Use one spelling for Music
Change “music” in R03 to “Music”, matching R06.
Not reviewed
Fill the empty cell with 0
Put zero sessions in R05 so every row has a number.
Not reviewed
The original stays untouched. Approve or reject a suggestion to begin.
Original records
| Record | Member | Club | Sessions |
|---|
Your edited copy
| Record | Member | Club | Sessions |
|---|
The average uses known values only. Missing means we don’t know, not that the member attended zero sessions.
Change log
- No changes yet.
Fictional attendance records and prepared cleaning suggestions. There is no live AI or shared database. A curriculum practice example, not student work.
What the child
is learning.
Explore the learning journeyYear 7 · Data cleaning, review and undo
A suggested fix needs a reason. Removing a duplicate or standardising a spelling differs from inventing a missing value. Keeping the original and a change log makes mistakes reversible.
Now try this…
Approve the zero suggestion and watch the average. Then undo it. What do you know about that member’s attendance—and what is still unknown?