What you will learn
- Identify the kind of performance you want to achieve.
- Use an unaided attempt to locate a specific gap.
- Revise practice using feedback and a fresh example.
Familiarity can feel like competence
An explanation can seem clear because the author has already selected the relevant information and arranged every step. Following that path is useful, but doing the work yourself requires additional decisions. You must recognize what kind of problem you face, recall relevant knowledge, choose a method, and notice errors. Reading a solved spreadsheet example may feel easy while building a new sheet feels confusing. That difference does not mean you are incapable. It tells you that recognizing someone else’s process and producing your own are different learning tasks. Define mastery as a concrete performance rather than a feeling of understanding.
Make the target performance visible
Write what you want to do, under what conditions, and how you will judge it. “Understand spreadsheets” is too broad. “Create a simple monthly expense total from a fresh set of entries and explain the formula” is testable. Decide whether reference materials are normally permitted. Independent performance does not always mean memorizing everything: a professional may appropriately use documentation while still needing to diagnose errors. Your test should resemble the real task. If you only copy a demonstrated example, you may be testing your ability to follow steps rather than your ability to decide which steps are needed.
Attempt first, then diagnose the precise gap
After studying a short example, hide the solution and attempt a related task. When you get stuck, record the exact point: did you misunderstand the question, forget a fact, choose the wrong method, or make an execution error? These require different repairs. If you chose the wrong formula, watching the whole tutorial again may be less useful than comparing two formulas and explaining when each applies. Use feedback to correct the attempt, then try a new example. The IES study guide provides background on worked examples, retrieval, and explanation. No technique removes the need for appropriate material, meaningful feedback, and enough time.
Check whether learning survives a change
An immediate repeat may show that you remember the recent steps. A later attempt with changed details asks more of your understanding. Change one feature at a time: the numbers, the order of information, or the context. Explain why the method still fits, and identify a case where it would not. Keep an error record with the mistake, its cause as best you understand it, and the correction you will test. Avoid using the number of videos watched as your main measure. A small task completed accurately and explained clearly is often stronger evidence of learning than a long history of passive exposure.
Use mistakes of the same type to choose practice material. If reading the task correctly is the obstacle, a set of increasingly complex calculations may add difficulty without addressing the actual gap.
Fictional case: Omar learns spreadsheet totals
Omar watches a tutorial and believes he understands expense formulas. When he builds a new table, his total omits the final row. Instead of replaying the entire lesson immediately, he compares the intended range with the actual formula and identifies the omission. He then creates a fresh table with entries in a different order and checks its total manually. Two days later he repeats the task without the video, using documentation only to confirm syntax. His record shows exactly what he can now do and what still needs checking. He treats the mistake as information about a skill, not evidence of low intelligence.
Your practical assignment
- Define one observable skill and the conditions in which you need it.
- Study a short worked example, then attempt a similar task without viewing the solution.
- Classify the first difficulty and seek feedback aimed at that gap.
- Try a changed example later and explain why your method applies.
Further reading
- Institute of Education Sciences: Organizing instruction and studyResearch-based practice guide for further reading on learning; the spreadsheet task is an original teaching example.