Course Details

• Fundamental :

• THEORY:• History and Generations of Computer .• Advantage and disadvantage of Computer • Block Diagram of a Computer.• Description of Different parts of a Computer.• System Software and Application Software.PRACTICAL:• Identification of Different parts of a Computer System.• Turning a computer system on and off

• Windows OS

PRACTICAL:• Identifying different Desktop Icons. My Computer, My Documents• Changing Desktop Backgrounds, Mouse Pointer, Screen SaverNotepad , WordPad, MS Paint

• MS Word:

THEORY:• Introduction to MS Office•• Word Processing Software PRACTICAL:• Document formatting options• Tables, Bullets and Numbering• Font, Alignment, paragraph formatting• Insert Picture, Clipart, Shapes, WordArt• Header & Footer, Text Box• Page Layout, Mail Merge• Spelling & Grammar

• MS Excel

THEORY:• Introduction to MS Office• Electronic SpreadsheetPRACTICAL:• Cell Formatting Options• Formulas and Functions• Charts• Sort, Filter, What if Analysis, Grouping Subtotal• Pivot Table

• MS PowerPoint

PRACTICAL: • Creating Slide Show by using Animation Technique. • Slide Master. • Clip Art. Picture Editing

• Internet & Email

THEORY: Internet Basics  What is Internet? How Internet works? Types of Internet Browsers and Web pages. Introduction to Web Overview of Internet and WWW. Web pages, home page, Web browsers, search Engines, web sites and servers. PRACTICAL: Internet Concepts  Opening websites and browsing. Writing, reading and sending emails.Connecting to Internet.  Browsing popular sites and using search engines.  Rail, Bus & Flight Ticket Booking Process

Semister I:  Same as CITA

Semister II:

MS Access :

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.  • Design a Database • Build a Database • Work with Forms • Sort, Retrieve, Analyze Data • Work with Reports • Access with Other Applications • Manage an Access Database

Algorithm and flowchart : 

• Basic Concept of algorithm and flowchart. Benefits of Using algorithms and flowcharts. • Basic/Common flowchart Symbols, Basic Problem Solving through algorithm and draw the flow chart (Example: Sum of two Numbers). 

Visual Basic :

1) Introduction to Visual Basic: Introduction Graphical User Interface (GUI), Programming Language (Event Driven), The Visual Basic Environment, How to use Visual Basic complier to compile / debug and run the programs. 2)  Introduction to Visual Basic Controls: Textboxes, Frames, Check Boxes , Option Buttons, Images, Setting a Border and Styles, The Shape Control, The line Control, Working with multiple controls and their properties, Designing the User Interface, Keyboard access, tab controls, Coding for controls. 3)  Variables: Variables Public, Private, Data Types, Constants, Declaring variables, Scope of variables, Val Function, Arithmetic Operations. 4)  Decision and Conditions: If Statement, Comparing Strings, Compound Conditions (And, Or, Not), Case Structure, Using If statements with Option Buttons and Check Boxes, Displaying Message in Message Box, Testing whether Input is valid or not. 5)  Menus defining / Creating and Modifying a Menu, Using common dialog box. 6)  Sub-Procedures and Sub-functions. 7)  Multiple Forms Creating, adding, removing Forms in project, Hide, Show Method, Load, Unload Statement, Me Keyword, Referring to Objects on a Different Forms 8)  List, Loops and Printing: List Boxes & Combo Boxes, Filling the List using Property window / Add Item Method, Clear Method, List box Properties, Removing an item from a list, List Box/ Combo Box, Do/Loops, For/Next Loops, Using MsgBox Function, Using String Function, Printing to printer using Print Method. 9)  Single-Dimension Arrays 10)  Accessing Database File: Creating the database files for use by Visual Basic (Using MSAccess), Using the Data Control, setting its property, Using Data Control with forms, navigating the database in code (the record set object using the move next, movepreviouse, move first and move last methods, checking for BOF and EOF, using list boxes and combo box as data bound controls, updating a database file (adding, deleting records). 

BASIC OF ACCOUNTING :

1. Introduction

2. Types of Accounts

3. Accounting Principles or concepts

4. Mode of Accounting

5. Rules of Accounting

FUNDAMENTALS OF TALLY.ERP 9 :

1. Company Features

2. Configuration

3. Getting functions with Tally.ERP9

4. Creation / setting up of Company in Tally.ERP9

ACCOUNTING MASTERS IN TALLY.ERP 9 :

1. Chart of Groups

2. Groups

3. Multiple Groups

4. Ledgers

5. Multiple Ledgers

INVENTORY MASTERS IN TALLY.ERP9 :

1. Stock Groups

2. Multiple Stock Groups

3. Stock Categories

4. Multiple Stock Categories

5. Units of Measure

6. Stock Items

VOUCHERS ENTRIES IN TALLY.ERP9 :

1. Introduction

2. Types of Vouchers

3. Chart of Vouchers

4. Accounting Vouchers

5. Inventory Vouchers

6. Invoicing

GST IN TALLY :

TECHNOLOGICAL ADVANTAGES IN TALLY.ERP9 :

1. Security controls

2. Backup and restore

3. Import and export of data

4. Printing Reports and Cheques

GENERATING REPORTS IN TALLY.ERP9 :

1. Financial Statements

2. Profit & Loss Account

3. Balance Sheet

4. Accounts Books and Reports

5. Inventory Books and Reports

6. Exception Reports

7. Statutory Reports

8. Trail balance

9. Day Book

10. List of Accounts

11. Stock Summary

HARDWARE :

1. Basic Hardware Theory (Computer Architechture, SMPS, Mother Board & Micro Processor etc.)

2. Introduction to Computers.

3. Types of Computers.

4. Introduction to Input Output Devices.

5. Introduction to Storage Devices.

6. Assembling a PC.

7. Basic Trouble shooting during the assembling.

8. Basic troubleshooting of PC.

9. BIOS, CMOS, HDD Partition & Installing Operating System.

10. Construction & Functioning of Different Personal Computer Parts (Monitor, Motherboard, Hard             disk, CD-ROM etc.).

11. Software Instillation.

NETWORKING :

1. Introduction to Various types of Cables and Connectors Used in Networking.

2. Introduction to Networking and Networking Concepts.

3. Networking Fundamentals & Network Configuration.

4. Explain network Topologies.

5. Explain how devices access local and remote network resources.

6. Cabling.

7. Repeaters, Hubs, Switches, Bridges, Routers.

8. Configuration of IP Address.

9. LAN Practical’s.

10. IP Addressing and IP Classes.

11. Basic Network Troubleshooting.

12. Basics of Network Security.

13. Peer to Peer Networks

14. Client-Server Networking

15. Setting up Internet