COURSE SYLLABUS Title of the course Visual Programming-II Level of Course Type of Course Language of Course Prerequisites of Course Method of the Course Coordinator of the course Instructor of the course Objective(s) of the Course Learning Outcomes of the Course Content of the Course Code Semester Theory Practice Credit ECTS GPR-2BL 2 2 2 3 5 Undergraduate Compulsory Turkish Face to face In this course, students are expected:  To understand basic programming concepts using databases,  To conduct queries to a data source using SQL,  To implement queries by using C# programming languages,  To transfer data for office software,  To create applications with databases in C# programming language. At the end of this course, students will be able to:  Explain database concepts,  Explain basic SQL syntax,  Use SQL for queries,  Make connections to MS Access or SQL Server databases,  Implement SQL commands using C# language,  Transfer data for office software,  Create reports for C# applications. This course covers following topics:  Basic principles of relational databases,  Basic SQL commands,  Basic data selection, sorting, filtering and search processes,  Basic interaction with office programs,  Report operations,  Setup preparation. Level of Contribution ( 1Lowest / 5Highest) 1 2 3 4 5 S PROGRAM QUALIFICATIONS 1 Students can have the basic knowledge of computer technology and define the basic concepts. X 2 Students can carry out definition, collection and utilization of data related to a well defined problem at computer technology, they can use required theoretical information, handcraft and intellectual skills in practical situations. X 1 3 While students can use appropriate methods and techniques, they can clearly explain designs and applications in computer technology to their colleagues, their superiors, people and groups served by them and also they can make well organized teamwork. X 4 Students can show learning independently and apply the information that they have learnt. They can learn how to use the latest technology and devices. X 5 Students can determine unexpected problems and can find a solution. They can show their problem solving skills and they develop solution proposals for unpredicted/unexpected problems encountered in studies. X 6 Students can conduct some activities to develop their subordinates. Students can objectively evaluate the performance of people working under their responsibilities and they can supervise them. X 7 Students can acquire adequate knowledge of foreign language in computer technology. X 8 Student can use required software and hardware programs in computer technology thanks to their basic computer knowledge. X 9 Students can perceive the knowledge and awareness of social responsibility, ethical values and social security rights in computer technology. X 10 11 12 13 14 15 Students can have the knowledge and awareness of work/worker safety and health, environmental security, like these issues related with computer technology. Students can utilize computer technology systems and they can maintain and repair operations by analyzing computer technology systems, system components and the process. Moreover they can utilize required tools, machines and devices for this purpose. Students can use effectively spoken and written Turkish lanuage. they can express their own thoughts and solutions for the problems to expert and non-expert people. Students can have awareness of requirement of lifelong learning that is crucial for them. They can follow developments in science and technology. They can improve themselves by using current technology in the field of machinery and equipment, tools and equipments. Students can have the ability of acquiring information, searching sources, using databases and other information source. In addition to this, they can analyze and interpret the information. Students can communicate effectively with people working in computer technology, with colleagues and people that they have contacts due to their jobs. 2 X X X X X X WEEKLY SUBJECTS AND VE PRELIMINARY PREPARATION Week Subjects 1 Database Concepts (Table, Field, Relations etc.) 2 SQL Language 3 Binding database objects to project 4 Adding and removing records 5 Updating records 6 Deleting records 7 Sorting records 8 Mid-term exam 9 Mid-term exam 10 Data transfer to office programs 11 Data transfer to office programs 12 Preparing reports 13 Preparing reports 14 Preparing setup files 15 Preparing setup files 16-17 Final exam SOURCES Course Book 1. Visual C#.Net 2008 Zirvedeki Beyinler Yüksel İNAN, Nihat DEMİRLİ Palme Yayıncılık Workbook 1. C# 4.0 Sefer ALGAN Pusula Yayıncılık 2. Visual C# Bilge Adam Kurs Notları 3. Algoritma Geliştirme ve Programlamaya Giriş (Fahri VATANSEVER Seçkin Yayıncılık Ankara 2002) ASSESSMENT Mid-terms Number Points Mid-term Exam 1 16 Final Exam 1 60 Average Worksheet Grade 1 16 Oral Assessment Grade 1 8 TOTAL 100 3 ECTS / STUDENT WORKLOAD CHART Number Duration (Hour) Total Workload Course Teaching Hour 13 4 52 Study ( Outside Courses) 6 3 18 Assignment 3 3 9 Study for Mid-term Exam 4 4 16 Mid-term Exam 1 4 4 Study for Final Exam 5 4 20 Final Exam 1 4 4 Activities TOTAL 123 ECTS 5 4