•   Web App Development with PHP/SQL R0315-3006 21.09.2021-31.12.2021  5 credits  (TON221SY, ...) +-
    Learning outcomes of the course
    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

    Teacher in charge

    Arvind Sharma

    Mode of delivery

    40% Face-to-face, 60% Distance learning

    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.

    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.

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

    Language of instruction
    • English
    Timing

    21.09.2021 - 31.12.2021

    Enrollment period

    24.05.2021 - 30.05.2021

    Group(s)
    • TON221SY
    • CCN221SY
    Seats

    20 - 30

    Unit

    Laurea Tikkurila

    Teacher(s)

    Arvind Sharma

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

    Programme(s)

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

    Campus

    Laurea Tikkurila

    RDI portion

    1 credits

    Virtual portion

    3 credits

    Evaluation scale

    H-5

    Alternative completion methods

    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.

    Location and time

    Laurea Tikkurila