GEP1375 Information and Communication Technology IIBahçeşehir UniversityDegree Programs SOFTWARE ENGINEERINGGeneral Information For StudentsDiploma SupplementErasmus Policy StatementNational QualificationsBologna Commission
SOFTWARE ENGINEERING
Bachelor TR-NQF-HE: Level 6 QF-EHEA: First Cycle EQF-LLL: Level 6

Course Introduction and Application Information

Course Code Course Name Semester Theoretical Practical Credit ECTS
GEP1375 Information and Communication Technology II Spring 3 0 3 5
This catalog is for information purposes. Course status is determined by the relevant department at the beginning of semester.

Basic information

Language of instruction: Turkish
Type of course: GE-Elective
Course Level: Bachelor’s Degree (First Cycle)
Mode of Delivery: E-Learning
Course Coordinator : ADEM ÖZER
Recommended Optional Program Components: -
Course Objectives: This course aims to provide proficiency in widely used office programs in the workplace, with a particular focus on advanced knowledge and usage of Excel. It also seeks to offer an updated perspective on contemporary software tools. Additionally, through various scenarios, the course aims to enhance students' problem-solving abilities. In this course, lecture, individual study, discussion, reading, technology-supported learning teaching methods and techniques are used.

Learning Outcomes

The students who have succeeded in this course;
By successfully completing this course, you will be able to:

Microsoft Word
- Create and format different document types (e.g., letters, reports, articles, etc.).
- Insert tables, charts, and images.
- Apply academic writing rules, such as citations and footnotes.
- Divide long documents into sections and create an index.
- Prepare forms and surveys.
- Collaborate on the same document with multiple users.

Microsoft Excel
- Perform basic and complex mathematical operations.
- Visualize data through tables and charts.
- Use techniques such as filtering and sorting for data analysis.
- Utilize advanced features like pivot tables.
- Import and process data from various data sources.

Microsoft PowerPoint
- Create impactful and professional presentations.
- Use different slide layouts and animations.
- Add audio, video, and images to presentations.
- Save and share presentations in different formats.
- Engage with the audience during presentations.

Course Content

This course aims to equip students with fundamental and advanced skills in Microsoft Word, Excel, and PowerPoint, along with an introduction to AI-powered presentation tools and emerging technologies in office software. Throughout the course, students will engage in hands-on practice, including document creation, data analysis, and professional presentation design, while developing essential skills for academic and professional settings.

Teaching Methods and Techniques Used in the Course:
Lecture
Discussion
Individual Study
Reading
Technology-Enhanced Learning

Week 1
Introduction to the course
Expectations from the course
Scope, rationale, significance, and rules of the course

Week 2
MS Word

Basic interface and functions of Microsoft Word
Creating and formatting different document types (e.g., letters, reports, articles)
Week 3
MS Word

Inserting tables, charts, and images in Word
Applying academic writing rules such as citations and footnotes
Dividing long documents into sections and creating an index
Week 4
MS Word

Creating forms and surveys in Word
Collaborating on the same document with multiple users
Week 5
MS Excel

Basic interface and functions of Microsoft Excel
Performing basic and complex mathematical operations
Week 6
MS Excel

Visualizing data through tables and charts
Using techniques such as filtering and sorting for data analysis
Week 7
MS Excel

Using advanced features like macros and pivot tables
Importing and processing data from various data sources
Week 8
Midterm Exam

Week 9
MS PowerPoint

Basic interface and functions of Microsoft PowerPoint
Creating impactful and professional presentations
Week 10
MS PowerPoint

Using different slide layouts and animations
Adding audio, video, and images to presentations
Week 11
MS PowerPoint

Saving and sharing presentations in different formats
Engaging with the audience during presentations
Week 12
Emerging Technologies

Artificial intelligence presentation tools
Using AI tools (e.g., Prezi AI, Beautiful.ai)
Benefits and limitations of AI presentation tools
Creating presentations using AI tools
Week 13
Emerging Technologies

