To translate an ICT task into an action sequence, read the brief once, underline every required output, then write one action per line in the order the work must happen, with a check after each. The result is a short list you can follow in any software.
Practical ICT tasks are long because they bundle several small jobs. The marks are usually in the small jobs: the right formula, the right sort, the right file format. A sequence keeps them from blurring together.
Why does a long brief feel harder than it is?
A brief mixes instructions, data and requirements in paragraphs. Your eyes jump between them and you start something before you know the whole task. Midway you discover that a later requirement should have shaped an earlier step.
The fix happens on paper before you touch the software. It takes five minutes and saves redoing work.
How to build the sequence
- Underline every required output: each file, column, format and name.
- Circle the order constraints, such as “before sorting” or “then save as”.
- Write one action per line in plain words, without menu names.
- Add a check to each line: what you should see when it worked.
- Add your software’s menu path beside each line once the plain version is right.
Worked example
Original brief: a school tuck shop records three items. Nasi lemak at RM3.50, 12 sold.
Kuih at RM1.20, 30 sold. Teh ais at RM2.00, 20 sold.
Produce a sheet with each item’s total, a grand total, totals shown in RM with two decimal places, items sorted by total with the largest first, and a copy saved as a CSV file.
| Step | Action | Check |
|---|---|---|
| 1 | Enter headings: Item, Price, Sold, Total | Four headings, one per column |
| 2 | Enter the three rows of data | Three rows, numbers stored as numbers |
| 3 | In Total, multiply Price by Sold, and fill down | Totals are 42, 36 and 40 |
| 4 | Add a grand total below the Total column | Shows 118 |
| 5 | Format Price and Total as currency, two decimal places | Shows RM42.00 style values |
| 6 | Sort all columns by Total, largest first | Order is Nasi lemak 42, Teh ais 40, Kuih 36 |
| 7 | Save a copy as CSV | The CSV opens and shows the same rows |
Check the arithmetic: 3.50 × 12 = 42, 1.20 × 30 = 36, 2.00 × 20 = 40, and 42 + 36 + 40 = 118.
The mistake to watch for
A student sorts only the Total column. The totals now read 42, 40, 36 but the item names stay in the old order, so Kuih appears beside 42.
The correction is in step 6: select all the data columns before sorting, so each row moves as one unit. The check afterwards catches this at once, because the name beside 42 should be Nasi lemak.
Check yourself
1. Why does the grand total come after the row totals in the sequence?
Show answer
It depends on the row totals. Building it first would leave it summing empty cells.
2. A brief says “save as a PDF, then add a footer”. What is wrong with that order if the footer must appear in the PDF?
Show answer
The footer has to be added before exporting, otherwise the PDF will not contain it. Order constraints change the sequence.
3. Rewrite “format and sort the data” as two steps with checks.
Show answer
Step A: format the Price and Total columns as currency; check the values show RM and two decimal places. Step B: sort all columns by Total, largest first; check each name still sits beside its own total.
Where this leads next
The ordered action checklist lesson builds this habit, and the spreadsheet formulas module covers the formula steps. Next, learn to check that exported output preserves the work. The ICT practical task and evidence checker gives original briefs for practice.
If your sequences are sound but the software steps keep failing, one-to-one ICT tuition can work in the software you actually use. The ICT learning guide shows where these skills sit in the subject.