courseComputer FundamentalsintermediateFeatured

Advanced Diploma in Computer Applications (ADCA)

This 1-year professional computer application course provides practical training in computer fundamentals, Windows & system utilities, Microsoft Office (Word, Excel, PowerPoint, Access, Outlook), internet & digital communication, web designing with HTML5/CSS3, PHP & MySQL, TallyPrime with GST, AI tools, cyber security, and typing skills. Students gain hands-on experience with 150+ Excel functions, responsive web design, PHP/MySQL CRUD applications, TallyPrime accounting, and AI tools like ChatGPT, Microsoft Copilot, Google Gemini, and DeepSeek through practical projects and a final capstone project, preparing them for careers such as Computer Operator, Office Executive, Data Entry Operator, Computer Teacher, MIS Executive, Web Designer, Tally Operator, and Technical Support Executive, or for higher studies in IT and Computer Applications.

Duration: 12 months
Mode: online/offline
Language: Hindi/English
View Curriculum

Curriculum

Module 1: Computer Fundamentals

3 weeks

Topics Covered:

  • Introduction to Computers
  • History & Generations of Computers
  • Types of Computers
  • Hardware & Software Concepts
  • Input & Output Devices
  • CPU, Memory & Storage Devices
  • Number System & Data Representation
  • Computer Languages
  • Operating System Basics
  • Booting Process
  • File & Folder Management
  • Computer Maintenance & Troubleshooting
  • Networking Fundamentals
  • Data Backup & Recovery
  • Digital Ethics & Green Computing

Projects:

  • Computer Hardware Identification
  • Computer Troubleshooting Assignment

Module 2: Microsoft Windows & System Utilities

3 weeks

Topics Covered:

  • Windows Installation & Configuration
  • Desktop Environment & Personalization
  • File Explorer & File Management
  • Control Panel & Windows Settings
  • User Accounts & Permissions
  • Device Manager & Driver Installation
  • Disk Management & Partitioning
  • Disk Cleanup & Storage Optimization
  • Windows Defender & Firewall
  • Backup & Restore
  • ZIP/UnZIP Files
  • Printer & Peripheral Device Setup
  • Common Troubleshooting Techniques

Projects:

  • Windows Installation Lab
  • System Maintenance Project

Module 3: Office Productivity Tools

2 weeks

Topics Covered:

  • Microsoft Paint
  • Notepad & WordPad
  • Snipping Tool
  • Calculator
  • Sticky Notes
  • Character Map
  • File Compression Utilities
  • PDF Creation & Management
  • OCR & Document Scanning Basics

Projects:

  • Digital Document Toolkit
  • PDF Conversion Assignment

Module 4: Microsoft Word (Advanced)

5 weeks

Topics Covered:

  • Document Creation & Formatting
  • Paragraph & Page Formatting
  • Tables & Table Design
  • Images, Shapes, Icons & 3D Models
  • SmartArt, WordArt & Charts
  • Headers, Footers & Watermarks
  • Columns & Sections
  • Mail Merge
  • Labels & Envelopes
  • Templates & Themes
  • References & Table of Contents
  • Comments & Track Changes
  • Document Protection
  • Printing & PDF Export

Projects:

  • Professional Resume
  • Company Letterhead
  • Mail Merge Project

Module 5: Microsoft Excel (Advanced)

9 weeks

Topics Covered:

  • Workbook & Worksheet Management
  • Cell Referencing (Relative, Absolute & Mixed)
  • Cell Formatting & Styles
  • Conditional Formatting
  • Data Validation
  • Sorting & Filtering
  • Tables & Named Ranges
  • Charts & Graphs
  • Pivot Tables & Pivot Charts
  • Dashboards
  • Slicers & Timelines
  • Flash Fill
  • What-If Analysis
  • Goal Seek & Scenario Manager
  • Power Query (Introduction)
  • 150+ Excel Functions & Formulas
  • Logical Functions (IF, IFS, AND, OR, NOT, Nested IF)
  • Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH, XMATCH, FILTER)
  • Math & Statistical Functions (SUM, PRODUCT, SUMPRODUCT, AGGREGATE, etc.)
  • Conditional Functions (SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS)
  • Text Functions (LEFT, RIGHT, MID, LEN, TEXT, CONCAT, TEXTJOIN, SUBSTITUTE)
  • Date & Time Functions (DATE, TIME, TODAY, NOW, YEAR, MONTH, DAY)
  • Financial Functions (PMT, PV, FV, IPMT, PPMT)
  • Engineering & Conversion Functions (CONVERT, ROMAN, BIN/DEC/HEX)
  • Dynamic Array Functions (SORT, SORTBY, SEQUENCE, RANDARRAY, LAMBDA)
  • Information Functions (IFERROR, IFNA, ISERROR, ISNUMBER, HYPERLINK, IMAGE)

