11  Working with Data: Spreadsheets and Python

Week 11 Planned, awaiting draft

ImportantLearning objectives (tentative)

By the end of this week you should be able to:

1. Build a well-structured engineering spreadsheet.
2. Load, clean, and summarize a dataset in Python.

NoteComing soon

These lecture notes will be written from the instructor’s Week 11 draft. The topics below are a working outline.

11.1 Planned topics

• Organizing engineering data
• Spreadsheet formulas, references, and pivot tables
• Python, pandas, and Colab for data analytics
• Cleaning and validating data

NoteKey terms in this chapter

• Data analytics — Examining data to find patterns, draw conclusions, and support decisions.