TÜRKÇE
ENGLISH
Information
| Unit | FACULTY OF SCIENCE AND LETTERS |
| PSYCHOLOGY PR. | |
| Code | PSI110 |
| Name | Introduction to Information Systems |
| Term | 2020-2021 Academic Year |
| Semester | 2. Semester |
| Duration (T+A) | 2-0 (T-A) (17 Week) |
| ECTS | 4 ECTS |
| National Credit | 2 National Credit |
| Teaching Language | Türkçe |
| Level | Lisans Dersi |
| Type | Normal |
| Label | C Compulsory |
| Mode of study | Uzaktan Öğretim |
| Catalog Information Coordinator | Prof. Dr. SÜLEYMAN ÇABUK |
| Course Instructor |
Prof. Dr. SÜLEYMAN ÇABUK
(Bahar)
(A Group)
(Ins. in Charge)
Prof. Dr. MUSTAFA TOPAKSU (Bahar) (B Group) (Ins. in Charge) |
Course Goal / Objective
The aim of this course is to create spreadsheets, to analyze data using functions, to draw graphics for data groups, to gain basic skills related to database management.
Course Content
Using application programs, tabulation and presentation programs.
Course Precondition
Resources
Notes
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | To define data, information and data management systems. |
| LO02 | Makes spreadsheet applications. |
| LO03 | Use function and formula in spreadsheet |
| LO04 | Makes analysis on spreadsheet data. |
| LO05 | Visualizes data graphically. |
| LO06 | Filter and sort in spreadsheet. |
| LO07 | Create and edit macros in spreadsheet. |
| LO08 | Makes database queries. |
| LO09 | Makes presentation program applications. |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | - | Explains the main concepts, questions and issues in the field and the sub-fields of psychology. | 0 |
| PLO02 | - | Explains the concepts of scientific research methods and principles. | 3 |
| PLO03 | - | Comprehends other basic sciences (eg, sociology, biology, philosophy) related to psychology, and establishes a multidisciplinary perspective. | 1 |
| PLO04 | - | Explains the development of psychology from the historical perspective | 0 |
| PLO05 | - | Applies the knowledge of psychology for the application areas | 1 |
| PLO06 | - | Explain the ethical principles and values of psychology and conducts research and application in accordance with these principles. | 0 |
| PLO07 | - | Applies critical thinking, creative thinking and problem solving skills in techniques and methods of psychology profession. | 2 |
| PLO08 | - | Explains the cognitive processes of humans and animals. | 0 |
| PLO09 | - | Comprehends the cognitive, emotional and behavioral processes of human with scientific thinking | 1 |
| PLO10 | - | Conducts basic and applied psychology research | 3 |
| PLO11 | - | Plans methods and techniques related to interdisciplinary teamwork and demonstrates their application skills. | 1 |
| PLO12 | - | Uses knowledge of psychology to serve society and humanity on the basis of universal and national needs | 1 |
| PLO13 | - | Applies therapeutic and empathic communication skills with ethical responsibility. | 0 |
| PLO14 | - | Demonstrates a sense of responsibility as an individual and team member in solving problems related to the area. | 2 |
| PLO15 | - | Demonstrates life-long learning and research awareness. | 2 |
| PLO16 | - | Effectively shows his knowledge and skills among experts and non-specialists. | 2 |
| PLO17 | - | Use information and communication technologies effectively. | 5 |
| PLO18 | - | Applies communication skills on professional level in human relations and group works. | 2 |
| PLO19 | - | Shows awareness of events and developments on the agenda of the society and the world. | 2 |
| PLO20 | - | Explains verbally and in writing effectively. Develops himself with the principle of lifelong development in addition to professional development, for the individual development of the scientific, social, cultural and sportive areas. Demonstrates a sense of professional responsibility expressed in the Code of Ethics of The Turkish Psychological Association. Applies successfully the knowledge and skills learned in basic and applied psychology. | 2 |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | General information about spreadsheets | Expression, Question-answer, Team work, Homework | |
| 2 | Introduction to MS Excel, pages and cell concept | Expression, Question-answer, Team work, Homework | |
| 3 | Meeting with MS Excel toolbars, working with files, worksheet | Expression, Question-answer, Team work, Homework | |
| 4 | Processes related to MS Excel workbook and worksheet | Expression, Question-answer, Team work, Homework | |
| 5 | MS Excel options to customize, row and column related operations | Expression, Question-answer, Team work, Homework | |
| 6 | Processes and formulas related to MS Excel cells | Expression, Question-answer, Team work, Homework | |
| 7 | MS Excel formulas | Expression, Question-answer, Team work, Homework | |
| 8 | Mid-Term Exam | General review | |
| 9 | Adding new objects to a worksheet | Expression, Question-answer, Team work, Homework | |
| 10 | Creating and editing graphics | Expression, Question-answer, Team work, Homework | |
| 11 | Sorting and filtering | Expression, Question-answer, Team work, Homework | |
| 12 | To do fixed / sequential auto-fill, use macro | Expression, Question-answer, Team work, Homework | |
| 13 | Worksheet structure related operations and sending to the printer | Expression, Question-answer, Team work, Homework | |
| 14 | MS Powerpoint presentation program, create slide, slide layout, slide design | Expression, Question-answer, Team work, Homework | |
| 15 | Custom animation, add sound, start slide, set slide show, effective presentation techniques | Expression, Question-answer, Team work, Homework | |
| 16 | Term Exams | General review | |
| 17 | Term Exams | General review |
Assessment (Exam) Methods and Criteria
| Assessment Type | Midterm / Year Impact | End of Term / End of Year Impact |
|---|---|---|
| 1. Midterm Exam | 100 | 40 |
| General Assessment | ||
| Midterm / Year Total | 100 | 40 |
| 1. Final Exam | - | 60 |
| Grand Total | - | 100 |
Student Workload - ECTS
| Works | Number | Time (Hour) | Workload (Hour) |
|---|---|---|---|
| Course Related Works | |||
| Class Time (Exam weeks are excluded) | 14 | 2 | 28 |
| Out of Class Study (Preliminary Work, Practice) | 14 | 2 | 28 |
| Assesment Related Works | |||
| Homeworks, Projects, Others | 1 | 0 | 0 |
| Mid-term Exams (Written, Oral, etc.) | 1 | 20 | 20 |
| Final Exam | 1 | 24 | 24 |
| Total Workload (Hour) | 100 | ||
| Total Workload / 25 (h) | 4,00 | ||
| ECTS | 4 ECTS | ||