WEB PUBLISHING AND DATABASES - 2017/8

Module code: COM1025

Module provider

Computer Science

Module Leader

PANAOUSIS E Dr (Computer Sci)

Number of Credits

15

ECT Credits

7.5

Framework

FHEQ Level 4

JACs code

I200

Module cap (Maximum number of students)

N/A

Module Availability

Semester 1

Overall student workload

Independent Study Hours: 106

Lecture Hours: 33

Laboratory Hours: 22

Assessment pattern

Assessment type Unit of assessment Weighting
Coursework COURSEWORK 1 (INDIVIDUAL WORK) 40
Coursework COURSEWORK 2 (INDIVIDUAL WORK) 60

Alternative Assessment

N/A

Prerequisites / Co-requisites

N/A

Module overview

This module introduces students to various basic Web technologies. It covers key technologies for data presentation and transmission over the World Wide Web (WWW), enabling students to create simple static and dynamic web pages. It also introduces students to basic concepts of database management systems, issues involved in relational database design and practical skills of using a selected relational database management system – MySQL – to solve real-world problems. It also illustrates database connectivity in Web-based applications. The module uses a problem-based approach to provide students with the necessary support to improve their problem-solving skills by working on given and self-selected web application in lab sessions and coursework assignments.

Module aims

Introduce important key web publishing technologies

Introduce basic database concepts

Help students to develop their analytic skills via modelling data of real-world problems

Guide students to build simple but realistic web pages

Enhance students' problem-solving and teamwork skills

Learning outcomes

Attributes Developed
Understand how the World Wide Web works and how it relates to the wider context of the Internet KCT
Demonstrate an understanding of key Web Publishing technologies and their relationships: HTML, CSS, PHP, and XML KCT
 Build static and simple dynamic web pages CPT
Understand main issues in database design: data modelling, data definition, data manipulation, data retrieval KCT
Model data of a real-world application, construct a conceptual database schema, translate it into a logical relational schema, and implement it in SQL CPT
Appreciate importance of team work P

Attributes Developed

C - Cognitive/analytical

K - Subject knowledge

T - Transferable skills

P - Professional/Practical skills

Module content

The following topics will be covered:

• Basic concepts of the Internet and WWW

• Building simple static web pages using HTML and CSS

• XML and XHTML

• Building simple server-side dynamic web pages using PHP

• Databases and data modelling

o Basic concepts of databases and relational databases

o Entity-relationship (ER) data modelling including enhanced ER models (EER)

o The query language SQL (MySQL as an example)

o Using MySQL in PHP to build database-driven websites

Methods of Teaching / Learning

The learning and teaching strategy is designed to:

Help students to gain a basic understanding of important Web publishing and database technologies via hands-on experiences on data modelling of real-world applications, translating data models to relational databases and building websites for data presentation on the Web. The skills gained will allow them to extend their knowledge on Web publishing and databases via self-study and more practical work, and they are transferrable to other modules of the programme.

The learning and teaching methods include:

• 3 hours lecture per week x 11 weeks

• 2 hours lab session per week x 11 weeks

• 2 hours drop-in session per week x 11 weeks

• Use of e-voting questions in lectures and tutorials

• Use of online discussion forum

• Encouraging independent work in lab sessions at the beginning and discussion with the module lecturer/demonstrators towards the end to get “hot” feedback

• Diagnostic test in the middle of the term

 

Assessment Strategy

The assessment strategy is designed to provide students with the opportunity to demonstrate

• A clear understanding of key Web publishing and database concepts and relationships among them

• Ability to think logically (for data modelling and database design) and to programme reasonably (for coding part)

• Appreciation of importance of both theories and practical problem-solving skills

Thus, the summative assessment for this module consists of:

• CW1: Coursework for developing a website from a given one with errors and incomplete features (40%). This coursework tests LO1, LO2, and LO3 in a practical setting.

• CW2: coursework on relational database design and its use in Web publishing (60%). This coursework tests all learning outcomes in a practical setting. It will pay more attention on LO4, LO5, and LO6 which are not tested in CW1.

The two pieces of coursework will be due around Week 8 (CW1) and Week 12 (CW2), but the precise deadlines will be decided by the Department according at the beginning of the semester after considering all modules’ deadlines and balancing students’ overall workload.

CW1 has two main purposes: 1) to highlight the importance of HTML and CSS code validation and how to write professional code; 2) to test students’ capabilities of working with a given task to stimulate what a web developer is often asked to do in real-world scenarios (i.e., the developer does not choose what website to build and often has to pick up somebody else’s incomplete work). Providing a basic outline of a website (although with errors) will help students without any prior (Web) programming experience to do the first piece of coursework more confidentially and independently. CW2 will be designed to allow students to choose one topic among a number of given ones so that they can possibly combine the database design and website development work with their personal interests. The topics will be defined in such a way to cover diversity (in terms of meeting students’ interests) and to facilitate marking efficiency and consistency. A large number of topics self-selected by students in previous years will be used as a reference. CW1 will test how students understand basic theoretical concepts such as sessions and cookies and CSS selectors in the context of actual coding. CW2 will test how students understand and appreciate the importance of data modelling and database theories for developing professional websites.

Both CW1 and CW2 are highly practical and will test students’ problem-solving skills and programming proficiencies, and the coursework reports will allow assessment of students’ understanding of abstract concepts and their logical thinking capabilities.

Formative assessment and feedback

Feedback will be given to students via e-voting questions and answers in an interactive manner during lectures. For each lab session, students will be encouraged to discuss their work with the module lecturer and demonstrators after attempting all exercises independently for getting “hot” feedback. Feedback on CW1 will inform students about how to do better in CW2 especially on the website part. The online discussion forum will be another channel to constantly give feedback to students. A mid-term diagnostic test will help students to self-evaluate their progress and get further individual feedback.

 

Reading list

Reading list for WEB PUBLISHING AND DATABASES : http://aspire.surrey.ac.uk/modules/com1025

Programmes this module appears in

Programme Semester Classification Qualifying conditions
Computer Science BSc (Hons) 1 Compulsory A weighted aggregate mark of 40% is required to pass the module
Computing and Information Technology BSc (Hons) 1 Compulsory A weighted aggregate mark of 40% is required to pass the module
Software Development for Business BSc (Hons) 1 Compulsory A weighted aggregate mark of 40% is required to pass the module
Data Science for Health BSc (Hons) 1 Compulsory A weighted aggregate mark of 40% is required to pass the module

Please note that the information detailed within this record is accurate at the time of publishing and may be subject to change. This record contains information for the most up to date version of the programme / module for the 2017/8 academic year.