Course title
エネルギーシステム解析特論I   [Energy Systems Analysis I]
Course category courses for the 5-years doctral program  Requirement   Credit 1 
Department   Year   Semester 3rd 
Course type 3rd  Course code 231005
Instructor(s)
秋澤 淳   [AKISAWA Atsushi]
Facility affiliation Graduate School of Bio-Applications and Systems Engineering Office afjgxte/L1151  Email address

Course description
This course provides lectures on model analysis with optimization as well as exercises to implement optimization analysis using Excel.
Expected Learning
Understanding how to formulate optimization problems and to solve them on Excel.
Corresponding criteria in the Diploma Policy:
See the Curriculum maps.
Course schedule
No.1 Optimization model
No.2 How to use Excel solver
No.3 Defining case study for optimization
No.4 Group work to formulate the case
No.5 Exercise: Curve fitting
No.6 Group work to solve the problem
No.7 Group work to discuss the solution
No.8 Presentation
Prerequisites
Capability to use Excel
Required Text(s) and Materials
None
References
Fujita Katsuyasu, Exercises of OR using Excel, Nikkagiren, 2002.
Assessment/Grading
Report: 20%, Presentation: 80%.
Message from instructor(s)
Optimization is useful not only for engineering but also for agriculture. Excel is an easy way to implement optimization.
Course keywords
Model, Optimization, Linear Programming, Excel solver
Office hours
Friday 12:00-13:00
Remarks 1
Remarks 2
Related URL
Lecture Language
Japanese
Language Subject
Last update
1/30/2020 4:56:06 PM