Core Module Information
Module title: Data Wrangling

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

Module code: SET11821
Module leader: Dimitra Gkatzia
School School of Computing, Engineering and the Built Environment
Subject area group: Computer Science


Description of module content:

Data Wrangling is the process of transforming and mapping data from "raw" data formats into other formats with the intent of making it more appropriate and valuable for a variety of downstream purposes such as analytics. This may include further data processing, visualisation, aggregation, training a statistical model, as well as many other potential uses. Data Wrangling includes several steps, starting with extracting the data in a raw form from the data source, processing the raw data using specialised algorithms (e.g. NLP approaches for text processing), storing using appropriate data structures (e.g. lists, matrices etc.) and finally utilise the resulting content into a data sink for storage and future use, such as training machine learning models.

Contemporary data acquisition and analysis has to address several challenges including the variety of data sources, the volume of data, validity 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 and will also introduce a range of associated data processing technologies and techniques.

The module covers the following topics:

• 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 text data such as vectorisation, bag of words, word embeddings
• Supervised Machine Learning approaches
• Developing and evaluating Data-Driven Applications in Python

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:

On completion of this module, students will be able to:
LO1: Critically evaluate the tools and techniques of data extraction, interfacing, aggregation and processing
LO2: Select and apply a range of specialised data types, tools and techniques for data extraction, interfacing, aggregation and processing
LO3: : Experiment with specialised techniques for dealing with complex text data sets, such as Natural Language Processing and machine learning.
LO4: Design, develop and critically evaluate data-driven applications in Python

Full Details of Teaching and Assessment
2022/3, Trimester 2, ONLINE, Edinburgh Napier University
Occurrence: 001
Primary mode of delivery: ONLINE
Location of delivery: WORLDWIDE
Partner: Edinburgh Napier University
Member of staff responsible for delivering module: Dimitra Gkatzia
Module Organiser:

Learning, Teaching and Assessment (LTA) Approach:
The online module presence has been designed to provide a clear roadmap for students to work through the learning materials. Module specific materials designed to support your studies are detailed in the module descriptors. This include items such as:
• A module introduction/overview, including learning outcomes, and summary of key learning points.
• Units of Learning materials, (subject specific units).
• Recorded keynote lectures/guest speakers (where appropriate).
• Case Studies (and outline solutions).
• Online discussions instigated and moderated by the module leader.
• Self-Assessment Questions,
• Reflective Exercises.
• End of Unit Progress tests.
• Links to core module academic materials; book chapters / journal articles / case materials etc.
• Additional readings – electronic links to journal articles, chapters etc.

In addition to this, online students are provided with online support in the form of:
• Dedicated online administrators who will keep track of student progress and will help you if you are having any problems.
• A dedicated interactive database of frequently asked questions specific to the online learning environment.
• A regular ‘virtual office hour’ will be held where module staff will be available for contact with you.

Teaching will concentrate on the critical analysis of the underlying principles and theories, and of their implementation in the Python language and relevant specialised code libraries, (LOs 1 - 4). Students are expected to spend a substantial proportion of their time doing practical programming exercises and researching the underlying principles and theories, and related academic literature (LOs 1 - 4). The practical materials are organised and selected for enhancing students’ understanding of the theories/principles covered.

Formative Assessment:
A variety of both formative and summative assessment methods are used in this module. The module is assessed on whether you have met its learning outcomes. You will be provided with formative feedback throughout the module through the use of self-assessment questions and case studies, both of which have outline solutions. This formative feedback will be available once the task is completed and will provide you with information to enable you to assess your progress and your level of understanding and provide you with constructive guidance to inform your development. Reflective Exercises within each unit will enable you to apply theory to practice – this is not assessed, but it will support your personal and professional development.

Summative Assessment:
Summative assessment will comprise of one practical coursework worth 100% of the final mark (covering LOs 1- 4). An element of this coursework will be submitted around week 7 to give some formative feedback (30%: L.Os 1, 2), with the main submission being at the end of the module (70%: LOs 3, 4) after which the final feedback will be given.

Student Activity (Notional Equivalent Study Hours (NESH))
Mode of activityLearning & Teaching ActivityNESH (Study Hours)
Online Lecture 12
Online Practical classes and workshops 24
Online Tutorial 15
Independent Learning Guided independent study 109
Online Guided independent study 40
Total Study Hours200
Expected Total Study Hours for Module200

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

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