VISUAL PROGRAMMING II PROGRAMME COURSE DESCRIPTION

Code	Name of the Course Unit	Semester	In-Class Hours (T+P)	Credit	ECTS Credit
CMP252	VISUAL PROGRAMMING II	4	3	3	8

GENERAL INFORMATION
Language of Instruction :	English
Level of the Course Unit :	ASSOCIATE DEGREE, TYY: + 5.Level, EQF-LLL: 5.Level, QF-EHEA: Short Cycle
Type of the Course :	Compulsory
Mode of Delivery of the Course Unit	-
Coordinator of the Course Unit	Lecturer ADNAN KÜRŞAT TEKE
Instructor(s) of the Course Unit
Course Prerequisite	No

OBJECTIVES AND CONTENTS
Objectives of the Course Unit:	The aim of this course is to be able to program various Windows applications using C# codes and objects in the computer environment. To be able to create programs that can contain information and make automation according to this information by associating these programs with databases.
Contents of the Course Unit:	In the content of this course, the use of various C# objects by using Visual Studio, the relationship of C# objects with each other and with files outside the application, the relationship between C# applications and SQL Server databases, debugging in projects, installation of the designed project as a program, recursive classes and function structures.

KEY LEARNING OUTCOMES OF THE COURSE UNIT (On successful completion of this course unit, students/learners will or will be able to)
Establishes a connection with the database.
Retrieves data from the database.
Inserts data to the database.
Updates the data in the database.
Creates and uses pdf files.
Handles files outside of the application.
Sends e-mail through the program.
Creates the installation folder of the program.
Recognizes errors that may occur during operation.
Resolves errors that may harm the program's operation.

WEEKLY COURSE CONTENTS AND STUDY MATERIALS FOR PRELIMINARY & FURTHER STUDY
Week	Preparatory	Topics(Subjects)	Method
1	-	Timer applications, error detection.	Instruction
2	-	Error checking and debugging.	Instruction, Demonstration
3	Researching Sources	File usage in forms.	Instruction, Demonstration
4	Researching Sources	File usage in forms.	Instruction, Demonstration
5	Researching Sources	Establishing a database connection and inserting data into the table.	Instruction, Demonstration
6	Researching Sources	Select, assign, update and delete database table data.	Instruction, Demonstration
7	Researching Sources	Reporting in the form.	Instruction, Demonstration
8	-	MID-TERM EXAM	-
9	Researching Sources	Creating a PDF file.	Instruction, Demonstration
10	Researching Sources	Recursive structures.	Instruction, Demonstration
11	Researching Sources	NuGet Packages	Instruction, Demonstration
12	Researching Sources	NuGet Packages	Instruction, Demonstration
13	Researching Sources	Extensions and setup file creation.	Instruction, Demonstration
14	Topic review from previous weeks	Various examples and applications prepared in C# language.	Practice
15	Topic review from previous weeks	Various examples and applications prepared in C# language.	Practice
16	-	FINAL EXAM	-
17	-	FINAL EXAM	-

SOURCE MATERIALS & RECOMMENDED READING
Projeler ile C# 7.0 and SQL Server 2016 - Writer: Süleyman UZUNKÖPRÜ

ASSESSMENT
Assessment & Grading of In-Term Activities	Number of Activities	Degree of Contribution (%)	Description

Level of Contribution
0	1	2	3	4	5

KNOWLEDGE
Theoretical
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Computer concepts, methods and the software would dominate.						5
2	Recognizes the basic functions of hardware.			2
3	Recognize personal and network operating systems.		1
4	Ethics related to the profession, oversees the health and safety measures.						5
5	Have adopted the philosophy of total quality and technical elements that could support institutional processes become.						5

KNOWLEDGE
Factual
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Hardware makes the process of discovery and establishment.		1
2	Explains data management processes.				3
3	Explains different areas where software languages are used.						5

SKILLS
Cognitive
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Software (PC, network and Internet environment) are involved in planning and design.					4
2	Professional in the field of algorithmic thinking to find solutions to deal with problems that will arise.						5
3	Use math skills in vocational areas.					4

SKILLS
Practical
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Word processor, spreadsheet, presentation, database, and graphics-based design of programs you install and use.					4
2	Are given the chance to apply theoretical issues.						5

OCCUPATIONAL
Autonomy & Responsibility
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Detects common software and hardware failures, produce solutions to problems.					4
2	Measures related to data security and storage space and become individuals find appropriate solutions.				3
3	Fault finding, problem solving, decision-making and planning processes become competent in the subjects.						5

OCCUPATIONAL
Learning to Learn
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	They can learn and put into practice what they learned fast.				3
2	With the basic knowledge learned in the training process of learning and innovation that exists will have the ability to develop them.					4

OCCUPATIONAL
Communication & Social
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Except of course in the section related to their field of study clubs that exist in the industry to meet and communicate with the companies they have a chance.		1

OCCUPATIONAL
Occupational and/or Vocational
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Department students and programming, web design and technical courses will increase their chances to opt for.				3
2	Programming courses enables students to develop new programs and projects that they produce their own applications gain competence.						5
3	Some small or medium-sized companies take the role of management and leadership.		1

WORKLOAD & ECTS CREDITS OF THE COURSE UNIT
Workload for Learning & Teaching Activities
Type of the Learning Activites	Learning Activities (# of week)	Duration (hours, h)	Workload (h)
Lecture & In-Class Activities	14	3	42
Preliminary & Further Study	14	3	42
Land Surveying	0	0	0
Group Work	0	0	0
Laboratory	0	0	0
Reading	0	0	0
Assignment (Homework)	4	5	20
Project Work	14	1	14
Seminar	1	3	3
Internship	0	0	0
Technical Visit	0	0	0
Web Based Learning	0	0	0
Implementation/Application/Practice	7	3	21
Practice at a workplace	0	0	0
Occupational Activity	1	3	3
Social Activity	0	0	0
Thesis Work	0	0	0
Field Study	0	0	0
Report Writing	1	2	2
Final Exam	1	1	1
Preparation for the Final Exam	14	3	42
Mid-Term Exam	1	1	1
Preparation for the Mid-Term Exam	7	2	14
Short Exam	0	0	0
Preparation for the Short Exam	0	0	0
TOTAL	79	0	205