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?
