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.
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
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.
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.