Projects:

  • Sales Dashboard
  • Payroll Management System
  • Inventory Tracker

Module 6: Microsoft PowerPoint

3 weeks

Topics Covered:

  • Professional Presentation Design
  • Themes & Templates
  • Slide Master
  • Tables & Charts
  • SmartArt & Infographics
  • Images, Audio & Video
  • Animations & Transitions
  • Hyperlinks & Action Buttons
  • Presenter View
  • Presentation Printing & Export

Projects:

  • Business Presentation
  • Course Presentation

Module 7: Microsoft Access

3 weeks

Topics Covered:

  • Database Fundamentals
  • Tables & Relationships
  • Primary & Foreign Keys
  • Queries
  • Forms
  • Reports
  • Data Validation
  • Import & Export Data
  • Database Security

Projects:

  • Student Database
  • Library Database

Module 8: Microsoft Outlook

2 weeks

Topics Covered:

  • Email Configuration
  • Email Management
  • Contacts
  • Calendar
  • Meeting Scheduling
  • Tasks & Notes
  • Rules & Filters
  • Signatures
  • Email Security

Projects:

  • Professional Email Workflow

Module 9: Internet & Digital Communication

3 weeks

Topics Covered:

  • Internet Fundamentals
  • Web Browsers
  • Effective Search Techniques
  • Google Workspace Basics
  • Gmail Features
  • Cloud Storage (Google Drive & OneDrive)
  • Online Forms
  • Digital Payments
  • Video Conferencing
  • Digital Collaboration
  • Internet Safety & Privacy

Projects:

  • Google Workspace Assignment
  • Online Survey Project

Module 10: Web Designing (HTML5 & CSS3)

6 weeks

Topics Covered:

  • HTML Structure
  • Text Formatting
  • Lists
  • Hyperlinks
  • Images
  • Tables
  • Forms
  • Multimedia
  • Semantic HTML
  • CSS Syntax & Selectors
  • Colors & Typography
  • Box Model
  • Margin & Padding
  • Flexbox
  • CSS Grid
  • Responsive Web Design
  • Media Queries
  • Bootstrap Framework

Projects:

  • Personal Portfolio Website
  • Responsive Business Website

Module 11: PHP Programming

6 weeks

Topics Covered:

  • PHP Environment Setup
  • Variables & Data Types
  • Operators
  • Conditional Statements
  • Loops
  • Arrays
  • Functions
  • Form Handling
  • Sessions & Cookies
  • File Upload
  • MySQL Connectivity
  • CRUD Operations
  • Login & Registration System
  • Error Handling

Projects:

  • Student Management System
  • Login & Registration System

Module 12: MySQL Database

4 weeks

Topics Covered:

  • Database Concepts
  • Database & Table Creation
  • Data Types
  • Keys & Constraints
  • SQL Commands
  • SELECT Queries
  • WHERE, ORDER BY, GROUP BY
  • Aggregate Functions
  • Joins
  • Views
  • Backup & Restore
  • Import & Export

Projects:

  • Library Management Database

Module 13: TallyPrime with GST

5 weeks

Topics Covered:

  • Company Creation
  • Accounting Fundamentals
  • Ledger & Groups
  • Voucher Entry
  • Inventory Management
  • Banking Features
  • Payroll Management
  • Cost Centres
  • GST Configuration
  • GST Transactions
  • GST Reports
  • Financial Statements
  • Backup & Restore

Projects:

  • Complete Business Accounting Project

Module 14: Artificial Intelligence (AI)

3 weeks

Topics Covered:

  • Introduction to AI
  • AI in Everyday Life
  • Generative AI
  • Prompt Engineering
  • ChatGPT
  • Microsoft Copilot
  • Google Gemini
  • DeepSeek AI
  • AI for Office Productivity
  • AI for Content Creation
  • AI for Coding Assistance
  • AI Image Generation
  • AI Ethics & Responsible Usage

Projects:

  • AI Productivity Assignment

Module 15: Typing Skills

3 weeks

Topics Covered:

  • English Typing Practice
  • Hindi Unicode Typing
  • Touch Typing Techniques
  • Keyboard Shortcuts
  • Speed & Accuracy Improvement

Projects:

  • Typing Speed Assessment

Module 16: Digital Skills & Professional Development

3 weeks

Topics Covered:

  • Resume & CV Preparation
  • Business Letter Writing
  • Professional Documentation
  • Presentation Skills
  • Interview Preparation
  • Time Management
  • Workplace Ethics
  • Digital Portfolio Creation

Projects:

  • Professional Resume
  • Digital Portfolio

