You are viewing information for England.  Change country.

Data management and analysis

This module addresses some of the key concepts required for the traditionally important area of data management, and the increasingly important area of data analytics. You will gain a practical, legal and ethical understanding of how to access, query and manage data collections, using traditional relational databases and contemporary NoSQL approaches. Using real-world datasets, standard software packages and data visualisation techniques, you will learn how to organise and analyse data collections to answer questions about the world, as well as developing an appreciation of user needs surrounding data systems.

Modules count towards OU qualifications

OU qualifications are modular in structure; the credits from this undergraduate module could count towards a certificate of higher education, diploma of higher education, foundation degree or honours degree.

Browse qualifications in related subjects

Module

Module code
TM351
Credits

Credits

  • Credits measure the student workload required for the successful completion of a module or qualification.
  • One credit represents about 10 hours of study over the duration of the course.
  • You are awarded credits after you have successfully completed a module.
  • For example, if you study a 60-credit module and successfully pass it, you will be awarded 60 credits.
30
Study level
Across the UK, there are two parallel frameworks for higher education qualifications, the Framework for Higher Education Qualifications in England, Northern Ireland and Wales (FHEQ) and the Scottish Credit and Qualifications Framework (SCQF). These define a hierarchy of levels and describe the achievement expected at each level. The information provided shows how OU module levels correspond to these frameworks.
OU SCQF FHEQ
3 10 6
Study method
Distance Learning
Module cost
See Module registration
Entry requirements
See Entry requirements

Student Reviews

I completed the first presentation of this course. There were many issues with the Virtual Machine provided on a USB...
Read more

I really did enjoy this course, although it was quite divisive with a lot of people. TM351 covers quite a...
Read more

Request your prospectus

Explore our subjects and courses

Request your copy now

What you will study

This module will provide you with a broad overview of the concepts, techniques and tools of modern data management and analysis. It will compare traditional relational databases with an alternative model (a NoSQL database), and will help you learn how to choose the most appropriate means of storing and managing data, depending on the size and structure of a particular dataset and its intended use. You will be introduced to preliminary techniques in data analysis, starting from the position that data is used to answer a question, and introduced to a range of data visualisation and analysis techniques that will instil an understanding of how to start exploring a new data set.

To ensure that you are comfortable with handling datasets, you will explore a range of real-world datasets to illustrate the key concepts in the module. Sources such as data.gov.uk, the World Bank, and a range of other national and international agencies may be used to provide appropriate data. You will spend approximately equal time between issues in data management (technical and socio-legal issues in storing and maintaining datasets), and issues in data analytics (understanding how data can be used to answer questions).

The module is framed around a narrative that looks at how to manage and extract value and insight from a range of increasingly large data collections. At each stage, a comparison will be drawn between different ways of representing the data (for example, using different sorts of charts or geographical mapping techniques), and limitations of the mechanisms presented. To enable you to get a feel for the use of data, each stage will also include an overview of some data analysis techniques, including summary reporting and exploratory data visualisation. This module is driven by Richard Hamming's famous quote: 'The purpose of computing is insight, not numbers'.

Some of the key ideas are:

Introducing data analysis

Starting with a data file such as a spreadsheet, this unit will provide you with a brief introduction to some basic operations on simple data files. This will give you an opportunity to study an outline of the key ideas in the module and help you become familiar with the module software.

Concepts in data management

You will look at three key areas in data management: data architectures and data access (CRUD), data integrity, and transaction management (ACID). Each of these topics will be illustrated using a relational database, and one non-relational alternative. The advantages and limitations of each model are discussed.

Legal and ethical issues

Here you will consider the legal and ethical issues involved in managing data collections. You will be required to obtain and read (parts of) the Data Protection Act and the Freedom of Information Act, and demonstrate how these apply to issues in data management. You will also consider privacy, ownership, intellectual property and licensing issues in data collection, management, retrieval and reuse.

Concepts in data analytics

These sections will focus on using data to answer a real question; the focus will be on exploratory techniques (such as visualisation) and formulating a question into a form that can be answered realistically using the data that is available. Issues in processing techniques for large and real-time streamed data collections will also be addressed along with techniques and technologies (such as MapReduce) for handling them. In this part of the module you will use a statistical package such as the python scientific libraries and/or ggplot2 to visualise the data and carry out appropriate analyses.

If you are considering progressing to The computing and IT project (TM470), this is one of the OU level 3 modules on which you could base your project topic. Normally, you should have completed one of these OU level 3 modules (or be currently studying one) before registering for the project module.

Teaching and assessment

Support from your tutor

You will have a tutor who will help you with the study material, who will mark and comment on your written work, and whom you can ask for advice and guidance. We may also be able to offer group tutorials that you are encouraged, but not obliged, to attend. Where your tutorials are held will depend on the distribution of students taking the module. There will also be online tutorials and other collaborative activities (such as student forums), which will take place in the online forum for your tutor group. Throughout the module you can use this forum to keep in touch with your tutor and fellow students.

Contact us if you want to know more about study with The Open University before you register.

Assessment

The assessment details for this module can be found in the facts box above.

You must use the online eTMA system to submit your tutor-marked assignments (TMAs).

Future availability

Data management and analysis (TM351) starts once a year – in October (places are limited and in high demand, so enrol early). This page describes the module that will start in October 2018. We expect it to start for the last time in October 2021.

Regulations

