IGESS (Institute for Global Economics and Social Sciences)

Back to List

PRI100CB(情報学基礎 / Principles of informatics 100)
Basic Computer Skills A

Yasushi KANBAYASHI

Class code etc
Faculty/Graduate school IGESS (Institute for Global Economics and Social Sciences)
Attached documents
Year 2023
Class code A9618
Previous Class code
Previous Class title
Term 秋学期授業/Fall
Day/Period 月5/Mon.5
Class Type
Campus 市ヶ谷 / Ichigaya
Classroom name オンライン/online
Grade 1~4
Credit(s) 2
Notes
Open Program
Open Program (Notes)
Global Open Program
Interdepartmental class taking system for Academic Achievers
Interdepartmental class taking system for Academic Achievers (Notes)
Class taught by instructors with practical experience
SDGs CP
Urban Design CP
Diversity CP
Learning for the Future CP
Carbon Neutral CP
Chiyoda Campus Consortium
Category General Education Courses/総合教育科目
Information Technology/情報学分野
Faculty Sponsored Department IGESS

Show all

Hide All

Outline and objectives

This course is about understanding how computers work and how to use them for academic developments. We also see how the computer technology will impact society and the workplace from both short-term and long-term points of view. There will be some exercises involving the use of office productivity software and computer programming. We will also follow current news and discuss developments as they occur.

Goal

Students be able to use spreadsheet for statistical work, word processing software for preparing academic papers. After this course, students can manipulate statistical data and extract meaningful information from them, and then express the information as academic papers.

Which item of the diploma policy will be obtained by taking this class?

IGESS Dipromapolicy DP2/DP9

Default language used in class

英語 / English

Method(s)(学期の途中で変更になる場合には、別途提示します。 /If the Method(s) is changed, we will announce the details of any changes. )

Demonstrations will be given of the use of software in class. Students are encouraged to try to perform the same tasks on their own computers. There will also be regular assignments, some to allow students to demonstrate that they can complete selected tasks and some involving essays on developments in computer technology. Homework assignments are to be submitted in the Hoppii system. Individual written feedback will be provided as appropriate, and general comments regarding the homework submissions will be made in class.

Active learning in class (Group discussion, Debate.etc.)

あり / Yes

Fieldwork in class

なし / No

Schedule

授業形態/methods of teaching:オンライン/online

※各回の授業形態は予定です。教員の指示に従ってください。

1[オンライン/online]:An introduction to computing

Introduction to the basic structure of computers. Input, storage, processing and output are explained.

2[オンライン/online]:The history of computers

A survey of the development of the concept of computing and computing machines.

3[オンライン/online]:Word processing 1

The way of document formatting is explained.

4[オンライン/online]:Word processing 2

The way of collaborative work with plural authors is explained.

5[オンライン/online]:Spreadsheet calculations 1

Introduction to Excel, and how to use it is given.

6[オンライン/online]:Spreadsheet calculations 2

Calculation of sum of table and ratio is given.

7[オンライン/online]:Spreadsheet calculations 3

The way of making graphs is explained.

8[オンライン/online]:Spreadsheet calculations 4

The way of inputting a large dataset is explained.

9[オンライン/online]:Spreadsheet calculations 5

The way of sorting data and matching criteria is explained.

10[オンライン/online]:Spreadsheet calculations 6

The way of analyzing data of one variable using the frequency table is explained.

11[オンライン/online]:Spreadsheet calculations 7

The way of location and obtaining scatter sales of the distribution of variables is explained.

12[オンライン/online]:Spreadsheet calculations 8

The way of analyzing two-dimensional data is explained.

13[オンライン/online]:Spreadsheet calculations 9

The way of using macros and user defined functions is explained.

14[オンライン/online]:Spreadsheet calculations 10

The way of using probability and random numbers is explained.

Work to be done outside of class (preparation, etc.)

No preliminary preparation for the class is required. The standard preparation and review time for this class is 2 hours each.

Textbooks

Kazumitsu Nawata, "Introduction to Statistics Using Excel" Asakura Publishing, 2021.
Additional materials will be given in the class.

References

Recommended references will be recommended in the class.

Grading criteria

Regular assignments (70%) and class participation of discussions (30%).

Changes following student comments

Classes will be discussion-based, so students can give immediate feedback during class. Teaching will be conducted in a flexible manner, taking students' comments into account, and making changes where appropriate. For example, if all students are already able to use office productivity software at a high enough level, it will be possible to focus more on current news reports relating to developments in computer technology.

Equipment student needs to prepare

It is assumed that students bring a laptop computer to the class with Microsoft Office installed. The class will be organized as a remote one. Providing a Microsoft Office installed computer is students' responsibility.

Others

Please note that if the number of students attending the first class significantly exceeds expectations, in order for the instructor to effectively manage the class, the number of students who are allowed to register for the course may be limited.