Using AI and other emerging technologies in Word and Excel
Preparing documents and spreadsheets more efficiently with new technologies
Week 14
Summary and Q&A

Weekly Detailed Course Contents

Week Subject Related Preparation
1) Introduction Course Overview Expectations from the Course Scope, Rationale, Significance, and Rules of the Course
2) The Basic Interface and Functions of Microsoft Word Creating and Formatting Different Document Types (e.g., letters, reports, articles, etc.)
3) Inserting Tables, Charts, and Images in Word Applying Academic Writing Rules, Such as Citation and Adding Footnotes Dividing Long Documents into Sections and Creating an Index
4) Creating Forms and Surveys in Word Collaborating on the Same Document with Multiple Users
5) Microsoft Excel's basic interface and functions Performing basic and complex mathematical operations
6) Visualizing data through tables and charts Using techniques such as filtering and sorting for data analysis
7) Using advanced features such as macros and pivot tables in Excel Importing and processing data from various data sources
8) Midterm Week
9) Microsoft PowerPoint's basic interface and functions Creating impactful and professional presentations
10) Using different slide layouts and animations Adding audio, video, and images to presentations
11) Saving and sharing presentations in different formats Engaging with the audience during presentations
12) Artificial Intelligence presentation tools Using artificial intelligence presentation tools (e.g., Prezi AI, Beautiful.ai) Benefits and limitations of artificial intelligence presentation tools Creating presentations using an artificial intelligence presentation tool
13) Using artificial intelligence and other emerging technologies in Word and Excel Preparing documents and spreadsheets more quickly and easily with new technologies
14) Summary and Q&A

Sources

Course Notes / Textbooks:
References: "İleri Düzey Excel 2019", Seçkin Yayınları, 9.Baskı, Ömer Bağcı
Office 2016/ Tolga Demirhan; Pınar Aydan Demirhan, İlker Hacıoğlu, Altan Mesut

Evaluation System

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

ECTS / Workload Table

Activities Number of Activities Duration (Hours) Workload
Course Hours 13 3 39
Study Hours Out of Class 12 3 36
Homework Assignments 2 15 30
Quizzes 1 10 10
Final 1 2 2
Total Workload 117

Contribution of Learning Outcomes to Programme Outcomes

No Effect 1 Lowest 2 Low 3 Average 4 High 5 Highest
           
Program Outcomes Level of Contribution
1) Be able to specify functional and non-functional attributes of software projects, processes and products.
2) Be able to design software architecture, components, interfaces and subcomponents of a system for complex engineering problems.
3) Be able to develop a complex software system with in terms of code development, verification, testing and debugging.
4) Be able to verify software by testing its program behavior through expected results for a complex engineering problem.
5) Be able to maintain a complex software system due to working environment changes, new user demands and software errors that occur during operation.
6) Be able to monitor and control changes in the complex software system, to integrate the software with other systems, and to plan and manage new releases systematically.
7) Be able to identify, evaluate, measure, manage and apply complex software system life cycle processes in software development by working within and interdisciplinary teams.
8) Be able to use various tools and methods to collect software requirements, design, develop, test and maintain software under realistic constraints and conditions in complex engineering problems.
9) Be able to define basic quality metrics, apply software life cycle processes, measure software quality, identify quality model characteristics, apply standards and be able to use them to analyze, design, develop, verify and test complex software system.
10) Be able to gain technical information about other disciplines such as sustainable development that have common boundaries with software engineering such as mathematics, science, computer engineering, industrial engineering, systems engineering, economics, management and be able to create innovative ideas in entrepreneurship activities. 4
11) Be able to grasp software engineering culture and concept of ethics and have the basic information of applying them in the software engineering and learn and successfully apply necessary technical skills through professional life. 3
12) Be able to write active reports using foreign languages and Turkish, understand written reports, prepare design and production reports, make effective presentations, give clear and understandable instructions.
13) Be able to have knowledge about the effects of engineering applications on health, environment and security in universal and societal dimensions and the problems of engineering in the era and the legal consequences of engineering solutions. 3