TÜRKÇE
ENGLISH
Information
| Unit | ADANA VOCATIONAL SCHOOL |
| Code | BPP206 |
| Name | Internet Programming II |
| Term | 2020-2021 Academic Year |
| Semester | 4. Semester |
| Duration (T+A) | 3-1 (T-A) (17 Week) |
| ECTS | 4 ECTS |
| National Credit | 3.5 National Credit |
| Teaching Language | Türkçe |
| Level | Ön Lisans Dersi |
| Type | Normal |
| Label | C Compulsory |
| Mode of study | Uzaktan Öğretim |
| Catalog Information Coordinator | Öğr. Gör. Dr. MEHMET İSMAİL SOLMAZ |
| Course Instructor |
Öğr. Gör. Dr. YILMAZ KOÇAK
(Bahar)
(A Group)
(Ins. in Charge)
Öğr. Gör. Dr. YILMAZ KOÇAK (Bahar) (B Group) (Ins. in Charge) |
Course Goal / Objective
To do database programming using server-sided web programming language.
Course Content
to prepare database, to do processing of database with server-sided web programming, to use data access and visualize controls, membership and member processes, role assignment to members, web-parts, application packaging and installing.
Course Precondition
Resources
Notes
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | Install database software for server-sided web applications. |
| LO02 | Does membership procedures for web site. |
| LO03 | Does web project packaging and installing. |
| LO04 | establishes a connection to a database server |
| LO05 | queries from the database, saves and deletes data |
| LO06 | installs and executes a server-based site on a server |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | - | Explains computer software and hardware. | 0 |
| PLO02 | - | Define the data and hardware necessary for solving well-defined problems in Computer Technologies and Programming. | 4 |
| PLO03 | - | Evaluate the developments in computer and computer network using scientific methods and techniques. | 4 |
| PLO04 | - | Explains the simple software and hardware failures encountered in the computer. | 0 |
| PLO05 | - | Explains the methods necessary for solving well-defined problems in Computer Technologies and Programming. | 5 |
| PLO06 | - | Explain the teaching methods, techniques and strategies of information technologies. | 0 |
| PLO07 | - | Use appropriate methods and techniques for the development of critical and creative thinking and problem solving skills. | 0 |
| PLO08 | - | Plans simple software and hardware failures in the computer and solutions to non-specialist problems. | 0 |
| PLO09 | - | Use appropriate techniques with verbal, numerical and graphical expression. | 0 |
| PLO10 | - | Use information technologies effectively in learning and learning process. | 0 |
| PLO11 | - | To be able to know, edit and query data in computer environment. | 0 |
| PLO12 | - | Takes responsibility as an individual and as a team in solving the problems. | 0 |
| PLO13 | - | It becomes a responsible citizen against the public and private sectors. | 0 |
| PLO14 | - | Gains the ability of self-learning, critically evaluates the information learned. | 0 |
| PLO15 | - | Evaluates independently what they learn and learn in the field of Computer Technologies and Programming. | 0 |
| PLO16 | - | Communicates well with students, teachers, school management, employers and customers. | 0 |
| PLO17 | - | Use computer and communication technologies effectively. | 4 |
| PLO18 | - | It attempts to think and develop on its own professional performance. | 0 |
| PLO19 | - | It follows current scientific, professional and artistic events. | 0 |
| PLO20 | - | Express their ideas in a foreign language orally and in writing, read foreign professional resources. | 0 |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Study with data; definition and properties of data provider,data set,connection objects, command objects, ada adapter. | READS ON CONDITIONS | |
| 2 | Preparing of database file and database file access via web programming tools. | READS ON CONDITIONS | |
| 3 | Database connection management, realization of data connection, data selection, insertion, updating and deleting. | READS ON CONDITIONS | |
| 4 | Dataconnection using configuration file, data access using data adapter, command object, data table, write data in datatable to XML file and data transfer from XML file into data table, serialization and deserialization. | READS ON CONDITIONS | |
| 5 | Data access controls (AccessDataSource, SqlDataSource, XmlDataSource, ObjectDataSource), data filtering, filtering, inserting, updating and deleting using parameter. | READS ON CONDITIONS | |
| 6 | Data view controls; data selection with GridView, DataList, DetailsView, FormView, Repeater, ListView. | READS ON CONDITIONS | |
| 7 | Data accessing, inserting, updating and deleting in the form of Master-Detail. | READS ON CONDITIONS | |
| 8 | Mid-Term Exam | READS ON CONDITIONS | |
| 9 | Database file preparing using SQL and accessing to database file. | READS ON CONDITIONS | |
| 10 | What is LINQ Acces to SQL Server data using LINQ. | READS ON CONDITIONS | |
| 11 | Profile and personalization; profile definition, profile provider, database structuring, connection to profile database, using profile, anonymous and defined users. | READS ON CONDITIONS | |
| 12 | Authentication and athurization, membership and member management, role definition and role assignment to members. | READS ON CONDITIONS | |
| 13 | Web-parts and web portal preparing. | READS ON CONDITIONS | |
| 14 | Performance management and configuration. | READS ON CONDITIONS | |
| 15 | Applicaiton packaging and intalling. | READS ON CONDITIONS | |
| 16 | Term Exams | READS ON CONDITIONS | |
| 17 | Term Exams | READS ON CONDITIONS |
Assessment (Exam) Methods and Criteria
| Assessment Type | Midterm / Year Impact | End of Term / End of Year Impact |
|---|---|---|
| 1. Midterm Exam | 100 | 40 |
| General Assessment | ||
| Midterm / Year Total | 100 | 40 |
| 1. Final Exam | - | 60 |
| Grand Total | - | 100 |
Student Workload - ECTS
| Works | Number | Time (Hour) | Workload (Hour) |
|---|---|---|---|
| Course Related Works | |||
| Class Time (Exam weeks are excluded) | 14 | 4 | 56 |
| Out of Class Study (Preliminary Work, Practice) | 14 | 2 | 28 |
| Assesment Related Works | |||
| Homeworks, Projects, Others | 0 | 0 | 0 |
| Mid-term Exams (Written, Oral, etc.) | 1 | 8 | 8 |
| Final Exam | 1 | 16 | 16 |
| Total Workload (Hour) | 108 | ||
| Total Workload / 25 (h) | 4,32 | ||
| ECTS | 4 ECTS | ||