Structural Programming
PİRİ REİS UNIVERSITY
FACULTY OF ECONOMIC AND ADMINISTRATIVE SCIENCES
|
Course Name : Advanced Web Design
|
Degree: Bachelor
|
|
Code
|
Year/Semester
|
Local Credits
|
ECTS Credits
|
Course Implementation, Hours/Week
|
|
Course
|
Tutorial
|
Laboratory
|
|
YBS 226
|
2/2 (spring)
|
3
|
5
|
3
|
0
|
0
|
|
Department
|
MANAGEMENT INFORMATION SYSTEMS
|
|
Instructors
|
Lect. Erhan Yıldırım
|
|
Contact Information
|
e-mail: eyildirim@pririreis.edu.tr
|
|
Office Hours
|
Monday 09:00- 12:00
|
|
Web page
|
http://pruonlinenew.pirireis.edu.tr/
|
|
Course Type
|
Compulsory
|
Course Language
|
English
|
|
Course Prerequisites
|
-
|
|
Course Description
|
The concepts and properties of web design and programming are described, PHP programming language is used. The content of the course includes, variables, control statements, array, html form controls, classes, functions, MySQL connection, read and write to database.
|
|
Course Objectives
|
The objective is to have advenced web programming design. To demonstrate the concepts of web design, opensource editor, apache server, mysql server is used. After completing this course students are expected to have depth knowledge about web programming, capable of solving 2 and 3 tier architectural problem and dynamic web design concepts and applications.
|
|
Course Learning Outcomes
|
By students who passed from Advanced Web Design YBS 226 successfully
- Knows the concept of web design and programming
- Able to access to database
- Coding using PHP/MySQL
- Creating dynamic web application
|
|
Instructional Methods and Techniques
|
The presentation of theoretical and practical techniques. Students are expected to do exercises in computer Lab and a project
|
|
Tutorial Place
|
(Classroom: A202)
|
|
Co-term Condition
|
-
|
|
Textbook
|
Fundamentals of Web Development ,R.Connolly, R. Hoar
|
|
Other References
|
Lecture notes, files and exercises.
|
|
Homework & Projects
|
Students will be required to solve problems presented in worksheets or online portal, to aid their efforts to follow the development of the course content and to prepare for the examinations.
|
|
Laboratory Work
|
-
|
|
Computer Use
|
Students will use computers during the practical sessions
|
|
Other Activities
|
|
|
Other Conditions
|
In case of plagiarism and cheating, university legislation is applied. Assignments must be submitted on the delivery date in accordance with the announced format. Assignments after the deadline are accepted with a 10 points penalty downgrade.
The student who does not take the exam must bring the doctor's report or inform the excuse by an e-mail. It is at the discretion of the instructor to make a make-up exam with the exception of the report status.
|
Success Requirements: Students must attend the course in accordance with the legislation, and if there is an excuse, they should report it at the appropriate time. One written midterm exam is given. 1 project assignments is given and expected to present them. These are all essential for the midterm grade. The percentage distributions is in the below table. The final term-end score is calculated by adding the final exam score.
Measurement and Evaluation Methods: The percentage distribution of related exams and projects are follows:
|
Assessment Criteria
|
Activities
|
Quantity
|
Effects on Grading, %
|
|
Attendance
|
1
|
10
|
|
Midterm
|
1
|
10
|
|
Quiz
|
|
|
|
Homework
|
|
|
|
Term Paper/Project
|
1
|
30
|
|
Laboratory Work
|
|
|
|
Practices
|
|
|
|
Tutorial
|
|
|
|
Seminar
|
|
|
|
Presentation
|
|
|
|
Field Study
|
|
|
|
Final Exam
|
1
|
50
|
|
TOTAL
|
|
100
|
|
Effects of Midterm on Grading, %
|
|
50
|
|
Effects of Final on Grading, %
|
|
50
|
|
TOTAL
|
|
100
|
|
ECTS/
WORKLOAD TABLE
|
Activities
|
Count
|
Hours
|
Total
Workload
|
|
Lecture
|
13
|
2
|
26
|
|
Midterm
|
|
|
|
|
Quiz
|
|
|
|
|
Homework
|
|
|
|
|
Term Paper/Project
|
1
|
25
|
25
|
|
Laboratory Work
|
13
|
2
|
26
|
|
Practices
|
|
|
|
|
Tutorial
|
|
|
|
|
Seminar
|
|
|
|
|
Presentation
|
|
|
|
|
Field Study
|
|
|
|
|
Final Exam
|
1
|
3
|
3
|
|
Individual Study for Mid term Exam (Preperation for lecture+exam)
|
1
|
26
|
30
|
|
Individual Study for Final Exam
|
1
|
25
|
25
|
|
Total Workload
|
|
|
125
|
|
Total Workload/25
|
|
|
150/25
|
|
Course ECTS Credits
|
|
|
5
|
Weekly Course Plan: The weekly course plan may vary according to the course speed. The related chapter of the book (_ch) is shown in parentheses:
|
Week
|
Topics
|
Course Outcomes
|
|
1
|
Introduction
|
|
|
2
|
Concept and properties
|
I
|
|
3
|
Data types
|
I,II,III
|
|
4
|
If..else, While loop, for loop, Switch case
|
I,II,III,IV
|
|
5
|
Classes, objects
|
I,II,III,IV
|
|
6
|
Superglobals
|
I,II,III,IV
|
|
7
|
Database API, SQL
|
I,II,III,IV
|
|
8
|
Accessing Mysql using PHP
|
I,II,III,IV
|
|
9
|
Mid-term exam
|
I,II,III,IV
|
|
10
|
MySql select
|
I,II,III,IV
|
|
11
|
MySql insert, update
|
I,II,III,IV
|
|
12
|
MySql where, order, functions
|
I,II,III,IV
|
|
13
|
Exercise Solutions
|
I,II,III,IV
|
|
14
|
Project Check-up and Review
|
I,II,III,IV
|
Relationship between the Course and the MANAGEMENT INFORMATION SYSTEMS Curriculum
|
|
Program Outcomes
|
Level of Contribution
|
|
1
|
2
|
3
|
|
a
|
To use concepts and theories related to different basic functions of business, to analyze and solve related process problems.
|
X
|
|
|
|
b
|
As managers of the business, making decisions using appropriate analytical and quantitative techniques.
|
X
|
|
|
|
c
|
Having research skills on how to obtain the necessary resources to evaluate and solve business problems.
|
|
X
|
|
|
d
|
When adapting information technology applications, be aware of relevant environmental, social and ethical rules
|
|
X
|
|
|
e
|
Using a foreign language and communicating verbally and in writing with colleagues from all over the world to follow new developments in business, management and information.
|
|
|
X
|
|
f
|
To demonstrate teamwork and leadership skills required in business environment and project management.
|
|
|
X
|
|
g
|
For information technology applications - for interdisciplinary work that can combine social and technical areas - to produce and analyze strategies that will improve operational efficiency, improve creativity and innovation.
|
|
X
|
|
|
h
|
Identify software, hardware, infrastructure, database and communication requirements according to business requirements, design the necessary components, make the selection, manage the system.
|
|
|
X
|
|
i
|
To create a project plan for an information system project, to analyze and document the necessary needs, to dominate the systematic database analysis, design and implementation stages, to give technical and managerial contributions, to take responsibility and to manage effectively.
|
|
|
X
|
|
j
|
To know programming and database logic and to use a modern programming language.
|
|
|
X
|
|
k
|
To have mastery of administrative / functional applications of enterprise information systems. To have knowledge about types of enterprise software, software selection and purchase decision, to plan and manage software development processes.
|
|
|
X
|
1: Small, 2: Partial, 3: Full
Programme Outcomes & Course Outcomes Connectivity Matrix
(Relationship between the Course and the MANAGEMENT INFORMATION SYSTEMS Curriculum)
|
|
|
Knows the concept of web programming
|
Able to access to database
|
Coding using PHP/MySQL
|
Creating dynamic web application
|
|
a
|
To use concepts and theories related to different basic functions of business, to analyze and solve related process problems.
|
1
|
1
|
2
|
2
|
|
b
|
As managers of the business, making decisions using appropriate analytical and quantitative techniques.
|
1
|
2
|
2
|
2
|
|
c
|
Having research skills on how to obtain the necessary resources to evaluate and solve business problems.
|
1
|
1
|
1
|
1
|
|
d
|
When adapting information technology applications, be aware of relevant environmental, social and ethical rules
|
3
|
1
|
2
|
1
|
|
e
|
Using a foreign language and communicating verbally and in writing with colleagues from all over the world to follow new developments in business, management and information.
|
2
|
2
|
2
|
2
|
|
f
|
To demonstrate teamwork and leadership skills required in business environment and project management.
|
1
|
1
|
2
|
2
|
|
g
|
For information technology applications - for interdisciplinary work that can combine social and technical areas - to produce and analyze strategies that will improve operational efficiency, improve creativity and innovation.
|
3
|
2
|
3
|
3
|
|
h
|
Identify software, hardware, infrastructure, database and communication requirements according to business requirements, design the necessary components, make the selection, manage the system.
|
3
|
3
|
3
|
3
|
|
i
|
To create a project plan for an information system project, to analyze and document the necessary needs, to dominate the systematic database analysis, design and implementation stages, to give technical and managerial contributions, to take responsibility and to manage effectively.
|
3
|
3
|
3
|
3
|
|
j
|
To know programming and database logic and to use a modern programming language.
|
1
|
1
|
2
|
2
|
|
k
|
To have mastery of administrative / functional applications of enterprise information systems. To have knowledge about types of enterprise software, software selection and purchase decision, to plan and manage software development processes.
|
2
|
2
|
2
|
3
|
|
Prepared by
LECT. ERHAN YILDIRIM
|
Date
15.01.2019
|
Signature
|