Module Descriptors
INFORMATION RETRIEVAL AND USE
COIS50860
Key Facts
Digital, Technology, Innovation and Business
Level 5
15 credits
Contact
Leader: Janet Francis
Email: J.Francis@staffs.ac.uk
Hours of Study
Scheduled Learning and Teaching Activities: 36
Independent Study Hours: 114
Total Learning Hours: 150
Assessment
- COURSEWORK weighted at 100%
Module Details
Module Additional Assessment Details
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.
The portfolio (a phased series of tasks) will comprise a series of practical exercises.
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 legislation
Database languages
SQL: DML, DDL and DCL
Developing applications with database tools
Information Retrieval
Levels of Information
Information Management
Use of Information
Related legislation
Module Learning Strategies
One lecture and a blocked 3-hour laboratory tutorial period each week.
The lecture will be used for keynote presentations.
Parts of the block tutorial (e.g. the first and last hour) will be tutored and will comprise a mix of delivered material (including presentations) and guided tutorial work, which will include individual and group activities.
Other parts of the block (e.g. the middle hour) will be set aside for untutored independent resource based learning. This will include problem based learning where students will be set a specific problem that requires a solution to be found, working through a tutorial book or analysing a case study. Every alternate week (six times in each 12-week teaching block), this session will be used as a surgery session for peer and self assessment to provide formative feedback and for guidance on assessment work.
Independent study will involve directed reading in order to extend knowledge in areas of the indicative content covered by the classroom teaching.
(1:n) 1, (1:20)2
Apprenticeships
The lecture will be used for keynote presentations.
Parts of the block tutorial (e.g. the first and last hour) will be tutored and will comprise a mix of delivered material (including presentations) and guided tutorial work, which will include individual and group activities.
Other parts of the block (e.g. the middle hour) will be set aside for untutored independent resource based learning. This will include problem based learning where students will be set a specific problem that requires a solution to be found, working through a tutorial book or analysing a case study. Every alternate week (six times in each 12-week teaching block), this session will be used as a surgery session for peer and self assessment to provide formative feedback and for guidance on assessment work.
Independent study will involve directed reading in order to extend knowledge in areas of the indicative content covered by the classroom teaching.
(1:n) 1, (1:20)2
Apprenticeships
Module Resources
ORACLE relational database management system or equivalent.
Module Special Admissions Requirements
Prior study of CE00825-1 IT Skills or equivalent
Disqualified Combination - CE00887-2 Information Retrieval and Use (Blended Learning Version) or equivalent
Disqualified Combination - CE00887-2 Information Retrieval and Use (Blended Learning Version) or equivalent
Module Texts
F D Rolland The Essence of Databases Prentice Hall 1998, ISBN: 0137278276
(Essential Reading)
(Essential Reading)