COURSE DESCRIPTION AND APPLICATION INFORMATION
| Course Name | Code | Semester | T+A+L (hour/week) | Type (C / O) | Local Credit | ECTS |
|---|---|---|---|---|---|---|
| Internet Programming Project | CMPE 487 | Fall | 03+00+02 | Elective | 4 | 8 |
| Academic Unit: | Computer Engineering Department, Faculty of Engieering and Natural Sciences |
| Mode of Delivery: | Face to face |
| Prerequisites: | None |
| Language of Instruction: | English |
| Level of Course Unit: | Undergraduate |
| Course Coordinator: | albert.ozkohen |
| Course Lecturer(s): | albert.ozkohen |
| Course Objectives: | This course will build a bridge between programming, internet, server management, databases and business application development. It will start with a recap on HTML and CSS for basic web page building. Then a recap on Basic Database Concepts will be provided in order to be able to build Business Applications. There will be term wide group project. Requirement preparations and database design will be practiced. Elements of PHP and MySQL languages will be delivered. Software implementation and maintenance, coding, testing, verification and validation will be the main activities. Additionally examples for using RAD tools for PHP code generation will be presented. |
| Course Contents: | Web page building using HTML, CSS, Database management with MySQL, Basic server management. Building basic internet applications using PHP language. Connecting PHP applications with MySQL database in order to provide SELECT, INSERT, UPDATE, DELETE operations. Sending emails and applying security concepts to application by user management and group based menus |
| Learning Outcomes of the Course Unit (LO): |
|
| Planned Learning Activities and Teaching Methods: | Classroom discussion, computer laboratory work., developing a group project |
WEEKLY SUBJECTS AND RELATED PREPARATIONS
| Week | Subjects | Related Preperation |
|---|---|---|
| 1 | Introduction to HTML & CSS | Course material, Textbook, Exercises in the Lab, Assignments |
| 2 | Introduction to Web development with PHP. How To Code a PHP application | Course material, Textbook, Exercises in the Lab, Assignments |
| 3 | How to code control statements. How to work with strings and numbers and dates | Course material, Textbook, Exercises in the Lab, Assignments |
| 4 | Introduction to relational databases and MySQL. How to use PHP with MySQL | Course material, Textbook, Exercises in the Lab, Assignments |
| 5 | How to use PHP with MySQL | Course material, Textbook, Exercises in the Lab, Assignments |
| 6 | How to test and debug a PHP application. How To work with form data | Course material, Textbook, Exercises in the Lab, Assignments |
| 7 | How to create and use arrays, Cookies and sessions, Create and use functions | Course material, Textbook, Exercises in the Lab, Assignments |
| 8 | How to design a database. How to use SQL to create / work a MySQL database | Course material, Textbook, Exercises in the Lab, Assignments |
| 9 | Professional PHP for working with MySQL. A database driven website | Course material, Textbook, Exercises in the Lab, Assignments |
| 10 | Project review and preparation | Course material, Textbook, Exercises in the Lab, Assignments |
| 11 | How to send email and access other database, how to work with files uploads and images | Course material, Textbook, Exercises in the Lab, Assignments |
| 12 | Security usernames / paasswords / form based security | Course material, Textbook, Exercises in the Lab, Assignments |
| 13 | RAD with Scriptcase | Course material, Textbook, Exercises in the Lab, Assignments |
| 14 | Project review and preparation | Course material, Textbook, Exercises in the Lab, Assignments |
At Kadir Has University, a Semester is 14 weeks; The weeks 15 and 16 are reserved for final exams.
REQUIRED AND RECOMMENDED READING
| 1.) Main text book: Murach , PHP and MySQL 2nd edition. 2.) Deitel, Internet and WWW how to program 5th edition. 3.) Powell, The Complete Reference – HTML & CSS 5th edition |
OTHER COURSE RESOURCES
| 1.) Tutorials on HTML, CSS, Javascript, SQL, PHP: https://www.w3schools.com/html/default.asp https://www.tutorialspoint.com/html/index.htm 2.) Online compilers: https://www.w3schools.com/php/php_compiler.asp https://www.w3schools.com/sql/trysql.asp?filename=trysql_editor https://onecompiler.com/php 3.) Full reference at : https://www.php.net/manual/en/ https://dev.mysql.com/doc/refman/8.4/en/ |
ASSESSMENT METHODS AND CRITERIA
| Semester Requirements | Number | Percentage of Grade (%) |
|---|---|---|
| Attendance / Participation | 1 | 10 |
| Practice / Exercise | 1 | 15 |
| Project | 1 | 30 |
| Homework Assignments | 1 | 15 |
| Midterms / Oral Exams / Quizes | 1 | 15 |
| Final Exam | 1 | 15 |
| Total: | 6 | 100 |
WORKLOAD
| Events | Count | Duration (Hours) | Total Workload (hour) |
|---|---|---|---|
| Course Hours | 14 | 3 | 42 |
| Laboratory | 14 | 2 | 28 |
| Practice / Exercise | 15 | 2 | 30 |
| Project | 1 | 60 | 60 |
| Homework Assigments | 4 | 5 | 20 |
| Midterms / Oral Exams / Quizes | 1 | 10 | 10 |
| Final Exam | 1 | 10 | 10 |
| Total Workload (hour): | 200 | ||
1 ECTS = 25 Hours Workload
THE RELATIONSHIP BETWEEN COURSE LEARNING OUTCOMES (LO) AND PROGRAM QUALIFICATIONS (PQ)
| # | PQ1 | PQ2 | PQ3 | PQ4 | PQ5 | PQ6 | PQ7 | PQ8 | PQ9 | PQ10 | PQ11 | PQ12 |
| LO1 | ||||||||||||
| LO2 | ||||||||||||
| LO3 | ||||||||||||
| LO4 | ||||||||||||
| LO5 | ||||||||||||
| LO6 | ||||||||||||
| LO7 | ||||||||||||
| LO8 | ||||||||||||
| LO9 | ||||||||||||
| LO10 |
Contribution: 1 Low, 2 Average, 3 High