What you'll learn
Advanced Diploma in Computer Application (ADCA)
Course Duration: 12 Months (1 Year)
Eligibility: 10th Pass or Equivalent
Mode: Offline / Online (Flexible Learning)
Language: English and Assamese (Bilingual)
Course Description:
The Advanced Diploma in Computer Application (ADCA) course is a one-year comprehensive program designed to provide in-depth knowledge of computer operations, office automation, digital tools, accounting software, and modern technologies.
It equips students with both theoretical and practical computer skills required for careers in education, business, accounting, data management, and digital platforms.
Students will learn everything from basic computer concepts to advanced applications like Tally, Graphic Designing, Internet & Email, Digital Marketing, and Artificial Intelligence (AI) tools.
Course Objectives:
- To provide advanced computer education for professional and personal growth.
- To train students in office automation, data handling, and accounting software.
- To make learners proficient in Internet, Email, and Google Workspace tools.
- To introduce AI-based applications for productivity and creativity.
- To prepare students for jobs or self-employment in the IT and business sector.
Show More
Course Syllabus
Course Structure:
The ADCA course is divided into two semesters, each focusing on essential skills.
Semester I: Basic and Office Automation
Module 1: Fundamentals of Computer
- Introduction to Computers and Their Components
- Input, Output, and Storage Devices
- Computer Hardware & Software
- Number Systems and Binary Concept
- Operating Systems (Windows Basics)
- File and Folder Management
Module 2: MS Office (Microsoft Office Suite)
- MS Word: Document Creation, Formatting, Tables, Mail Merge
- MS Excel: Formulas, Functions, Charts, Data Sorting, Reports
- MS PowerPoint: Slides, Animations, Transitions, Presentations
- MS Access: Database Design, Queries, Forms, Reports
Module 3: WordPad, Notepad, Paint
- Basic Editing Tools and Uses
- Creating Simple Documents and Graphics
Module 4: Internet and Email
- Web Browsing, Search Engines, and Online Forms
- Creating and Managing Email Accounts
- File Attachments, Google Drive, and Cloud Storage
- Cyber Safety and Netiquette
Module 5: Google Workspace
- Google Docs, Sheets, Slides
- Online Collaboration and Sharing
- Introduction to Google Drive and Cloud Productivity
Semester II: Professional Applications
Module 6: Tally Prime (GST & Accounting)
- Introduction to Accounting and Tally Interface
- Company Creation and Ledger Management
- Voucher Entry (Purchase, Sales, Payment, Receipt)
- GST Configuration and Reports
- Balance Sheet, Trial Balance, Profit & Loss
- Printing Reports and Tax Invoices
Module 7: Graphic Designing (Photoshop / Canva)
- Basics of Digital Design
- Image Editing, Filters, and Effects
- Poster, Banner, and Logo Design
- Social Media Creative Design using Canva
Module 8: Computer Networking
- Types of Networks (LAN, WAN, MAN)
- Internet Protocols and IP Addressing
- Network Devices: Hub, Switch, Router
- Data Sharing and Network Security
Module 9: Digital Marketing (Introduction)
- Basics of Digital Marketing
- Social Media Marketing (Facebook, Instagram, YouTube)
- SEO, SEM, and Content Creation
- Email Marketing and Online Branding
Module 10: Uses of Artificial Intelligence (AI)
- Introduction to Artificial Intelligence
- Practical Uses of AI in Education and Office Work
- Using ChatGPT, Microsoft Copilot, and Google Gemini
- AI for Writing, Data Handling, and Creativity
- Ethical Use of AI
Module 11: Project Work
- Create a Business Report using MS Word
- Prepare an Excel Data Sheet with Formulas
- Design a Presentation on “Digital India” using PowerPoint
- Maintain Accounts of a Shop in Tally Prime
- Design a Poster in Canva
Assessment:
- Theory Exam: 40 Marks
- Practical Exam: 50 Marks
- Project & Viva: 10 Marks
- Total: 100 Marks per Semester
Career Opportunities:
After completing ADCA, students can work as:
- Computer Operator
- Data Entry Operator
- Office Assistant
- Accountant (Tally)
- Graphic Designer
- Digital Marketing Executive
- Computer Instructor / Lab Assistant
Certification:
After successful completion, students will receive a
“Advanced Diploma in Computer Application (ADCA)”
awarded by Sankar Azan Computer Saksharata Mission (SACSM).