Office Automation Computer Course

Lesson 1 • Keyboard and Mouse Proficiency

Develops accurate typing habits and efficient mouse control. Speed and accuracy here reduce errors in all word processing and data entry tasks.

Lesson 2 • Operating System Navigation Basics

Covers desktop layout, taskbar, and system menus. Provides the navigational foundation every subsequent software application depends on.

Lesson 3 • Basic System Settings and Maintenance

Introduces display, sound, and user account settings. Empowers students to configure a comfortable, secure personal workspace.

Lesson 4 • Hardware and Peripherals Overview

Identifies core hardware components and their office roles. Establishes physical literacy needed before any software instruction begins.

Lesson 1 • Text Formatting and Styles

Applies fonts, sizes, bold, italic, and paragraph styles. Consistent formatting is the foundation of professional document appearance.

Lesson 2 • Document Creation and Text Entry

Covers opening, saving, and entering text in a word processor. Establishes the baseline document workflow all formatting skills build upon.

Lesson 3 • Lists, Tables, and Visual Elements

Creates bulleted lists, numbered lists, and formatted tables. These elements organise complex information clearly in business reports.

Lesson 4 • Reviewing and Finalising Documents

Uses spell check, grammar tools, track changes, and comments. Ensures documents are error-free and collaboration-ready before distribution.

Lesson 1 • Formulas and Core Functions

Builds formulas using arithmetic operators and essential functions. These skills enable automated calculations central to office data tasks.

Lesson 2 • Spreadsheet Interface and Navigation

Introduces cells, rows, columns, and workbook structure. Navigation fluency is required before any data entry or formula work begins.

Lesson 3 • Data Entry and Cell Formatting

Covers entering numbers, text, and dates with proper cell formats. Accurate formatting prevents calculation errors in later formula work.

Lesson 4 • Charts and Data Visualisation

Creates bar, line, and pie charts from spreadsheet data. Visual outputs communicate trends and comparisons in reports and presentations.

Lesson 1 • Presentation Software Interface

Navigates the slide panel, ribbon, and view modes. Interface fluency accelerates all subsequent slide creation and editing tasks.

Lesson 2 • Slide Transitions and Animations

Adds transitions between slides and entrance animations to objects. Used purposefully, motion guides attention without distracting audiences.

Lesson 3 • Slide Content and Text Design

Applies text hierarchy, bullet points, and placeholder formatting. Clear text design ensures audiences absorb key messages quickly.

Lesson 4 • Visual Elements and Media

Inserts images, icons, shapes, and embedded media into slides. Visual elements reinforce messages and maintain audience engagement.

Lesson 1 • Email Client Setup and Interface

Configures accounts, explores inbox layout, and sets up signatures. A properly configured client is the prerequisite for all communication tasks.

Lesson 2 • Calendar and Scheduling Tools

Creates appointments, sends meeting invites, and manages shared calendars. Scheduling tools coordinate team availability and reduce meeting conflicts.

Lesson 3 • Inbox Organisation and Productivity

Uses folders, rules, flags, and search to manage high email volume. Organised inboxes reduce missed messages and response delays.

Lesson 4 • Contacts, Tasks, and Notes

Manages contact lists, task assignments, and digital notes. These tools complete the personal information management system for office professionals.

Lesson 1 • Introduction to Cloud Storage

Explains cloud storage concepts, providers, and account setup. Understanding cloud basics is required before any file sharing or collaboration begins.

Lesson 2 • Real-Time Co-Editing Documents

Co-edits documents, spreadsheets, and presentations simultaneously with teammates. Real-time collaboration eliminates version conflicts in team projects.

Lesson 3 • Sharing and Permission Management

Sets view, comment, and edit permissions for shared files. Correct permissions protect sensitive data while enabling team collaboration.

Lesson 4 • Cloud Security and Best Practices

Covers two-factor authentication, secure sharing, and data backup habits. Security practices protect organisational data stored and shared in the cloud.

Lesson 1 • Reports and Data Output

Generates formatted reports from query results for printing and sharing. Reports present database findings in a professional, readable format.

Lesson 2 • Queries and Data Retrieval

Writes select queries to filter, sort, and retrieve specific records. Query skills transform raw tables into targeted, decision-ready information.

Lesson 3 • Database Concepts and Structure

Defines tables, fields, records, and relationships in a database. Conceptual clarity here prevents structural errors in all subsequent database work.

Lesson 4 • Forms for Data Entry

Builds input forms to simplify and validate data entry. Forms reduce entry errors and make databases accessible to non-technical staff.

Lesson 1 • Macros and Task Automation

Records and runs macros to automate repetitive formatting and data tasks. Automation reduces manual effort and enforces consistency across documents.

Lesson 2 • Workflow Planning and Process Mapping

Maps office processes using flowcharts and task lists to identify automation opportunities. Process mapping is the strategic capstone of integrated office work.

Lesson 3 • Linking Data Across Applications

Embeds and links spreadsheet data and charts into word processor documents. Linked objects update automatically, keeping reports current with source data.

Lesson 4 • Mail Merge for Mass Communication

Links a data source to a document template to produce personalised outputs. Mail merge eliminates manual repetition in letters, labels, and emails.