Module 17: Cyber Security & Digital Safety

3 weeks

Topics Covered:

  • Cyber Security Fundamentals
  • Password & Account Security
  • Two-Factor Authentication
  • Malware & Virus Protection
  • Phishing Awareness
  • Antivirus & Firewall
  • Safe Internet Browsing
  • Data Privacy
  • Digital Signatures
  • Cyber Laws & IT Act (Overview)

Projects:

  • Cyber Security Awareness Report

Module 18: Practical Assignments

4 weeks

Topics Covered:

  • Microsoft Word Project
  • Advanced Excel Dashboard
  • PowerPoint Presentation
  • Access Database Project
  • Responsive Website Design
  • PHP & MySQL Web Application
  • TallyPrime Accounting Project
  • AI Productivity Assignment

Projects:

  • Module-wise Practical File

Module 19: Final Project

4 weeks

Topics Covered:

  • Industry-Oriented Project Development
  • Project Planning
  • Implementation
  • Documentation
  • Presentation

Projects:

  • Student Management System
  • Library Management System
  • Inventory & Billing Software
  • Responsive Business Website
  • Personal Portfolio Website
  • Accounting Management System
  • AI-Assisted Office Automation System

Learning Objectives

  • Master computer fundamentals, hardware, software, and networking concepts
  • Operate and manage Windows systems, utilities, and troubleshooting
  • Create professional documents, spreadsheets, and presentations in MS Office
  • Apply 150+ Excel functions to build dashboards and business reports
  • Manage databases using Microsoft Access and MySQL
  • Build responsive websites using HTML5, CSS3, and Bootstrap
  • Develop dynamic web applications with PHP and MySQL
  • Manage business accounting and GST compliance using TallyPrime
  • Use AI tools such as ChatGPT, Copilot, Gemini, and DeepSeek for productivity
  • Apply cyber security and digital safety best practices

Why Choose ADCA at The Geek Institute of Cyber Security?

The Advanced Diploma in Computer Applications (ADCA) is a comprehensive, 1-year industry-oriented diploma that transforms computer users into job-ready IT and office professionals. This course bridges the gap between basic computer literacy and professional, hands-on proficiency across the Microsoft Office suite, web technologies, databases, accounting software, and modern AI tools.

  • Industry-Relevant Curriculum: 19 structured modules covering computer fundamentals, MS Office, web designing, PHP & MySQL, TallyPrime with GST, AI tools, and cyber security
  • 100% Practical & Hands-on Training: Every module pairs concept sessions with real assignments and projects
  • 150+ Excel Functions & Formulas: Deep, function-by-function mastery of Advanced Excel for dashboards and business reporting
  • Multiple Career Paths: Opens doors to office administration, web designing, accounting/Tally operations, and AI-assisted productivity roles
  • Expert Instructors: Learn from experienced trainers across office productivity, web development, and accounting
  • Small Batch Experience: Personalized instructor guidance throughout the program
  • Placement Support: Resume building, interview preparation, and employability skills training
  • Professional Certificate: Recognized ADCA diploma enhancing your employability

Who Should Enroll?

This course is perfect for:

  • 12th Pass Students planning a career in IT, office administration, or accounting
  • Graduates from non-IT backgrounds wanting to build strong computer application skills
  • Computer Users with basic skills wanting to advance into web designing, accounting, or AI-assisted office work
  • Aspiring Web Designers wanting hands-on HTML5, CSS3, and PHP/MySQL training
  • Accounting Aspirants wanting to master TallyPrime with GST
  • Working Professionals wanting to upgrade their MS Office and AI productivity skills
  • Small Business Owners wanting to manage their own websites, accounts, and office documentation

Prerequisites: Basic computer knowledge or willingness to start from the fundamentals with extra effort.

What You'll Build

During this 12-month journey, you'll create a well-rounded practical portfolio drawn directly from the curriculum:

Office & Productivity Projects

  • Professional Resume and Company Letterhead (MS Word)
  • Mail Merge Project
  • Sales Dashboard, Payroll Management System, and Inventory Tracker (Advanced Excel)
  • Business Presentation and Course Presentation (PowerPoint)
  • Student Database and Library Database (MS Access)
  • Professional Email Workflow (Outlook)

Web Development Projects

  • Personal Portfolio Website — HTML5, CSS3
  • Responsive Business Website — HTML5, CSS3, Bootstrap
  • Student Management System — PHP & MySQL with CRUD operations
  • Login & Registration System — PHP & MySQL
  • Library Management Database — MySQL

Accounting & GST Projects

  • Complete Business Accounting Project in TallyPrime
  • GST Configuration, Transactions, and Reports

