Dungarvan College,
Youghal Road, Dungarvan, Co. Waterford.

Email: dungarvancollege@wwetb.ie    Tel: 058 41184

Spreadsheet Methods 5N1977

Level: QQI Level 5 (5N1977)

Download: Course Description

Description: 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.

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.

Tutor: TBC

Fee: €240

Duration: 12 weeks

Start Date: 5th February 2019

Class Time: 6.30pm – 9.30pm

Day: Tuesday

Further Education

The prime aim of Post Leaving Cert Courses is to prepare students for entry to the workforce or to further education and training. more
Progression to WIT
Students from Dungarvan College who meet the eligibility requirements, may apply for preferential entry to WIT.
Online Applications
Applications are now being taken.

Night Classes 2019

Here at Dungarvan College we offer a variety of evening classes and day courses for those looking to learn a new skill or explore personal interests. You can now enrol and pay securely online for any of our courses. more
Dungarvan College, Dungarvan, Co. Waterford, Ireland.
Website by: Déise Design