Why a Spreadsheet Can Put 10 Before 2 | The Text-or-Number Test

A Primary 6 pupil in Clementi has a tidy-looking Science table: Trial 1, Trial 2, Trial 10. The teacher asks for the trials in numerical order. The pupil clicks Sort, watches the rows move, and gets Trial 1, Trial 10, Trial 2. The spreadsheet has not mixed up its arithmetic. It may have followed a perfectly consistent rule for text, rather than the rule the pupil expected for numbers.

This tiny problem sits inside a surprisingly useful lesson about data. A computer must decide what kind of thing a cell contains before it can compare one cell with another. The symbol 10 can mean a quantity ten, the characters one then zero, a classroom seat label, an examination candidate identifier, or part of a date. Those meanings lead to different sensible sorting rules. The screen may display the same two characters whichever meaning the program uses.

If your Excel or Google Sheets data seems to sort incorrectly, this guide shows how to distinguish numbers stored as numbers from numbers stored as text, why text-based sorting can put 10 before 2, how copied tables and CSV imports create mixed columns, and how learners can repair a file without destroying valuable identifiers. It also shows what parents and teachers can ask when a neat spreadsheet quietly changes the story. There is no need to blame the student or the software before checking the type of comparison being made.

The 50-second answer

When a spreadsheet treats 1, 10 and 2 as text, it may compare the characters from left to right. Both 10 and 1 begin with the character 1, which sorts before the character 2, so the text sequence can be 1, 10, 2. When the cells contain the numeric values 1, 10 and 2, a smallest-to-largest numerical sort should give 1, 2, 10. A mixed column may behave differently again, depending on the spreadsheet and its settings. The first repair is to ask whether the column contains quantities, labels or a mixture, then inspect the stored value type before converting or sorting. Never automatically turn identifiers such as 0012 into numbers: doing so can erase leading zeros that matter.

The first question is not “Which button did you click?”

Picture the three trial numbers written on a whiteboard. A child naturally sees them as amounts: one, two, ten. A computer does not have to make that same assumption. It can see three pieces of character data. In a character-by-character comparison, 10 has an initial 1, and 2 has an initial 2. Because the first character already decides the order, the following 0 in 10 does not get a chance to make it bigger than 2.

Now put those values into an actual quantity column headed “Number of seedlings.” If the cells are truly numeric, ten seedlings is more than two, no matter how many digits are needed to write the number. This is a numeric comparison. A programme that stores and sorts typed quantities as numbers is doing a different job from one that stores and sorts labels as text. Both rules are understandable; only one matches the particular classroom question.

Students often say, “It is clearly a number because I can see digits.” That statement confuses the appearance of the entry with its stored meaning. Written symbols do not carry their type around as visible badges. A leading apostrophe, a copied value from a web page, a CSV import option or a column formatted as Text may create a string even when the characters look numeric. By the time the pupil discovers the unexpected order, the display can have hidden the reason.

This is why a reliable repair begins with diagnosis. Do not start by choosing a different sort direction at random. Ask what the entries represent. Are they measurements, counts or prices? Are they room numbers or candidate codes? Is the desired order numerical, alphabetical, chronological or a custom sequence? Sorting is an operation on meaning, not merely a decoration that makes a table look clean.

Stage 1: Identify the four things a spreadsheet keeps apart

A useful school model has four separate layers. First is the visible display, the characters and formatting shown to the pupil. Second is the stored value, such as a number or a string of text. Third is the comparison rule, such as smallest number first or text A–Z. Fourth is the purpose of the column, which belongs to the experiment or assignment rather than to the application. Errors happen when one layer is assumed to determine all the others.

Consider 002. In a trial-code column, that might be an identifier whose leading zeros are part of its identity. 002 should remain 002. In a seedlings-count column, 002 and 2 would ordinarily describe the same quantity. A careless conversion from text to number might be harmless for the count but destructive for the identifier. Before pressing Convert, a student should decide whether mathematical operations should ever be performed on the entries.

A phone number is another useful example. It contains digits, but it is not a quantity to be added, averaged or made smaller by subtraction. A postcode, a class seat code and a book identifier can behave the same way. Sorting those labels as text is not inherently wrong. What is wrong is asking a numerical question of a column whose entries are labels, or silently converting the labels until they lose meaning.

That distinction matters in school Science. A column called “Distance travelled (cm)” should generally contain numeric measurements that can be compared and used in calculations. A column called “Sample ID” may appropriately contain text such as S01, S02 and S10. An Excel table can hold both columns side by side. The student needs to know which one determines the order for the intended investigation.