AI & Digital Skills Projects

  • AI Productivity Assignment using ChatGPT, Microsoft Copilot, Google Gemini, and DeepSeek
  • Digital Portfolio Creation
  • Cyber Security Awareness Report

Final Capstone Project

Choose from industry-oriented projects such as:

  • Student Management System
  • Library Management System
  • Inventory & Billing Software
  • Responsive Business Website
  • Personal Portfolio Website
  • Accounting Management System
  • AI-Assisted Office Automation System

Career Opportunities

ADCA qualifies you for multiple career paths:

Office & Administrative Roles (₹10,000 - ₹22,000/month)

  • Computer Operator
  • Office Executive
  • Data Entry Operator
  • MIS Executive

Web Designing (₹12,000 - ₹25,000/month)

  • Junior Web Designer
  • PHP Developer (Entry-Level)
  • Website Maintenance Executive

Accounting & GST (₹12,000 - ₹25,000/month)

  • Tally Operator
  • Accounts Executive (GST Billing & Compliance)

Teaching & Support (₹10,000 - ₹20,000/month)

  • Computer Teacher
  • Technical Support Executive

Further Study Paths

  • Specialized Web Development (Full Stack with PHP/MySQL)
  • Advanced Excel & Data Analysis
  • Advanced TallyPrime & GST Practitioner Courses
  • Cyber Security Specialization
  • AI Tools & Prompt Engineering Specialization

Learning Experience

Learning Format

  • Duration: 12 months
  • Mode: Online or Offline
  • Structured Learning: Concept sessions, practical labs, and projects across 19 modules
  • Total Hours: 192+ hours of training

Learning Methodology

  • 40% Theory & Concepts
  • 60% Hands-on Practice & Projects
  • Weekly assignments and module-wise practical files
  • Module-wise assessments
  • Practical Assignments module covering Word, Excel, PowerPoint, Access, Web Design, PHP & MySQL, TallyPrime, and AI productivity
  • Final Capstone Project with industry-oriented deliverables

Course Includes

  • Course Material: Complete notes and practice files for every module
  • Software Access: MS Office, MySQL, TallyPrime, and web development tools
  • Lab Practice: Individual computer with necessary tools
  • Assessments: Regular tests and project evaluations
  • Certification: Government-recognized ADCA diploma
  • Job Support: Resume, digital portfolio review, and interview preparation
  • Alumni Access: Lifetime learning community

Fee Structure

Course Fee: ₹20,000 (12 months)

Payment Options:

  1. One-time Payment: ₹17,000 (₹3,000 discount)
  2. Half-yearly: ₹10,000 × 2 installments
  3. Quarterly: ₹5,000 × 4 installments
  4. Monthly: ₹1,667 × 12 installments

What's Included:

  • All course materials and software access
  • Lab access during and after class hours
  • Project guidance and module-wise evaluation
  • Certificate upon completion
  • 1-year post-course support

Certification & Recognition

Upon successful completion, you receive:

  1. ADCA Diploma Certificate — Government-recognized
  2. Geek Institute Completion Certificate — With grade
  3. Project Completion Certificates — For each major project
  4. Digital Badges — For LinkedIn and resume
  5. Digital Portfolio — Showcase your practical work and final project

Student Success Stories

"The Advanced Excel module with 150+ functions completely changed how I work. I built dashboards in my office job that impressed my whole team."Rahul Verma, MIS Executive at a Manufacturing Firm

"After completing the Web Designing and PHP & MySQL modules, I started building small business websites on the side using exactly what I learned in the Student Management System project."Anjali Singh, Junior Web Designer

"The TallyPrime with GST module helped me get an accounts executive position. The combination of accounting and computer skills is highly valued in my city."Suresh Kumar, Accounts Executive at a Trading Firm

Frequently Asked Questions

Do I need prior computer knowledge to join ADCA?

Basic computer familiarity helps, but the course starts from Computer Fundamentals, so beginners can join after a quick assessment.

Is ADCA enough to get a job in IT or office administration?

It builds a strong, practical base for entry-level roles in office administration, web designing, accounting, and technical support, along with employability skills training.

Will you help me get a job after ADCA?

Yes, we provide resume building, digital portfolio review, and interview preparation as part of the course.

Is online mode available?

Yes, both online and offline modes are available.

Does the course cover GST?

Yes, the TallyPrime module includes complete GST configuration, transactions, reports, and financial statements.

Are AI tools like ChatGPT and Copilot covered?

Yes, the dedicated AI module covers ChatGPT, Microsoft Copilot, Google Gemini, DeepSeek AI, prompt engineering, and AI tools for office productivity, content creation, coding assistance, and image generation.

Tags

MS OfficeAdvanced ExcelHTML/CSSPHPMySQLTallyPrimeGSTAI Tools