Module 7: Spreadsheets, Tables, and Engineering Data - Worked Examples

Agentic Engineering For Civil Engineers

These examples use AI as a data-analysis assistant while protecting source data, formulas, units, identifiers, and reproducibility.

Auditing a CSV Before Analysis

For this exercise, design and verify an AI-assisted civil-engineering workflow for Auditing a CSV Before Analysis. State the relevant evidence, assumptions, tool or method boundaries, expected output, and the independent check or human approval required before consequential use.

Step-by-Step Solution

0 of 3 Steps Completed
1

Spreadsheet Formula Audit

For this exercise, design and verify an AI-assisted civil-engineering workflow for Spreadsheet Formula Audit. State the relevant evidence, assumptions, tool or method boundaries, expected output, and the independent check or human approval required before consequential use.

Step-by-Step Solution

0 of 3 Steps Completed
1

Reconciling Summary Totals

For this exercise, design and verify an AI-assisted civil-engineering workflow for Reconciling Summary Totals. State the relevant evidence, assumptions, tool or method boundaries, expected output, and the independent check or human approval required before consequential use.

Step-by-Step Solution

0 of 3 Steps Completed
1

Detecting Outliers Without Deleting Them

For this exercise, design and verify an AI-assisted civil-engineering workflow for Detecting Outliers Without Deleting Them. State the relevant evidence, assumptions, tool or method boundaries, expected output, and the independent check or human approval required before consequential use.

Step-by-Step Solution

0 of 3 Steps Completed
1

Creating a Reproducible Chart

For this exercise, design and verify an AI-assisted civil-engineering workflow for Creating a Reproducible Chart. State the relevant evidence, assumptions, tool or method boundaries, expected output, and the independent check or human approval required before consequential use.

Step-by-Step Solution

0 of 3 Steps Completed
1

Converting a Table into a Controlled Template

For this exercise, design and verify an AI-assisted civil-engineering workflow for Converting a Table into a Controlled Template. State the relevant evidence, assumptions, tool or method boundaries, expected output, and the independent check or human approval required before consequential use.

Step-by-Step Solution

0 of 3 Steps Completed
1

Generating a Data Validation Script

For this exercise, design and verify an AI-assisted civil-engineering workflow for Generating a Data Validation Script. State the relevant evidence, assumptions, tool or method boundaries, expected output, and the independent check or human approval required before consequential use.

Step-by-Step Solution

0 of 3 Steps Completed
1

Building an Engineering Data Audit Trail

For this exercise, design and verify an AI-assisted civil-engineering workflow for Building an Engineering Data Audit Trail. State the relevant evidence, assumptions, tool or method boundaries, expected output, and the independent check or human approval required before consequential use.

Step-by-Step Solution

0 of 3 Steps Completed
1