| 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 |