IT Applications – Applications Software

This unit is expiring
The expiry date of this unit is 31/07/2026.

Overview

Framework:
Access to HE
Level:
Level 3
Unit No:
QU011411
Credits:
3
Guided learning hours:
Not available

Qualification Grading Type

Graded

Grade Descriptors

  • GD3-Application of skills
  • GD7-Quality

Unit Learning Outcomes

1.

Understand how to manage files and folders.

Assessment Criteria

  • 1.1
    Use the features of a Graphical User Interface effectively to navigate and to manipulate computer files.
  • 1.2

    Organise study materials and coursework into folders and files using an appropriate hierarchical structure.

2.

Be able to create word-processed documents using word processor application.

Assessment Criteria

  • 2.1

    Use features and formatting techniques of a word processing package to produce two documents appropriately.

  • 2.2
    Use advanced features such as multi-level numbering, column splitting and merging, borders, inserting images with wrap-around text to enhance word-processed document.
  • 2.3
    Use template and mail-merge facility to create standard document.
  • 2.4
    Use master documents, footnotes and endnotes, indexes, bookmarks and cross-references and table of contents facilities to create large document such as report.
3.

Be able to create a spreadsheet document to solve a simple and complex problem.

Assessment Criteria

  • 3.1

    Use standard features of a spreadsheet software to solve a specified problem.

  • 3.2
    Produce range of effective graphical representation of spreadsheet data such as combination charts, with appropriate titles and data labels.
  • 3.3

    Use advanced features of a spreadsheet package such as, absolute references, library functions, users defined functions, multiple worksheets, macros, and validation of input data to solve a complex problem.

4.

Be able to use presentation software application to present information effectively.

Assessment Criteria

  • 4.1

    Use a range of features and formatting techniques to produce a presentation that is clear, accurate and effective.

  • 4.2

    Use advanced features such as multiple slide master, slide transition, timing, movie & sound, animations and speaker notes to enhance and run a presentation