Lecturer  Eisuke KITA, Professor 

Department  Institute of Liberal Arts & Sciences, 2014 Spring & Fall 
Recommended for:  ( 1st semester ) Students in the school of Informatics and Sciences (Social and Human Science Informatics), Letters, Economics, Education and Law ( 2nd semester ) Students in the school of Informatics and Sciences (Natural Science Informatics), Engineering, Science, Medicine and Agriculture (2・1.5 hours / session 1 session / week 15 weeks / semester) 
In the first part of this course, we will be learning about the analytic algorithm of time series data using spreadsheet software. In the second part of this lecture, we will be focusing on the usage of the formula manipulation software, Mathematica. Basic usage for mathematics calculations, creation of graphs and animations, and music composition will be the main topic of our exercise problems.
This lecture is experiential learning. Therefore, Many example problems will be given in the lecture in order to make this lecture interesting. Also example problems will be realistic matters such as earning of department store or stock for your better understanding.
Main objective of this lecture is to introduce convenient usages of data analysis software and computer computation software. In the first part of the lecture, our main focus will be on the application of spreadsheet software. We will be learning about the analytic method of time series data by using least squares analysis, moving average analysis, correlated analysis and so on. In the second part of the lecture, our main focus will be on Mathematica. We will be learning how to use Mathematica for the linear algebra and calculus calculations. In addition, we will also experience some of the interesting application for making animation and composing music. The contents of the class will be different depending on the students' major and interests.
Mathematics and Information literacy are not required but deeply related to the contents of this course.
Lecture will be in the PC lab in the Integrated Research Building. Contents will be as following.
No textbooks are assigned.
This lecture is experiential learning. Therefore, exercise will be the main part of the lecture and I would like all the students to have fun in the lecture.
This course is designed for both beginner and intermediate user of Computer. Therefore this lecture consists of the basics of informatics literacy and further application of computer software on the various analyses. In the first part of the lecture, we will begin with the introduction of email and word processing software. It is because these soft wares will be the most fundamental knowledge for using Computer. Then secondly we will be learning about the method of data analysis using Excel and Mathematica. Since using Mathematica should be the first time for many students, I would like all the students to experience new software and to increase their interests and knowledge thorough experiential learning. Balance of basic materials and intermediate materials varies depending on the needs of the students. If you have any suggestion about the lecture or exercise, it is very welcome.
An Introduction to Programming with Mathematica, Third Edition (Hardcover), Paul R. Wellin, Richard J. Gaylord, Samuel N. Kamin, Cambridge University Press; 3 edition, 2005
Programming in Mathematica, Third Edition (Paperback), Roman Maeder, AddisonWesley Professional; 3 editions, 1997
Assignments are to solve the example problems given in the lecture.
Session  Contents 

1 
Guidance

2 
Basics of Excel (creating charts and figures)

3 
Least mean square approximation analysis using Excel

4 
Correlated analysis using Excel

5 
Autocorrelation analysis using Excel

6 
Difference analysis using Excel

7 
Moving Average analysis using Excel

8 
Basics of Mathematica

9 
Algebra calculations using Mathematica

10 
Linear Algebra calculations using Mathematica

11 
Calculus calculations using Mathematica

12 
Curve fitting using Mathematica

13 
Creating graphics using Mathematica

14 
Two dimensional animation using Mathematica

15 
Composing music using Mathematica

Note: All files are in Japanese.
Session #2 Basics of Excel
Session #3 Least mean square approximation analysis using Excel No.1
Session #3 Least mean square approximation analysis using Excel No. 2
Session #4 Correlated analysis using Excel
Session #5 Autocorrelation analysis using Excel
Session #6 Difference analysis using Excel
Session #7 Moving Average analysis using Excel
Session #8 Basics of Mathematica
Session #9 Algebra calculations using Mathematica
Session #10 Linear Algebra using Mathematica
Session #11 Calculus using Mathematica
Session #12 Curve fitting using Mathematica
Session #13 Graphics using Mathematica
Session #14 Two dimensional animation using Mathematica
Session #15 Composing music using Mathematica
Students will be evaluated based on your reports (65 %) and attendance (35%). You can see reports assignments given in year 2007 in lecture notes section.
January 14, 2020