Advance Diploma in Computer Application (ADCA) by CertifiKation.

Module 1: Introduction to Computers

• History and Generation of Computers
• Types of Computers and Applications
• Hardware and Software Overview
• Input, Output & Storage Devices
• Operating System Basics (Windows / Linux)
• File Management and System Tools

Module 2: Microsoft Word (Word Processing)

• Introduction to MS Word Interface
• Creating, Editing, and Formatting Documents
• Paragraph, Styles, and Page Layout
• Tables, Lists, and Templates
• Mail Merge and Labels
• Printing and Exporting Documents

Module 3: Microsoft Excel (Spreadsheets)

• Excel Interface and Basic Formulas
• Cell Referencing (Relative, Absolute)
• Functions: SUM, IF, VLOOKUP, COUNTIF, etc.
• Data Sorting and Filtering
• Charts and Graphs
• Conditional Formatting and Pivot Tables

Module 4: Microsoft PowerPoint (Presentations)

• Understanding the PowerPoint Interface
• Creating Slides and Slide Layouts
• Adding Images, Shapes, and SmartArt
• Transitions, Animations, and Slide Timings
• Designing Professional Presentations
• Running Slide Shows and Printing

Module 5: Internet & Email

• What is the Internet and How it Works
• Browsers: Chrome, Edge, Firefox Basics
• Search Engines and Effective Searching
• Creating and Managing Email Accounts
• Sending, Receiving, and Attaching Files
• Online Safety and Cyber Awareness

Module 6: Database Management (MS Access / SQL Basics)

• Introduction to Databases and DBMS Concepts
• Tables, Fields, and Data Types
• Primary Keys and Relationships
• Creating Queries and Reports
• Basic SQL: SELECT, INSERT, UPDATE, DELETE
• Practical Database Exercises

Module 7: Accounting Basics / Digital Finance Tools

• Introduction to Accounting Principles
• Company Creation and Ledger Setup
• Journal Entries and Vouchers
• GST Billing and Reports
• Balance Sheet and Profit & Loss
  

Module 8: Graphic Design Basics (Photoshop / Canva)

• Introduction to Graphic Design
• Working with Raster and Vector Graphics
• Tools: Selection, Brush, Layers, and Masks
• Editing, Retouching, and Color Correction
• Designing Posters, Banners, and Logos
• Exporting Designs for Print and Web

Module 9: Web Design Basics (HTML & CSS)

• Introduction to Web Technologies
• Structure of an HTML Document
• Headings, Paragraphs, Links, and Images
• Lists, Tables, and Forms
• Basics of CSS for Styling
• Creating a Simple Web Page Project

Module 10: Programming Fundamentals (Java / Python Intro)

• Introduction to Programming Logic
• Variables, Data Types, and Operators
• Conditional Statements and Loops
• Arrays / Lists and Functions
• Input / Output Operations
• Simple Console Programs (Calculator, Grades, etc.)

Module 11: Computer Networking & Cyber Security

• Basics of Computer Networks (LAN, WAN, Internet)
• IP Address, DNS, and Cloud Overview
• Cyber Threats and Security Practices
• Antivirus, Firewalls, and Data Protection
• Introduction to Cloud Tools (Google Drive, OneDrive)

Module 12: Soft Skills & Office Productivity Tools

• Typing Practice and Shortcuts
• File Compression and PDF Management
• Introduction to Google Workspace / MS 365
• Communication and Email Etiquette
• Resume Writing and Interview Preparation

Module 13: Final Project & Review

• Office Document Project: Create a company profile in Word
• Excel Report Project: Monthly sales data with charts
• Tally Project: Small business accounting
• Web Page Project: Personal Portfolio site (HTML/CSS)
• Graphics Project: Poster / Flyer for local business

Outcome

By the end of the course, students will:

• Gain proficiency in MS Office, Tally, and Internet Tools
• Understand database, web, and programming fundamentals
• Be capable of performing office and digital tasks independently
• Receive a 6-month certificate in “Advanced Diploma in Computer Application"