Stage 2: Reproduce the surprising order with an honest toy table

Build a three-row example in a blank workbook. Label one column “Text label” and enter the strings 1, 10 and 2 as text—perhaps by preparing a column explicitly for text before entering them. In a second column, enter the numeric values 1, 10 and 2. Display both columns in the same general-looking number style where possible. You have created two lists that look similar to the eye but are intended to represent different value types.

Sort the first column as text from A to Z, using the spreadsheet’s available text-sort method. The typical left-to-right character order is 1, 10, 2. Sort the second as numeric values from smallest to largest. The numerical order is 1, 2, 10. Both are valid outputs for their respective rules. If the software displays a conversion warning or a special dialog when it detects mixed data, read the warning rather than clicking through it automatically.

Next, add 11, 20 and 3 to the text list. A lexical sequence may put 11 beside 10 and before 2, with 20 beside 2. Ask the learner to explain why before showing the computer result. If they can predict the order, they have discovered the underlying comparison, not simply observed a glitch. Add 02 and ask how its characters change the position. Do not present one universal order for all spreadsheet apps: locale, collation options, text/numeric mixing and custom sort choices can influence the actual result.

Record the result in a miniature audit table: original cell, intended meaning, detected type, chosen sort rule, observed position. That table is more instructive than a screenshot of the Sort button because it shows how a decision was reached. If the pupil is building a Science graph, keep the measurement sequence in a separate time or trial-order column; sorting values for inspection should not silently replace the original experimental order.

Stage 3: Find out how the digits became text

A value can enter a spreadsheet through typing, copying from a website, pasting from a PDF, exporting from a learning platform, or importing a CSV file. These pathways do not always produce identical types. A downloaded file might carry a number as a quoted character field. A teacher may have deliberately saved an identifier with leading zeros. A pasted value may begin with a hidden space or a leading apostrophe. A column may have been designated Text in advance because someone wanted to preserve its exact contents.

Microsoft’s support documentation explicitly warns that numbers stored as text can cause unexpected sorts and calculations. It notes that imported information and values entered with a leading apostrophe can be affected. Some Excel versions show a small indicator or align text differently from numbers by default, but those visual clues are not guaranteed: users can change alignment and error checking, and other products have different interfaces. Appearance is a clue, not a definitive type test.

A robust investigation selects a suspect cell and asks how the application represents it. Check the formula bar or the relevant cell-information tool. Compare with an unquestionably numeric cell. Where available, test with an appropriate type-checking function, such as Excel’s ISNUMBER or ISTEXT. Avoid assuming that the exact function name, argument separators or import options are identical in every spreadsheet language and version. The key idea is to distinguish a display format from the value’s underlying type.

If a column contains different types, it may not sort like either a clean number list or a clean text list. Excel’s documented behaviour can group numeric values separately from text values; other tools can show different orderings or prompts. This is the point where a student should stop guessing. A consistent column is often necessary for a consistent answer, but the correct consistency depends on whether the content represents quantities or identifiers.

Stage 4: Convert quantities without destroying identifiers

Suppose the column is “Plant height (cm)” and all values are intended to be measurements. A careful learner makes a copy of the column, checks for blanks and annotations, then converts the numeric-looking text to genuine numbers using the application’s documented method. Microsoft describes ways to convert text-formatted numbers, including a conversion option and the VALUE function for appropriate inputs. The learner then repeats the sort and verifies the values against the original source. A successful conversion changes the stored type while preserving the intended measurements.

Do not apply the same conversion blindly to P001, 0023, class codes or dates. 0023 might be a sample’s permanent identifier; converting it to 23 would discard information. Likewise, 1-2 may mean a trial range or a class label rather than a date. This topic neighbours the separate Science-table sorting guide, which focuses on preserving observation order. Here the owner is narrower: how typed values determine a sort that can look mathematically wrong.

Always check for decimal separators, thousand separators, units embedded as text, currency symbols and stray spaces. An entry of 3.5 cm is not the same kind of value as a numeric 3.5 paired with a column heading containing cm. The latter keeps the data easier to compare and calculate; the former may require parsing. A comma can mean a decimal separator in one locale and a grouping separator in another. Do not use a conversion method unless you can verify the resulting values row by row or with a suitable sample audit.

