A note before we start
The scenario below is entirely hypothetical. The company, the people and the figures are invented to illustrate how an employer might use open courses. Nothing here describes a real organization or reports real results, and real outcomes will differ. The aim is to show the kinds of decisions, costs and trade-offs involved.
The fictional employer
Imagine a regional distribution business we will call Northfield Supplies, employing around 60 people across a warehouse, an office and a small customer service team. It has no dedicated training department. Training is handled by the operations manager, alongside everything else.
The company faces three practical problems:
- The office staff use spreadsheets constantly but have never been taught to use them well, so reports take longer than they should and errors occur.
- Customer service staff want to improve written communication.
- Two supervisors have been promoted from the warehouse floor and have not had any training in managing people.
The budget for training is small, and the manager is wary of paying for a library of courses that nobody uses.
Step one: pick a narrow goal
Rather than launching a general program, the operations manager chooses one team and one skill. The finance and administration group of eight people will aim to build and check spreadsheets more reliably. The measurable goal is modest: by the end of three months, each person should be able to complete a set of practical tasks, such as sorting and filtering data, using basic formulas and making a clear chart, without help.
Step two: curate and check
The manager looks for openly licensed introductions to spreadsheet skills. She reviews several against a short checklist: is it accurate, is it pitched at beginners, is it recent, does it have transcripts or captions, and what does the license allow? She selects two main resources and a set of practice exercises, then writes a one-page guide linking the exercises to the company’s own reports.
Because the license allows adaptation with credit, she changes some of the generic examples to use data that looks like the firm’s stock and delivery figures, keeping the original credit lines. No confidential data is included.
Step three: protect the time
Each participant is given one hour a week during working time, and a lunchtime drop-in session is held fortnightly where people can ask questions and share tips. A more experienced colleague volunteers as the first point of contact.
This step matters more than any content choice. Many training schemes fail because staff are expected to learn in their own time.
What the cost might look like
Suppose, purely for illustration, that the firm would otherwise have bought a license for a commercial course costing 120 currency units per person. For eight people that would be 8 × 120 = 960. The open route avoids that fee. But the manager spends about 12 hours on curation and the one-page guide, and each participant spends 12 hours over three months in learning time, which is 8 × 12 = 96 hours in total, and the colleague mentor gives a further 6 hours. The license saving is real, but depending on pay rates the value of staff time may be as large or larger, and it is spent in either approach. The case for the open route rests on control and flexibility as much as on avoided fees.
What might go well
In this imagined scenario, most of the group complete the practical tasks. People appreciate the tailored examples. Two staff members continue on their own to learn more advanced features. The manager notices that routine reports are produced with fewer corrections.
What might go wrong
A fair case study includes setbacks. Imagine that:
- Two participants fall behind after a busy month and stop attending.
- One of the chosen resources uses an older version of the software, and some menu names differ, causing confusion.
- A participant asks whether the course gives a certificate, which it does not, and feels the effort is not recognized.
- The manager realizes she has no record of how well people performed before the start, so improvement is hard to prove.
Each of these is a reasonable lesson. Check software versions in advance, agree what recognition will be offered, collect a baseline, and plan catch-up time.
Measuring the result
Northfield collects a handful of simple measures: attendance, the practical task results at the start and end, the participants’ own ratings of confidence, and the number of corrections needed on a monthly report. These show change, but the manager is careful not to claim that the training alone explains it. Busy periods, staff changes and new report formats also affect results. With only eight people, the numbers are too few to draw firm conclusions, and the manager treats them as signals worth following up, not proof.
What the employer decides next
Given the mixed results, the manager decides to keep the spreadsheet resources, fix the version issue, and offer a short certificate of completion signed by the company. She plans a similar small trial for customer service writing, and for the supervisors she decides open material alone will not be enough, so she looks into a local, in-person course and uses open reading as preparation. That last decision is a reminder that open resources are suited to some needs and not others.
Lessons from the scenario
- Start with a specific problem and a small group.
- Check every resource for accuracy, version and license.
- Protect learning time and give light support.
- Collect a baseline before you begin.
- Count staff time, not only license fees.
- Expect some setbacks, and plan to adjust.
- Use open material where it fits and other methods where it does not.
Real employers will find different results depending on their staff, sector and goals. This fictional example is a planning aid, not evidence that open education will work in any particular place.