E-Trade-E-Management

PİRİ REİS UNIVERSITY
FACULTY OF ECONOMICS AND ADMINISTRATIVE SCIENCES
Course Name : E-commerce
Degree: Bachelor
Code
Year/Semester
Local Credits
ECTS Credits
Course Implementation, Hours/Week
Course
Tutorial
Laboratory
UIT 301
2019-2020/2 (SPRING)
3 6
3
-
Department
Management Information Systems
Instructors
Dr. FARID HUSEYNOV
Contact Information
e-mail: fhuseynov@pirireis.edu.tr
Office Hours
Web page
Course Type
Selective
Course Language
English
Course Prerequisites
Course Category by Content, %
Basic Sciences
Engineering Science
Engineering Design
Humanities
30
35
35
--
Course Description
This course aims to teach students how to build a responsive e-commerce web page by using HTML5, CSS3 and PHP programming language. After learning the required technologies student will work on a small e-commerce project and present their project during the course.
Course Objectives
Objective of this course is to teach key technologies required to develop a dynamic database-driven e-commerce webpage.
Course Learning Outcomes
By students who passed from this course successfully;
I. Understand the relational model and relational database management system
II. Use SQL to store and retrieve data from relational databases
III. Use HTML and CSS to structure a web page
IV. Learn how to develop a responsive web page
V. Learn how to use PHP with a MySQL database
VI. How to develop a database-driven website
Instructional Methods and Techniques
Lectures, computer lab activities
Tutorial Place
Class, Lab
Co-term Condition
-
Textbook  Boehm, A., & Ruvalcaba, Z. (2015). Murach’s HTML5 and CSS3. Mike Murach & Associates.  Murach, J., (2019). Murach’s MySQL (2rd Edition). Mike Murach & Associates, Inc.
Other References  Murach, J., & Harris, R. (2010). Murach's PHP and MySQL. Mike Murach & Associates, Inc..
Homework & Projects
Students will be required to complete a programming project and submit assigned homeworks
Laboratory Work
---
Computer Use
---
Other Activities
---
Assessment Criteria
Activities
Quantity
Effects on Grading, %
Attendance
Midterm
1
40
Quiz
1
10
Homework
Term Paper/Project
1
50
Laboratory Work
Practices
Tutorial
Seminar
Presentation
Field Study
Final Exam
TOTAL
100
Effects of Midterm on Grading, %
50
Effects of Final on Grading, %
50
TOTAL
100
Week
Topics
Course Outcomes
1
Introduction to web development - Murach's HTML5 and CSS3 - ch1
III, IV
2
How to use HTML to structure a web page - Murach's HTML5 and CSS3 – ch3
III, IV
3
How to use CSS to format the elements of a web page - Murach's HTML5 and CSS3 – ch4
III, IV
4
More Skills on CSS - Murach's HTML5 and CSS3 – ch5-ch7
III, IV
5
An introduction to relational databases and SQL - Murach's MySQL, 2nd Edition (2015) by Joel Murach - Topic 1
I, II
6
How to retrieve data from a single table- Murach's MySQL, 2nd Edition (2015) by Joel Murach - Topic 2
I, II
7
How to retrieve data from two or more tables- Murach's MySQL, 2nd Edition (2015) by Joel Murach - Topic 3
I, II
8
How to insert, update, and delete data - Murach's MySQL, 2nd Edition (2015) by Joel Murach - Topic 4
I, II
9
How to code summary queries and subqueries - Murach's MySQL, 2nd Edition (2015) by Joel Murach - Topic 5-6 + MIDTERM
I, II
10
How to design a database- Murach's MySQL, 2nd Edition (2015) by Joel Murach - Topic 10
I, II
11
How to create databases, tables, and indexes- Murach's MySQL, 2nd Edition (2015) by Joel Murach - Topic 11
I, II
12
Introduction to web development with PHP
I, II, V,VI
13
How to code a PHP application
I, II, III,IV,V,VI
14
How to use PHP with a MySQL database
I, II, III,IV,V,VI
ECTS / WORKLOAD TABLE
Activity
Count
Hours
Total Workload
Course
14
3
42
Preparation for the lecture
12
3
36
Homeworks
Quiz
1
10
10
Presentations/ Seminars Preparation
0
0
0
Midterm(s) (Exam +Preparation)
1
20
20
Group Project
1
40
40
Lab.
0
0
0
Field Work
0
0
0
Final Exam (Exam +Preparation)
0
0
0
Total Workload
148
Course ECTS Credits
(Total Workload/ 25)
6
Relationship between the Course and the International Trade and Business Curriculum
Level of
Program Outcomes
Contribution
1
2
3
a
To be able to benefit from the basic disciplines of international business and trade (economics, business, law) and to have fundamental knowledge of these disciplines.
X
b
To be able to evaluate and interpret data, concepts and ideas in the field of international business and trade with scientific methods.
X
c
To obtain the ability to analyze international economic and trade developments, identify problems, express opinions and present solutions to problems in the organization.
X
d
To be able to comprehend the necessity of international competition and the unique business practices of different countries.
X
e
To be fully aware of the requirements of international (consumer and industrial goods) markets and be able to develop and decide strategies in finance, management, production and marketing, especially in times of crisis affecting international business environment.
X
f
To be able to foresee the processes and results of the decisions to be taken and the projects to be implemented, to take into account the cause - effect relationships and to develop a strategic approach.
X
g
To be able to focus on continuous improvement, take responsibility and be innovative in the area.
X
h
To be able to have leadership and management competencies that a manager and entrepreneur should have working at the international level.
X
i
To be able to work in teams, make horizontal and vertical communication based on professional sharing and interaction with experts in other fields, as well as having the ability to make intercultural communication.
X
j
To be able to use information and communication technologies along with the computer software at the level required by the field.
X
k
To be able to use information systems and software used in international trade operations and data analysis in addition to using computers.
X
l
To have the knowledge of at least B2 level English within the scope of European Language Portfolio Independent User and to use these qualities in verbal and written communication.
X
m
To act in accordance with social, scientific, cultural and ethical values and with the consciousness of social responsibility in various fields of international trade.
X
1: Small, 2: Partial, 3: Full
Relationship between the Course and the Maritime Business Management Curriculum
Program Outcomes
Level of Contribution
1
2
3
a
Having the ability to apply business, economics, law, logistics, transportation and maritime knowledge to maritime business management problems.
X
b
To be able to interpret and analyze the data related to maritime management and management, to be able to define the problems and to have the ability to bring up solution proposals.
X
c
Having the ability to identify, research and solve maritime business management problems.
X
d
Having the ability to communicate effectively and verbally.
X
e
To have planning, implementation and control skills in line with business functions and objectives in maritime businesses.
X
f
To have the ability to apply the information required by the legal, social and environmental aspects of all transportation operations connected with the business and maritime transport.
X
g
Within the scope of international, national and social maritime businesses, customers, users, stakeholders; having the ability to implement maritime business solutions taking into account the priorities of efficiency, efficiency, quality, safety, security and environment.
X
h
Ability to collect data on maritime transport and to develop strategies and plans.
X
i
Having the ability to use and develop contemporary business management techniques.
X
j
Obtaining creativity, interrogation, self-confidence, entrepreneurship and leadership qualities.
X
k
Having a universal, social, international, national and individual vision.
X
l
To have the ability to conduct multidisciplinary team work.
X
m
To have quality values.
X
1: Small, 2: Partial, 3: Full
Relationship between the Course and the Logistics Management Curriculum
Level of Contribution
Program Outcomes
1
2
3
a
To have advanced knowledge in related fields of logistics and transportation.
X
b
Able to work effectively with multidisciplinary teams or individually in national and international logistics and transportation areas both in theoretical and applied scope.
X
c
Able to identify, define, formulate and solve problems with theoretical and applied transportation and logistics knowledge.
X
d
Able to communicate oral and written effectively with logistics and transportation stakeholders, and can use a foreign language minimum B1 level in European Language Portfolio.
X
e
To have advanced competence on general, logistics, and transportation information technologies.
X
f
To have knowledge about logistics and transportation principles, policies, and legislations.
X
g
To have knowledge about corporate governance, legal framework, business practices and environmental effects with professional and ethical responsibility
X
h
Able to access information by searching text, visual and digital resources, and be able to use this information for interpreting and analyzing data, identifying problems, and offering solutions.
X
i
Able to use the theoretical and practical knowledge that learned from logistics and transportation companies with business management techniques.
X
j
Able to develop the project in logistics and transportation area, and can take responsibility and act as coordinator or participant as an individual or group member in accordance with project goals.
X
1: Small, 2: Partial, 3: Full
Relationship between the Course and the Economics and Finance Curriculum
Program Outcomes
Level of Contribution
1
2
3
a
Ability to analyze the theoretical information in the area of economics and finance, and to assess their implications in implementation.
X
b
Ability to acquire distinctive information in the area of social and behavioral sciences through academic, managerial, and politically focused written and visual resources
X
c
Ability to acquire knowledge by integrating information related to the field of economics and finance into computerized environments.
X
d
Ability to present obtained information by employing the technical skills required by the field of economics and finance (such as in computerized environments) in Turkish or English.
X
e
Ability to employ knowledge related to the field of economics and finance in decision-making, application, and the application of decisions.
X
f
Ability to produce multidisciplinary assessments and conduct analyses in harmony with the area of economics and finance, related sub-fields, and other social science areas.
X
g
Ability to incorporate and accurately assess ethical and Professional responsibilities.
X
h
Ability to establish effective high-level written and oral communications in Turkish and English.
X
i
To have a wide-range understanding for the incorporation of the effects of the field of economics and finance in a global context.
X
j
Having acquired lifelong learning skills.
X
k
Having wide knowledge on contemporary topics.
X
l
Being open and adaptive to novelty and varying condition
X
m
Having practical and theoretical technical knowledge for being able to obtain information and results through data analysis.
X
1: Small, 2: Partial, 3: Full
Relationship between the Course and the Management Information Systems Curriculum
Level of Contribution
Program Outcomes
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