Even after conversion, sorting the wrong column can destroy a time-series interpretation. A temperature graph should usually keep the time column and observation together. Sorting by temperature can be useful for ranking results, but it should not be mistaken for the order in which temperatures were measured. This distinction protects the experiment from two separate hazards: type confusion and sequence confusion.

Stage 5: Keep the rows together

One of the riskiest spreadsheet mistakes is sorting only one column from a table that describes connected observations. Imagine that each row contains a trial label, time, temperature and student’s initials. If the trial column moves independently from the other three, the labels can point to the wrong readings. The numerical sort may look fixed while the experiment becomes corrupted.

Treat a row as a record whose fields belong together. Select or structure the complete data range, confirm headers and follow the spreadsheet’s table or range-sorting workflow. Keep an untouched source copy or a reliable undo path so the team can compare the result with the original. The step is routine for experienced analysts but often invisible to a young learner who sees a column as a list rather than as one part of a set of connected records.

In a classroom exercise, make four rows containing Trial 1, Trial 2, Trial 10 and Trial 11, with distinct temperatures and times. Ask one group to sort the trial-code column only in a copy of the data and another to sort the complete table by an appropriate key. Compare which rows still preserve the true pairings. The point is not to punish an error. It is to make a data dependency visible. The students should be able to explain why a correct sort operation applied to the wrong range can produce an incorrect scientific record.

A second check asks whether the field being sorted is an identifier such as Trial 10 rather than the numeric value 10. An application may sort those whole strings in lexical order, placing “Trial 10” before “Trial 2”. A robust table often separates a numeric trial-order field from a display label. Then the teacher can show “Trial 10” on the page while still sorting by the true sequence number.

A worked school case: labels that look like data, and data that look like labels

Consider this fictional record from a Clementi class investigating how different amounts of water affect a plant over a short observation period. Four pots carry identifiers P01, P02, P10 and P11. Each pot also has a numeric water volume, measured in millilitres, and a height recorded in centimetres. The teacher asks for “the pots from least water to most water.” The appropriate key is the water volume, not the pot identifier—even if both happen to contain digits.

If a pupil sorts by pot code instead, the result may look neat and internally consistent while answering the wrong question. If they sort the volumes but the imported values have become text, they may get an odd order such as 100, 20, 5 under certain text comparisons. Those are different failure modes. One is wrong variable chosen; the other is wrong type applied to the right variable. A good diagnosis names which one occurred.

Now imagine one volume cell says 20 ml while the others contain 5, 20 and 100 as pure numeric values. The units belong in the heading rather than mixed into measurement cells. The learner should first check whether the text cell is genuinely a measurement, then separate the number from the unit with a documented, checked conversion. If the annotation about 20 ml expresses uncertainty, automatic conversion could erase that important qualification. Do not silently turn approximate observations into exact-looking data.

This case shows why data literacy is also language literacy. The student needs to read “from least water to most water,” identify which column answers that question, recognise what each entry means and verify that the computer’s comparison is compatible. A mathematical-looking table can fail because of a word, a type or a missing field relation—not because the pupil cannot calculate.

What changes when the values are negative, decimal or very large?

The difference between text order and numeric order becomes even more noticeable when the list grows. Consider -3, -20 and 5. Numerically, negative twenty is smaller than negative three, so the ascending numerical sequence is –20, –3, 5. In a simple character comparison, punctuation, digits and other characters follow text-collation rules that are not designed to represent magnitude. The exact text ordering can depend on the app and locale. The reliable educational point is that alphabetical order is not a substitute for numerical comparison.

Decimal entries create another trap. In one setting, 2.5 denotes two and a half. In another locale, a comma may be the decimal separator. A source containing 2,5 or 2.500 may be parsed differently from what the learner intended, depending on the selected convention. Do not treat punctuation as harmless decoration in a quantity field. Confirm the measurement, the source language or locale, and the intended precision before importing or converting data.

Large numbers can make the difference surprisingly hard to spot. A list of text strings 9, 80, 700, 60 can sort by their first characters rather than by their values. Because the shorter strings may already look “roughly increasing” in some subsets, a casual glance will not always catch a problem. A quick manual estimate of the minimum and maximum values can expose a strange first or last row. This is a good reason to check the table at its extremes after a sort.

Scientific notation adds a useful challenge for older students. An entry such as 1.2E3 might be recognised by the application as the number 1,200, or remain a literal string, depending on how it was entered and imported. If students are comparing concentrations, counts or distances, they must verify that apparent notation has been parsed to the intended number. They must also preserve units and significant figures rather than assuming every visual change is only formatting.

