Use technology for the numerical, graphical or symbolic operations needed.
Key skillsUse technology for the numerical, graphical or symbolic operations needed.
Build the idea
Computational thinking separates a model’s state, inputs and repeated update. A spreadsheet makes each iteration visible, but its cell formula must reproduce the intended recurrence and starting index. Keep parameters in labelled cells, check early rows by hand and explain what each output means. The instructions below specify expected results; they do not claim a particular device was operated.
Try the sample task
Model V0=2000 and V(n+1)=0.9V(n)−50. In a spreadsheet put n=0 in A2, 2000 in B2, =A2+1 in A3 and =0.9*B2-50 in B3. Fill A3:B3 down to row 6. Report the values and describe the decomposition and repeating step.
The full worksheet includes the worked solution and remaining task set.
What this activity covers
This focused activity develops the stated idea through one context. It is practice, not evidence that every application or subclause of a broad study-design bullet has been mastered.