SECTION I: GENERAL INFORMATION ABOUT THE COURSE

Course Code	Course Name	Year	Semester	Theoretical	Practical	Credit	ECTS
50613METOZ-BLP0062	Electronic Spreadsheet and Macro Programming	1	Spring	1	1	2	4

Course Type :	Compulsory
Cycle:	Associate      TQF-HE:5. Master`s Degree      QF-EHEA:Short Cycle      EQF-LLL:5. Master`s Degree
Language of Instruction:	Turkish
Prerequisities and Co-requisities:	N/A
Mode of Delivery:	Face to face
Name of Coordinator:	Instructor FATİH ZAHİD GENÇ
Dersin Öğretim Eleman(lar)ı:	Instructor FATİH ZAHİD GENÇ
Dersin Kategorisi:

SECTION II: INTRODUCTION TO THE COURSE

Course Objectives & Content

Course Objectives:	With this course, the students, Microsoft Excel Program Macro program development is aimed to gain the ability.
Course Content:	Creating Macro with Microsoft Excel Program, Programming with Excel Visual Basic Application (VBA).

Course Learning Outcomes (CLOs)

Course Learning Outcomes (CLOs) are those describing the knowledge, skills and competencies that students are expected to achieve upon successful completion of the course. In this context, Course Learning Outcomes defined for this course unit are as follows:

Knowledge (Described as Theoritical and/or Factual Knowledge.)

Skills (Describe as Cognitive and/or Practical Skills.)

1) Makes macro operations.

2) Uses variables and constants.

3) Performs function processing.

4) Uses operators.

5) Uses decision control statements.

6) Uses loop statements.

7) Forms will do applications.

Competences (Described as "Ability of the learner to apply knowledge and skills autonomously with responsibility", "Learning to learn"," Communication and social" and "Field specific" competences.)

Weekly Course Schedule

Week	Subject	Materials Sharing *
		Related Preparation	Further Study
1)	Excel developer tab and Visual Basic interface	Cenk İltir, Excel'de Makrolar: VBA, Seçkin-Bilgisayar, 2014. Reading the related chapter and other resources to be obtained
2)	Working with Macros	Cenk İltir, Excel'de Makrolar: VBA, Seçkin-Bilgisayar, 2014. Reading the related chapter and other resources to be obtained
3)	Macro recording and operation procedures	Cenk İltir, Excel'de Makrolar: VBA, Seçkin-Bilgisayar, 2014. Reading the related chapter and other resources to be obtained
4)	Macro security	Cenk İltir, Excel'de Makrolar: VBA, Seçkin-Bilgisayar, 2014. Reading the related chapter and other resources to be obtained
5)	Macro-object linking	Cenk İltir, Excel'de Makrolar: VBA, Seçkin-Bilgisayar, 2014. Reading the related chapter and other resources to be obtained
6)	Introduction to Macro programming	Cenk İltir, Excel'de Makrolar: VBA, Seçkin-Bilgisayar, 2014. Reading the related chapter and other resources to be obtained
7)	Function Operations in Macro Programming	Cenk İltir, Excel'de Makrolar: VBA, Seçkin-Bilgisayar, 2014. Reading the related chapter and other resources to be obtained
8)	Midterm
9)	Excel-Visual Basic relation	Cenk İltir, Excel'de Makrolar: VBA, Seçkin-Bilgisayar, 2014. Reading the related chapter and other resources to be obtained
10)	Visual Basic Programming Language Overview, Basic Functions	Cenk İltir, Excel'de Makrolar: VBA, Seçkin-Bilgisayar, 2014. Reading the related chapter and other resources to be obtained
11)	User Defined Functions	Cenk İltir, Excel'de Makrolar: VBA, Seçkin-Bilgisayar, 2014. Reading the related chapter and other resources to be obtained
12)	Domain Concept in User Defined Functions	Cenk İltir, Excel'de Makrolar: VBA, Seçkin-Bilgisayar, 2014. Reading the related chapter and other resources to be obtained
13)	Basic Operations of Visual Basic Editor in Excel	Cenk İltir, Excel'de Makrolar: VBA, Seçkin-Bilgisayar, 2014. Reading the related chapter and other resources to be obtained
14)	Variables, Definitions, Conditional Constructs and Cycles	Cenk İltir, Excel'de Makrolar: VBA, Seçkin-Bilgisayar, 2014. Reading the related chapter and other resources to be obtained
15)	Developing projects with Excel-VBA	Cenk İltir, Excel'de Makrolar: VBA, Seçkin-Bilgisayar, 2014. Reading the related chapter and other resources to be obtained
16)	Final

