Faculty Of Engıneerıng
Computer And Software Engıneerıng
Course Information
| WEB PROGRAMMING II | |||||
|---|---|---|---|---|---|
| Code | Semester | Theoretical | Practice | National Credit | ECTS Credit |
| Hour / Week | |||||
| CSE216 | Spring | 2 | 2 | 3 | 4 |
| Prerequisites and co-requisites | Yok |
|---|---|
| Language of instruction | English |
| Type | Elective |
| Level of Course | Bachelor's |
| Lecturer | Asst. Prof. Dr. Maryam Eskandari |
| Mode of Delivery | Face to Face |
| Suggested Subject | |
| Professional practise ( internship ) | None |
| Objectives of the Course | Analyze the basic working of dynamic websites Define to program in PHP Learn the basic working of databases Apply all acquired knowledge to your personal dynamic website by means of a real life example (for instance a Cultural events calendar, an Online Bookstore or a Content Management System)" |
| Contents of the Course | This course enables students to build dynamic database driven web sites using the PHP programming language. The course is explicitly meant for students with limited or no programming experience and discusses basic programming building blocks needed to create interactive, dynamic websites. We do not address in depth discussions of for instance object oriented programming. PHP is an open source based programming language widely used on the Internet for both commercial and non-commercial websites such as facebook. This course gives an introduction in programming with PHP in combination with some simple database techniques in order to be able to understand the working of dynamic websites. |
Learning Outcomes of Course
| # | Learning Outcomes |
|---|---|
| 1 | Making web pages dynamic using PHP |
| 2 | Integrating MySQL with PHP and make database connectivity |
| 3 | Understanding of advanced web server technologies |
| 4 | Knowledge of using the latest web development and programming technologies |
Course Syllabus
| # | Subjects | Teaching Methods and Technics |
|---|---|---|
| 1 | Introduction PHP and MySQL | Lecture, discussion, presentation |
| 2 | PHP Data Types | Lecture, discussion, presentation |
| 3 | Conditional Statements | Lecture, discussion, presentation |
| 4 | Loops (For, While, Do While, Foreach) | Lecture, discussion, presentation |
| 5 | PHP Functions | Lecture, discussion, presentation |
| 6 | Arrays and Array Functions | Lecture, discussion, presentation |
| 7 | Midterm | Lecture, discussion, presentation |
| 8 | MySQL Database Training | Lecture, discussion, presentation |
| 9 | Working with MySQL Admin | Lecture, discussion, presentation |
| 10 | Working with MySQL Admin | Lecture, discussion, presentation |
| 11 | SQL Queries | Lecture, discussion, presentation |
| 12 | SQL Queries | Lecture, discussion, presentation |
| 13 | Connecting local server to a remote server | Lecture, discussion, presentation |
| 14 | Using multiple servers using phpMyAdmin | Lecture, discussion, presentation |
| 15 | Adding and retrieving medias using phpMyAdmin | Lecture, discussion, presentation |
| 16 | Final Exam | Lecture, discussion, presentation |
Course Syllabus
| # | Material / Resources | Information About Resources | Reference / Recommended Resources |
|---|---|---|---|
| 1 | Learning PHP, MySQL, and JavaScript by Robin Nixon. |
Method of Assessment
| # | Weight | Work Type | Work Title |
|---|---|---|---|
| 1 | 40% | Mid-Term Exam | Mid-Term Exam |
| 2 | 60% | Final Exam | Final Exam |
Relationship between Learning Outcomes of Course and Program Outcomes
| # | Learning Outcomes | Program Outcomes | Method of Assessment |
|---|---|---|---|
| 1 | Making web pages dynamic using PHP | 1͵2͵3͵4 | 1͵2 |
| 2 | Integrating MySQL with PHP and make database connectivity | 1͵2͵3͵4 | 1͵2 |
| 3 | Understanding of advanced web server technologies | 1͵2͵3͵4 | 1͵2 |
| 4 | Knowledge of using the latest web development and programming technologies | 1͵2͵3͵4 | 1͵2 |
Work Load Details
| # | Type of Work | Quantity | Time (Hour) | Work Load |
|---|---|---|---|---|
| 1 | Course Duration | 14 | 4 | 56 |
| 2 | Course Duration Except Class (Preliminary Study, Enhancement) | 14 | 2 | 28 |
| 3 | Presentation and Seminar Preparation | 0 | 0 | 0 |
| 4 | Web Research, Library and Archival Work | 0 | 0 | 0 |
| 5 | Document/Information Listing | 0 | 0 | 0 |
| 6 | Workshop | 0 | 0 | 0 |
| 7 | Preparation for Midterm Exam | 0 | 0 | 0 |
| 8 | Midterm Exam | 1 | 2 | 2 |
| 9 | Quiz | 1 | 1 | 1 |
| 10 | Homework | 0 | 0 | 0 |
| 11 | Midterm Project | 0 | 0 | 0 |
| 12 | Midterm Exercise | 0 | 0 | 0 |
| 13 | Final Project | 0 | 0 | 0 |
| 14 | Final Exercise | 0 | 0 | 0 |
| 15 | Preparation for Final Exam | 1 | 2 | 2 |
| 16 | Final Exam | 1 | 1 | 1 |
| 90 | ||||