Course Details

1. ADCA (Advance Diploma in Computer Applications)

Comprehensive 1-Year Program | 2 Semesters

Semester 1: Office Management & Automation

 * Computer Fundamentals: History, Hardware (RAM, ROM, CPU), Software types, Windows 10/11 Interface, File & Folder Management.

 * Mastering MS Word:

   * Document formatting, Watermarks, Page Borders.

   * Mail Merge: Sending one letter to 100 people automatically.

   * Creating Resumes, Letterheads, and ID Cards.

 * Mastering MS Excel (Intermediate):

   * Data Entry, Cell Formatting, Basic Mathematical Formulas (Sum, Average, Percentage).

   * Creating Invoices and Salary Sheets.

 * Mastering MS PowerPoint:

   * Slide Transitions, Custom Animations, Inserting Audio/Video.

   * Creating a professional business presentation.

 * Internet & Digital Services: Emailing (CC/BCC), Google Drive, Online Forms, Ticket Booking (Rail/Air).

Semester 2: Professional Specialization

 * Advanced Excel: VLOOKUP, HLOOKUP, Pivot Tables, Data Validation.

 * Financial Accounting (Tally Prime): Company creation, Ledgers, Vouchers, and Basic GST.

 * Graphic Design Basics: Introduction to Photoshop (Photo editing) and CorelDraw (Logo design).

 * Web Basics: Understanding HTML & Internet Protocols.

 * Soft Skills: Resume building and Mock Interview preparation.

2. Expert Accounting with Tally Prime & GST

Duration: 3 Months | Focus: Finance & Taxation

Module 1: Manual Accounting Concepts

 * Understanding Debit & Credit.

 * Types of Accounts (Real, Personal, Nominal).

 * Journal Entries and Trial Balance.

Module 2: Computerized Accounting (Tally Prime)

 * Company Management: Creating, altering, and securing company data.

 * Masters: Creating Ledgers, Groups, and Stock Items.

 * Vouchers: Contra, Payment, Receipt, Journal, Sales, and Purchase.

 * Banking: Cheque printing, Bank Reconciliation Statement (BRS).

Module 3: Taxation (GST)

 * GST Fundamentals: CGST, SGST, IGST explained.

 * Invoicing: Creating GST-compliant bills (B2B, B2C).

 * E-Way Bill: Generating E-Way bills for transport.

 * GST Returns: Understanding GSTR-1, GSTR-2, and GSTR-3B.

 * TDS & Payroll: Calculating Tax Deducted at Source and generating Employee Payslips.

3. Advanced Excel & MIS Reporting

Duration: 2 Months | Focus: Data Analysis

Module 1: Advanced Functions

 * Logical Functions: IF, AND, OR, NESTED IF (Complex conditions).

 * Lookup Functions: VLOOKUP (Approx & Exact match), HLOOKUP, INDEX-MATCH.

 * Text Functions: LEFT, RIGHT, MID, CONCATENATE, TEXT-TO-COLUMNS.

Module 2: Data Management & Visualization

 * Pivot Tables: Summarizing large data sets, using Slicers and Timelines.

 * Charts: Creating dynamic Column, Pie, and Line charts.

 * Data Validation: Creating Drop-down lists to prevent errors.

 * Conditional Formatting: Highlighting top performers, duplicates, or overdue dates automatically.

Module 3: Security & Protection

 * Protecting sheets and workbooks with passwords.

 * Hiding formulas and locking specific cells.

4. Diploma in Desktop Publishing (DTP)

Duration: 3-4 Months | Focus: Design & Print Media

Module 1: Adobe Photoshop (Image Editing)

 * Tools: Selection tools, Lasso, Magic Wand, Crop.

 * Retouching: Healing Brush (removing pimples/spots), Clone Stamp.

 * Layers: Understanding layer masks and blending modes.

 * Projects: Creating Passport size photos, Changing backgrounds, Photo manipulation.

Module 2: CorelDraw (Vector Graphics)

 * Drawing: Bezier tool, Pen tool, Shape manipulation.

 * Typography: Text effects, fitting text to path.

 * Print Design: Designing Business Cards, Letterheads, Wedding Cards, Flex Banners, and Flyers.

Module 3: Printing Standards

 * CMYK vs. RGB color modes.

 * Setting margins and bleed areas for professional printing.

5. Web Design Fundamentals

Duration: 2-3 Months | Focus: Front-End Development

 * HTML5 (Structure): Tags, Headings, Paragraphs, Lists, Tables, Forms, Inserting Images and Videos.

 * CSS3 (Styling): Colors, Fonts, Borders, Margins, Padding, Backgrounds.

 * Responsive Design: Making websites look good on Mobile phones vs. Laptops.

 * Live Project: Students will code and launch a simple 3-page personal portfolio website.

6. English & Hindi Typing

