Designing dynamic webpages, using databases in web design, web site management
Vertical Tabs
Course Learning Outcomes
Learning Outcomes |
Program Learning Outcomes |
Teaching Methods |
Assessment Methods |
Dynamic Web Pages - PHP |
1-2-3-4 |
1-2-12 |
A,C |
Databases – MySQL |
7-10 |
1-2-12 |
A,C |
Course Flow
Week |
Topics |
Study Materials |
1 |
Introduction to PHP |
|
2 |
Data types, variables, arrays |
|
3 |
Adding control and logic to webpages |
|
4 |
Adding control and logic to webpages |
|
5 |
Strings, numbers and date |
|
6 |
Designing PHP pages with examples |
First 5 weeks |
7 |
Midterm |
|
8 |
PHP form design |
|
9 |
PHP forms and form validation, regex |
|
10 |
Introduction to SQL |
|
11 |
Designing dynamic webpages with MySQL and PHP |
|
12 |
Designing dynamic webpages with MySQL and PHP |
|
13 |
Designing dynamic webpages - Examples |
First 12 weeks |
14 |
Designing dynamic webpages - Examples |
First 12 weeks |
Recommended Sources
Textbook |
Ullman, Larry. Visual Quick Pro Guide, PHP 6 and MySQL 5 |
Additional Resources |
|
Material Sharing
Assessment
IN-TERM STUDIES |
NUMBER |
PERCENTAGE |
Mid-terms |
1 |
30 |
Quizzes |
5 |
30 |
Project |
1 |
40 |
Total |
|
100 |
CONTRIBUTION OF FINAL EXAMINATION TO OVERALL GRADE |
|
50 |
CONTRIBUTION OF IN-TERM STUDIES TO OVERALL GRADE |
|
50 |
Total |
|
100 |
COURSE CATEGORY |
Expertise/Field Courses |
Course’s Contribution to Program
No |
Program Learning Outcomes |
Contribution |
|||||
1 |
2 |
3 |
4 |
5 |
|||
1 |
Information Systems graduates have the knowledge and the skills to design and develop the complete systems for multi-media visual user interface. |
|
|
|
|
x |
|
2 |
Information Systems graduates have advanced the knowledge and skills to design, develop and install the application systems for multi-media. |
|
|
|
|
x |
|
3 |
Information Systems graduates have the knowledge and the skills to design, develop and apply algorithms and data structures to solve the basic problems of information processing, within the framework of discrete mathematics. |
|
|
|
|
x |
|
4 |
Information Systems graduates have the knowledge and the skills to design and develop computer applications, based on user specified requirements, using modern structured development tools and install them on various hardware platforms and deploy their usage. |
|
|
|
|
x |
|
5 |
Information Systems graduates have the knowledge and the skills to design and develop computer applications, based on user specified requirements, using modern object-oriented development tools and install them on various hardware platforms and deploy their usage. |
|
|
x |
|
|
|
6 |
Information Systems graduates know the logic of computer operating systems, the basic set of system commands, how to control access to system resources by users of different departments and how to monitor the running of jobs in the system. |
|
|
x |
|
|
|
7 |
Information Systems graduates have the knowledge and the skills to design and develop data models serving different requirements, database applications that would access and process data using various types of software, including queries, reports and business applications. |
|
|
|
|
x |
|
8 |
Information Systems graduates have the knowledge and the skills to design and develop business applications that would provide data access, modification and processing for data kept in enterprise database systems. |
|
|
|
x |
|
|
9 |
Information Systems graduates have the knowledge about computer networks, and have the skills to design, develop and monitor computer networks, how to configure them and how to maintain their performance. |
|
|
x |
|
|
|
10 |
Information Systems graduates have the knowledge and the skills to design and develop visual user interfaces for the web, web-based applications for n-tier client/server configurations, how to deploy them in enterprises. |
|
|
|
|
x |
|
11 |
Information Systems graduates, within his/her job responsibilities can communicate the necessary information both written and orally in Turkish, English and another foreign language, respecting the values the societal institutions and establishments, of which he/she has acquired in the program. |
|
|
|
|
|
ECTS
Activities |
Quantity |
Duration |
Total |
Course Duration (Including the exam week: 16x Total course hours) |
15 |
3 |
45 |
Hours for off-the-classroom study (Pre-study, practice) |
15 |
3 |
45 |
Mid-terms |
1 |
3 |
3 |
Quiz |
5 |
2 |
10 |
Project |
1 |
30 |
30 |
Final examination |
1 |
10 |
10 |
Total Work Load |
|
|
143 |
Total Work Load / 25 (h) |
|
|
5,72 |
ECTS Credit of the Course |
|
|
6 |