Information Processing I

Course Information

College Akashi College Year 2023
Course Title Information Processing I
Course Code 5226 Course Category Specialized / Compulsory
Class Format Lecture Credits Academic Credit: 2
Department Civil Engineering Student Grade 2nd
Term Second Semester Classes per Week 2
Textbook and/or Teaching Materials
Instructor WATANABE Moriyoshi

Course Objectives

1) Can do description statistics such as data aggregation and visualization.
2) Can predictive statistics such as predictive analysis by regression analysis of data.
3) Can collect and analyze open data and summarize it as a report.

Rubric

Ideal LevelStandard LevelUnacceptable Level
Achievement 1Can do description statistics such as data aggregation and visualization to purpose.Can do description statistics such as data aggregation and visualizationCannot do description statistics such as data aggregation and visualization
Achievement 2Can predictive statistics to purpose such as predictive analysis by regression analysis of data to purpose.Can predictive statistics such as predictive analysis by regression analysis of dataCannot predictive statistics such as predictive analysis by regression analysis of data
Achievement 3Can collect and analyze to purpose open data and summarize it as a report to purpose.Can collect and analyze open data and summarize it as a reportCannot collect and analyze open data and summarize it as a report

Assigned Department Objectives

Teaching Method

Outline:
In this course, students will learn the basic knowledge and skills necessary to create reports and scientific and technical documents through exercises using software documents, spreadsheets, and presentations.
Style:
Classes will be mainly conducted through exercises using slides and e-learning portals on a PC in the computer lab.
Notice:
This course's content will amount to 90 hours of study in total. These hours include the learning time guaranteed in classes and the standard self-study time required for pre-study / review, and completing assignment reports.
Students who miss 1/3 or more of classes will not be eligible for evaluation.

Characteristics of Class / Division in Learning

Active Learning
Aided by ICT
Applicable to Remote Class
Instructor Professionally Experienced

Course Plan

Theme Goals
2nd Semester
3rd Quarter
1st Class guidance and basic computer operation Determine the level of understanding for information ethics and information security. Can explain the objectives of the course and perform basic computer operation.
2nd Basic operation of spreadsheet software Can perform basic operation of spreadsheet software. and exercises.
3rd Discription Statistics 1 Data feature extraction Can calculate averages, medians, etc used Excel functions
4th Discription Statistics 2 Data visualization Can create graphs used Execl.
5th Conditional branch instruction Can perform calculations using conditional branch instructions.
6th Survey data result organization and visualization 1 Leveling survey results can be organized and graphed using spreadsheet software.
7th Survey data result organization and visualization 2 Leveling survey results can be organized and graphed using spreadsheet software.
8th Estimation statistics 1 Feature extraction oftwo-variable data Understand how to extract features between two-variable data
4th Quarter
9th Estimation statistics 2 correlation coefficient Correlation coefficient of two-variable data can be performed.
10th Estimation statistics 3 regression analysis Regression analysis of two-variable data can be performed.
11th Use of Open Data Acquire appropriate open data for the task and summarize it in spreadsheet software.
12th Analysis of Open Data Analyze the data obtained to achieve the purpose of the task using the learned knowledge.
13th Preparation of presentation materials Can create presentation materials to achieve purpose.
14th Presentation 1 Can presentation to achieve purpose.
15th Presentation 2 Can presentation to achieve purpose.
16th

Evaluation Method and Weight (%)

ExercisePresentationsPresentationsAttitudePortfolioOtherTotal
Subtotal80200000100
Basic Proficiency0000000
Specialized Proficiency80200000100
Cross-Disciplinary Proficiency0000000