Module 1 – Office Applications & Communication

Microsoft Office

• Documentation with MS Word
• Presentation with MS PowerPoint
• Database Management with MS Access
• Introduction to MS Outlook

Office Management & Procedures

• Office vs Organization
• Importance of Effective Office Management
• Roles & Responsibilities of an Office Administrator
• File Management and Documentation
• Planning Meetings, Travel & Events
• Using Skype & TeamViewer for Communication
• Data Backup using Pen Drive, Hard Disk, CD/DVD & OneDrive
• Printer Connection, Printing & Scanning
• Procuring Office Supplies

Popular AI Tools Covered

• ChatGPT
• Google Gemini
• Canva AI
• MidJourney / DALL·E
• Runway ML
• Copy.ai / Jasper

Communication Skills

• Importance of Effective Communication
• Verbal Communication – Smart Talk
• Telephone Communication
• Office & Business Correspondence
• Writing and Reading Professional Documents

Module 2 – Advanced Excel & VBA Programming

Microsoft Excel

• Introduction to MS Excel
• Spreadsheet Management
• Data Handling and Analysis

VBA (Visual Basic for Applications)

• Introduction to VBA Macros
• Importance, Benefits & Limitations of VBA
• Developer Tab and VB Editor
• Macro Recording
• Writing Basic VBA Codes
• Working in Visual Basic Editor
• Saving and Managing Macros

VBA Programming Concepts

• Decision Making Statements (If, Else, And/Or, Select Case)
• Loops and Range Objects
• Writing Excel Formulas through Programming
• Error Types & Debugging
• Forms and ActiveX Controls
• Advanced User Forms

Data Analysis & Reporting

• Data Analysis Techniques
• Charts from Multiple Data Sheets
• Dashboard Reporting
• MIS Reporting

Module 3 – Web Development Fundamentals

Web Development Basics

• Understanding the Role of Web / Media Developer

HTML & HTML5

• HTML Tags, Elements and Attributes
• Images and Web Page Structure
• Links and Web Page Connections
• Lists, Tables, Frames and Forms
• HTML5 Features
• HTML Multimedia

CSS

• Introduction to CSS
• CSS Selectors and Styling
• Background Colors, Images & Gradients
• Borders and Layout Design
• Text Effects and Web Fonts
• Multi Background Techniques
• CSS Transforms and Animations

JavaScript

• Introduction to JavaScript
• JavaScript Fundamentals
• Events and Objects
• Window, Frame and Form Objects

Workplace Skills

• Work Planning and Organizational Standards
• Clean Workplace Practices
• Company Policies and Rules
• Work Output Requirements

Module 4 – CMS, Web Tools & Database

Content Management System (CMS)

• Introduction to CMS
• WordPress as Open Source CMS
• WordPress Features and Tools
• Pages, Themes and Categories
• Theme Customization
• Building Dynamic Websites and Blogs
• Website Content Management

Web Designing Tools

• Web Designing with Dreamweaver
• Website Layout Design
• Adding Design Elements
• Hyperlinks and Media Integration
• Final Website Upload

SQL & Database Management

• Introduction to Databases
• Concept of RDBMS
• Database Normalization
• SQL Syntax, Datatypes and Constraints
• SQL Joins and Queries
• Nested Queries

Professional Development

• Maintaining a Healthy & Safe Work Environment
• Work Management & Reporting
• Using Standard Information Templates
• Personality Enhancement
• Personal Effectiveness for Professional Impression

Career Opportunities

After completing the CAP course, students can work as:

• Computer Operator
• Office Administrator
• Data Entry Operator
• MIS Executive
• Web Developer / Website Designer
• Excel & VBA Specialist