Practice in Data Processing I
| Numbering Code | U-AGR03 2C211 PJ83 | Year/Term | 2022 ・ First semester | |
|---|---|---|---|---|
| Number of Credits | 2 | Course Type | Seminar | |
| Target Year | 2nd year students | Target Student | ||
| Language | Japanese | Day/Period | Thu.3・4 | |
| Instructor name |
HAMA TAKEHIDE (Graduate School of Agriculture Associate Professor) KIYAMA SHIYOUICHI (Graduate School of Agriculture Assistant Professor) |
|||
| Outline and Purpose of the Course |
Learning how to use computers (personal computers) necessary for learning about regional environmental engineering. Understanding language for programming (Fortran and VBA) and acquiring data processing techniques using Excel. |
|||
| Course Goals |
Learning basic concepts and methods of programming by using Fortran language, Excel macro function (VBA). Understanding fundamental statistical processing of data using Excel. |
|||
| Schedule and Contents |
Lectures and exercises are performed according to the following plan. 1. Outline of the exercise and basic matters on computer use (Kiyama, Nakamura) 2. Fortran's fundamentals (basic matters of Fortran) (Kiyama) 3. Basic Exercise (1) (procedure of writing programs, subroutines, operation of input / output files) 4. Basic Exercise (2) (IF statement, built-in function) (Kiyama) 5. Foundation of numerical calculation method (outline of numerical calculation, various calculation methods using computer) (Kiyama) 6. Numerical calculation exercise (1) (iterative method by successive substitution method, Newton-Raphson method) (Kiyama) 7.-8. Numerical calculation exercise (2) (numerical integration method, difference method) (Kiyama) 9. Numerical calculation exercise (3) (simultaneous linear equations) (Kiyama) 10. Fundamentals of Excel (basic usage of Excel) (Nakamura) 11. Exercise using Excel (1) (calculation using macro function (VBA)) (Nakamura) 12.-14. Exercises using Excel (2) (statistical method, histogram, average, variance, correlation, regression analysis, estimation, test, analysis of variance) (Nakamura) 15. Feedback: Accept and respond to questions from students (Kiyama, Nakamura) |
|||
| Evaluation Methods and Policy |
Evaluation will be based on active participation (20 points) and report for each subject (80 point). Refer to current year's 'Guide to Degree Programs' for attainment levels of evaluation. |
|||
| Course Requirements | It is a premise that there is basic knowledge on the usage of personal computer. | |||
| Study outside of Class (preparation and review) | It is necessary to energetically work on report preparation outside the class. It is important not to leave unknown points for mastering programming, so be careful not to be absent because you will not be able to follow from the next time. You have to ask questions for unclear points to teachers or teaching assistant students. Be sure to write reports by yourself. | |||
| Textbooks | Textbooks/References | Handouts and files are distributed. | ||
