Parttime Classroom Business and administration and law

GY Advanced Excel / Spreadsheets L5

Module Aim

The purpose of this award is to equip the learner with the
knowledge, skill and competence to create and modify
spreadsheets under supervision, using common spreadsheet
features

Target Award

QQI Office Administration – 5M1997

Start Date: 08-01-2025 Hours/week: 03 Hrs 30 Mins Duration: 20 weeks

Timetable

Day Mornings Afternoons Evenings
Monday
Tuesday
Wednesday
Thursday
Friday
Education Requirements
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
Learning Outcomes of Level 5 Spreadsheet Methods 5N1977
Learners will be able to:
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.

Provider

Gorey Further Education and Training Centre


Location

Civic Square, The Avenue, Gorey, Co Wexford


Facilities

  • Pay Parking
  • Wheel Chair Access
  • Tea/Coffee Making

Contact Details

Course Contact:
Susan Neville

Email:
susanneville@wwetb.ie

Phone:
0861074556