Transcript Lecture1x - Krisada Chaiyasarn

วธ. 498 การใช้โปรแกรมคอมพิวเตอร์ทวั่ ไปในการ
แก้ปํญหาพื้นฐานทางวิศวกรรม
DE 498 Introduction to Computing Tools in
Solving Engineering Problems
By
Dr. Krisada Chaiyasarn
Krisada Chaiyasarn
Education
BA/MA (Civil Engineering), University of Cambridge
MEng (Civil Engineering), University of Cambridge
PhD (Civil and Information Engineering), University of Cambridge
Work Experience
J.P.Morgan, IB Technology, Electronic Market Maker Developer
Ministry of Mobility and Public Works Belgium/Cambridge University, Engineering
Consultant
ITM Soil/Cambridge University, Engineering Consultant
Phusis Ltd./Rolls-Royce, Engineering Data Analyst
CE489 Introduction to Computing Tools in Civil Engineering
Outline
• Why this course is important?
• Some examples of uses in Civil Engineering
• Excel and capabilities
• Class agreement
• Excel Anatomy
CE489 Introduction to Computing Tools in Civil Engineering
Why?
• Improve work efficiency, e.g. shortcuts, macro, proper used of
functionalities
• Required skills in professional careers
• Enhance job opportunities in today’s job market
• Great tools for data analysis and mining (used widely in amazon,
google, retail), and charting, useful for business owners
CE489 Introduction to Computing Tools in Civil Engineering
Transferable vs. non-transferable skills
Technical skills
- E.g. structural design, foundation design, reinforced concrete design,
etc.
- E.g. CAD, Autodesk, programming libraries, SAP, ABACUS, FEMLAB,
etc.
Transferable skills
- E.g. organisation, leadership, presentation, writing, timemanagement, languages, etc.
- Generic computing skills, Matlab, MS office, programming
CE489 Introduction to Computing Tools in Civil Engineering
Job opportunities
- Sought after skills
- Back up with evidence
- Useful for interviews
- Progress faster
- Multiple use, e.g. financial
modelling, financial planning,
project management, cost
analysis, etc.
- Required skills in most
corporates.
CE489 Introduction to Computing Tools in Civil Engineering
Structural analysis
- Use widely for structural analysis,
e.g. calculating forces and
moments and dimensions for
structural components
-
Use in Eurocode
- E.g. Load takedown for column in
tall buildings
- Tumcivil.com
CE489 Introduction to Computing Tools in Civil Engineering
Geotechnical Engineering
-
Calculate the size of slap foundation
-
Depend of the size of ground stiffness
-
Relation to concrete stiffness and soil properties, many dependency, different worksheet used for data
CE489 Introduction to Computing Tools in Civil Engineering
and calculation
Water engineering
- Design retaining wall, e.g. Dam
- Amount of required soil and
concreted, dependency include
water pressure
- Can vary different parameters for
optimal design
- Possible for diagrams
- Parametric testings
CE489 Introduction to Computing Tools in Civil Engineering
Construction Management
-
Gantt chart for project management
-
Good to manage subtasks with many sub-contractors
-
Monitor project progress
CE489 Introduction to Computing Tools in Civil Engineering
Data Analysis
• Analyse large amount of data
• Perform repeated calculations
• Regression, can fit multiple models with errors analysis
• Many bar charts and charts types available
• Template used for new data
• E.g. BOTDR example
CE489 Introduction to Computing Tools in Civil Engineering
Modelling
CE489 Introduction to Computing Tools in Civil Engineering
Data Organisation
• Pivot Table
• Project Life cycle cost analysis
• Separate calculation to data
• Organize to different categories
• Easy to analyse where the costs occurs
CE489 Introduction to Computing Tools in Civil Engineering
Others
• Scenario analysis
• Project management, e.g. time tracking, etc.
• Use as database, record data and link them, although Database tools,
such as SQL or Access have advantages
• Diagram or flow chart, but Visio is better
CE489 Introduction to Computing Tools in Civil Engineering
Data Presentation
Source www.informationisbeautiful.net
- Present large data in more visually interesting
- Easy to understand and analyse
- Capture audience attention, great for PR
CE489 Introduction to Computing Tools in Civil Engineering
Course outline
Introduction to Excel and basic functionalities
Advance functionalities
Data Analysis
Graph design and plotting
Macro and VBA
Modelling and Using Solver
CE489 Introduction to Computing Tools in Civil Engineering
Tools
• Excel 2013
• Maltab
• Words
• Power Points
• Labtop
CE489 Introduction to Computing Tools in Civil Engineering
Assessment
• Class assessment 15%
• Mid-term 20%
• Final 30%
• Project 35%
CE489 Introduction to Computing Tools in Civil Engineering
Classroom etiquette
• No mobile or communication devices
• No talking, or causing disturbance in a class
• Late no more than 15 mins
CE489 Introduction to Computing Tools in Civil Engineering
Excel Anatomy
name
ribbon
Work sheet
Quick access tool bar
Formula bar
Cell
CE489 Introduction to Computing Tools in Civil Engineering