Web App Development with PHP/SQL (5 cr)

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

Location and time

Laurea Tikkurila

Materials

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.

Teaching methods

This is a blended learning course.
Contact sessions will be conducted in daytime as well as in evenings.
Contact Sessions are in classroom at Tikkurila campus also conducted via Zoom

You can also participate in this course virtually by following online instructions and material.

Completion alternatives

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 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.

Evaluation scale

H-5

Further information

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).