G7307100 Basic Business Data Processing

Hiroshima University Syllabus

Japanese

Academic Year 2024Year School/Graduate School School of Economics Economics Evening Course

Lecture Code G7307100 Subject Classification Specialized Education

Subject Name 基礎情報処理

Subject Name
（Katakana）キソジョウホウショリ

Subject Name in
English Basic Business Data Processing

Instructor TOKUDA MISATO

Instructor
(Katakana) トクダ　ミサト

Campus Higashi-Senda Semester/Term 2nd-Year, Second Semester, Second Semester

Days, Periods, and Classrooms (2nd) Fri13-14：Higashi-Senda Lecture Rm M301

Lesson Style Lecture Lesson Style
(More Details) 　

Credits 2.0 Class Hours/Week 　 Language of Instruction J : Japanese

Course Level 2 : Undergraduate Low-Intermediate

Course Area（Area） 24 : Social Sciences

Course Area（Discipline） 04 : Management

Eligible Students

Keywords

Special Subject for Teacher Education 　 Special Subject 　

Class Status
within Educational
Program
(Applicable only to targeted subjects for undergraduate students)
Criterion referenced
Evaluation
(Applicable only to targeted subjects for undergraduate students) Economics and Management
（Knowledge and Understanding）
・Basic knowledge of management, accounting and information technology

Class Objectives
/Class Outline Aim of this class is to acquire the basic techniques of statistic processing through the spreadsheet exercises.The software used is Microsoft Excel. By following the textbook and resume and solving examples such as numerical data processing and analysis, students will learn basic processing methods.

Class Schedule Session 1　Orientation
Session 2　Basic operation of Excel：Data entry/correction, file saving, insert/delete columns and rows
Session 3　Data Processing (1) : Sorting, Filtering
Session 4　Data Processing (2) : Tables,Graphs
Session 5　Data Processing (3) :String processing
Session 6 　Data Processing (4) :Logical operation
Session 7 　Data Processing (5) :Use of Pivot Table
Session 8 　Fundamentals of descriptive statistics : Create frequency tables and histograms
Session 9 　Wrap up for first half
Session 10　Basic statistics : Mean, Variance, Standard deviation
Session 11　Correlation coefficient, regression line
Session 12　Probability distribution : Normal distribution and probability
Session 13　Statistical estimation : Interval estimate of the population mean
Session 14　Statistical estimation : Population mean difference test, independence test
Session 15　Wrap up for second half

Final Examination will be executed.

Text/Reference
Books,etc. Texts will be introduced in the 1st session.

PC or AV used in
Class,etc. 　

(More Details) To obtain data, access public information of prefectural offices and companies via the Internet.

Learning techniques to be incorporated 　

Suggestions on
Preparation and
Review The participants are expected to review each sessions.

Requirements Due to the nature of the class, the number of students is limited to 48. Registration will be announced on My Momiji in mid-September. If there are too many applicants, students will be selected by lottery before the first lecture.

Grading Method In order to take the final exam, the participants must attend more than 2/3 sessions.
The grade is considered 100% by the final exam.

Practical Experience Experienced

Summary of Practical Experience and Class Contents based on it The faculty who has worked in the manufacturer's business department will use the experience to give lectures on how to collect and analyze the data necessary for planning documents and reports.

Message The students will find issues in newspaper articles, consider hypotheses for them, and validate them through data processing.
This aims to increase the opportunities for the students to think about the meaning of the problem and to associate and learn the data collection and processing methods needed to solve.

Other

Please fill in the class improvement questionnaire which is carried out on all classes.
Instructors will reflect on your feedback and utilize the information for improving their teaching.

Academic Year	2024Year	School/Graduate School	School of Economics Economics Evening Course
Lecture Code	G7307100	Subject Classification	Specialized Education
Subject Name	基礎情報処理
Subject Name （Katakana）	キソジョウホウショリ
Subject Name in English	Basic Business Data Processing
Instructor	TOKUDA MISATO
Instructor (Katakana)	トクダ　ミサト
Campus	Higashi-Senda	Semester/Term	2nd-Year, Second Semester, Second Semester
Days, Periods, and Classrooms	(2nd) Fri13-14：Higashi-Senda Lecture Rm M301
Lesson Style	Lecture	Lesson Style (More Details)

Credits	2.0	Class Hours/Week		Language of Instruction	J : Japanese
Course Level	2 : Undergraduate Low-Intermediate
Course Area（Area）	24 : Social Sciences
Course Area（Discipline）	04 : Management
Eligible Students
Keywords
Special Subject for Teacher Education		Special Subject
Class Status within Educational Program (Applicable only to targeted subjects for undergraduate students)
Criterion referenced Evaluation (Applicable only to targeted subjects for undergraduate students)	Economics and Management （Knowledge and Understanding）・Basic knowledge of management, accounting and information technology
Class Objectives /Class Outline	Aim of this class is to acquire the basic techniques of statistic processing through the spreadsheet exercises.The software used is Microsoft Excel. By following the textbook and resume and solving examples such as numerical data processing and analysis, students will learn basic processing methods.
Class Schedule	Session 1　Orientation Session 2　Basic operation of Excel：Data entry/correction, file saving, insert/delete columns and rows Session 3　Data Processing (1) : Sorting, Filtering Session 4　Data Processing (2) : Tables,Graphs Session 5　Data Processing (3) :String processing Session 6 　Data Processing (4) :Logical operation Session 7 　Data Processing (5) :Use of Pivot Table Session 8 　Fundamentals of descriptive statistics : Create frequency tables and histograms Session 9 　Wrap up for first half Session 10　Basic statistics : Mean, Variance, Standard deviation Session 11　Correlation coefficient, regression line Session 12　Probability distribution : Normal distribution and probability Session 13　Statistical estimation : Interval estimate of the population mean Session 14　Statistical estimation : Population mean difference test, independence test Session 15　Wrap up for second half Final Examination will be executed.
Text/Reference Books,etc.	Texts will be introduced in the 1st session.
PC or AV used in Class,etc.
(More Details)	To obtain data, access public information of prefectural offices and companies via the Internet.
Learning techniques to be incorporated
Suggestions on Preparation and Review	The participants are expected to review each sessions.
Requirements	Due to the nature of the class, the number of students is limited to 48. Registration will be announced on My Momiji in mid-September. If there are too many applicants, students will be selected by lottery before the first lecture.
Grading Method	In order to take the final exam, the participants must attend more than 2/3 sessions. The grade is considered 100% by the final exam.
Practical Experience	Experienced
Summary of Practical Experience and Class Contents based on it	The faculty who has worked in the manufacturer's business department will use the experience to give lectures on how to collect and analyze the data necessary for planning documents and reports.
Message	The students will find issues in newspaper articles, consider hypotheses for them, and validate them through data processing. This aims to increase the opportunities for the students to think about the meaning of the problem and to associate and learn the data collection and processing methods needed to solve.
Other
Please fill in the class improvement questionnaire which is carried out on all classes. Instructors will reflect on your feedback and utilize the information for improving their teaching.

Back to syllabus main page