Computer Fundamentals & Operating System (Approx. 20 Hours)

This module provides the theoretical base and the practical knowledge of navigating the computer environment.

Computer Fundamentals:

Introduction: History, generations, types, and characteristics of computers.

Hardware Components: Understanding the CPU, Motherboard, Memory (RAM/ROM), Storage devices (HDD/SSD), and I/O devices (Keyboard, Mouse, Printer).

Concepts: Basic data representation, number systems (binary, decimal).

Operating System (OS):

Introduction to OS (e.g., Windows): Functions, different versions, and their user interfaces.

File and Folder Management: Creating, renaming, moving, and deleting files and folders using Windows Explorer.

Desktop Management: Using the Taskbar, Start Menu, Recycle Bin, and setting up Control Panel options (Date/Time, Display).

Accessories: Working with basic Windows applications like Notepad and Paint.

Word Processing - Microsoft Word (Approx. 30 Hours)

The focus is on creating, editing, and professional formatting of text documents.

Document Creation & Editing:

Creating, saving, opening, and printing documents.

Text selection, cut, copy, paste, undo, and redo functions.

Using Find and Replace.

Formatting:

Character Formatting: Font style, size, color, bold, italic, underline, and highlighting.

Paragraph Formatting: Alignment, line spacing, indentation, bullets, and numbering.

Page Layout: Page setup, margins, headers, and footers.

Advanced Features:

Tables: Creating, editing, merging cells, and formatting tables.

Mail Merge: Creating bulk letters, labels, or envelopes (a key office skill).

Inserting objects, pictures, SmartArt, and WordArt.

Spreadsheet Application - Microsoft Excel (Approx. 40 Hours)

This is often the most time-consuming module due to the complexity and importance of data management and calculations.

Worksheet Fundamentals:

Creating, saving, and navigating Workbooks and Worksheets.

Entering data, text, and formulas into cells.

Inserting, deleting, and renaming rows/columns/sheets.

Formulas & Functions:

Basic Formulas: Addition, subtraction, multiplication, division.

Essential Functions: SUM, AVERAGE, MAX, MIN, COUNT, IF (Conditional Logic).

Cell Referencing: Relative, Absolute ($), and Mixed referencing.

Data Management & Formatting:

Sorting and Filtering data.

Applying Conditional Formatting.

Charts and Graphs: Creating different types of visual data representations (Bar, Line, Pie).

Printing: Setting print area, page breaks, and print titles.

Presentation & Digital Literacy (Approx. 30 Hours)

This final module covers presentation skills and essential internet usage for office work.

Presentation Software - Microsoft PowerPoint:

Creating and saving presentations.

Working with different Views (Normal, Slide Sorter, Slide Show).

Adding text, images, clip art, and multimedia elements.

Design & Animation: Applying templates, themes, transitions, and custom animations.

Running and controlling a slide show.

Internet & Digital Communication:

Internet Concepts: WWW, Web Browsers, URLs, Search Engines.

Email: Creating an email account, composing, sending, receiving, and managing emails, including attachments.

Online Data Management: Introduction to cloud storage (e.g., Google Drive) or basic online form filling.

Typing Skills (Optional/Integrated):

A brief introduction or mandatory practice in Touch Typing to improve efficiency.

This 120-hour Certificate program is highly practical and aimed at preparing students for roles like Data Entry Operator, Office Assistant, or Clerk, especially in government and private offices where a certified skill in Microsoft Office (Office Automation) is mandatory.

Would you like me to find information on the career scope after completing this CCA course?