Programming with Data

Short name: PWD

SITS code: BUCI065H7

Credits: 15

Level: 7

Module leader: Alessandro Provetti

Lecturer(s): Alessandro Provetti

Aims

The aim of the module is to build on a first module on programming in Python with material which is relevant to students studying Data Science. As such, the module pursues a style of software development (in Python) that is centred on data manipulation, focussing on

the Python modules that are most commonly in use for Data Science
the Relational Data Model and SQL for data manipulation and data querying, and
the ethical issues related to Data Science that are required for accreditation by the British Computer Society (previously covered in the Information Systems module which is no longer compulsory).

Learning Outcomes

On successful completion of this module a student will be expected to be able to:

demonstrate satisfactory knowledge of Python modules that are specific to Data Science;
deal with different data formats and data sources (e.g., spatial data, time series data);
understand the organization of data in the relational data model, and show fluency in writing SQL queries;
understand and apply basic Python/SQL techniques for quantitative data analysis/visualisation.

Syllabus

Python modules for Data Manipulation/Data Science;
Basic Python data visualization;
The relational data model;
Querying and retrieving data using SQL;
basics on semi-structured information (XML/HTML),
Web data extraction, and
Ethics issues in Data Science.

Various topics will be demonstrated by practical lab sessions.

Guest lecturers from industry may present parts of certain topics.

Timetable

All dates and timetables are listed in the programme handbooks of individual programmes.

Coursework

This will include a set of 2 short coursework assignments related to the data analytics methods presented in class.

Assessment

Coursework assignments (20%) and a 2 hour exam (80%).

Department of Computer Science and Information Systems