Your Cart

Basic end User Computing - Module 2

Program 2: Introduction to Spreadsheet Applications

Introduction

The Introduction to Word Spreadsheet Applications course is part of our Basic End-User Computing Skills Programme, designed to equip learners with practical computer skills for school, work, and personal use. This course provides a solid foundation in digital literacy by covering the most essential features of spreadsheet processing software.

Knowledge Covered

Area 1: Spreadsheet Fundamentals

Area 2: Entering, Managing, and Organizing Data

Area 3: Formatting and Visual Clarity

Area 4: Calculations and Formulas

Choose a pricing plan

Basic End-User Computing Module 2

ZAR850

Course curriculum

Spreadsheet Fundamentals

1. What is a Spreadsheet and How It’s Used_________ 2. Structure and Components of a Spreadsheet

3. Opening and Creating a Spreadsheet____________4. Saving Spreadsheets in Various Formats (CSV, PDF, Text)

Entering, Managing and Organising Data

1. Working with Existing Data_____2. Using Multiple Spreadsheet

3. Editing Columns and Rows_____4. Copying and Pasting Data

Formatting and Visual Clarity

1. Formatting Cells (Text, Numbers, Currency, Fonts)___2. Page Formatting (Margins, Orientation, Page Numbers)

3. Page Navigation and Printing__________________4. Using Help Functions in Software

Calculations and Formulas

1. Basic Mathematical and Statistical Principles_______2. Using Built-in Functions of a Spreadsheet Software

3. Formatting Numbers and Formulas

1

Introduction Video
- Introduction to Spreadsheet Applications Video
2

Section 1: Spreadsheet Fundamentals
- Lecture 1: KT0201 What is a Spreadsheet and How It’s Used
- Lecture 2: KT0202 Open & Create a Spreadsheet
- Lecture 3: KT0212 Structure & Components of Spreadsheet Applications
- APPLICATION TASK - BEUC020201
- PRACTICAL 1 -KM02-KT01_02_12
- Lecture 4: KT0204 Saving Spreadsheets in Various Formats (CSV, PDF, Text)
- APPLICATION TASK - BEUC020202
- ASSIGNMENT 1 - KM02-KT0201/02/04/12
3

Section 2: Entering, Managing, and Organizing Data
- Lecture 5: KT0203 Working with Existing Data
- Lecture 6: KT0205 Using Multiple Spreadsheets
- Lecture 7: KT0207&09 Editing Rows & Columns and Copying & Pasting Data
- APPLICATION TASK BEUC020203
- PRACTICAL 2
- ASSIGNMENT 2
4

Section 3: Formatting and Visual Clarity
- Lecture 8: KT0206 & KT0211- Formatting Cells & Page Formatting
- APPLICATION TASK BEUC020204
- PRACTICAL 3
- Lecture 9: KT0208 & KT0210: Page Navigation and Printing & Using Help Functions in Software
- PRACTICAL 4
- ASSIGNMENT 3
5

Section 4: Calculations and Formulas
- Lecture 10: KT0213&14 Basic Mathematical and Statistical Principles & Fundamental Features of spreadsheets
- PRACTICAL 5
- APPLICATION TASK BEUC020205
- ASSIGNMENT 4