This module will provide the student with a basic understanding of the principles of electronic spreadsheet use. It gives the learner an understanding of, and% the ability to apply, business, analytical and presentational graphics.
-
Creating a new spreadsheet
-
Modifying a spreadsheet structure.
-
Adding formula and Functions.
-
Use of function wizard.
-
Absolute and relative cell referencing.
-
Sorting records and applying Filters.
-
Conditional Formatting.
-
Spreadsheet protection.
-
Nested/Compound Functions.
-
Pivot Tables and Data Tables.
-
Lookup, What IF Analysis, Goal Seeking and PMT Functions.
-
Statistical Functions.
-
Use of business, analytical and presentation graphics.
Spreadsheets Introduction
Creating a new spreadsheet Modifying a spreadsheet structure.
Formulae and Functions
Adding formula and Functions. Use of function wizard. Absolute and relative cell referencing. Sorting records and applying Filters.
Conditional Formatting
Spreadsheet protection. Nested/Compound Functions. Pivot Tables and Data Tables.
Tools
Lookup, What IF Analysis, Goal Seeking and PMT Functions.
Statistical Functions.
Use of business, analytical and presentation graphics.
lectures, practical demonstrations, self-directed learning, computer-based learning
| Module Content & Assessment | |
|---|---|
| Assessment Breakdown | % |
| Other Assessment(s) | 100 |