Why formatting a cell is not always the same as converting its value

Students often open the Number Format menu, click Number, and assume the problem has disappeared. Sometimes that is enough for a particular workflow. Sometimes the underlying stored value remains text, and changing its display setting does not perform the conversion the student had in mind. That is why the next step should be a type check or an actual comparison, not simply a different-looking toolbar icon.

The safe diagnostic loop is small. Make a duplicate of the file. Choose two suspect cells and one trusted numeric cell. Inspect their value types with the software’s available tools. Convert a test copy of the suspect cells using a documented method. Compare the original and converted displays, and check whether a numeric sort now places the known values correctly. Only then apply the method to a larger column. This approach protects the learner from “fixes” that remove leading zeros, merge labels or change dates.

The difference resembles the distinction between painting a box blue and changing what is inside the box. Formatting can make a number appear with two decimals, a currency symbol or a percentage sign; the underlying value may still be the same numeric quantity. But a character string that resembles a number is not necessarily transformed into a mathematical value merely because its cell is painted with a numerical style. A good learner learns to ask which layer an action changes.

Be careful with familiar right-aligned and left-aligned cues. Microsoft documentation describes typical default alignment differences between numbers and text, but cells can be manually aligned. A deliberately centred results sheet may hide that clue. Other spreadsheet products can render or import values differently. The audit should rely on checks that fit the actual application and file, not on an internet trick treated as a universal law.

The difference between an identifier and a measurement is a thinking skill

Imagine a class attendance list. The values 01, 02 and 10 may be stable registration labels. A learner who converts them to 1, 2 and 10 may obtain a pleasant numerical sort while destroying the exact stored identifiers. In another worksheet, a measurement column contains 01, 02 and 10 only because somebody typed leading zeros. Converting them to 1, 2 and 10 may be the right repair. The digits are the same, but the correct treatment differs because the data have different roles.

This is why data cleaning should start with a data dictionary, even a tiny one. Define each column: what it means, acceptable entries, whether it is numeric or textual, its units where relevant, whether it can be blank, and whether leading zeros matter. For a Primary 6 investigation, the dictionary may be four sentences at the top of the page. For a larger research database, it can be a formal document. The habit is identical: do not let the software guess the semantics that the scientist has not explained.

When learners encounter a discrepancy, ask whether their question is about count, rank, identity or time. Counts and measurements support arithmetic; identifiers support lookup and matching; dates and times require chronological interpretation; ranks are positions relative to a specified rule. A column that looks numerical can belong to any of these categories. A spreadsheet is powerful precisely because it can store them together, and error-prone precisely because the screen can make them look alike.

This lesson transfers directly to reading public statistics and digital forms. An official-looking table is not self-explanatory. Before comparing rows, we need to know what a field denotes, what values are valid, and what ordering was applied. The computation may be flawless while the interpretation remains wrong. This is a point of critical data literacy, not merely a software troubleshooting tip.

Six common failure modes, and the quickest reliable repair

Failure mode one: sorting a mixture of numbers and text. The column has numeric 2, textual 10, and numeric 1. The resulting groups may be surprising. Repair by deciding whether the whole column should represent quantities or labels, then standardising its stored types in a copy. Document any entries that cannot be converted without losing meaning.

Failure mode two: converting identifiers because they contain digits. A code 0007 becomes 7 and no longer matches another school’s identifier. Repair by restoring the original and keeping the identifier as text. If a separate numeric rank is needed, add a separate sort-key column rather than changing the identity field itself.

Failure mode three: sorting only the highlighted column. Temperatures move but observation times do not. Repair by restoring the original data and sorting the entire record or table. Verify two or three distinctive row pairings before trusting the result. A beautiful ascending list is worthless if each value now belongs to the wrong trial.

Failure mode four: sorting the wrong field. The task asks for increasing temperature; the pupil sorts by trial label. Repair by reading the assignment question aloud, naming the comparison variable and marking the intended sort key. This is a comprehension error rather than a data-type error, and it requires a different teaching response.

Failure mode five: copying a result without preserving the sort rule. A student sends a screenshot of an ordered table but nobody knows whether it was sorted alphabetically, numerically or by a hidden secondary field. Repair by recording the key, direction, tie-breaker and data version alongside the result. Reproducible sorting is part of reproducible analysis.