*These fields provides students with course materials for their pre- and further study before and after the course delivered.

Recommended or Required Reading & Other Learning Resources/Tools

Course Notes / Textbooks:	Cenk İltir, 2014; Excel'de Makrolar: VBA, 5.Baskı, Seçkin-Bilgisayar
References:	Ömer Bağcı, 2020; İleri Düzey Excel 2019, 1.Baskı, Seçkin-Bilgisayar Kemal Sezen, 2016; Excel 2010 & VBA Kullanım ve Programlama, Sentez Yayıncılık Okan Emir, 2016; Profesyoneller için 102 Örnekle Excel Makro, Pusula Yayıncılık Bilge Adam, VBA Uygulamaları ve Ders Notları (PDF) Süleyman Uzunköprü, 2015; Projeler ile Excel ve Makrolar,Kodlab

SECTION III: RELATIONSHIP BETWEEN COURSE UNIT AND COURSE LEARNING OUTCOMES (CLOs)

(The matrix below shows how the course learning outcomes (CLOs) associates with programme learning outcomes (both KPLOs & SPLOs) and, if exist, the level of quantitative contribution to them.)

Relationship Between CLOs & PLOs

(KPLOs and SPLOs are the abbreviations for Key & Sub- Programme Learning Outcomes, respectively. )

CLOs/PLOs	KPLO 1						KPLO 2						KPLO 3										KPLO 4				KPLO 5
	1	2	3	4	5	6	1	2	3	4	5	6	1	2	3	4	5	6	7	8	9	10	1	2	3	4	1	2	3	4	5	6	7	8	9
CLO1
CLO2
CLO3
CLO4
CLO5
CLO6
CLO7

Level of Contribution of the Course to PLOs

No Effect	1 Lowest	2 Low	3 Average	4 High	5 Highest

	Programme Learning Outcomes	Contribution Level (from 1 to 5)
1)	Explains the basic, theoretical and practical knowledge related to the field of computer programming.	5
	1.1 Knows the basic concepts in the field of information technologies.	5
	1.2 Defines the problems that s/he may face in the field of computer programming.	1
	1.3 Have the analytical thinking skills required by computer programming.	2
	1.4 Defines the fundamentals of programming and algorithm information.	1
	1.5 Defines the basics of web design.
	1.6 Have knowledge about the basic concepts and management of computer networks.
2)	Knows the techniques, tools and information technologies necessary to develop applications related to the field.	3
	2.1 Knows the technical and modern tools necessary for applications related to computer programming.	3
	2.2 Knows the editors, compilers and platforms used in program development.	3
	2.3 Have the necessary program information to edit the visuality of the web page and to develop the web page.
	2.4 Have knowledge about tools used for database design and management.
	2.5 Knows game and mobile application development platforms.
	2.6 Follows technological innovations in software and hardware.	2
3)	Produces solutions by using the theoretical knowledge learned.	5
	3.1 Develops programs using analytical thinking skills by using software languages.	5
	3.2 Performs the installation and management of computer networks.
	3.3 Performs coding using game development platforms.
	3.4 Gains the ability to analyze and design information systems.
	3.5 Makes graphic design and animation applications.
	3.6 Realizes web design, software and programming.
	3.7 Installs and manages operating systems.
	3.8 Develops database applications.
	3.9 Learns visual and object-oriented programming.	5
	3.10 Produces solutions to problems encountered in computer programming and develops methods to solve the problems encountered.	4
4)	Applies the theoretical knowledge learned in business life for a semester.	5
	4.1 Experiences all processes in business life.
	4.2 Takes part in activities related to the field of education in a business operating in the field.
	4.3 Questions the application with theoretical knowledge.	5
	4.4 Compiles the knowledge and experience gained in the field.	5
