Spreadsheet Methods (Excel) - 5N1977
The aim of this award is to provide the Learner with the knowledge, skill and competence to use a spreadsheet software application to create and modify spreadsheets using spreadsheet features and functions in an efficient and accurate manner. On completion of this module, the learner will gain a thorough working knowledge of a spreadsheet application package, through developing good work practices and through the use of ancillary equipment and resources, such as a printer and materials, to produce professional worksheets and workbooks to a professional standard.
QQI Credits: 15
Facilitate the Learner to investigate a range of common uses for spreadsheets.
Learner explains the term spreadsheet and explores different uses for spreadsheets and why you would choose a spreadsheet over other software applications.
List applications suitable for creating a spreadsheet.
Explore key spreadsheet elements including cells, cell references, numeric, alpha, and alphanumeric data, formulae, functions, graphs and macros.
Learner to explain the terms, spreadsheet, row, column cell, cell reference, label, value, formula, formula bar, name box, and autofill.
Learner understands how and why to input different cell types: numeric, characters and alphanumeric data.
Use of formula for summation, addition, dividing and multiplying.
Copy formula across a range of cells using relative and absolute cell references.
Explore the use of autofill, graphs and macros.
Create a chart from specified cell ranges and insert titles and axis labels.
Demonstrate common spreadsheet usability features to include use of toolbars, window management, sorting and filtering.
Demonstrate opening, saving and closing spreadsheets.
Viewing spreadsheets by freezing panes, arranging windows and switching from one window to another.
Using edit functions and explore the sorting facility, including custom sort.
Create a data filter on one or more columns, to include text, numbers, colour, incorporating the use of equals, less than, and greater than.
Use alignment features in cells, including wrap text and merge and centre.
Save a spreadsheet to a specified drive/folder.
Use spreadsheet design features involving data and cell formatting techniques which enhance understanding and legibility.
Create a new spreadsheet, open, edit, insert new rows and columns and delete unwanted rows and columns.
Enter specified data into a spreadsheet.
Explore toolbar design features to include inserting and deleting columns and rows, and adjusting column width.
Format data to include decimal, date, currency, percentage.
Enhance the display of cells using font enhancement features including borders and fill colour.
Adjust the width and height of rows and columns as required to display data appropriately.
Automate routine multi-step tasks through the creation, execution, and management of simple macros.
Create and execute simple automated macros with specified commands.
Print complete or partial sections of a spreadsheet, formatted fit for presentation.
Print an entire workbook, active sheet and selection on a sheet.
Use advanced spreadsheet features including absolute and relative cell references, conditional IF statements, statistical, financial, and date and time functions.
Perform calculations using formulae containing both absolute and relative cell references.
Perform calculations using statistical functions such as AVERAGE, MIN, MAX, MEDIAN, COUNTA, COUNTIF.
Use conditional IF statements, using logical operators AND, OR, NOT.
Perform calculations using financial functions DEPRECIATION, and/or NPV and/or PMT.
Perform calculations using date and time functions.
Generate a variety of types of graphs, with appropriate titles and labels, from spreadsheet data.
Create at least two different graph types – bar chart and pie chart.
Produce a spreadsheet, with minimal supervision, that meets a simple design specification and is fit for purpose.
Create a design specification for a spreadsheet including data input and format, data processing, data output and formatting.
Demonstrate personal initiative and resourcefulness in editing and amending spreadsheets to ensure they are fit for purpose.
Create a spreadsheet with a specific purpose from a design specification demonstrating editing and amending skills to ensure spreadsheet is fit for the purpose it was designed.
Classroom-based, face-to-face 'Live Tutor instruction/in a classroom/and online class environment.
Blended learning (hybrid model where a portion of learning is classroom-based and a portion of which is online learning.
Tutor support available between classes (online, face-to-face, or by telephone).
QQI Level 4 Certificate, or equivalent life/work experience. A copy of your current Curriculum Vitae or certificate. It is expected that you will have a range of learning styles, strengths and needs related to the programme and have the capacity to take responsibility for your own learning within the managed classroom and online environment, provided by Lir Business Services & Training Centre.
Learners must reside in Ireland. This course is delivered through English. A competency test may be carried out for English language and literacy and/or computer skills to ensure that you have the skills necessary to complete the programme.
The following English language proficiency tests and results are acceptable :
IELTS Indicator Test The minimum score is 6 unless otherwise stated.
TOEFL iBT Special Home Edition The minimum score is 92 unless otherwise stated.
Duolingo English Test The minimum score required is 95 unless stated otherwise.
Exam English If you are unsure of your current level, you can take a free test on sites such as this one.
If you are unsure contact Lir Reception (044) 9342754 to speak to a qualified person who will be able to assist you.
IT/Computer Skills: sufficient working knowlege of computers. Learner must have access to a PC, laptop or mobile device with internet access, Windows 8 or later or a Mac with OSX 10.5 or later, a browser with the latest version of Microsoft Edge, Chrome, Firefox or Safari, Adobe Reader to view PDFs. Your device must have a working camera and audio. PC must be capable of playing video and audio files. We provide you with access to Microsoft 365 Office applications (Word, Excel, Powerpoint, Outlook, Teams).
Blended Learning: Learners must be self-motivated and be able to take responsibility for their own self-directed learning, outside the 'Live' Tutor online classes as they complete their blended learning course.
Reasonable Accommodation: Learners with a disability, medical condition or learning difficulty: In line with the Equal Status Acts 2000 to 2015 - Lir provides reasonable accommodation to meet the needs of our learners to ensure fairness and equality with others on the course.
Following successful completion, you will receive a QQI Level 5 component certificate in Spreadsheet Methods (5N1977) from QQI.
Quality and Qualifications Ireland (QQI) is the national awarding body for further education and training in Ireland. Lir Business Services & Training Centre Ltd is registered with QQI, as a Private Training Provider, to offer programmes leading to QQI awards on the National Framework off Qualifications in Ireland (N.F.Q.)
Learner Progression: Learners who successfully complete this module may use the associated credits towards a relevant Major Award.
Assessment: Project 50% and Examination: Practical 50%
Grading: Pass 50% - 64%, Merit 65% - 79%, Distinction 80% - 100%
See Lir Course Schedule
A Blended and Online Course with 'Live' Tutor classes, optional Virtual Office Hours and Tutorials. 2 x Workshops over 5 weeks or 8 x Evening Classes plus self-directed learning with online support.
This Programme comprises of 1 module. The duration of this module is typically 150 hours. This is a combination of 50 hours of Directed Learning and 100 hours of Self-directed learning. The 50 hours of Directed Learning takes place in Classroom Attendance and 'Live' Tutor Online Classes. Self-directed Learning is learner-led, and it includes self-directed study, through Lir eLearning Hub. This will entail preparation and reflection time on your part. There are Virtual Office Hours throughout the week also to give you the opportunity of meeting your Tutor online, if you have any queries.
Upon successful completion of a Major award, learners can progress to an award on the next level on the NFQ. Alternatively, the Higher Education Links Scheme (HELS) gives learners the opportunity to use their QQI Level 5/6 Major Award to apply through the CAO for a place in the first year of a higher education programme. In some instances, progression is on the basis of specific Level 5 or 6 Major Awards, Learners should check with the higher education institution prior to commencement. Components (Minor Awards), or achievement of less than 120 credits, will not suffice for progression under the HELS.
Course fee: Phone Lir Reception (044) 934 2754 for a quote.. Payment: 1) in full, or 2) flexi-payments, 3) funding, 4) in-company - separate quote You may qualify for funding by contacting your local Intreo/DSP Office.
22 July 2022 at 09:44:09