Duration: Monthly Basis | Focus: Speed & Accuracy

 * Finger Placement: Learning the home row, top row, and bottom row.

 * Blind Typing: Typing without looking at the keyboard.

 * Speed Building: Timed paragraphs (10 mins / 30 mins).

 * Remington Gail / Mangal Font: (Specific for Hindi Government Jobs).

 * Typing Games: To improve speed in a fun wa

y.

7. Computer Hardware & Networking (Desktop Support)

Duration: 3 Months | Focus: Repair & Maintenance

Ideal for students who prefer working with hardware rather than software.

Module 1: Assembling & Disassembling

 * Identifying components: Motherboard, Processor, RAM, SMPS, Hard Disk/SSD.

 * How to build a PC from scratch.

 * Understanding BIOS and Boot Menu settings.

Module 2: Software Installation & Formatting

 * Creating Bootable USB drives (Windows 10/11).

 * Formatting computers and partitioning hard drives.

 * Installing Drivers (Audio, Video, Printer) and Antivirus.

Module 3: Basic Networking

 * Crimping LAN cables (RJ45 connectors).

 * Setting up Wi-Fi Routers and sharing printers over a network.

 * Troubleshooting "No Display" or "Slow Computer" issues.

Job Opportunities: Hardware Technician, Computer Repair Shop Owner, IT Support Executive.

8. Digital Marketing & Social Media Specialist

Duration: 3 Months | Focus: Online Marketing

Every local business needs this skill today to grow.

Module 1: Social Media Marketing (SMM)

 * Facebook & Instagram: Creating business pages, running paid Ads, and increasing followers.

 * Content Creation: Using Canva to design professional social media posts without being a graphic designer.

Module 2: Google & Local SEO

 * Google My Business: How to put a shop/business on Google Maps and manage reviews.

 * YouTube: Creating a channel, uploading videos correctly, and understanding Tags/Keywords.

Module 3: Email & Affiliate Marketing

 * Basics of sending professional bulk emails.

 * Introduction to earning money online (Affiliate basics).

Job Opportunities: Social Media Manager, Digital Marketing Intern, Freelancer.

9. Video Editing (YouTuber/Creator Course)

Duration: 2 Months | Focus: Media Production

Very high demand among youth wanting to start YouTube channels or Instagram Reels.

Module 1: Editing Basics (Filmora / Premier Pro Basics)

 * Importing footage and organizing files.

 * Cut, Trim, and Split videos.

 * Adding Transitions and Visual Effects.

Module 2: Audio & Text

 * Removing background noise from audio.

 * Adding background music and voiceovers.

 * Adding Titles, Subtitles, and Lower Thirds.

Module 3: Exporting & Publishing

 * Rendering videos in 1080p/4K.

 * Designing attractive Thumbnails.

Job Opportunities: Video Editor for YouTubers, Wedding Video Editor, Social Media Content Creator.

10. Programming Languages (C, C++ & Python)

Duration: 2-3 Months (Per Language) | Focus: Logic & Coding

Essential for school students (Class 9-12) and BCA/B.Tech aspirants.

Module 1: C Language (The Foundation)

 * Variables, Data Types, and Operators.

 * Control Structures: If-Else, Switch Case, Loops (For, While).

 * Arrays and Functions.

Module 2: C++ (Object Oriented)

 * Introduction to OOPs (Object-Oriented Programming).

 * Classes and Objects.

 * Inheritance and Polymorphism.

Module 3: Python (Modern Coding)

 * Why Python is popular (AI/Data Science basics).

 * Python Syntax vs C++.

 * Working with Lists, Tuples, and Dictionaries.

 * Basic mini-projects (e.g., Calculator, Number Guessing Game).

Job Opportunities: Junior Programmer, Academic Tutor, Preparation for Engineering College.

11. Spoken English & Personality Development

Duration: 3 Months | Focus: Confidence & Communication

A great "Add-On" course to bundle with ADCA or Tally.

Module 1: Communication Basics

 * Self-Introduction: How to introduce yourself in an interview.

 * Daily Usage Sentences: Greetings, asking questions, small talk.

 * Overcoming hesitation and stage fear.

Module 2: Professional Skills

 * Email Etiquette: How to write formal emails to bosses or clients.

 * Body Language: Eye contact, sitting posture, and hand gestures.

 * Interview Preparation: Mock interviews and answering common HR questions.

Job Opportunities: Front Desk Officer, Sales Executive, BPO/Call Center.

Updated Course Categories Summary

You can organize your brochure sections like this:

 * Office & Accounting: ADCA, DCA, Tally Prime, Adv. Excel

 * Creative & Media: DTP, Video Editing

 * Technical & Hardware: Hardware Networking, Web Design

 * Coding & Logic: C, C++, Python

 * Marketing & Soft Skills: Digital Marketing, Spoken English

 * Basics: BCC, CCC, Typing