Return to SAQA NQF ACCREDITATION page

Microsoft Excel (Intermediate) - Level 2

Programme

LP: MS Excel (Intermediate) - Level 2

Unit Standards

SAQA ID 116940: Use a Graphical User Interface (GUI)-based spreadsheet application to solve a given problem
(NQF Level 3, 6 Credits)

Course Duration

3 x Full Days: 08h30 to 16h30
(including 2 x 15 min Tea Breaks & 1 x 30 min Lunch Break)

This learning programme is intended for all persons who need to:

Use a Graphical User Interface (GUI)-based spreadsheet application to solve a given problem.

This Unit Standard is intended for people who need to plan, produce, use and spreadsheets to solve problems using a Graphical User Interface (GUI)-based spreadsheet application either as a user of computers or as basic knowledge for a career needing this competency, like the ICT industry.

Programme entry level requirements

It is assumed that people learning towards this Unit Standard are already competent in:

Mathematical literacy and communication skills at least at NQF level 2
Use generic functions in a Graphical User Interface (GUI)-environment (ID 117902 - NQF Level 1}
Use a Graphical User Interface (GUI)-based spreadsheet application to create and edit spreadsheets (ID 116937 - NQF Level 2)

UNIT STANDARD RANGE

This standard is applicable to any spreadsheet application that runs on any Graphical User Interface(GUI) operating system.

Where spreadsheets are referenced, it refers to a whole spreadsheet, a single page of a spreadsheet, or selected text in a spreadsheet.
Where wording are not exact for the chosen operating system, the learner can choose the equivalent item or option to demonstrate competence in the specific outcome or assessment criteria.

Programme Outcomes

This learning programme is outcomes-based which means we take the responsibility of learning away from the Skills Development Provider and place it in your hands.

In this unit, we will be covering the following learning outcomes:

• Use a Graphical User Interface (GUI)-based spreadsheet application to solve a given problem

During the workshop, the learner will complete several class activities that will form part of their formative assessment. In this, the learner can practise and explore new skills in a safe environment.

The learner should take the opportunity to gather as much information as they can use during their workplace learning and self-study.

The workshop will be followed by summative assessment tasks to be completed in your workplace. In some cases, the learner may be required to do research and complete the tasks in their own time.

Module 1

Use MS Excel to prepare and produce a spreadsheet to provide a solution to a given problem

Duration: Morning Session
(Day 1)

Define spreadsheet in terms of its purpose and use
Name examples of spreadsheet programs
Provide examples of spreadsheets that can be produced using a spreadsheet application
Explain the benefits of using a spreadsheet application for producing and working with spreadsheets
Identify and describe the properties of a spreadsheet
Identify and describe the properties of a spreadsheet in terms of its purpose and use
Work within organisational standards and procedures with MS Excel
Create a spreadsheet
Edit a spreadsheet
Format a spreadsheet
Apply security
Check and print the spreadsheet

Module 2

Use MS Excel to adjust settings to customise the view and preferences to suit the solution created for the given problem

Duration: Afternoon Session
(Day 1)

Switch toolbar menus off and on
Enlarge and make the view of the spreadsheet smaller
Change the way that the spreadsheet is viewed
Freeze cells to prevent scrolling
Change the default file location
Add a user name to the file

Module 3

Use MS Excel to work with multiple worksheets to suit the solution to the given problem

Duration: Morning / Afternoon Session
(Day 2)

Explain the purpose of using multiple worksheets within one spreadsheet file with examples
Open new worksheets
Rename worksheets in terms of their purpose within the solution to the given problem
Manipulate cells between worksheets
Delete a worksheet within a workbook (or spreadsheet)

Module 4

Use MS Excel to apply formulae to provide alternative solutions to the given problem

Duration: Afternoon Session
(Day 2)

Enter formulae taking into consideration the natural order of operation
Enter formulae to deliberately change the natural order of operation
Interpret formula error messages and the correct the formula accordingly
Demonstrate the difference between relative and absolute cell addressing by using it in a formula
Change data to test possible solutions to the given problem without having to change formulae
Create scenarios that demonstrate different possible outcomes

Module 5

Use MS Excel to apply simple built-in functions to the given problem

Duration: Morning Session
(Day 3)

Explain functions in terms of their purpose, use and construct
Apply simple mathematical functions to the given problem
Apply statistical functions that achieve the anticipated result

Module 6

Use MS Excel to apply formatting and special effects applicable to the given problem

Duration: Morning Session
(Day 3)

Explain methods of automatically formatting a spreadsheet
Create a spreadsheet using a template
Format cells using styles
Copy formats between cells
Use special effects to improve the presentation of the spreadsheet

Module 7

Use MS Excel to evaluate a spreadsheet to comply with the given problem

Duration: Morning Session
(Day 3)

Evaluate the spreadsheet for compliance with a given problem, appropriate formatting, readability, legibility, presentation, accuracy, and data integrity
Modify the spreadsheet if required and confirm compliance with the brief

Debrief & Conclusion

Debrief and conclude the programme by referring to each person’s objective for the course and ask whether they have achieved their objective

Duration: Afternoon Session
(Day 3)

Program Reflection
Program Evaluation
Summative Assessment

Google Sites

Report abuse