ADVANCED DIPLOMA IN COMPUTER APPLICATIONS ( ADCA )

BASIC COMPUTER COURSE                                                                                                    Module 1

Word Processing

·         Creating letters, reports and other documents, academic writing and research projects, resume making etc.

·         Text Editing and Formatting

·         Project templates, Form Designing, Cover Page, Designing question paper, Table, advertisement formatting, invoice formats.

·         Text Editing, Format Painter, Hyphenation, Watermark, Indentation, Index making, Bibliography, Mail Merge, Tracking, Document views, etc.

Basic Excel + Advance Excel (Official and Financial)

·         Functions and Formula (Logical, Reference, Text, Math, Finance etc.)

·         IF, SUM, AVERAGE, HLOOKUP, VLOOKUP, XLOOKUP, DATE, SUMIF, CONCATENATE, DAYS360, CEILING, ABS, SUMPRODUCT etc.

·         MIS (Management Information System Reporting)

·         Create Dashboard of your Data

·         Practical Illustration and Projects with Groups of Function/Formula

·         Formula, Sorting, Pivot Table, Conditional Formatting, Formula Auditing, Grouping, Consolidate, Goal Seek, Data Table, Data Validation, Table Formatting, Filter, Advance etc.

PowerPoint

·         Slide Design and layout, Animations and Transition, SmartArt, Charts, Customization in slides, Slide Master, Presenter view, Slide show etc.

MS Access

Internet

·         Internet Browser Mail Sites, Online Surfing, Online Form Filling Online Payment, Gmail, etc.

GRAPHICS DESIGNING                                                                                     Module 2

Photoshop

·         For Basic Photo Editing, To Create Photo Manipulations, For Graphic Design Work, for Improving Product Photos, To Create GIF Animations etc.

·         Remove Background From Photos, Enhance Images For Print, Effect On Photos, YouTube Thumbnails, Adding Affects, Image Editing, Practical Effects, etc.

CorelDraw

·         For Cover Page Designing, Logo Making, Card Designing, Certificate Format Designing, Advertisement Format Designing, etc.

·         Menu, Tools, etc.

Page Maker

·         To Design Professional Looking Documents Like Brochures, Newsletters, Reports, Design E-Books, Hand Bills, Visiting Cards, Wedding Cards, Student Id Card, etc.,

·         Data Management, Data Applications, Data Linking, Data Queries, Data Customization, Data Automation, Data Sharing, Application Forms, etc.

FINANCIAL ACCOUNTING                                                                                    Module 3

·         Tally Prime, Tally, Tally E.R.P 9

·         Introduction of Accounting, Golden rules of Accounting, Company Creation, Alter, Delete, Ledger Creation, Groups, Stock Item Creation

·         Accounting info & Vouchers

·         Journal Entry in voucher

·         All Vouchers Purchase, Sale, Payment, Receipt, Contra, Journal Debit Notes,
Credit Notes, and others.

·         Inventory Info Vouchers, Configuration of Stock Group, Stock Godown, Stock Categories Batch Wise Details

·         GST Introduction, Types of GST, Calculation of GST, HSN Code, CGST, SGST, IGST

·         Bank Reconciliations, GST Return, etc.

·         Registration Structure of GST and rules, Process of GSTIN, Types of Return

·         Introduction to Income Tax, Digital Signature, Various Analytical Reports, Calculation and Record in Tally.

WEB DESIGNING                                                                                                             Module 4

·         Understanding the role of Web / Media Developer

HTML 

• HTML Tags, Elements and Attributes
• Images in HTML
• Connecting Web Pages
• Lists, Tables, Frames and Forms
• More on HTML 5
• HTML Multimedia

CSS

• Role of CSS in Web designing
• CSS Basics
• Selectors in CSS & CSS Rules Overriding
• Background colors, images, gradients, Borders
• Text effects
• Multi Background
• Web Fonts
• 2D and 3D Transforms
• Animations

JavaScript

• Introduction to the scripting language- JavaScript
• JavaScript Fundamentals
• Events and Objects
• Window, frame and form object