ADCA (ADVANCE DIPLOMA IN COMPUTER APPLICATION)
The one year advance diploma in computer application course conducted by us to meet the demand of the growing needs of experts, internet, operating systems, office automation, multimedia & Video Mixing, programming language, Tally, DTP, Internet & Networking etc.
Duration : 12 Months.
Eligibility : 10th
Level : Advance Diploma
This course is divided in two semesters.
Computer Concepts and Fundamentals
Introduction of Computer, Evolution of the Computer, Computer Generations, Types of Computer, Characteristics of Computers, Classification of Computers, Basic Applications of Computer, Components of a Computer System, Computer Memories System, Input / Output Devices, Concept of Hardware & Software, Binary System, Digital Number System, Computer Virus & Vaccines / Anti-Virus, Network, IECT, E-Governance.
MS-Windows – 7 : Introduction, Different Versions of Windows 7, Basic Elements of Opening Screen, Elements of a window, Windows Accessories, WordPad, Notepad, MS-Paint, Calculator, Character Map, Control Panel, Switching between two windows, Searching Files/Folders, Windows Explorer, Folder, Recycle Bin, Start Menu, Use of Network, Disk Defragment, Personal Folders, Shortcut Keys.
MS-Windows - 10 : Introduction, Release, New Features, User Interface and desktop, System and Security, Online Services and functionality, Multimedia and Gaming.
Introduction of MS-DOS, File Naming, Internal Commands, External Commands, Attrib Command & Batch File.
Launch Word and navigate the editing screen, Create and edit a Word document, Use the proofing tools, Apply character formatting and themes, Set and modify tab stops, Format paragraphs, Preview and print a document, Print envelopes and labels, Work with columns, pictures, diagrams, and charts, Create basic tables, Use templates and wizards, Compare and merge documents., Integrate Word with other Office applications, Customize tables, Work with multipage documents, Create custom styles and control pagination, Use the mail merge wizard, Use other mail merge features, Sort text and tables, Create and modify document references, Work with drawing objects and graphics, Work with large documents, Use online forms, Integrate Word documents with the Internet, Use macros, Manage files
Examine spreadsheet concepts and explore the Microsoft Office Excel environment, Create, open and view a workbook, Save and print workbooks, Enter and edit data, Modify a worksheet and workbook, Work with cell references, Learn to use functions and formulas, Create and edit charts and graphics, Filter and sort table data, Work with pivot tables and charts, Import and export data.
arithmetic calculation, Freeze pane , Auto completion of series , Sort and filter ,Charts ,Data validation, Conditional formatting , Importing data and text to columns , Functions o Mathematical- String ,IF, AND, OR ,NOT, Searching: match, search, vlookup , Dates , Pivot tables ,Recording and Editing Macros.
Microsoft Power Point
Examine slide show presentation concepts and explore the Microsoft Office PowerPoint environment, Create a new presentation, Modify presentation themes, Add and edit text to slides, Add new slides to a presentation, Insert clipart images and shapes to slides, Insert and modify tables and charts, Add sound and video to a slide presentation, Insert and edit animations and slide transitions, Display a speaker-lead and self-running presentation.
Examine database concepts and explore the Microsoft Office Access environment, Design a simple database, Build a new database with related tables, Manage the data in a table ,Query a database using different methods, Design a form, Generate a report, Import and export data, Basics of RDBMS, Introduction to database -What is a Database, Why use a Relational Database, Overview of Database Design, Integrity Rules (Primary/Foreign Key, One-to-Many, Many-to-Many, One-to-One), Introduction to MS Access (Objects, Navigation). Create a Table in MS Access, Data Types, Field Properties, validation rules Data Entry, Add record delete record and edit text, Sort option, find/replace, What is filter, rearrange columns, freeze columns, Edit a Tables- copy, delete, import, modify table structure ,Working with Query, Working with Forms, Tool Box, working with Reports, Introduction to Reports, Types of Basic Reports: Single Column, Tabular Report Groups, Single and Multi table report, Preview and print report, Creating Reports and Labels, Wizard
DTP(Desktop Publishing-Print Media Designing)
Getting started with Corel Draw- Introduction to Corel Draw ,Features of Corel Draw ,Corel Draw Interface ,Tool Box Moving from Adobe Illustrator to Corel Draw ,Common Tasks ,Drawing and Coloring -Selecting Objects, Creating Basic Shapes ,Reshaping Objects ,Organising objects ,Applying color fills and Outlines ,Mastering with Text- Text Tool, Artistic and paragraph text Formatting ,Text Embedding Objects into text ,Wrapping Text around Object ,Linking Text to Objects, Applying Effects - Power of Blends ,Distortion ,Contour Effects, Envelopes, Lens effects ,Transparency ,Creating Depth Effects ,Power Clips ,Working with Bitmap Commands -Working with Bitmaps, Editing Bitmaps , Applying effects on Bitmaps ,Printing,
Introduction To Adobe Photoshop, Getting Started with Photoshop, Working with Images, Resizing & Cropping Images, Working With Basic Selections, Getting Started With Layers, Painting In Photoshop, Photo Retouching, Introduction To Color Correction, Using Quick Mask Mode, Working With The Pen Tool, Creating Special Effects, Exporting Your Work
Multimedia,Flash Animation & Video Mixing
o Video & Audio Mixing
o Split Video & Audio Clips
User Interface and Company Management : Introduction to Tally ERP9 , Installing Tally ERP9 License Server ,Creating a Company , Data Path for Tally ERP9 Companies ,Altering and Deleting Company , Gateway of Tally and User Interface, Understanding Ledgers ,Creating Ledgers ,Creating Multiple Ledgers ,Altering and Deleting Ledgers, Masters – Groups ,Billwise Debtors and Creditors Ledgers , Voucher Types and Class - Contra, Payment, Receipt, Journal, Sale, Purchase, Understanding Inventory- Stock Group, Godown & Locations, Stock Category, Unit of Measure, Stock Item, Goods and Services Tax (GST)- About Goods and Services Tax (GST), Activating Tally in GST, Setting Up GST (Company Level, Ledger Level or Inventory Level) , GST Taxes & Invoices , Understanding SGST, CGST & IGST, Creating GST Masters in Tally, Cost Centres and Cost Categories , Purchase and Sales Reporting, Stock Analysis and Reports , Cash and Bank Reports , Financial Reports - Trail Balance, Profit & Loss Account, Balance Sheet, Export, Import, Backup and Restore, Tax Deducted at Source (TDS), Value Added tax (VAT), Income tax, & Service Tax.
Web Designing (HTML, DHTML, CSS)
HTML, DHTML, CSS : Introduction to HTML, HTML fonts, Styles, Links, Images ,Tables ,Static V/S Dynamic Websites, HTML attributes, Headings ,Paragraphs, Formatting ,Lists, Colors ,Forms ,Links on a same page, DHTML Introduction, Marquee Tag Effects ,CSS Introduction ,CSS Id & Class , Styling Backgrounds ,Fonts, Links ,CSS Border ,Margin, Cell Padding, Style Guide ,Media, Video ,Audio ,Plug-ins.
Programming Language (C & C++)
Introduction -The C Language and its Advantages , The Structure of a C Program ,Writing C Programs ,Building an Executable Version of a C Program ,Debugging a C Program ,Examining and Running a C Application Program , Data Types and Variables -Data Types, Operands, Operators, and Arithmetic Expressions, Input/Output Management -The Input/Output Concept ,Formatted Input Function ,Control-Flow Statements - The Control-Flow Program Statements ,Looping Statements ,The Data-checking process, Modular Programming with Functions -The C Function ,Passing Data to Functions ,Passing an Address to Modify a Value in Memory ,Using Functions in the Checkbook Program ,C Standard Library Functions ,Arrays, Pointers, and Strings ,Using Arrays, Strings, and Pointers in the Checkbook Program Structures ,Structures ,Arrays of Structures , Passing Structures to Functions ,Nesting Structures ,File Input/Output -Command-line Arguments , Combining Command-line.
Introduction to C++ ,Creating a project ,Writing, compiling and running a program ,Variables and data types- Expressions ,Constants ,Operators ,Type conversions ,Looping constructs : While, do…while, for loops ,If…else statements ,Switch/case construct, Functions -Passing arguments ,Function prototyping ,Default argument initializers ,Inline functions ,Arrays -Array initialisation ,Multi-dimensional arrays ,Character arrays ,Working with character strings, Pointers -Pointer and arrays ,Pointers to character strings ,Arrays of pointers ,C++ classes, Inheritance -Base classes and derived classes ,Inherited member access ,Base class initialisation ,Protected members of a class.
Internet & Networking Overviews
Origin of Internet, Computer Network- LAN, MAN, WAN, ISP(Internet Service Provider), Newsgroups, IRC (Internet Relay Chat) ,Telnet, Instant Messaging, FTP, Intranet, WWW (World Wide Web) ,WEBSITE, WEB SERVER, WEB CLIENT/ WEB BROWSER, HTTP (HYPERTEXT TRANSFER PROTOCOL), URL(UNIFORM RESOURCE LOCATOR), BOOKMARK, WEB COOKIES, IP Address, Domain Name System, Search Engine, E- Commerce, Firewall, Netiquettes. Computer Communication, Communication Media, Microwave Communication, Satellite, Modules of Transmission, Serial and Parallel Transmission, Multiplexing, Analog and Digital Data Transmission.