5)	Acquires the competencies defined as the institutional outcomes of Beykoz University on the basic level, inline with the expectations of business world and the society.	4
	5.1 Acquires competency of analyzing and solving the problems.	4
	5.2 Has awareness for ethical and social responsibility.
	5.3 Takes responsibility as a team member in works and operations of his/her field.	2
	5.4 Is aware of written, verbal communication and interaction.
	5.5 Follows the developments of advanced technology and digital transformation.	2
	5.6 Acquires the awareness for lifelong learning.
	5.7 Has awareness about citizenship competency.
	5.8 Evaluates the developments of his/her field with the understanding of an entrepreneur.
	5.9 Acquires communication in a Foreign Language (English) competence defined on the level of at least A2 in European Language Portfolio. (In programs whose medium of instruction is English, on the level of B1).

SECTION IV: TEACHING-LEARNING & ASSESMENT-EVALUATION METHODS OF THE COURSE

Teaching & Learning Methods of the Course

(All teaching and learning methods used at the university are managed systematically. Upon proposals of the programme units, they are assessed by the relevant academic boards and, if found appropriate, they are included among the university list. Programmes, then, choose the appropriate methods in line with their programme design from this list. Likewise, appropriate methods to be used for the course units can be chosen among those defined for the programme.)

Teaching and Learning Methods defined at the Programme Level	Teaching and Learning Methods Defined for the Course
Lectures
Discussion
Case Study
Problem Solving
Demonstration
Views
Laboratory
Reading
Homework
Project Preparation
Thesis Preparation
Peer Education
Seminar
Technical Visit
Course Conference
Brain Storming
Questions Answers
Individual and Group Work
Role Playing-Animation-Improvisation
Active Participation in Class

Assessment & Evaluation Methods of the Course

(All assessment and evaluation methods used at the university are managed systematically. Upon proposals of the programme units, they are assessed by the relevant academic boards and, if found appropriate, they are included among the university list. Programmes, then, choose the appropriate methods in line with their programme design from this list. Likewise, appropriate methods to be used for the course units can be chosen among those defined for the programme.)

Aassessment and evaluation Methods defined at the Programme Level	Assessment and Evaluation Methods defined for the Course
Midterm
Presentation
Final Exam
Quiz
Report Evaluation
Homework Evaluation
Oral Exam
Thesis Defense
Jury Evaluation
Practice Exam
Evaluation of Implementation Training in the Workplace
Active Participation in Class
Participation in Discussions

Relationship Between CLOs & Teaching-Learning, Assesment-Evaluation Methods of the Course

(The matrix below shows the teaching-learning and assessment-evaluation methods designated for the course unit in relation to the course learning outcomes.)

Contribution of Assesment & Evalution Activities to Final Grade of the Course

Measurement and Evaluation Methods	# of practice per semester	Level of Contribution
Quizzes	2	% 20.00
Midterms	1	% 30.00
Semester Final Exam	1	% 50.00
Total		% 100
PERCENTAGE OF SEMESTER WORK		% 50
PERCENTAGE OF FINAL WORK		% 50
Total		% 100

SECTION V: WORKLOAD & ECTS CREDITS ALLOCATED FOR THE COURSE

WORKLOAD OF TEACHING & LEARNING ACTIVITIES
Teaching & Learning Activities	# of Activities per semester	Duration (hour)	Total Workload
Course	14	2	28
Laboratory	0	0	0
Application	0	0	0
Special Course Internship (Work Placement)	0	0	0
Field Work	0	0	0
Study Hours Out of Class	14	1	14
Presentations / Seminar	0	0	0
Project	0	0	0
Homework Assignments	0	0	0
Total Workload of Teaching & Learning Activities	-	-	42
WORKLOAD OF ASSESMENT & EVALUATION ACTIVITIES
Assesment & Evaluation Activities	# of Activities per semester	Duration (hour)	Total Workload
Quizzes	2	14	28
Midterms	1	10	10
Semester Final Exam	1	15	15
Total Workload of Assesment & Evaluation Activities	-	-	53
TOTAL WORKLOAD (Teaching & Learning + Assesment & Evaluation Activities)			95
ECTS CREDITS OF THE COURSE (Total Workload/25.5 h)			4