ADCA

Course Modules Course: ADVANCE DIPLOMA IN COMPUTER APPLICATION

=> Computer Fundamentals & Basic Hardware Concepts

-> Introduction to Computers

-> Types of Computers and Devices

-> Input / Output Devices

-> Memory Units & Storage Devices

-> Number System Basics

-> Operating System Concepts

=> MS Office Tools with Windows File & Folder Management

-> MS Word: Formatting, Tables, Mail Merge

-> MS Excel: Functions, Charts, Data Entry

-> MS PowerPoint: Slides, Animation, Presentation

-> File & Folder Handling in Windows

-> Control Panel & System Settings

-> Keyboard Shortcuts & Tips

=> Internet, Email & HTML-Based Web Designing

-> Basics of Internet, Browsers & Search

-> Creating & Managing Email

-> Google Tools (Drive, Docs, Forms)

-> Introduction to HTML Tags

-> Simple Web Page Structure

-> Web Hosting & Domain Basics

=> Tally ERP with GST & Inventory Management

-> Company Creation in Tally

-> Ledger & Voucher Entry

-> GST Configuration & Transactions

-> Inventory Items & Stock Groups

-> Tax Reports & Print Settings

-> Backup & Restore

=> Manual Accounting, Payroll & Basic Taxation

-> Basics of Bookkeeping

-> Journal Entry, Ledger, Trial Balance

-> Payroll Calculations

-> Introduction to GST, TDS, ITR

-> Tax Slabs and Forms (Basic)

-> Balance Sheet & P&L Statement

=> Graphic Designing using Photoshop, CorelDRAW & PageMaker

-> Tools & Workspace Overview (Photoshop/CorelDRAW)

-> Image Editing & Layer Handling

-> Designing ID Cards, Banners, Posters

-> Text & Layout Management in PageMaker

-> Color Theory & Print Setup

-> File Export & Optimization

=> Software Installation, Antivirus & System Utilities

-> Installing Common Software (MS Office, PDF, Browsers)

-> Antivirus Installation & Scan

-> Disk Cleanup, Defragmentation, Backup

-> File Conversion Tools (PDF, ZIP, etc.)

-> System Troubleshooting Tips

-> Keyboard & Utility Tools

=> Project Work: MS Office, Tally, Designing & Web

-> Word Project: Resume / Application

-> Excel Project: Invoice / Report

-> PowerPoint: Presentation on Any Topic

-> Tally File with GST Transactions

-> Poster or Brochure Design

-> HTML Page with Form & Table

=> Final Practical Exam, Viva & Internal Assessment

-> Final Lab Practical (Across All Modules)

-> Oral Viva on Software & Tools

-> File Check (Project + Assignment)

-> Internal Marking by Faculty

=> Database Management using MySQL, MS Access & PHP Basics

-> Concepts of DBMS

-> Tables, Fields & Data Types

-> SQL Basics: SELECT, INSERT, UPDATE

-> MS Access Forms & Queries

-> Introduction to PHP Form Handling

-> Primary Key & Relationships

=> Advanced Excel & MIS Reporting

-> Logical Functions (IF, VLOOKUP)

-> Pivot Tables & Charts

-> Data Validation

-> MIS Report Formats

-> Dashboard Basics