Module Descriptors
INFORMATION RETRIEVAL AND USE (WBL)
COIS50967
Key Facts
School of Computing and Digital Technologies
Level 5
15 credits
Contact
Leader: Janet Francis
Email: J.Francis@staffs.ac.uk
Hours of Study
Scheduled Learning and Teaching Activities: 24
Independent Study Hours: 126
Total Learning Hours: 150
Assessment
- COURSEWORK weighted at 100%
Module Details
Module Indicative Content
- Recap on design, mapping designs to implementations, normalisation and de-normalisation.
Introduction to the concept and use of a Database Management systems (DBMS)
o SQL: DML, DDL and DCL
o Developing applications with database tools
o Information Retrieval
o Levels of Information
o Information Management
o Use of Information
- Systems Architectures
- System testing methods
Introduction to the concept and use of a Database Management systems (DBMS)
o SQL: DML, DDL and DCL
o Developing applications with database tools
o Information Retrieval
o Levels of Information
o Information Management
o Use of Information
- Systems Architectures
- System testing methods
Module Additional Assessment Details
A report (circa 3000 words) covering all learning outcomes to comprise
- A working database which corresponds to the design.
- A User Manual
- A report containing a requested query statements and their output.
- A report covering testing strategies, testing outputs and analysis of results
- A working database which corresponds to the design.
- A User Manual
- A report containing a requested query statements and their output.
- A report covering testing strategies, testing outputs and analysis of results
Module Learning Strategies
An on-line Module Work Book is provided which will guide students through a series of tasks which will give structure to independent academic research, work based investigation and practical work based learning.
24 hours classroom teaching is advised but the precise delivery mechanism for this module is left flexible with each centre to choose a method suitable for the students involved. It is anticipated that broad coverage of the indicative content will be achieved through seminar sessions, which will include individual and group activities, discussions and case study analysis.
Outside the classroom, students will be encouraged to discuss aspects of the module within discussion forums that are part of the VLE. These forums will allow discussion with a student's peer group as well as the module tutor. Where group work is essential, students will be expected to utilise the VLE and other means of electronic communication to facilitate this.
Independent study will involve directed reading in order to gain and extend knowledge in areas of the indicative content not covered in depth by the classroom teaching.
Students are encouraged to seek re-enforcement of academic learning through practical experience in their own workplace. Work based learning will include the students working through exercises and tasks in the module work-book guided by their work-based Mentor. Employer Feedback Forms will be completed by the work-based mentor with formative feedback. This feedback will be discussed at regular reviews (usually two per teaching block) with the module tutor.
24 hours classroom teaching is advised but the precise delivery mechanism for this module is left flexible with each centre to choose a method suitable for the students involved. It is anticipated that broad coverage of the indicative content will be achieved through seminar sessions, which will include individual and group activities, discussions and case study analysis.
Outside the classroom, students will be encouraged to discuss aspects of the module within discussion forums that are part of the VLE. These forums will allow discussion with a student's peer group as well as the module tutor. Where group work is essential, students will be expected to utilise the VLE and other means of electronic communication to facilitate this.
Independent study will involve directed reading in order to gain and extend knowledge in areas of the indicative content not covered in depth by the classroom teaching.
Students are encouraged to seek re-enforcement of academic learning through practical experience in their own workplace. Work based learning will include the students working through exercises and tasks in the module work-book guided by their work-based Mentor. Employer Feedback Forms will be completed by the work-based mentor with formative feedback. This feedback will be discussed at regular reviews (usually two per teaching block) with the module tutor.
Module Texts
Systems Analysis and Design : Techniques, Methodologies, Approaches, and Architectures (Available as e-book in University library), Chiang, Roger Siau, Keng Hardgrave, Bill C. 2009 , M.E. Sharpe, Inc. eISBN: 9780765623768 (Edition: 4)
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)
(Information Systems Development: Methodologies, Techniques and Tools, Avison, G., Fitzgerald D.,2006. McGraw-Hill, ISBN-10: 0077114175, ISBN-13: 978-0077114176 (Edition: 4)
Object Oriented Systems and Design using UML, Bennett, S, Mcrobb, R., Farmer, S. 2010, McGraw Hill ISBN-10: 0077125363, ISBN-13: 978-0077125363, (Edition: 4)
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)
(Information Systems Development: Methodologies, Techniques and Tools, Avison, G., Fitzgerald D.,2006. McGraw-Hill, ISBN-10: 0077114175, ISBN-13: 978-0077114176 (Edition: 4)
Object Oriented Systems and Design using UML, Bennett, S, Mcrobb, R., Farmer, S. 2010, McGraw Hill ISBN-10: 0077125363, ISBN-13: 978-0077125363, (Edition: 4)
Module Resources
None.
Module Special Admissions Requirements
Prior Study of CESCOM10091-4: Professional and Academic Skills for ICT II or similar