DEGREE PROGRAMS  Associate's Degree (Short Cycle)  Bachelor’s Degree (First Cycle)  Master’s Degree (Second Cycle)

Course Description Course Name : Computer Programming 4 Course Code : İSB344 Course Type : Optional Level of Course : Sub-Level (Undergraduate Degree) Year of Study : 3 Course Semester : Spring (16 Weeks) ECTS : 6 Name of Lecturer(s) : Lecturer ERKAN KAYNAK Learning Outcomes of the Course : Understand the concept of databases Understand the concept of XML files use Microsoft Access. Use Visual C# to connect Access database files. Can add / read data. Use Microsoft SQL Server Management Studio Use Visual C# to connect SQL Server databases. Data input and output to SQL Server databases. Create VIEW on a SQL Server database.. Create Stored Procedure on a SQL Server database. Mode of Delivery : Face-to-Face Prerequisites and Co-Prerequisites : None Recommended Optional Programme Components : None Aim(s) of Course : The concept of database. Using Visual C# to develop database applications . Course Contents : The concept of database. Introduction to XML files. Read and write data on XML files. Microsoft Access and Microsoft SQL Server. Use Visual C# to connect a database. Develeop database applications. Write stored procedures on SQL Server. Language of Instruction : Turkish Work Place : Faculty classrooms and computer labs.   Course Outline /Schedule (Weekly) Planned Learning Activities Week Subject Student's Preliminary Work Learning Activities and Teaching Methods 1 XML Files Source reading. Lecture, samples, create projects on computer. 2 Use Visual C# to read and write data to XML files. Source reading. Lecture, samples, create projects on computer. 3 The concept of database. Introduction to tables and fields on a database. Source reading. Lecture, samples, create projects on computer. 4 Microsoft Access I. (Create database. Add data to a Access database) Source reading. Lecture, samples, create projects on computer. 5 Microsoft Access II. Source reading. Lecture, samples, create projects on computer. 6 Use Visual C# to connect an Access database I. Source reading. Lecture, samples, create projects on computer. 7 Use Visual C# to connect an Access database II. (Database operations) Source reading. Lecture, samples, create projects on computer. 8 Midterm Exam Review the topics discussed in the lecture notes and sources Create projects on computer. 9 Microsoft SQL Server. Use Microsoft SQL Server Management Studio. Create databases and tables on SQL Server. Source reading. Lecture, samples, create projects on computer. 10 Use Visual C# to connect SQL Server database. Source reading. Lecture, samples, create projects on computer. 11 SQL Source reading. Lecture, samples, create projects on computer. 12 Create VIEW s on SQL Server. Source reading. Lecture, samples, create projects on computer. 13 Create Stored Procedures on SQL Server Source reading. Lecture, samples, create projects on computer. 14 Use Visual C# to execute Stored Procedures. Source reading. Lecture, samples, create projects on computer. 15 Sample projects. Source reading. Lecture, samples, create projects on computer. 16/17 Final Exam Review the topics discussed in the lecture notes and sources Create projects on computer.   Required Course Resources Resource Type Resource Name Recommended Course Material(s)  Hamza Erol (2010), Microsoft Visual C# .Net ile Görsel Programlama, Nobel Kitapevi - ADANA  John Sharp, Microsoft® Visual C#® 2010 Step by Step  John Sharp, Adım Adım Visual C# 2010, Arkadaş Yayınları Required Course Material(s)   Assessment Methods and Assessment Criteria Semester/Year Assessments Number Contribution Percentage     Mid-term Exams (Written, Oral, etc.) 1 60     Homeworks/Projects/Others 10 40 Total 100 Rate of Semester/Year Assessments to Success 40   Final Assessments 100 Rate of Final Assessments to Success 60 Total 100   Contribution of the Course to Key Learning Outcomes # Key Learning Outcome Contribution* 1 Utilize computer systems and softwares 5 2 Apply the statistical analyze methods 1 3 Make statistical inference(estimation, hypothesis tests etc.) 0 4 Generate solutions for the problems in other disciplines by using statistical techniques 0 5 Discover the visual, database and web programming techniques and posses the ability of writing programme 5 6 Construct a model and analyze it by using statistical packages 4 7 Distinguish the difference between the statistical methods 0 8 Be aware of the interaction between the disciplines related to statistics 3 9 Make oral and visual presentation for the results of statistical methods 2 10 Have capability on effective and productive work in a group and individually 0 11 Develop scientific and ethical values in the fields of statistics-and scientific data collection 0 12 Explain the essence fundamentals and concepts in the field of Probability, Statistics and Mathematics 0 13 Emphasize the importance of Statistics in life 0 14 Define basic principles and concepts in the field of Law and Economics 0 15 Produce numeric and statistical solutions in order to overcome the problems 0 16 Construct the model, solve and interpret the results by using mathematical and statistical tehniques for the problems that include random events 0 17 Use proper methods and techniques to gather and/or to arrange the data 0 18 Professional development in accordance with their interests and abilities, as well as the scientific, cultural, artistic and social fields, constantly improve themselves by identifying training needs 0 * Contribution levels are between 0 (not) and 5 (maximum).   Student Workload - ECTS Works Number Time (Hour) Total Workload (Hour) Course Related Works     Class Time (Exam weeks are excluded) 14 4 56     Out of Class Study (Preliminary Work, Practice) 14 4 56 Assesment Related Works     Homeworks, Projects, Others 10 1 10     Mid-term Exams (Written, Oral, etc.) 1 10 10     Final Exam 1 10 10 Total Workload: 142 Total Workload / 25 (h): 5.68 ECTS Credit: 6