Module: CCO6005-20 Web Apps

Level: 6

Credit Value: 20

Module Tutor: Gary Renes

Module Tutor Contact Details: g.renes@bathspa.ac.uk

Please note that in order to take this module you must have studied CCO5103-20 The Responsive Web.

Please also note that this module is a pre-requisite for CCO6006-20 Tomorrow’s Web.

1. Brief description of module

This module builds on the front-end development techniques encountered in The Responsive Web to create database driven web apps. You learn how to handle database information, perform queries, and use the results to deliver dynamic content to the end user.

Web apps commences with an overview of database design and population using SQL, before moving onto deployments of PHP and XML to query tables and transport data. You also learn how to protect sensitive information as is passes between client and server, as well as troubleshoot connection and data handling errors as they occur.

2. Outline syllabus:

Topics covered in Web Apps include:

• The client-server model

• Database design principles

• Access control and security

• Web protocols and standards

• Database connection and querying via SQL.

• PHP array functions, while loops and conditionals

• Database result handling

• PHP session variables and HTML5 local storage

• User interface and data entry/handing (HTML5 forms, AJAX requests)

• Presentation of assets using PHP and JavaScript

3. Teaching and learning activities:

Class Hours

Learning is predominately lab-based, and evolves through a series of short programming tasks that reinforce understanding of the topics listed above. Lab sessions include the introduction of theoretical concepts and student-led presentations of development work. You are advised strongly to compile a ‘code repository’ locally or on a web-based service such as GitHub. The repository is a useful tool for version control, keeping track of specific coding techniques, and streamlining your workflow.

Independent Learning

Independent study helps consolidate and extend your lab-based learning. Short research and development tasks are set regularly to aid your review of in-class material, and to support your understanding of SQL, PHP and AJAX. Often these exercises encourage collaboration with one or more learning partners. You are provided with a bank of learning resources via Minerva that comprise tutor presentations (slides, notes), code snippets and links to LinkedIn Learning video tutorials. It is good practice to get into a routine of exploring these materials, giving yourself enough time to follow up on topics that interest you particularly or require further clarification.

Assessment Item 1:

• Assessment Type: Course Work

• Description: Social Media Clone

• % Weighting: 100%