Applications of spreadsheet software to facilitate engineering tasks: its interface; math functions; cell references; worksheet formatting; data visualisation; text functions, logical functions; lookup functions; statistical analysis; pivot table; goal seek and optimisation; introducing to macro VBA.
Learning Outcomes
-
Identify science and mathematics topics that can be used to solve a given problem.
-
Formulate mathematical models for a given problem.
-
Solve problems relate to science and mathematics using formulas and functions of spreadsheet software.
-
Visualise data by using spreadsheet software to create and modify charts and graphics.
-
Apply spreadsheet applications in various situations.
- อาจารย์: M6601096 ตะลันต์ นามวงศ์กา
- อาจารย์: ผศ. ดร.วรรณวนัช บุ่งสุด