NEERAJ KANT
TEACHING / ASSESSMENT
Suppose the goal is to use a spreadsheet formula to calculate a total. A recall question might ask: “What is a formula?” Keep that question when vocabulary matters, but add a task that requires a learner to use the idea.
Use a small, fictional stationery budget: notebooks cost ₹40 each and pens cost ₹10 each. Ask learners to calculate the cost of three notebooks and five pens, then explain how they would update the total when the quantity changes.
A learner can enter quantities in one column, unit prices in another, and use a multiplication formula for each row. The total is ₹170. Changing the number of notebooks from three to four should change the overall total to ₹210.
Ask learners to show their formulas and explain why a formula is more useful than typing the calculated answer directly. This reveals both the method and the reasoning behind it.
This is an illustrative classroom rubric, not an official examination marking scheme. Adapt it to the learning goal and learners’ prior knowledge.
Offer a partially completed table if students are new to spreadsheets. For a challenge, ask them to compare two budgets without exceeding a given spending limit.
End by asking: “Which mistake did you check for, and how?” A brief explanation often reveals more than a correct answer alone. Keep the context familiar and the reading load manageable so that the task assesses the intended computing skill.