Jupyter Sandbox for Civil Engineering: Toward a Sustainable World#
This book is a curated sandbox of nearly 75 interactive tools developed from years of classroom experience and academic exploration. Designed for undergraduate civil and environmental engineering students, it empowers learners to experiment with model sensitivity, estimate design parameters, and deepen their understanding of sustainability, water systems, geotech, and coastal engineering. Whether you’re just starting out or refining your expertise, this resource invites you to explore, simulate, and design with purpose.
Introduction to Environmental Engineering
Engineering Hydrology
Pipe and open channel Hydraulics
Geotechnical Engineering and Labs
Ocean and Coastal Engineering
Sustainable Engineering
Remote pilot and Drone
Computer Science and Numerical methods
🙌 Acknowledgments Special thanks to Civil and Environmental Engineering, College of Engineering UNO, mentors, colleagues, and students whose questions and insights inspired the structure and content of this book. Collaborative knowledge-building is the force behind every page.
🎯 Mission Statement: Our mission is to make complex engineering systems clear, accessible, and actionable. We believe good design begins with deep understanding—and that learning should be as dynamic and applied as the challenges we aim to solve. Dive in, experiment, and discover how thoughtful engineering can shape a more sustainable world.
Check out the content pages bundled with this sample book to see more.
- 1.0 Biochemical Oxygen Demand (BOD) Modeling
- 1.1 Stream Water Quality – Streeter-Phelps Model
- 1.2 Chemical Reactor Performance and Design
- 1.3 Lake Water Quality
- 1.4 Stream Water Quality – Sediment and Nutrient
- 1.5 Air Quality – Indoor Air Quality based on CSTR
- 1.6 Air Quality – Gaussian Plume Dispersion
- 2.0 SpatioTemporal Disaggregation of Rainfall/Runoff
- 2.1 Rainfall Frequency & Runoff Estimation (NOAA, SCS-CN, Rational)
- 2.2 Drought Indices and Analysis
- 2.3 Soil Hydrology – Infiltration
- 2.4 Extreme Value Distribution and Model Selection
- 2.5 Eco-Hydraulics - Habitat Suitabiltiy Index
- 2.6 Groundwater Hydrology - Aquifer
- 2.7 Sediment erosion
- 3.0 Pipe Hydraulics – Design
- 3.1 Open Channel Hydraulics – Normal & Critical Flow
- 3.2 Gradually Varied Flow – Standard and DirectStep
- 3.3 RiverHydraulics – Normal & Critical Flow
- 3.4 Structure – Seepage Analysis
- 3.5 Flow Over Broad-Crested Weirs
- 3.6 Weir Notches and Discharge Relationships
- 3.7 Structure – Energy Dissipator
- 3.8 Culvert Design Principles and Calculations
- Chapter 3 Hydraulics: Hydraulic Pumps
- 📐 Pump curve generator (simplified characteristic shapes)
- 📊 Plot curves
- 🎛️ Interactive Controls
- 3.10 Design of Stromwater Drain
- 3.11 Channel Design- Rigid and Mobile
- 3.12 Structure - Gravity Dam
- 3.13 Structure - Arch Dam
- 4.0 USCS Soil Classification Toolkit
- 4.1 Particle Size Distribution – Lab Tool
- 4.2 Atterberts limts test – Lab Tool
- 4.3 Lab and Field Density test – Lab Tool
- 4.4 Soil permeability test – Lab Tool
- 4.5 Soil Strength Triaxial Test – Lab Tool
- 4.6 1D Consolidation – Lab Tool
- 4.7 1D Consolidation Analysis
- 4.8 Foundation Design Essentials
- 4.9 Deep Foundation Design- Piles
- 4.10 Retaining wall Design
- 4.11 Slope Stability Analysis
- 5.0 Wave Kinematics – Airy Wave Theory
- 5.1 Wave Kinematics – Nonlinear Wave Theory
- 5.2 Coastal Waves – Breaking waves
- 5.3 Coastal Waves- Transformation I
- 5.4 Coastal Waves- Transformation II
- 5.5 Coastal Waves - Oscillation
- 5.6 Coastal Wave- Wind wave
- 5.7 Wave Analysis – Tidal Waves
- 5.8 Sediment Transport – Longshore
- 5.9 Sediment Transport - Crossshore Transport
- 5.10 Sediment Transport – Beach Profile
- 5.11 Empirical Wave Run-Up Estimation
- 5.12 Depth of Closure – Multimodel Estimation
- 5.13 Sea Level Rise and Variability
- 5.14 Coastal Structures – Breakwater Design
- 5.15 Coastal Structure - Detached Breakwater
- 5.16 Coastal Structure – Non-Breakwaves
- 5.17 Coastal Structure – Breaking Waves
- 5.18 Pile Force Estimation – Morrison Equation
- 6.0 Engineering Sustainabilty - Watersupply
- 6.1 Engineering Sustainabilty- Landscapewater
- 6.2 Engineering Sustainabilty- Stormwater
- 6.3 Engineering Sustainabilty- Carbon Emission
- 6.5 Potential Evapotranspiration
- 6.6 Solar Energy and Building Orientation
- 6.8 Window Transmittance Analysis
- 6.9 Engineering Sustainabilty- Concrete
- 6.10 Engineering Sustainabilty- Foundation
- 6.11 Engineering Sustainabilty - LCA Analysis
- 6.12 Environmental Sustainability - Biogeochemical Cycles
- 6.13 Environmental Sustainability - Carbonate Cycle
- 6.14 Environmental Sustainability- Renewal Energy
- 7.0 Remote Pilot and Drone- Components
- 7.1 Remote Pilot and Drone- Flight performance
- 7.2 Remote Pilot and Drone- GIS
- 7.3 Remote Pilot and Drone- Remote Sensing
- 7.4 Remote Pilot and Drone- Photogrammetry
- 7.5 Remote Pilot and Drone- Part 107 Test
- 🔢 Number Systems Overview
- 🌍 Types of Number Systems
- 🧠 Key Differences
- 📘 Summary Table
- 🔄 Interactive Number System Converter
- 🧠 What It Does
- ⚙️ How It Works
- ✅ Example
- 💻 Basics of Computer Information Systems
- 🧩 Components of Computer Information Systems
- 🌟 Importance of CIS
- ⚠️ Challenges in CIS
- 🚀 Opportunities in CIS
- 📘 Summary Table
- 🧠 Programming Language Comparison
- Overview Table
- 📌 Use Cases by Domain
- Java
- python
- python
- C++
- 📚 Classic Data Structures: Definitions, Diagrams, and Trade-offs
- 🧮 Array
- 🧱 Stack
- 🚦 Queue
- 🔗 Linked List
- 🌳 Tree
- 🌐 Graph
- 🔍 Visualization Tools
- 📊 Comparison of Classic Data Structures
- 🧮 Sorting Algorithms: Concepts, Comparisons, and Curiosities
- 📚 Overview of Common Sorting Algorithms
- 🧠 Conceptual Questions
- 📝 Mini Quiz
- 🎉 Fun Facts About Sorting
- 🔍 Reflection Prompt
- 🔍 Search Algorithms in Computer Science
- 🧠 What Is a Search Algorithm?
- 📂 Types of Search Algorithms
- 🔄 Searching vs Sorting
- 🧠 Conceptual Questions
- 📝 Mini Quiz
- 🎉 Fun Facts About Searching
- 🔍 Reflection Prompt
- 🔌 Logic Gates Overview
- 🧠 Types of Logic Gates
- 📘 Summary Table
- SQL command
- SQL Lite
- 🧠 Database Administration Learning Module
- 📘 What Is Database Administration?
- 🧰 Core DBA Responsibilities
- 🧮 Essential SQL Commands for DBAs
- 🧪 Suggested Practice Activities
- 📚 Recommended Resources
- 🛡️ Cybersecurity Fundamentals Learning Module
- 📘 What Is Cybersecurity?
- 🧱 Core Components of Cybersecurity
- 🔐 Common Cybersecurity Algorithms
- 🔄 Cybersecurity Lifecycle Steps
- 👨💼 Cybersecurity Roles & Responsibilities
- 🧠 Skills Needed for Cybersecurity Success
- 🌐 Computer Networks: Overview and Analysis
- 1️⃣ What Is a Computer Network?
- 2️⃣ Types of Computer Networks
- 3️⃣ Comparison of Network Protocols
- 4️⃣ Tools and Skills for Network Analysis
- 🛠️ Tools
- 🧠 Skills
- 📘 Summary Table
- 1. Protocol Simulation: Simulate how different protocols behave (e.g., TCP vs. UDP):
- IP Address and Subnet Calculaton: Students input IP and subnet mask to compute network details:
- 3. OSI Model Explorer: Interactive dropdown to explore each OSI layer:
- 📊 Sampling and Descriptive Statistics
- 🎯 Population vs. Sample Statistics
- 🧪 Sampling Methods
- 📈 Descriptive Statistics
- 📊 Comparison of Mean Types
- ✅ Summary
- ⚖️ Types of Weighted Means: Concepts, Applications, and Limitations
- 📐 What Is a Weighted Mean?
- 🧮 Types of Weighted Means
- 🔍 Detailed Descriptions
- ⚠️ Summary of Limitations
- ✅ Choosing the Right Mean
- 📏 Goodness-of-Fit Measures: Overview and Interpretation
- 🔢 Common Goodness-of-Fit Metrics
- 📘 Interpretation Guidelines
- 🧪 Use Cases
- ⚠️ Limitations
- 🎲 Understanding Probability and Its Role in Risk Assessment
- 📘 What Is Probability?
- 🔍 Why Is Probability Important?
- ⚖️ Probability in Risk Assessment
- 🧪 Example: Geotechnical Risk
- 📊 Key Probability Concepts
- 🎯 Interactive Simulation: Empirical Probability and Return Period
- 🔍 What the Code Does
- 📈 Visualization
- 🧪 Applications
- ⚙️ Interactive Controls
- 📊 Example Use Case
- 📊 Using Theoretical Distributions in Risk and Probability Analysis
- 📘 Why Use Theoretical Distributions?
- 📐 Common Theoretical Distributions
- ⚖️ Application in Risk Assessment
- 🧪 Example: Flood Risk Using Gumbel Distribution
- 🧠 Key Takeaways
- Distribution fitting and goodness of fit
- 🧠 ETL: Extract, Transform, Load – Foundation of Data-Driven Intelligence
- 1️⃣ What is ETL?
- 2️⃣ Why is ETL Important for Business Intelligence?
- 3️⃣ How Does ETL Work?
- 4️⃣ What is Data Extraction?
- 5️⃣ Methods of Data Extraction
- 6️⃣ What is Data Transformation?
- 7️⃣ What is Data Loading?
- 8️⃣ Challenges in ETL
- 9️⃣ Tools & Commands to Master ETL
- 🔍 Summary
- 🔄 Data Normalization Summary
- 🧪 ETL Simulation: Cleaning → Aggregation → Derivation
- 📦 Components
- 🎯 Dataset Features
- 🧼 Cleaning Options
- 📊 Aggregation
- 🧮 Derivation
- 🧠 Learning Objectives
- 🧠 ETL for Business Intelligence — Quiz
- 📥 Extraction
- 🔧 Transformation
- 📦 Load
- 🧩 Reflection
- 🧠 Data Modeling: Concepts and Types
- 📐 Key Aspects of Data Modeling
- 🧩 Types of Data Models
- 📊 Data Model Types: Summary of Strengths, Weaknesses, and Applicability
- 📊 BI Context: Dimensional Modeling
- 📊 Fact Tables, Dimension Tables, and Schema Design in BI
- 🧮 Fact Table
- 🔹 Example:
SalesFact
- 🧾 Dimension Tables
- 🔹 Example:
ProductDim
- 🔹 Example:
CustomerDim
- 🔹 Example:
DateDim
- ⭐ Star Schema
- 🔹 Structure
- ❄️ Snowflake Schema
- 🔹 Structure
- ⭐ Star Schema vs ❄️ Snowflake Schema
- 🧠 Reflection Questions
- 🧩 Interactive Schema Explorer Overview
- 📊 Power BI Visual Types & Applications
- 🧠 Tips for Choosing Visuals
- Based on Eazybi
- 📊 Chart Type Selector: A Decision Guide for Effective Data Visualization
- 🎯 Step 1: What is your presentation goal?
- 🔢 Step 2: How many variables are you showing?
- 🔁 Step 3: Are you showing data over time?
- 👥 Step 4: Are you comparing groups or categories?
- 🧠 Chart Type Selection Rules
- 🧪 Example Prompts
- 📘 DAX Function Reference Table
- 🔢 Aggregation & Math
- 📅 Date & Time
- ⏱️ Time Intelligence
- 🔍 Logical & Conditional
- 🧹 Filter & Context
- 🔗 Relationships & Tables
- 🔤 Text & Formatting