Failure mode six: treating a conversion warning as an inconvenience. A learner clicks away a warning about numbers stored as text, then assumes the sort is meaningful. Repair by checking one representative affected value, comparing the proposed conversion with the column’s purpose, and converting only when the semantics are clear. Software warnings are information, not instructions to surrender judgment.

A learner’s route: a ten-minute test you can do independently

First create two columns with the entries 1, 2, 10 and 11, one deliberately stored as text and the other as numbers. Predict each sort order before clicking. Second, add a unique letter prefix such as T01, T02, T10 and T11 and decide whether the column now represents quantity or identity. Third, add one intentionally inconsistent entry to a copy of the numeric column and investigate how your spreadsheet warns, groups or handles it. Finally, explain to a classmate why 10 can appear before 2 without the machine having made an arithmetic mistake.

A good written answer is short enough to fit in a school notebook: “The cells were compared as text, so the first character decided the order. Because 10 begins with 1, it can come before the text 2. To sort quantities, I need confirmed numeric values; to sort identifiers, I should preserve their exact text.” The first two sentences explain the mechanism. The last sentence stops an overzealous correction.

If you are submitting a Science report, copy your cleaned table into a separate worksheet and keep the raw observation sheet unchanged. Add units to headings, not inconsistently inside measurement cells. Compare a few source entries after the sort. If a line chart is involved, verify the source range and the observation sequence; see the distinct spreadsheet chart source-range test. It owns the chart’s inclusion of records, while this guide owns typed-value comparison.

The aim is for the learner to become able to predict, diagnose and verify, not to memorise a button sequence that will be renamed in the next software update. When an unfamiliar spreadsheet opens, the same questions still work: What is each column? What is each value’s type? What comparison is being requested? How will I know the output preserved the original records?

A parent’s route: diagnose meaning before offering the mouse

When a child shows you a “wrong” sorted table, ask for the original assignment instruction. The child might be sorting a measurement, a student code or a sequence of observations. If the column represents identifiers, the lexical order might be perfectly acceptable, and the real problem may be that the instruction was unclear. If the column represents quantities, you have a reason to inspect whether digits were stored as text.

Try three questions in order. “What does 10 stand for in this table?” “Would you ever add these entries together?” “What should the first and last rows mean after sorting?” The child’s answers reveal whether the needed repair is mathematical, linguistic or technical. This is more useful than taking over the keyboard and returning a correct-looking file with the underlying misunderstanding intact.

Keep the household exercise small. You can demonstrate with paper cards marked 1, 10 and 2. Sort them first as written labels, comparing the first visible character. Sort them again as quantities, comparing their numerical values. Ask your child to name the two different rules. Then, if appropriate, reproduce the result in a spreadsheet. The software becomes a confirmation of an understood mechanism rather than the mysterious source of the answer.

Parents should avoid turning a single import error into a broad judgement about the child’s intelligence or diligence. The question to answer is practical: which concept was missing, and can the learner now apply it to a different list? A ten-minute type-check exercise may be more informative than a long lecture about being careful with computers.

A teacher’s route: teach the idea and the software separately

Use two deliberately comparable tables. In one, 1, 10, 2 are sample identifiers. In the other, they are numeric counts. Ask students to predict suitable orders for both. Reveal that the same displayed digits can legitimately be stored and compared differently. Model one software procedure for inspecting a value’s type. Check understanding before assigning an independent conversion task. This progression fits evidence-informed explicit teaching without pretending that one spreadsheet exercise has a measured effect on achievement.

Next, introduce an error for which automatic conversion is not appropriate. Put 0004 in an ID column and ask what information might be lost by treating it as the numeric value four. Have learners propose a better structure with separate Sample ID and Observation number fields. This prevents students from overgeneralising the first lesson into “all digit strings should be numbers.” Good teaching exposes the limits of a new rule before that rule becomes another misconception.

For independent practice, give a CSV-like table containing a measurement, an identifier, a date-like label and one blank. Students must classify the roles, decide which columns should be numeric, choose a sort key, and state one limitation. Do not reward only the final row order. Ask them to explain why their solution protects leading zeros and keeps records together. Give a slightly different dataset a week later to check whether the reasoning transfers.

A final exit ticket can show two identical-looking cells and ask: “One contains the number 10, the other contains the text 10. Does the screen alone prove they will sort identically?” The expected answer is no. Ask for a method of checking and a reason not to convert codes indiscriminately. This single item distinguishes an actual conceptual gain from success at following yesterday’s button instructions.

