Calculate a fictional basket total one line at a time

Practise quantities, line totals and an independent check using invented training amounts.

Set up a basket with clear units

Write PRACTICE ONLY at the top of your page. Use training units, abbreviated TU, for every amount; they are invented arithmetic units, not a currency or a quotation of Zimbabwean shop prices. Draw columns for item, quantity, amount per item and line total. For this original exercise, imagine a learner preparing records for a fictional community stationery table.

Enter three notebooks at 2.40 TU each, two pencils at 0.75 TU each and one folder at 1.80 TU. The item names are ordinary examples rather than real product offers. Keep quantity separate from unit amount. A line saying notebooks 2.40 without stating how many notebooks makes the record ambiguous and encourages the reader to mistake a single-item amount for the whole line.

Calculate each line before adding

Multiply quantity by the amount for one item. The notebook line is 3 × 2.40 = 7.20 TU. The pencil line is 2 × 0.75 = 1.50 TU. The folder line is 1 × 1.80 = 1.80 TU. Write the multiplication beside each answer during practice, so that another learner can follow the method instead of seeing only unexplained numbers.

Add the three line totals: 7.20 + 1.50 + 1.80 = 10.50 TU. Label that answer basket total. Do not add the quantity column to the amounts or include both unit amounts and line totals in the same sum. Keeping the columns distinct is a simple way to prevent a correct arithmetic operation from answering the wrong question.

Check using a different route

Calculate the same basket by grouping whole and fractional parts. Three notebooks contribute 6.00 + 1.20, two pencils contribute 1.00 + 0.50, and the folder contributes 1.00 + 0.80. The whole parts total 8.00 and the fractional parts total 2.50, giving 10.50 TU again. A different route provides a stronger check than simply staring at the original answer.

Now deliberately change the notebook quantity to four while leaving the unit amount unchanged. Recalculate that line as 9.60 TU and the basket as 12.90 TU. Ask which cells or written entries need changing and which do not. This variation tests whether you understand the relationship, rather than memorising the first total and adjusting numbers without a reason.

Transfer the method to a practice sheet

In a spreadsheet, keep the same column meanings and use a formula for each line total. LibreOffice’s mathematical documentation supports SUM for adding a range; its number-formatting guidance distinguishes the displayed decimals from the stored value. Test your sheet with the known 10.50 TU example before inventing a second basket. A formula is useful only if it references the intended cells.

Finish by explaining the calculation to a partner without hiding the intermediate lines. Ask them to point out the quantity, unit amount and total for one item. Keep the completed example and its answer as a reference exercise. This worksheet develops arithmetic and record clarity; actual tills, product units, discounts, taxes and payment requirements belong to the real employer’s authorised systems and current instructions.

Sources & further reading

Use these references to check the underlying guidance and any current local requirements. Practical worksheets and illustrative examples in this guide are original educational material.

  1. LibreOffice Calc: Mathematical functions
  2. LibreOffice Calc: Formatting numbers with decimals

This guide is general information. Source notes are not a claim of independent professional review.