| Course title | |||||
| 情報処理学 [Computer Science] | |||||
| Course category | Requirement | Credit | 2 | ||
| Department | Year | 1～ | Semester | Spring | |
| Course type | Spring | Course code | 01RN1111a | ||
| Instructor(s) | |||||
| 三宅 清 [MIYAKE Kiyoshi] | |||||
| Facility affiliation | Graduate School of Agriculture | Office | Email address | ||
| Course description |
|
"This 2-credit course provides students with a way of data processing including the use of the internet. It will address the fundamentals of information science that are part of the department of ecoregion science. The topics covered are logical analysis, program flow, permissible error and data accuracy with Excel. |
| Expected Learning |
|
Describe topics above. Create programs using Excel macro language. Create interactive systems using Excel VBA language. |
| Course schedule |
|
1 Introduction 2. Excel: use of formula, error analysis and formatting. 3. Excel: functions, graphing and creation of reports. 4. Excel: boolean equation and program flow. 5. Excel: practice 1. 6. Excel Macro programing:Macro creation using Excel function. 7. Excel Macor programing:Editing programs & execution. 8. Excel VBA Introduction of VBA 9. Excel VBA: linguistic structure and points of programing. 10. Excel VBA: variable formulas and functions. 11. Excel VBA Form function input/output. 12. Excel VBA Practices .how to make the system of surveying calculation 13. Excel VBA Practice (Pls see Moodle ). |
| Prerequisites |
| Basic mathematics, Excel and Excel VBA |
| Required Text(s) and Materials |
| References |
| Assessment/Grading |
| Practices are worth 80% of your grade and attendance records are 20%. |
| Message from instructor(s) |
| Course keywords |
| Office hours |
| Contact by e-mail |
| Remarks 1 |
| Remarks 2 |
| Related URL |
| Lecture Language |
| Japanese |
| Language Subject |
| Last update |
| 3/27/2018 6:00:42 PM |