Advance Diploma in Computer Application

Semester 1: Computer Fundamentals & Office Automation

This semester focuses on foundational computer knowledge and essential office productivity tools.

• Computer Fundamentals:

• Introduction to Computers (Hardware, Software, Generations of Computers)

• Operating Systems (Windows, basic Linux commands)

• Memory and Storage Devices (RAM, ROM, Hard Drives, etc.)

• Computer Viruses and Security

• Number Systems and Data Representation

• Microsoft Office Suite:

• MS Word: Document creation, editing, formatting, mail merge, advanced features.

• MS Excel: Data entry, formulas, functions, charts, data analysis (sorting, filtering, pivot tables), advanced Excel concepts.

• MS PowerPoint: Creating presentations, animations, transitions, design principles.

• MS Access (Database Management System): Database tables, queries, forms, reports.

• MS Outlook: Email management, calendar, contacts.

• Internet & Web Basics:

• Internet concepts, WWW, web browsers, search engines.

• Email communication, online transactions (UPI, digital payments).

• Introduction to HTML (for basic web page designing).

Semester 2: Accounting with Tally Prime & Advanced Applications

This semester delves into accounting principles and practical application using Tally Prime, along with other relevant skills.

• Financial Accounting Fundamentals:

• Basic accounting concepts, golden rules of accounting.

• Types of accounts, journal entries, ledger posting.

• Trial balance, final accounts (Trading, Profit & Loss A/c, Balance Sheet).

• Introduction to GST, TDS, TCS.

• Tally Prime with GST:

• Introduction to Tally Prime: Company creation, features & configurations (F11, F12).

• Accounting Masters: Creating groups, ledgers (single & multiple).

• Inventory Masters: Stock groups, stock categories, stock items, units of measure, godowns/locations.

• Voucher Entry: Accounting vouchers (receipt, payment, contra, journal, sales, purchase, debit/credit notes), inventory vouchers, order processing.

• Advanced Accounting Features: Cost categories and cost centers, budgets, interest calculation, cheque printing, credit limits, reorder levels, price lists.

• Taxation & Compliance:

• GST: Activating GST, setting up GST rates, updating masters for GST, recording GST transactions (sales, purchases, returns, advances, reverse charge), generating GST reports (GSTR-1, GSTR-3B), e-way bills.

• TDS (Tax Deducted at Source): Fundamentals, configuration, transactions, payments, reports.

• TCS (Tax Collected at Source): Concepts and transactions.

• Payroll: Introduction to payroll features, setting up payroll masters, processing payroll.

• Banking: Bank reconciliation, cheque printing.

• Data Management & Administration: Backup & restore, split company data, export/import data, security controls, TallyVault.

• Reports: Generating financial statements (Balance Sheet, P&L A/c), trial balance, registers & ledgers (sales/purchase register, cash/bank book), stock summary, ratio analysis.

Online Taxation Return Filing: Basic understanding and assistance in filling online ITR, VAT/CST returns (conceptual).

• Module 1: Computer Fundamentals & Operating Systems

• Introduction to Computers: Hardware, Software, Generations, Types of Computers.

• Memory Concepts: RAM, ROM, Storage Devices (HDD, SSD, USB).

• Input/Output Devices.

• Operating Systems: Windows (e.g., Windows 10/11) – basics, desktop management, file and folder management, system settings, control panel, software installation/uninstallation.

• Introduction to Networking and Internet: Types of networks, basic internet concepts, web browsers, search engines, email communication.

• Cyber Security Basics: Viruses, malware, data protection, online safety.

• Module 2: Microsoft Office Suite

• MS Word: Document creation, editing, formatting, tables, mail merge, headers/footers, proofreading tools, templates, document security.

• MS Excel: Spreadsheets, formulas, functions (mathematical, logical, statistical), charting, data sorting and filtering, pivot tables, data validation, basic macros.

• MS PowerPoint: Creating effective presentations, slide layouts, themes, transitions, animations, inserting multimedia (images, audio, video), presentation delivery.

• MS Access (Database Fundamentals): Introduction to databases, creating tables, relationships, queries, forms, and reports.

• MS Outlook: Email client configuration, sending/receiving emails, managing contacts, calendar, tasks.

Semester 2: Graphic Designing & Advanced Concepts

This semester focuses on the core graphic design principles and the practical application of industry-standard software.

• Module 3: Graphic Design Fundamentals & Raster Graphics

• Introduction to Graphic Design: Principles of design (balance, contrast, unity, hierarchy), color theory (CMYK, RGB), typography, layout, image resolution.

• Adobe Photoshop:

