Spreadsheets QQI Level 5
Purpose
The purpose of this award is to enable the learner to acquire the knowledge, skills and competence to work independently and under supervision in an administrative role in a range of business contexts and/or to progress to further and higher education and training.
1.Investigate a range of common uses for spreadsheets.
2.Explore key spreadsheet elements including cells, cell references, numeric, alpha, and alphanumeric data, formulae, functions, graphs and macros.
3.Demonstrate common spreadsheet usability features to include use of toolbars, window management, sorting, and filtering.
4.Use spreadsheet design features involving data and cell formatting techniques which enhance understanding and legibility.
5.Automate routine multi-step tasks through the creation, execution, and management of simple macros.
6.Print complete or partial sections of a spreadsheet, formatted fit for presentation.
7.Use advanced spreadsheet features including absolute and relative cell references, conditional IF statements, statistical, financial, and date and time functions.
8.Generate a variety of types of graphs, with appropriate titles and labels, from spreadsheet data.
9.Produce a spreadsheet, with minimal supervision, that meets a simple design specification and is fit for purpose.
10.Demonstrate personal initiative and resourcefulness in editing and amending spreadsheets to ensure they are fit for purpose.
Target Award
QQI Business Administration – 5M2468
Start Date: 26-08-2025 Hours/week: 02 Hrs 00 Mins Duration: 33 weeks
NFQ Level 4 or equivalent when accessing a Level 5 programme.
CERFL proficiency at B2 for access to Level 5 courses for those whose first language is not English
Mature learner entry requirements available via the local ETB pathway
Additional requirements may apply to non-EU/EEA Applicants and may be subject to full international fees (Please refer to Information for International Learners)
*Each provider may have additional requirements, not outlined above.
Age Requirements
Minimum statutory school leaving age (16+)
Learning Aptitude
Applicants must have a motivation to learn, an interest in the subject and the ability to acquire the knowledge, skills and competencies set out in the course.
Previous Experience
Applicants must be able to demonstrate a moderate range of knowledge, skills and competencies relevant to the course, be able to work with responsibility and demonstrate the ability to work on their own initiative.
| Module | Award | Body |
|---|---|---|
| Spreadsheet Methods | Spreadsheet Methods (5N1977) | QQI |