Modelling for Data Analytics (Level 8)

1. Analyse the major properties of database systems and their importance in an organization
2. Apply tools and techniques of data modelling and distinguish different types of data models and their uses
3. Evaluate object-oriented data modelling techniques
4. Appraise and critically analyse the process of creating the relational data model from user requirements
5. Design, implement and administer a database system with an appropriate database package
6. Formulate advanced SQL commands to manipulate the structure of a database and its contents and produce value-added reporting

The Modelling for Data Analytics module is assessed by 50% continuous assessment (x 2 CA’s at 25% each) and 50% proctored examination. The grades will accumulate over the two semesters. The use of continuous assessment is based on developing the learner’s ability to investigate, evaluate theories and concepts and apply them to a given scenario.

The 50% Proctored Written Examination will be case study based. The case study will be issued two hours before the examination for review. The examination will be two hours in duration and all questions will be based on the case study. Learners will be required to demonstrate the learning of concepts, theories etc by identifying issues in the case study and offering recommendations, with justifications.

Questions in the examination will be linked requiring learners to complete/attempt the first question before attempting the second and so on.

Mapping of Assessments to Module Learning Outcomes

Where the combined marks of the assessment and examination do not reach the pass mark the learner will be required to repeat the element of assessment that they failed. Reassessment materials will be published on Moodle after the Examination Board Meeting and will be aligned to the MIMLOs and learners will be capped at 40% unless there are personal mitigating circumstances.