• Interface and Workspace Management.

• Image Editing: Cropping, resizing, color correction, retouching.

• Layers and Masks: Non-destructive editing.

• Selections and Compositing: Combining multiple images.

• Photo Manipulation and Special Effects.

• Working with Text and Shapes.

• Preparing images for print and web.

• Module 4: Vector Graphics & Page Layout

• Adobe Illustrator:

• Understanding Vector Graphics vs. Raster Graphics.

• Tools and Workspace.

• Creating and editing shapes, paths, and lines.

• Working with text, colors, and gradients.

• Logo design, icon design, illustration.

• Vector tracing, converting raster to vector.

• CorelDraw:

• Introduction to Desktop Publishing (DTP).

• Creating multi-page documents (brochures, flyers, magazines, books).

• Text and image integration, master pages, styles.

• Pre-press and print production basics.

Semester 1: Computer Fundamentals & Office Automation

This semester focuses on equipping students with essential computer literacy and proficiency in standard office productivity tools.

• Module 1: Computer Fundamentals & Operating Systems

• Introduction to Computers: Hardware, Software, Generations, Types of Computers.

• Memory and Storage Devices: RAM, ROM, HDD, SSD, USB.

• Input/Output Devices and Peripherals.

• Operating Systems (e.g., Windows 10/11): Basic operations, file and folder management, system settings, control panel, software installation.

• Introduction to Networking: Basic concepts of LAN, WAN, Internet, WWW.

• Cyber Security Basics: Understanding viruses, malware, phishing, safe Browse practices.

• Module 2: Microsoft Office Suite

• MS Word: Document creation, editing, advanced formatting, tables, mail merge, templates, styles, document security.

• MS Excel: Spreadsheets, formulas and functions (mathematical, logical, financial, statistical), data sorting, filtering, charting, pivot tables, data validation.

• MS PowerPoint: Creating professional presentations, slide layouts, themes, transitions, animations, inserting multimedia, presentation delivery tips.

• MS Access (Database Fundamentals): Introduction to database concepts, creating tables, relationships, queries, forms, and reports.

• MS Outlook: Email client configuration, professional email communication, managing contacts and calendars.

Semester 2: Web Designing & Development

This semester dives deep into the technologies and principles required for designing and developing dynamic and responsive websites.

• Module 3: Web Fundamentals & Static Web Design (Frontend)

• Introduction to Web Design: Understanding web browsers, servers, domain names, hosting, URL, HTTP/HTTPS.

• HTML5 (HyperText Markup Language):

• Structure of an HTML document, basic tags, text formatting, links, images, lists.

• Tables, forms, semantic HTML5 elements.

• Introduction to responsive design principles.

• CSS3 (Cascading Style Sheets):

• Introduction to CSS, selectors, properties, values.

• Applying styles (inline, internal, external).

• Box model, positioning, floats, flexbox, grid.

• Responsive web design techniques using media queries.

• Transitions, transformations, animations.

• Basic Graphic Design for Web: Understanding image formats (JPEG, PNG, GIF, SVG), optimization for web, basic image manipulation using tools like Photoshop (basic usage for web assets).

• UI/UX (User Interface/User Experience) Principles: Basic concepts of user-centric design, wireframing, prototyping (conceptual).

• Module 4: Dynamic Web Design & Scripting (Frontend & Basic Backend)

• JavaScript:

• Introduction to programming concepts, variables, data types, operators.

• Control flow (conditionals, loops).

• Functions, arrays, objects.

• DOM (Document Object Model) manipulation for interactive web pages.

• Event handling, form validation.

• jQuery (Optional/Framework Introduction): A fast, small, and feature-rich JavaScript library for simplified DOM manipulation and event handling.

• Bootstrap (Framework):

• Introduction to front-end frameworks.

• Using Bootstrap for responsive layouts, components (navigation bars, carousels, forms).

• Introduction to Backend & Databases (Conceptual):

• Understanding client-server architecture.

• Basic concepts of server-side scripting (e.g., introduction to PHP or Python basics).

• Introduction to databases (e.g., MySQL/SQLite for web applications).

• Module 5: Web Project & Deployment

• Final Project: Students typically work on a comprehensive web design project, applying all learned skills to build a complete, functional, and responsive website.

• Domain & Hosting Basics: Understanding how to register a domain name and host a website.

• FTP (File Transfer Protocol): Uploading files to a web server.

• Website Testing & Debugging: Basic tools and techniques.

• Introduction to SEO (Search Engine Optimization): Basic concepts for making websites discoverable.

Portfolio Development: Guidance on compiling a professional portfolio to showcase web design projects.