International Trade and Business (English)
Bachelor TR-NQF-HE: Level 6 QF-EHEA: First Cycle EQF-LLL: Level 6

Course Introduction and Application Information

Course Code: EASF105
Course Name: Computer Literacy
Semester: Fall
Course Credits:
ECTS
6
Language of instruction: English
Course Condition:
Does the Course Require Work Experience?: No
Type of course: Compulsory Courses
Course Level:
Bachelor TR-NQF-HE:6. Master`s Degree QF-EHEA:First Cycle EQF-LLL:6. Master`s Degree
Mode of Delivery: Face to face
Course Coordinator: Dr. Öğr. Üy. SÜLEYMAN SERDAR YÖRÜK
Course Lecturer(s): Asst.Prof.Dr. Hazar Altınbaş
Course Assistants:

Course Objective and Content

Course Objectives: Aim of the course is to provide basic computer knowledge, give insight to ethical aspects of digital technologies, teach internet searching techniques and practice office software for academic and professional purposes and to give a basic understanding about programming.
Course Content: Technology in modern world, computers and computer system basics, software, hardware, information, computer networks, the Internet, Google search tips, academic databases and searching, M.S. Word (ribbons and menus, formatting, styles, table of contents, cross-references), academic writing with M.S. Word and Mendeley, M.S. Excel (formatting, user-defined and built-in functions, Pivot table, plotting), M.S. Powerpoint (formatting, slide master, animations, slide show, presentation tips). Introduction to programming with Python.

Learning Outcomes

The students who have succeeded in this course;
1) Explain fundamentals of computer and digital technologies
2) Make use of technology ethically and securely
3) Can utilize internet and academic databases efficiently
4) Use M.S. Office software for academic and professional purposes
5) Explain programming basics

Course Flow Plan

Week Subject Related Preparation
1) Introducing course and explaining evaluation to students, Pointing out the importance of the course within curriculum. 1. Technology in society 2. Windows 10/11 basics, installing browsers, using browsers Reading related chapters in textbook. Installing Windows and any browser of choice.
2) 1. Emerging technologies and ethics 2. Searching in Google Reading related chapters in textbook.
3) 1. Computers, input and output devices 2. Using Google scholar and academic databases, reference management software Reading related chapters in textbook.
4) 1. Processing and memory, data storing 2. Introduction to M.S. Word; text formatting Reading related chapters in textbook. Installing M.S. Word.
5) 1. Software, productivity and business software 2. M.S. Word; styles, header and footer, equations and symbols Reading related chapters in textbook.
6) 1. Multimedia and educational software, system software 2. M.S. Word; layout, footnotes, captions, citations, reviewing Reading related chapters in textbook.
7) 1. Hardware, CPU, memory, storage 2. M.S. Word: Table of contents, table of figures, indexing Reading related chapters in textbook.
8) MIDTERM
9) 1. Digital information, ethical issues in digital era 2. Introduction to M.S. Excel; cells, rows, columns, formatting workbook elements, charts, plotting, data filtering Reading related chapters in textbook. Installing M.S. Excel.
10) 1. Computer networks, the Internet 2. M.S. Excel; built-in functions, user-defined functions Reading related chapters in textbook.
11) 1. Computer system security, data and internet security 2. M.S. Excel; importing/exporting data, pivot table, brief introduction to data analysis tools Reading related chapters in textbook.
12) 1. Tips for an effective presentation 2. Introduction to M.S. PowerPoint; slides, formatting, illustrations, animations, slide show Installing M.S. PowerPoint.
13) 1. Introduction to programming 2. Introduction to Python Reading related chapters in suggested reading. Installing Python.
14) 1. Fundamentals of programming 2. First codes on Python Reading related chapters in suggested reading.

Sources

Course Notes / Textbooks: 1. Evans, A., Martin, K., Poatsy, M.A. (2020). Technology in Action Complete, 16th edition. Pearson.
2. “Microsoft Office 365 & Office 2019 Introductory”, Sandra Cable, Steven M. Freund, Ellen Monk, Susan L. Sebok, Joy L. Starks, and Misty E. Vermaat
References: 1. Microsoft Official Academic Course Books. Wiley
2. Microsoft Office: Step by Step. Microsoft
3. Hunt, J. (2019). A beginners guide to Python 3 programming. Springer.

Course - Program Learning Outcome Relationship

Course Learning Outcomes

1

2

3

4

5

Program Outcomes
1) Has a broad and interdisciplinary perspective on international business and trade by the use of social sciences and mathematics,
2) Possess the knowledge and skills related to different functions and interactions of international business and trade.
3) Possess the knowledge and skills to interpret the data, concepts and ideas in the field of international business and trade with scientific and technological methods. 1
4) Use different theoretical approaches to understanding and solving various business and trade problems. 3
5) Explains the competitiveness of the countries with the requirements of international competition and interprets the functioning of the actors and regulatory structures in the international environment.
6) Understands the value of developing new trade projects and generating strategies within international market needs.
7) Solves complex business and global trade problems by using various statistical techniques and numerical methods and makes analyzes by using statistical programs effectively.
8) Uses a foreign language at the B1 General Level in terms of European Language Portfolio criteria according to the level of education.
9) Develops teamwork, negotiation, leadership and entrepreneurship skills.
10) Possess the knowledge of universal ethical values, social responsibility and sufficient legal and regulatory knowledge.
11) Develops positive attitudes related to lifelong learning and identifies individual learning needs and carries out studies to correct them. 2 2 2
12) Students will be able to communicate their ideas and solutions both written and orally, and present and publish them on both national and international platforms. 3 3
13) Uses information and communication technologies together with computer software at the advanced level of European Computer Using License required by the field. 3 3 3 3

Course - Learning Outcome Relationship

No Effect 1 Lowest 2 Average 3 Highest
       
Program Outcomes Level of Contribution
1) Has a broad and interdisciplinary perspective on international business and trade by the use of social sciences and mathematics,
2) Possess the knowledge and skills related to different functions and interactions of international business and trade.
3) Possess the knowledge and skills to interpret the data, concepts and ideas in the field of international business and trade with scientific and technological methods. 1
4) Use different theoretical approaches to understanding and solving various business and trade problems. 1
5) Explains the competitiveness of the countries with the requirements of international competition and interprets the functioning of the actors and regulatory structures in the international environment.
6) Understands the value of developing new trade projects and generating strategies within international market needs. 1
7) Solves complex business and global trade problems by using various statistical techniques and numerical methods and makes analyzes by using statistical programs effectively.
8) Uses a foreign language at the B1 General Level in terms of European Language Portfolio criteria according to the level of education.
9) Develops teamwork, negotiation, leadership and entrepreneurship skills.
10) Possess the knowledge of universal ethical values, social responsibility and sufficient legal and regulatory knowledge.
11) Develops positive attitudes related to lifelong learning and identifies individual learning needs and carries out studies to correct them. 2
12) Students will be able to communicate their ideas and solutions both written and orally, and present and publish them on both national and international platforms. 3
13) Uses information and communication technologies together with computer software at the advanced level of European Computer Using License required by the field. 3

Assessment & Grading

Semester Requirements Number of Activities Level of Contribution
Quizzes 2 % 20
Midterms 1 % 30
Final 1 % 50
total % 100
PERCENTAGE OF SEMESTER WORK % 50
PERCENTAGE OF FINAL WORK % 50
total % 100

Workload and ECTS Credit Calculation

Activities Number of Activities Workload
Course Hours 13 26
Application 13 26
Quizzes 7 12
Midterms 5 36
Final 6 56
Total Workload 156