7870735176, 9334134557 info@uceti.com
Loading...

ADCA ( Advance Diploma in Computer Application )

Course Code: UC105

Course Description

Course Duration: 12–15 Months

ADCA course builds strong computer skills with MS-Office 2024, Advanced Excel, and Tally Prime, preparing students for office and accounting jobs.”

DCA, TALLY PRIME (with GST), DTP, and Project Work

Course Features

๐Ÿ“˜ Easy-to-Understand Notes
๐ŸŽฅ Recorded Video Lectures
๐Ÿง‘โ€๐Ÿซ Live Classes
๐Ÿ“ Practice Sets
๐Ÿ“š Question Bank
๐Ÿงช Test Series
๐Ÿ’ป Online Exams
๐ŸŽง Student Support
๐Ÿ”— One-Year Valid Course Access (After Completion)

Course Syllabus

๐Ÿ“˜  Fundamentals of Computer

  • Introduction to computers and working process
  • Types of computers (Desktop, Laptop, Server, Supercomputer)
  • Input devices (Keyboard, Mouse, Scanner, Microphone)
  • Output devices (Monitor, Printer, Speaker)
  • Hardware and Software concepts
  • Memory (RAM, ROM, HDD, SSD, Pen Drive)
  • Number system (Binary, Decimal basics)
  • Applications of computers in daily life

๐Ÿ–ฅ๏ธ  Operating System (Windows)

  • Windows interface (Desktop, Taskbar, Icons)
  • File and folder management (Create, Rename, Delete)
  • Copy, Paste, Move operations
  • Control Panel settings
  • Software installation and uninstallation
  • System tools (Disk Cleanup, Task Manager)
  • Shortcut keys

๐Ÿ“„  MS Office 2024

๐Ÿ‘‰ MS Word 2024 (Detailed)

  • Document creation, editing, saving
  • Formatting (Font, Size, Color, Bold, Italic)
  • Paragraph formatting (Alignment, Line spacing)
  • Page setup (Margin, Orientation, Size)
  • Tables creation and formatting
  • Insert images, shapes, icons
  • Mail Merge (bulk letters and certificates)

Advanced Topics:

  • Header and Footer
  • Page numbering
  • Columns and Section breaks
  • Find and Replace
  • WordArt and Text Box
  • Hyperlink and Bookmark
  • Spell Check and Grammar
  • Track Changes and Comments
  • Document protection (password)
  • Resume and letter design
  • Print setup and PDF export

๐Ÿ‘‰ MS Excel 2024 (Detailed)

  • Workbook and Worksheet basics
  • Data entry and formatting
  • Formulas (SUM, AVERAGE, COUNT, MAX, MIN)
  • Functions (IF, VLOOKUP, HLOOKUP, IFERROR)
  • Charts (Bar, Pie, Line)
  • Sorting and Filtering

Advanced Topics:

  • Conditional Formatting
  • Data Validation (Drop-down list)
  • Pivot Table and Pivot Chart
  • Freeze Panes
  • Cell Referencing (Relative and Absolute)
  • Text Functions (LEFT, RIGHT, MID, LEN)
  • Date and Time Functions
  • Dashboard basics
  • Sheet protection
  • Printing and Page Layout

๐Ÿ‘‰ MS PowerPoint 2024

  • Slide creation and layout
  • Design themes
  • Insert images, icons, charts
  • Animation and Transition
  • Slide show presentation

๐ŸŒ  Internet & Networking

  • Introduction to Internet and its working
  • Web browsers (Chrome, Edge)
  • Email (create, send, receive, attachments)
  • Download and Upload
  • Cloud storage basics
  • Networking concepts (LAN, WAN, MAN, Wi-Fi)
  • IP Address basics

๐Ÿ”  Cyber Security

  • Virus, Malware, Ransomware
  • Antivirus usage
  • Safe browsing techniques
  • Password security
  • Phishing and online fraud awareness
  • Data protection basics

ACCOUNTING → TALLY → ADVANCED → GST → PAYROLL → MANUFACTURING → PRACTICAL

๐Ÿ“˜:Accounting

  • Introduction to Accounting
  • Types of Accounts
  • Golden Rules
  • Journal, Ledger, Trial Balance
  • Final Accounts
  • Cash Book & BRS

๐Ÿ’ป : Tally (Basic + Inventory)

๐Ÿ‘‰ Introduction

  • TallyPrime Overview
  • Gateway of Tally

๐Ÿ‘‰ Company Setup

  • Create / Alter / Delete Company
  • Security & Backup

๐Ÿ‘‰ Accounting in Tally

  • Groups & Ledgers
  • Voucher Entry (Payment, Receipt, Sales, Purchase, etc.)

๐Ÿ“ฆ Inventory

  • Stock Groups, Items
  • Units
  • Godown

๐Ÿ“ˆ  Advanced (Price List, POS, Costing)

๐Ÿ‘‰ Price List

  • Price Levels
  • Customer-wise Pricing
  • Discount System

๐Ÿ‘‰ POS

  • POS Invoice
  • Retail Billing

๐Ÿ‘‰ Costing

  • Cost Centre
  • Expense Tracking
  • Profit Analysis

๐Ÿงพ GST

  • GST Setup
  • GST Configuration
  • CGST, SGST, IGST
  • GST Invoice
  • Input & Output Tax
  • GST Reports
  • GST Return Basics

๐Ÿ‘จ‍๐Ÿ’ผ Payroll

  • Employee Creation
  • Salary Structure
  • PF, ESI
  • Payslip

๐Ÿญ  Manufacturing (NEW ADDED โœ”๏ธ)

  • Manufacturing Introduction
  • Bill of Materials (BOM)
  • Production Entry
  • Raw Material Consumption
  • Finished Goods
  • Stock Update
  • Manufacturing Reports
  • Cost Calculation

๐Ÿ› ๏ธ Practical & Project

  • Price List Practice โœ”๏ธ
  • POS Billing โœ”๏ธ
  • GST Billing โœ”๏ธ
  • Manufacturing Entry โœ”๏ธ
  • Full Accounting Work โœ”๏ธ
  • Real Business Project
  • Final Assessment

DTP (Desktop Publishing)

๐Ÿ–Œ๏ธ Software:

  • Adobe Photoshop
  • CorelDRAW
  • Adobe Illustrator

๐Ÿ“š Topics:

  • Page design
  • Visiting card
  • Poster, Banner
  • Logo design
  • Image editing
  • Typography
  • Tools & Layers
  • Color (RGB, CMYK)
  • Print setup
  • Export formats

๐Ÿ› ๏ธ  Project Work

  • Live project
  • Practical work
  • Final assessment

Certificate will be provided after course completion. The certificate fee is not included in the course fee and will be charged separately as applicable.

Course Information

Duration

1 Year

Course Fee
โ‚น5,550.00

โ‚น3,330.00

40% off
Certificate

Yes, upon completion