Phase VII · FE Civil Academy
Computational Tools
Use spreadsheets, logic and algorithms as verifiable engineering tools.
Topic mastery
0%
Accuracy
0%
Questions attempted
0
Average pace
0 s
Practical scenario
Your capstone spreadsheet computes 240 load combinations. Before you trust it, you must verify it against a hand calculation and protect the inputs.
Why this matters
Engineers are responsible for the output of their tools. Verification, documentation and logic are examinable and professionally required.
Concept explanation
- Spreadsheet formulas use relative and absolute references; absolute references ($) lock a constant cell.
- Structured logic uses sequence, selection (IF) and iteration (loops) to express an algorithm.
- A flowchart documents an algorithm so another engineer can follow and check it.
- Verification asks whether the model solves the equations correctly; validation asks whether they are the right equations.
Unit guidance
- Write units on every substituted value.
- Cancel units symbolically before evaluating numbers.
- Confirm the result unit matches the quantity you were asked for.
Handbook navigation
- Open the Computational Tools section of the handbook.
- Search the term "spreadsheet computations" rather than scrolling.
- Note the equation number so you can return to it quickly.
Calculator guidance
- Confirm angle mode before any trig entry.
- Store intermediate values in memory instead of re-keying rounded numbers.
- Round only at the final answer.
FE strategy
- Trace the logic of the pseudocode line by line with a test value.
- Look for off-by-one errors in loop bounds.
Conceptual example
A conceptual computational tools item will ask which quantity increases, decreases, or stays the same when one input changes. Reason from the governing relationship, not from memory of a numeric answer.
Common mistakes
- Dragging a formula without absolute references and shifting the constant.
- Using approximate-match lookups on unsorted tables.
- Trusting a model that has never been checked against a hand calculation.
Guided practice
- Work the first worked example with the solution visible.
- Re-solve it closed-book and compare every step.
- Explain the unit cancellation out loud.
Independent practice
- Complete a 10-question Computational Tools quiz in practice mode.
- Classify every miss by error category.
- Re-test the missed subtopic within 48 hours.
Summary
- $ locks a reference.
- Verification is correctness of solution; validation is correctness of model.
- Always hand-check at least one case.
Capstone application: Spreadsheet and model verification in your calculation package.