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.

To have achieved equivalent to QQI Level 4 Certificate, or equivalent life/work experience.

QQI 5N1977 Spreadsheet Methods Component Certificate

Options for you to complete your Course:

- You can book 'Live' Tutor, scheduled weekly classes, OR

- You can book One-to-One Private classes with a Tutor, OR

- You can book an eLearning Online Course only.

  1. Facilitate the Learner to investigate a range of common uses for spreadsheets.

    1. Learner explains the term spreadsheet and explores different uses for spreadsheets and why you would choose a spreadsheet over other software applications.

    2. List applications suitable for creating a spreadsheet.

  2. Explore key spreadsheet elements including cells, cell references, numeric, alpha, and alphanumeric data, formulae, functions, graphs and macros.

    1. Learner to explain the terms, spreadsheet, row, column cell, cell reference, label, value, formula, formula bar, name box, and autofill.

    2. Learner understands how and why to input different cell types: numeric, characters and alphanumeric data.

    3. Use of formula for summation, addition, dividing and multiplying.

    4. Copy formula across a range of cells using relative and absolute cell references.

    5. Explore the use of autofill, graphs and macros.

    6. Create a chart from specified cell ranges and insert titles and axis labels.

  3. Demonstrate common spreadsheet usability features to include use of toolbars, window management, sorting and filtering.

    1. Demonstrate opening, saving and closing spreadsheets.

    2. Viewing spreadsheets by freezing panes, arranging windows and switching from one window to another.

    3. Using edit functions and explore the sorting facility, including custom sort.

    4. Create a data filter on one or more columns, to include text, numbers, colour, incorporating the use of equals, less than, and greater than.

    5. Use alignment features in cells, including wrap text and merge and centre.

    6. Save a spreadsheet to a specified drive/folder.

  4. Use spreadsheet design features involving data and cell formatting techniques which enhance understanding and legibility.

    1. Create a new spreadsheet, open, edit, insert new rows and columns and delete unwanted rows and columns.

    2. Enter specified data into a spreadsheet.

    3. Explore toolbar design features to include inserting and deleting columns and rows, and adjusting column width.

    4. Format data to include decimal, date, currency, percentage.

    5. Enhance the display of cells using font enhancement features including borders and fill colour.

    6. Adjust the width and height of rows and columns as required to display data appropriately.

  5. Automate routine multi-step tasks through the creation, execution, and management of simple macros.

    1. Create and execute simple automated macros with specified commands.

  6. Print complete or partial sections of a spreadsheet, formatted fit for presentation.

    1. Print an entire workbook, active sheet and selection on a sheet.

  7. Use advanced spreadsheet features including absolute and relative cell references, conditional IF statements, statistical, financial, and date and time functions.

    1. Perform calculations using formulae containing both absolute and relative cell references.

    2. Perform calculations using statistical functions such as AVERAGE, MIN, MAX, MEDIAN, COUNTA, COUNTIF.

    3. Use conditional IF statements, using logical operators AND, OR, NOT.

    4. Perform calculations using financial functions DEPRECIATION, and/or NPV and/or PMT.

    5. Perform calculations using date and time functions.

  8. Generate a variety of types of graphs, with appropriate titles and labels, from spreadsheet data.

    1. Create at least two different graph types – bar chart and pie chart.

  9. Produce a spreadsheet, with minimal supervision, that meets a simple design specification and is fit for purpose.

    1. Create a design specification for a spreadsheet including data input and format, data processing, data output and formatting.

  10. Demonstrate personal initiative and resourcefulness in editing and amending spreadsheets to ensure they are fit for purpose.

    1. 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.

Blended/Online with 'Live' Tutor sessions, Tutorials and One-to-One sessions.

Blended/Online (See Virtual Learning Schedule) or Classroom Attendance: 10 x 3 hour classes

In full or Flexi-pay options available

Lir Business Services & Training Centre Ltd
Co. Westmeath,
Ph: 044-9342754

© Lir 2020