ADVERTISING
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:	Problem-Solving Skills This course equips students with the ability to solve various problems using ICT tools. Students learn to use ICT tools to address real-life problems through assignments and projects. Critical Thinking Skills This course helps students develop critical thinking skills while using ICT tools. Students learn to evaluate the ethical and social implications of ICT tool usage. Knowledge of Information Technologies This course provides students with knowledge of fundamental concepts and principles of information technologies. Students gain awareness of critical topics such as data security and backup. Career Opportunities This course prepares students for various careers in the ICT field. The skills acquired in this course are highly sought after across many industries.
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.

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

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 (Online)
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
Total		%
PERCENTAGE OF SEMESTER WORK		% 0
PERCENTAGE OF FINAL WORK		%
Total		%

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)	To be able to apply theoretical concepts related to mass communication, consumer behavior, psychology, persuasion,sociology, marketing, and other related fields to understand how advertising and brand communication works in a free-market economy.	1
2)	To be able to critically discuss and interpret theories, concepts, methods, tools and ideas in the field of advertising.	2
3)	To be able to research, create, design, write, and present an advertising campaign and brand strategies of their own creation and compete for an account as they would at an advertising agency.	2
4)	To be able to analyze primary and secondary research data for a variety of products and services.	3
5)	To be able to develop an understanding of the history of advertising as it relates to the emergence of mass media outlets and the importance of advertising in the marketplace.	2
6)	To be able to follow developments, techniques, methods, as well as research in advertising field; and to be able to communicate with international colleagues in a foreign language. (“European Language Portfolio Global Scale”, Level B1)	3
7)	To be able to take responsibility in an individual capacity or as a team in generating solutions to unexpected problems that arise during implementation process in the Advertising field.	2
8)	To be able to understand how advertising works in a global economy, taking into account cultural, societal, political, and economic differences that exist across countries and cultures.	3
9)	To be able to approach the dynamics of the field with an integrated perspective, with creative and critical thinking, develop original and creative strategies.	3
10)	To be able to to create strategic advertisements for print, broadcast, online and other media, as well as how to integrate a campaign idea across several media categories in a culturally diverse marketplace.	2
11)	To be able to use computer software required by the discipline and to possess advanced-level computing and IT skills. (“European Computer Driving Licence”, Advanced Level)	1
12)	To be able to identify and meet the demands of learning requirements.	2
13)	To be able to develop an understanding and appreciation of the core ethical principles of the advertising profession.	3