Information Processing Ⅱ

Course Information

College	Gunma College	Year	2024
Course Title	Information Processing Ⅱ
Course Code	3K011	Course Category	Specialized / Compulsory
Class Format	Lecture	Credits	Academic Credit: 2
Department	物質工学科	Student Grade	3rd
Term	First Semester	Classes per Week	2
Textbook and/or Teaching Materials	Handouts will be distributed in each class.
Instructor	NKAJIMA Satoshi

Course Objectives

□ Able to understand the algorithm suitable for computer calculation to achieve a certain purpose.
□ Able to express the algorithm for a certain purpose in the form of program source using Decimal BASIC as a programming language.
□ Able to understand how variables are changed when executing a program source.
□ Able to use Excel to make a spreadsheet according to a certain purpose.
□ Able to understand the correspondence between repetitive calculations in Decimal BASIC and spreadsheets in Excel.
□ Able to output the results of calculations and graphs as intended by using Decimal BASIC and Excel.
□ Learn how to simulate chemistry and physics problems using Decimal BASIC and Excel, and to be able to solve simple problems.

Rubric

	Ideal Level	Standard Level	Unacceptable Level
Achievement 1	The student is able to write down his/her own algorithm suitable for computer computation to reach a certain goal.	The student can understand standard algorithms.	The student does not know the algorithm.
Achievement 2	The student can express the algorithm for the purpose in the form of a program source code.	The student can understand the program source of a basic algorithm and can write a short program source code by him/herself.	The student is unable to express even short algorithms in the form of program source code.
Achievement 3	The student can understand the roles of all variables used in the program, also paying attention to their scope.	The student is able to consider changes in key variables along the execution of the program.	The student is unable to follow changes in variables along the execution of a program.
Achievement 4	The student is able to use Excel spreadsheets with standard functions and formulas using absolute and relative cell specifications.	The student is able to perform simple Excel spreadsheets.	The student does not know how to use an Excel spreadsheet.
Achievement 5	The student is able to implement iterative calculations involving nested structures in decimal BASIC and understand their correspondence with Excel spreadsheets.	The student can implement simple repetitive calculations in decimal BASIC and understand them in terms of Excel spreadsheets.	The student is unable to implement repetitive calculations in decimal BASIC.
Achievement 6	The student is able to output calculation results and graphs as intended using both Excel and Decimal BASIC.	The student can output the desired calculation results, graphs, etc. as intended using either Excel or Decimal BASIC.	The student is unable to output the desired calculation results, graphs, etc. as intended using either Excel or Decimal BASIC.
Achievement 7	The student is able to simulate and numerically solve chemistry and physics problems by performing numerical calculations of equations and differential equations.	The student can describe methods for simulating or numerically solving chemistry and physics problems.	The student does not know the methods used to simulate or numerically solve chemistry or physics problems.

Assigned Department Objectives

準学士課程 B-3 （コンピュータリテラシーの基礎を学習し、それを簡単な工学的問題に応用できる。）

Teaching Method

Outline:

This course uses Decimal BASIC, Word, and Excel to review the following topics
Processing measurement and estimation errors
Standard use of Decimal BASIC, Word, and Excel
Creating graphs
Relationships among graphs, derivatives, and integrals
Numerical integration
Numerical solution of equations
　Bisection
　Simulation of pH and titration curves of electrolyte solutions
Numerical solution of differential equations
　Euler and Runge-Kutta methods
　Simulation of motion of an object

Style:

Classes will be conducted as practical exercises in the computer-room. Regular examinations are given in the form of written classroom tests.

Notice:

Mandatory submission of assignments in every class.

Course Plan

			Theme	Goals
1st Semester
	1st Quarter
		1st	Class Guidance How to Use a PC	How to use a PC Creating a Word template for homework submission What can be done with Excel and Decimal BASIC
		2nd	Structured programming	Algorithms Structured programming Handling of imperatives, variables, and functions in Decimal BASIC Programs and Variables Flowcharts
		3rd	Branching and Iteration Implementation	Branching with IF Statements Nested structure of branches and flowcharts Repetition and its nesting structure using FOR NEXT statements Creation of Multiplication table Confirmation of variable transition by tracing
		4th	Excel Operations	Auto-filling, relative and absolute specification of cells Variable types and cell display formats in Excel Creation of Multiplication table in Excel Conditional Formatting
		5th	Graphing	Difference between Line Charts and Scatter Plots in Excel Details of Graphing with Scatter Plots Graphing Function Formulas in Excel Notes on Excel-specific formula input, -x², etc.
		6th	Graphing	Generating Repeating Signals by Summing Fourier Series Graphing Using Decimal BASIC Overlaying Graphs Using Arrays Handling of discontinuities and conditional branching in tangent graphs
		7th	Graphing from Numerical Data	Handling of DATA statements and external files in csv format Graphing titration curves based on titration data Adding derivative curves by differential processing of numerical values Conditional branching based on the sign of the derivative value (average rate of change)
		8th	Graphing from Numerical Data	Graphing of numerical data by Excel Smoothing by interval moving average Visualization of inflection points by combining binarization with threshold values and conditional formatting
	2nd Quarter
		9th	Intermediate examinations
		10th	Relationship between graphs and equations, dichotomy	Properties of discrete numbers and their handling by computer Algorithm and scope of application of dichotomy Basics of equation solving programs using the dichotomy method
		11th	Equation Solving Simulation calculation of pH of aqueous solutions	Definition of external functions and scope of variables Properties of the evaluation equation derived from the electro-neutrality condition of ions in aqueous solution Solution of the evaluation equation by the Dichotomous method Externalization of the dichotomous solution of the evaluation equation and creation of titration curves by iteration
		12th	Statistical treatment of data containing errors	Creation of data following a normal distribution using random numbers (decimal BASIC) and analysis using Excel 　Creation of box plots and scatter plots 　Creation of histograms 　Analysis using Excel data analysis tools 　Confirmation of the meaning of confidence intervals
		13th	Solving differential equations Euler's method	General and special solutions, analytical and numerical solutions Principles of Euler's method Directional fields Simulation of oblique projection using Excel
		14th	Solution of differential equations Hoyne method (RK2), RK4	Taylor expansion of trigonometric functions and approximation by quadratic curves Comparison of Euler method, Hoyne method (RK2), and RK4 Numerical computation of second-order differential equations by Excel Simulation of cometary motion around a fixed star
		15th	Application to real data Absorption spectra and molar absorption coefficients	Graphing of Absorption Spectra of DMA Zero correction of absorption spectrum Creation of calibration curves by linear approximation and calculation of molar absorption coefficients
		16th

Evaluation Method and Weight (%)

	Examination	Presentation	Mutual Evaluations between students	Behavior	Portfolio	Other	Total
Subtotal	60	0	0	0	0	40	100
Basic Proficiency	40	0	0	0	0	10	50
Specialized Proficiency	20	0	0	0	0	20	40
Cross Area Proficiency	0	0	0	0	0	10	10