Module Descriptors
INTRODUCTION TO WEB AND DATABASE TECHNOLOGIES
COIS30888
Key Facts
Faculty of Computing, Engineering and Sciences
Level 3
30 credits
Contact
Leader: Janet Francis
Email: J.Francis@staffs.ac.uk
Hours of Study
Scheduled Learning and Teaching Activities: 96
Independent Study Hours: 204
Total Learning Hours: 300
Assessment
- COURSEWORK weighted at 40%
- COURSEWORK weighted at 60%
Module Details
Module Additional Assessment Details
Coursework item 1 weighted at 40% covering learning outcome 2, comprising
- Interface design documentation
- A set of linked web pages demonstrating application of usability concepts and technical skills
Coursework item 2 (final assessment) weighted at 60% covering learning outcome 1, 3, 4 comprising
- A simple working database which corresponds to a given design.
- A report containing required query statements and their output.
- A web form which enables rows to be inserted and deleted from the database.
- Interface design documentation
- A set of linked web pages demonstrating application of usability concepts and technical skills
Coursework item 2 (final assessment) weighted at 60% covering learning outcome 1, 3, 4 comprising
- A simple working database which corresponds to a given design.
- A report containing required query statements and their output.
- A web form which enables rows to be inserted and deleted from the database.
Module Learning Strategies
The contact time will be broken down as follows:
48 hours of lectures, 48 hours of tutorials
Lectures will be used to deliver technical knowledge and academic concepts
Tutorials will be used to develop practical skills
48 hours of lectures, 48 hours of tutorials
Lectures will be used to deliver technical knowledge and academic concepts
Tutorials will be used to develop practical skills
Module Texts
The following are not essential texts but will provide useful background reading:
Introducing HTML5, New Riders, Lawson, B. Sharp, R. , 2011, ISBN-10: 0321784421, ISBN-13: 978-0321784421 (Edition: 2)
Prioritizing Web Usability, Nielsen, J., Loranger, H.,2006, New Riders, ISBN-10: 0321350316 | ISBN-13: 978-0321350312 (Edition: 1 )
Designing with Web Standards (Voices that Matter), Zeldman, J., 2009, New Riders, ISBN-10: 0321616952, ISBN-13: 978-0321616951 (Edition: 3)
HTML Dog: The Best-Practice Guide to XHTML and CSS, Griffiths. P. 2006, New Riders, ISBN-10: 0321311396, ISBN-13: 978-0321311399 (Edition: 1)
CSS: The Missing Manual (Missing Manuals), Sawyer McFarland, D. ,2009, Pogue Press / O'Reilly, ISBN-10: 0596802447, ISBN-13: 978-0596802448, (Edition: 2)
Designing Effective Database Systems (Available as e-book in University library), Riordan, R.M., 2005, Addison-Wesley Professional, ISBN-10: 0321290933 , ISBN-13: 978-0321290939 (Edition: 1)
Introducing HTML5, New Riders, Lawson, B. Sharp, R. , 2011, ISBN-10: 0321784421, ISBN-13: 978-0321784421 (Edition: 2)
Prioritizing Web Usability, Nielsen, J., Loranger, H.,2006, New Riders, ISBN-10: 0321350316 | ISBN-13: 978-0321350312 (Edition: 1 )
Designing with Web Standards (Voices that Matter), Zeldman, J., 2009, New Riders, ISBN-10: 0321616952, ISBN-13: 978-0321616951 (Edition: 3)
HTML Dog: The Best-Practice Guide to XHTML and CSS, Griffiths. P. 2006, New Riders, ISBN-10: 0321311396, ISBN-13: 978-0321311399 (Edition: 1)
CSS: The Missing Manual (Missing Manuals), Sawyer McFarland, D. ,2009, Pogue Press / O'Reilly, ISBN-10: 0596802447, ISBN-13: 978-0596802448, (Edition: 2)
Designing Effective Database Systems (Available as e-book in University library), Riordan, R.M., 2005, Addison-Wesley Professional, ISBN-10: 0321290933 , ISBN-13: 978-0321290939 (Edition: 1)
Module Resources
Access to suitable development environments, Modelling tools eg. QSEE Superlite
Web Page Editors such as Adobe Master Collection CS5, Microsoft Expression Studio
Database Management System such as Oracle, SQL Server
Web Page Editors such as Adobe Master Collection CS5, Microsoft Expression Studio
Database Management System such as Oracle, SQL Server
Module Special Admissions Requirements
None.
Module Indicative Content
The module will cover the following topics:
Interface Design
- Usability
- HCI
Web
- Standards
- Storyboarding and navigation maps
- HTML 5
- CSS
- Graphics
- Javascript
Databases
- Data Modelling ¿ use of ERDs
- Validation of data
- DDL and SQL
Web Database connectivity
Interface Design
- Usability
- HCI
Web
- Standards
- Storyboarding and navigation maps
- HTML 5
- CSS
- Graphics
- Javascript
Databases
- Data Modelling ¿ use of ERDs
- Validation of data
- DDL and SQL
Web Database connectivity