Select a suitable tool function and justify that choice.
Key skillsSelect a suitable tool function and justify that choice.
Build the idea
Computational thinking can separate data entry, transformation, model fitting and checking into distinct steps. In a spreadsheet, retain the original variables alongside transformed columns so predictions can be interpreted correctly. Use an XY scatter plot rather than treating input values as evenly spaced labels. Verify a transformed model against the original observations before reporting it.
Try the sample task
Enter x=1,2,3,4 in column A and y=5,11,21,35 in column B. In C2 enter =A22 and fill down. Plot y against column C, calculate a linear fit and translate it back to x.
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.