Module Descriptors
INFORMATION RETRIEVAL AND USE (WBL VERSION)
COIS50752
Key Facts
School of Digital, Technologies and Arts
Level 5
15 credits
Contact
Leader: Janet Francis
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 Resources
ORACLE relational database management system, or equivalent.
Module Learning Strategies
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 Indicative Content
Entity models, relational design, mapping designs to implementations, normalisation and de-normalisation.
Database languages
SQL: DML, DDL and DCL
Developing applications with database tools
Information Retrieval
Levels of Information
Information Management
Use of Information
Related Legist ration
Module Additional Assessment Details
A COURSEWORK weighted at 100%.

100% Coursework consisting of a portfolio assessing Learning Outcomes 1-3.

The portfolio (a phased series of tasks) will comprise a series of practical exercises. (3000 words max.)
Module Texts
F D Rolland The Essence of Databases Prentice Hall 1998, ISBN: 0137278276
(Essential Reading)
Module Special Admissions Requirements
Students must be in related employment and have access to a work-based Mentor
Prior study of CE00891-1 IT Skills or equivalent
Disqualified Combination - CE00873-2 Information Retrieval and Use