Core Module Information
Module title: Data Analytics and Wrangling

SCQF level: 10:
SCQF credit value: 20.00
ECTS credit value: 10

Module code: SET10714
Module leader: Sana Ullah Jan
School School of Computing, Engineering and the Built Environment
Subject area group: Computer Science
Prerequisites

Requisites: AND Pre-requisite: A suitable mathematics qualification including statistics. Experience with relational databases. AND Pre-requisite: [Module SET09702] Database Technology

Description of module content:

The challenges of contemporary data acquisition and analysis provide new challenges as unstructured data and information reaches the web, e.g. text reviews, social media data, etc. These require the use of specialised data storage, aggregation and processing techniques. This module introduces a range of tools and techniques necessary for working with data in a variety of formats with a view to developing data driven applications. The module focuses primarily on developing applications using the Python scripting language and associated libraries, data analysis and evaluation modelling techniques as well as visualisation approaches. The module covers the following topics:• Data Preparation – Data collection, feature generation and data selection. • Data Pre-processing – data quality, data cleaning, data integration• Data Analysis – techniques of analysing data, such as correlation, regression, forecasting, classification, clustering, including a variety of machine learning methods that are widely used in data mining• Post processing – data visualisation, interpretation, evaluation• Data types and formats: numerical and time series, textual, unstructured • Data sources and interfaces: open data, APIs, social media, web-based• Techniques for dealing with heterogeneous data sets• Developing Data Driven Applications in PythonTools used in this module include Weka, OpenRefine, Pandas, SciPy, NLTK, or R.The Benchmark Statement for Computing specifies the range of skills and knowledge that should be incorporated in computing courses. This module encompasses cognitive skills in Computational Thinking, Modelling and Methods and Tools, Requirements Analysis and practical skills in specification, development and testing and the deployment and use of tools and critical evaluation in addition to providing useful generic skills for employment.

Learning Outcomes for module:

Upon completion of this module you will be able to

LO1: Analyse the concepts and process of data analysis, including pre-processing and preparation of data.

LO2: Analyse and evaluate modelling methods and techniques in data analysis.

LO3: Integrate data analysis algorithms to conduct data analysis and visualisation.

LO4: Critically interpret and evaluate results generated by analysis techniques.

LO5: Integrate specialised techniques for dealing with heterogeneous data sets.

Full Details of Teaching and Assessment
2023/4, Trimester 1, FACE-TO-FACE,
VIEW FULL DETAILS
Occurrence: 001
Primary mode of delivery: FACE-TO-FACE
Location of delivery: UK PARTNER
Partner:
Member of staff responsible for delivering module: Sana Ullah Jan
Module Organiser:


Student Activity (Notional Equivalent Study Hours (NESH))
Mode of activityLearning & Teaching ActivityNESH (Study Hours)
Face To Face Practical classes and workshops 18
Online Guided independent study 182
Total Study Hours200
Expected Total Study Hours for Module200


Assessment
Type of Assessment Weighting % LOs covered Week due Length in Hours/Words
Project - Practical 30 1,2 3 HOURS= 12
Project - Practical 70 3,4,5 4 HOURS= 28
Component 1 subtotal: 100
Component 2 subtotal: 0
Module subtotal: 100
2023/4, Trimester 3, In Person,
VIEW FULL DETAILS
Occurrence: 001
Primary mode of delivery: In Person
Location of delivery: MERCHISTON
Partner:
Member of staff responsible for delivering module: Sana Ullah Jan
Module Organiser:


Student Activity (Notional Equivalent Study Hours (NESH))
Mode of activityLearning & Teaching ActivityNESH (Study Hours)
Face To Face Practical classes and workshops 18
Online Guided independent study 182
Total Study Hours200
Expected Total Study Hours for Module200


Assessment
Type of Assessment Weighting % LOs covered Week due Length in Hours/Words
Project - Practical 30 1~2 3 HOURS= 12
Project - Practical 70 3~4~5 4 HOURS= 28
Component 1 subtotal: 100
Component 2 subtotal: 0
Module subtotal: 100

Indicative References and Reading List - URL:
Contact your module leader