Skip to main content

Web App Development with PHP/SQL (5 cr)

Code: R0315-3005

General information


Enrollment

18.05.2020 - 09.08.2020

Timing

24.08.2020 - 18.12.2020

Number of ECTS credits allocated

5 op

Virtual proportion

1 op

RDI proportion

4 op

Mode of delivery

80 % Contact teaching, 20 % Distance learning

Unit

Laurea Tikkurila

Campus

Laurea Tikkurila

Teaching languages

  • English

Seats

20 - 30

Degree programmes

  • Complementary competence, bachelor's studies in English (CCN2), Information and Communication Technologies (ICT)

Teachers

  • Arvind Sharma

Teacher in charge

Arvind Sharma

Groups

  • CCN220SY
    Complementary competence (bachelor’s studies), S20, Information and Communication Technologies (ICT)

Learning outcomes

The student is able to
- develop and implement interactive web applications using PHP and relational databases
- use the PHP programming language to implement server-side scripts that interact with a relational database
- use online collaborative tools to build and deploy PHP based web applications
- manage the deployment process of PHP based web applications

Teaching methods

New information here: You can also participate in this course virtually by following online instructions and material.

Old Information:
This is a blended learning course.
Contact sessions will be conducted in daytime as well as in evenings.

Location and time

Laurea Tikkurila

Learning materials and recommended literature

fi
Students will be able to build online system using PHP and mysql
an example of the online system
- A student can Sign-up (with validation)
- Login & Logout.
- After logging in a student can select the quiz from 1 to 5.
- Each quiz has 10 questions in it and each question has 4 multiple choice answers out of which only one is correct. Each quiz is of maximum 10 points (1 point for each correct answer).
- A student can pick the quiz and start answering. Once the quiz is submitted, final score should be displayed and the student name, student number, quiz number, score, result should be stored in database table.
- Teacher Login form with predefined username and password.
- A teacher is able to see individual student’s quiz and quiz result, score.

Alternative completion methods of implementation

According to the degree regulations “all students are entitled to demonstrate their competence. The
recognition and accreditation of prior competence is initiated by the students themselves. The
competence is recognised and accredited by the teacher responsible for the module or study unit or
another person designated by the director of the UAS unit. The assessment is carried out according to the
same criteria and grading scale as that adopted for the corresponding study unit.”

Content and scheduling

Php and Mysql App-
- A student can Sign-up (with validation)
- Login & Logout.
- After logging in a student can select the quiz from 1 to 5.
- Each quiz has 10 questions in it and each question has 4 multiple choice answers out of which only one is correct. Each quiz is of maximum 10 points (1 point for each correct answer).
- A student can pick the quiz and start answering. Once the quiz is submitted, final score should be displayed and the student name, student number, quiz number, score, result should be stored in database table.
- Teacher Login form with predefined username and password.
- A teacher is able to see individual student’s quiz and quiz result, score.

Further information for students

According to the degree regulations (section 18) “students must be present in the first contact session or
notify their teacher in charge if they cannot attend. If they fail to notify the teacher of their absence in the
first contact session, their enrolment will be rejected. Another student in the queue may be enrolled in the
study unit in the place of the absent student.” (Laurea degree regulations) In the case of online studies
the lecturer can also specify some other way than participation on an online meeting what is required
from the student so that he/she verifies his/her attendance on the study unit (Decision by the vice
president, education 7/2019).

Grading scale

H-5

Evaluation methods and criteria

Weekly Assignment Tasks
Grade 0-5
Submitting the all reports on weekly basis without failing the due dates.

1-2
PROFESSIONAL KNOWLEDGE BASIS, INFORMATION SEARCHING AND REPORTING
- use essential professional concepts when explaining various work practices and situations
- search for information in different sources
- report
PROFESSIONAL PRACTICE AND WORKPLACE DEVELOPMENT
- work under guidance using the skills and methods learned
- interact with customers and/or cooperation partners
- receive guidance
GROUP WORK, MANAGEMENT AND RESPONSIBILITY
- work as a member of a team
- plan the progress of his/her work and use of time under guidance
- work safely and in accordance with the professional code of conduct
- follow the provided instructions and rules
3-4
PROFESSIONAL DATABASE, INFORMATION SEARCH AND REPORTING
- use professional concepts in a consistent manner when explaining various work practices and situations
- gather information and use his/her knowledge basis
- report in the agreed manner
PROFESSIONAL ACTIVITIES AND DEVELOPMENT OF WORKING LIFE
- work using the skills and methods learned
- engage in professional interaction with customers and/or co-operation partners and identify their needs
- take part in guidance and utilise it
GROUP WORK, MANAGEMENT AND RESPONSIBILITY
- engage in goal-oriented work in a team
- plan and manage the progress of his/her work and use of time
- detect safety-related risks
- justify this/her actions in accordance with the professional code of conduct
5
PROFESSIONAL KNOWLEDGE BASIS, INFORMATION SEARCHING AND REPORTING
- use professional concepts Extensively
- compare and choose relevant information
- report and communicate in a professional manner
PROFESSIONAL PRACTICE AND WORKPLACE DEVELOPMENT
- work independently, using the skills and methods learned
- take responsibility for interaction with customers and/or co-operation partners and for responding to their needs
- anticipate his/her need for guidance
TEAMWORK SKILLS, LEADERSHIP AND RESPONSIBILITY
- promote the team’s work and team spirit
- manage his/her time appropriately, completing the agreed tasks at the required quality level
- work responsibly, applying the skills and methods learned plan and evaluate their work, taking safety and/or ethical aspects into consideration

“Students who have failed assignments or examinations required for passing
a study unit must supplement or retake their study attainment in a manner and schedule defined by the
teacher of the study unit. ... A failed examination or other study attainment can be retaken twice. A
failure to attend an actual examination is considered to be one completion attempt.” (Laurea degree
regulations.)
All staff and students of Laurea are expected to adhere to good scientific practices, which includes
appropriate referencing. Familiarise yourself with the practices and, if needed, ask for more information.
All study assignments are to be done as individual work unless otherwise instructed. [If Urkund is used
when assignments are checked, the lecturer will inform the students of this.]