What this problem cannot tell you

An unusual sort order by itself does not prove that cells are stored as text. A custom sort list, an active filter, a secondary sort key, imported formatting, a hidden column or an application-specific collation rule could also influence the result. Diagnose the actual file. Do not claim that a particular order “always” means one cause without checking the program and data types.

Likewise, if the order becomes correct after a conversion, that does not establish that every value has been preserved. The conversion may have stripped leading zeros, interpreted a date differently or ignored an annotation. Verification requires comparing the converted values with the original intended meanings, not merely checking that the newest screenshot looks more reasonable.

This guide is not a certified tutorial for every version of Excel, Sheets or another spreadsheet product. Menu locations, import options and formula behaviour change across products and updates. Microsoft’s support pages provide authoritative examples for Excel, but some instructions will need adapting elsewhere. The invariant is conceptual: distinguish stored type, visible format, chosen comparison and field meaning.

There is also no evidence presented here that a child who masters spreadsheet sorting will automatically perform better in a mathematics examination. The claim is narrower and useful: the child can learn to diagnose one concrete data representation problem and can practise explaining how representation affects a computational result. That is worth learning without inventing score gains.

FAQs: when the numbers sort out of order

Why does 10 come before 2 in Excel or Google Sheets?

A common cause is that the digits are being compared as text. In left-to-right text order, the initial 1 in 10 precedes the initial 2 in 2. Verify the stored data type and sort settings in the actual file; do not assume the cause without checking.

Isn’t 10 always a number?

Not in digital storage. The characters 1 and 0 can form the textual label 10, or they can represent the numeric quantity ten. The purpose of the column and the stored type decide which interpretation is useful.

Can I fix every number-looking cell by converting it to Number?

No. Candidate numbers, sample codes, postcodes and other identifiers may need to retain leading zeros or exact characters. Convert a field only after establishing that it represents a mathematical quantity and verifying that its meaning survives.

How do I check the type of a cell?

Use the application’s documented type or error-checking tools, formula bar and suitable functions where available. Compare with a trusted numeric cell. Alignment and display style alone are weak clues because they can be customised.

Why did sorting fix the list but break my graph?

You may have changed the order of observations or sorted only one column while leaving the related values behind. Preserve complete records and keep a separate original observation order when the experiment depends on time or sequence.

What is the difference between a text sort and a number sort?

A text sort follows character comparison rules; a number sort compares numerical values. That is why 1, 10, 2 can be an appropriate text sequence while 1, 2, 10 is the ascending numerical sequence. Application details vary, especially with mixed types and locale settings.

Can the same problem happen with dates?

Yes. A date-like entry may be stored as text, as a recognised date value or as a different interpretation from the one intended. Always verify imported dates against their source and the chosen regional convention. Date auto-formatting is a related but separately owned mechanism.

What is the fastest sensible check for a school assignment?

Read the question, name the required sort key, inspect whether the entries are quantities or identifiers, confirm the relevant value types, make a copy, perform the sort on the complete table and spot-check the first, last and several middle rows against the source.

Sources and useful neighbouring explanations

• Microsoft Support — Sort Data in a Range or Table in Excel. Documents numeric and text sorting and cautions about numbers stored as text.
• Microsoft Support — Sort Data in a Workbook in the Browser. Explains text comparison order and mixed data-type issues.
• Microsoft Support — Fix Text-Formatted Numbers. Details common imported-text symptoms and correction routes; interface instructions may depend on product version.
• Microsoft Support — Convert Numbers Stored as Text to Numbers. Documents conversion methods including the VALUE function for applicable values.
• Australian Education Research Organisation — Teach Explicitly: Primary and Secondary. Supports modelling a small mechanism before guided and independent application.
• US Institute of Education Sciences, What Works Clearinghouse — Improving Mathematical Problem Solving in Grades 4–8. Supports monitoring reasoning and use of representations; it does not test this specific spreadsheet activity.
• eduKateSG — Why Sorting a Science Results Table Can Change the Story. Canonical neighbour for observation-order versus value-order decisions.
• eduKateSG — Why a Spreadsheet Chart Can Ignore the Newest Result. Canonical neighbour for chart source-range omissions.
• eduKateSG — How Education Works. Broader route for evidence, feedback and learning transfer.

Editorial note: Clementi pupils, trial tables and classroom exchanges in this article are illustrative. The examples explain documented spreadsheet behaviours without claiming that every version of every application uses the same sorting convention. No real student records are used.