GLOBAL KNOWLEDGE ARK

Learning Science · A learning plan you can revise

Recognising when resources or help are needed

Recognise a need for help, prepare a useful question and check whether the help resolves the obstacle.

Use the examples to connect this lesson with the earlier topics. No specialist equipment is needed.

Back to the chapter

After reading, you can

  • Differentiate types of support
  • Make a precise help request
01

Help can be part of competent learning

A learner cannot interpret a graph because the legend is missing. More effort cannot recover information the resource does not provide. Another learner has the legend but does not understand the units. The first needs a complete resource; the second needs instruction. Recognising the distinction prevents wasted practice.

Help may provide access, missing facts, a model, feedback or specialist supervision. It can come from a person or a dependable resource. Competence includes knowing when a task exceeds current knowledge or safe conditions, rather than pretending every activity should be completed alone.

02

Bring evidence to the request

State the goal, what you tried and where progress stopped. “I understand these two steps but cannot see why the sign changes here” is easier to answer than “I do not understand anything.” Include a small example while protecting private or sensitive information.

After receiving help, explain it in your own words and try a new relevant case. This checks whether the response addressed the obstacle and whether you can use it. If help only supplies a final answer, ask for the reasoning or choose a source that explains it.

03

Plan for access and reliability

A resource must be usable in language, format and setting. A source that sounds confident may still be wrong; compare consequential claims with appropriate expertise or established material. When the task requires trained supervision, a brief online answer is not equivalent to that support.

A request can distinguish access from explanation: “I cannot read the diagram labels” calls for a usable diagram before a conceptual tutorial. When help is delayed, choose a safe independent step that does not depend on the missing information. Keep the unresolved question visible instead of inventing an answer.

In the spreadsheet example, B6 contains an ordinary numeric subtotal. It is not a special SUBTOTAL function. Both formulas are entered in another cell, so the issue is including a duplicate total rather than a circular reference.

Worked example

Requesting spreadsheet help

B2:B5 contain 3, 4, 5 and 8; B6 contains their numeric subtotal 20. Why does =SUM(B2:B6) in another cell produce 40?

  1. Identify the target: total the four original entries, not those entries plus a previously calculated total. The intended data are B2 through B5.
  2. The range B2:B6 includes both endpoints, so it adds 3 + 4 + 5 + 8 + 20 = 40. The subtotal 20 counts the original entries again.
  3. Use =SUM(B2:B5) for this target and verify 3 + 4 + 5 + 8 = 20 by direct addition. Then total a fresh column to check the range-selection decision rather than copying the corrected number.

The first range double-counts the four entries by including their subtotal. The corrected range is B2:B5 and its total is 20. The formula sits outside that range.

Including a subtotal counts the data again

Including a subtotal counts the data againColumn B contains 3, 4, 5 and 8 in rows 2 through 5, totalling 20. Row 6 contains their ordinary numeric subtotal 20. A formula in a separate cell summing B2:B6 returns 40; summing only B2:B5 returns 20.Check which cells the range includesRowB23344558620=SUM(B2:B5)3 + 4 + 5 + 8 = 20=SUM(B2:B6)3 + 4 + 5 + 8 + 20 = 40B6 already totals the entries.Adding it repeats their amount.B6 is an ordinary numeric subtotal, not SUBTOTAL().Both formulas are outside the shown range.
Column B contains 3, 4, 5 and 8 in rows 2 through 5, totalling 20. Row 6 contains their ordinary numeric subtotal 20. A formula in a separate cell summing B2:B6 returns 40; summing only B2:B5 returns 20.

Try it yourself

Think through each question before opening the answer.

  1. When is repeating practice the wrong next step?

    Show the answer and reasoning

    When essential information, access, feedback or supervision is missing. Obtain the missing support first.

    Repeating without an essential resource cannot supply missing information, access or supervision. Obtain the appropriate support and then practise the intended action under usable conditions.

  2. How can you tell whether help was useful?

    Show the answer and reasoning

    Try the relevant action or explanation again, preferably on a fresh case, and inspect whether the original obstacle is resolved.

    A fresh attempt checks whether the original obstacle was resolved and the explanation became usable. Receiving a polished answer alone cannot show that the learner can select the right range next time.

What to carry forward

  • Identify the kind of help needed.
  • Show the attempted work and precise obstacle.
  • Check that help becomes usable knowledge.

References

Sources supporting the explanations and learning checks in this lesson.

  1. How People Learn II: Learners, Contexts, and Cultures — Chapter 1, Introduction (2018)National Academies of Sciences, Engineering, and MedicineConsensus report chapternationalacademies.orgRead source
  2. SUM functionMicrosoft SupportTeaching resourcesupport.microsoft.comRead source