KENYA · GUIDE 0629 · EDITION 4.2

Spreadsheet lessons in Kenya: Records and Planning Worksheets

Keep evidence that answers a real operating question

For spreadsheet lessons, the record should connect the promised output, its cost and the buyer's acceptance. Begin with:

Record learner tasks, formula choices, reference errors, validation attempts, independently corrected mistakes, and follow-up topics that will make the spreadsheet useful in actual daily work.

An order and acceptance record

Field	What to enter
Output and exclusions	Teach spreadsheets through a defined learner task, covering data structure, formulas, references, checking, and saving, with examples relevant to the learner's work or studies.
Sale unit	Workshop or lesson
Acceptance check	Ask learners to modify the example independently and detect a deliberately incorrect formula, checking understanding of references rather than the ability to reproduce a demonstration.
Missed-cost check	Include task design, practice datasets, instruction, individual troubleshooting, feedback, and reusable notes, allowing extra support where basic computer skills constrain spreadsheet progress during the session.
Failure to investigate	Training fails when learners produce an attractive table but extend formulas incorrectly or treat calculated results as trustworthy without checking the source data and logic.

Add the date, private customer reference, agreed price, advance, balance, promised handover and actual acceptance. Record a change before carrying it out. An unresolved complaint needs its own action and follow-up date rather than being overwritten by the next order.

A supplier and cost record

For each required input, record the specification, quantity, supplier identity, quote date, delivered cost, payment terms and reason for selection. Match the record to the receipt and inspect what arrived. Keep one-time setup, recurring inputs and refundable deposits in separate categories so that the same cash movement is not counted twice.

A weekly review

Compare accepted output with started output; reconcile money collected with outstanding balances; investigate rework and returns. Review whether measured capacity can meet the next commitment. A positive surplus estimate does not remove a shortage of cash caused by late collection.

Use sources within their stated scope

ODPC guidance for MSMEs — Privacy principles, lawful basis, data minimisation, processor arrangements and retention; check the provisions applying to the actual operation. Reference recorded 2026-10-26.
Kenya Copyright Board National Rights Registry — Official registry for literary, music, video and spoken-word works; a reference for rights ownership, not permission to reuse third-party material. Reference recorded 2026-10-26.

These references route sector and activity questions. They do not independently establish local customer demand, supplier stock, a complete budget or business profitability. A reference date records the earlier check; it is not a claim that every linked requirement was reverified today.

The complete downloadable guide includes editable planning worksheets. Save backups privately when they contain personal, customer or supplier information. These planning forms do not replace required statutory records or professional advice for a regulated task.

Evidence register for this particular offer

Import data from data sources (Power Query) - Import preview and data-source workflow; version-specific menus may differ. Recorded 2026-10-26.
SUMIFS function — Microsoft - Conditional summation and matching range dimensions; business metric definitions remain client decisions. Recorded 2026-10-26.
Rights Of A Data Subject - Kenyan privacy principles and data minimisation; not a complete compliance assessment. Recorded 2026-10-26.

These recorded references support only their stated scope. They do not establish current supplier stock, actual local demand, operator competence or complete commercial feasibility. Preserve source dates and record new checks separately.

Match the evidence to a decision

Decision question	Business-specific record to retain
Was the input fit for use?	Confirm formula separator/version.
Was the work acceptable?	Learner saves and reopens own copy.
What remains unresolved?	No live accounts or software version tested.

The operating pack provides an itemised quote tool, supplier request, sales draft, job card, quality response sheet, evidence gaps, operations desk and cashflow/launch-review workbook. Keep a separate private backup per actual job and per scenario. Test restoring it before closing the original. Exported files may contain customer or supplier information; do not publish completed private records as SEO content.