Data Analysis

Search courses
Search staffs.ac.uk

Hit enter to search or ESC to close

This course will teach learners to understand and use data manipulation techniques to manipulate, transform and present data in a meaningful format. As part of this course you will develop skills and knowledge of producing spreadsheets applying automated formatting, scripting, formulas and functions, charts and objects to cleanse, analyse, and manipulate and present data to technical and non-technical audiences.

Course Overview

Content includes using Excel to perform the following:

Spreadsheets, Workbook and Worksheets
Importing Data and Data Types
Sorting and Filtering Data
Data Visualisation
Conditional Formatting
Calculations and Data Transformation
Formulas and Scripting
Charts and Tables
Pivot Tables

Award

After completing this course, you will receive 5 credits which can then be used for future learning.

Funding

The Stoke-on-Trent Higher Skills Accelerator is fully funded by the UK Shared Prosperity Fund in partnership with Stoke-on-Trent Council and offered free of charge to each participating individual.

Delivery method

On campus

Location

Stoke-on-Trent campus

Duration

This is a 4-week course with one 4-hour session per week.

There will also be an estimated 30 hour independent study time required.

Start date

4 September 2024

Entry requirements

This masterclass is open to anyone who lives in Stoke-on-Trent (paying council tax to Stoke-on-Trent city council), is 18 years old and over, and meets the following criteria:

Employed for one hour or more of paid work per week (including those temporarily away from work because they are sick or on holiday).
Temporary and permanent employees who are on fixed-term contracts or agency temping.
Self-employed people.
People on government-supported training programmes, engaging in any form of work, work experience, or work-related training.
People on maternity or paternity leave.

Cost

This course is free to all learners who meet the criteria above.

Staff

Robin Oldham

Course Director

Robin Oldham is Course Director for Computer Science and Digital Apprenticeships at Staffordshire University having worked in Higher Education for 20+ years as a Lecturer, Manager and Technology Professional

Robin's profile

Andrew Cartlidge

P/T Lecturer (Hrly) - Computing

How to apply

To apply for this course, please email employers@staffs.ac.uk