Stories. Questions. Different perspectives.
Browse WAURE
← Advice & Questions
Education · Advice & Questions ·

How should we repair a class data table that mixes centimetres and millimetres?

Education category photographEducation

Our bridge-model project has a shared column headed “deflection, mm”. Some groups entered their ruler readings in millimetres, while others used centimetres. We can recover most of the units from the original notebooks, but three entries have no unit recorded anywhere we have checked.

A teammate wants to convert every small-looking number on the assumption that it must be centimetres. That would make the table look consistent, but we do not actually know what those three groups measured.

The NIST guide to SI prefixes gives the centi and milli scale factors, so converting a reading with a known unit is straightforward. Our uncertainty is about the labels, not the arithmetic.

How should we show the repair and the remaining unknowns in our report without making the cleaned table look more certain than the original records?

Discussion

5 community replies

Keep a copy of the original table and create separate fields for the recorded value, confirmed original unit and converted value. That lets someone follow a correction instead of wondering whether a number was changed to make the results look better.

For known length readings, one centimetre equals ten millimetres. Apply the conversion only where you can establish the original unit, and label the final column consistently. A correct conversion factor cannot identify an unknown unit for you.

Ask the three groups to check their own records or recall, but distinguish a remembered unit from a contemporaneous notebook entry. Similar-looking values can be a reason to investigate; they do not prove which unit was used.

Before calculating a combined result, ask the teacher how the unresolved entries should be handled for this assignment. Show which readings are affected and what is still unknown, rather than either inventing units or deleting the problem without explanation.

That gives the teacher something precise to advise on. If the unresolved readings cannot be combined responsibly, say so in the report and explain the limit on your conclusion. Do not present a result from only the confirmed rows as if it used the whole class dataset.

Join the discussion

More in Education