As a student of The Open University, you should be aware of the content of the academic regulations which are available on our Student Policies and Regulations website.

    Course work includes:

    2 Tutor-marked assignments (TMAs)
    7 Interactive computer-marked assignments (iCMAs)
    End-of-module assessment
    No residential school

    Course satisfaction survey

    See the satisfaction survey results for this course.


    Entry requirements

    This is an OU level 3 module. OU level 3 modules build on study skills and subject knowledge acquired from previous studies at levels 1 and 2. They are only intended for students with recent experience of higher education in a related subject.

    To study this module you should be a competent and experienced programmer, comfortable in programming using a range of languages and environments. Normally, you should have completed Object-oriented Java programming (M250) and Algorithms, data structures and computability (M269).

    You are not expected to have a background in statistics, but should be comfortable working with mathematical concepts.

    You should also be able to:

    • use your computer to carry out tasks such as writing with a word-processor, creating and managing spreadsheets, saving and locating files, installing software and accessing a website
    • perform simple calculations
    • read and understand written English of a style and complexity characteristic of a professional magazine or quality newspaper
    • write clearly in English.
    If you have any doubt about the suitability of the module, please speak to an adviser.

    Register

    Start End Fee
    - - -

    No current presentation - see Future availability

    This module is expected to start for the last time in October 2021.

    Additional Costs

    Study costs

    There may be extra costs on top of the tuition fee, such as a laptop, travel to tutorials, set books and internet access.

    If you're on a low income you might be eligible for help with some of these costs after your module has started.

    Ways to pay for this module

    Open University Student Budget Account

    The Open University Student Budget Accounts Ltd (OUSBA) offers a convenient 'pay as you go' option to pay your OU fees, which is a secure, quick and easy way to pay. Please note that The Open University works exclusively with OUSBA and is not able to offer you credit facilities from any other provider. All credit is subject to status and proof that you can afford the repayments.

    You pay the OU through OUSBA in one of the following ways:

    • Register now, pay later – OUSBA pays your module fee direct to the OU. You then repay OUSBA interest-free and in full just before your module starts. 0% APR representative. This option could give you the extra time you may need to secure the funding to repay OUSBA.
    • Pay by instalments – OUSBA calculates your monthly fee and number of instalments based on the cost of the module you are studying. APR 5.1% representative.

    Joint loan applications

    If you feel you would be unable to obtain an OUSBA loan on your own due to credit history or affordability issues, OUSBA offers the option to apply for a joint loan application with a third party. For example, your husband, wife, partner, parent, sibling or friend. In such cases, OUSBA will be required to carry out additional affordability checks separately and/or collectively for both joint applicants who will be jointly and severally liable for loan repayments.

    As additional affordability checks are required when processing joint loan applications, unfortunately, an instant decision cannot be given. On average the processing time for a joint loan application is five working days from receipt of the required documentation.

    Read more about Open University Student Budget Accounts (OUSBA).  

    Employer sponsorship

    Studying with The Open University can boost your employability. OU courses are recognised and respected by employers for their excellence and the commitment they take to complete. They also value the skills that students learn and can apply in the workplace.

    More than one in ten OU students are sponsored by their employer, and over 30,000 employers have used the OU to develop staff so far. If the module you’ve chosen is geared towards your job or developing your career, you could approach your employer to see if they will sponsor you by paying some or all of the fees. 

    • Your employer just needs to complete a simple form to confirm how much they will be paying and we will invoice them.
    • You won’t need to get your employer to complete the form until after you’ve chosen your module.  

    Credit/debit card

    You can pay part or all of your tuition fees upfront with a debit or credit card when you register for each module. 

    We accept American Express, Maestro (UK only), Mastercard, Visa/Delta and Visa Electron. 

    Mixed payments

    We know that sometimes you may want to combine payment options. For example, you may wish to pay part of your tuition fee with a debit card and pay the remainder in instalments through an Open University Student Budget Account (OUSBA).


    For more information about combining payment options, speak to an adviser or book a call back at a time convenient to you.


    Please note: your permanent address/domicile will affect your fee status and therefore the fees you are charged and any financial support available to you. The fees and funding information provided here is valid for modules starting before 31 July 2019. Fees normally increase annually in line with inflation and the University's strategic approach to fees. 

    This information was provided on 19/12/2018.

    What's included

    Module website, online study materials, sample datasets and module software.

    Computing requirements

    A computing device with a browser and broadband internet access is required for this module.  Any modern browser will be suitable for most computer activities. Functionality may be limited on mobile devices.

    Any additional software will be provided from a hardware device e.g. DVD drive or USB stick or is generally freely available. However, some activities may have more specific requirements. For this reason, you will need to be able to install and run additional software on a desktop or laptop computer with either:

    • Windows 7 or higher
    • Mac OS 10.7 or higher
    • a modern Linux version

    The screen of the device must have a resolution of at least 1024 pixels horizontally and 768 pixels vertically.

    To participate in our online-discussion area you will need both a microphone and speakers/headphones. 

    Our Skills for OU study website has further information including computing skills for study, computer security, acquiring a computer and Microsoft software offers for students. 

    If you have a disability

    The OU strives to make all aspects of study accessible to everyone and this Accessibility Statement outlines what studying TM351 involves. You should use this information to inform your study preparations and any discussions with us about how we can meet your needs.

    To find out more about what kind of support and adjustments might be available, contact us or visit our Disability support website.