IT Tools for Business

Unit-I

Computer Fundamentals: Data, Instruction and Information, Characteristics of Computers, Various Fields of Application of Computers, Input-output Devices (Hardware, Software, Human ware and Firmware) Advantages and Limitations of Computer, Block Diagram of Computer, Function of Different Units of Computer, Classification of Computers. Data Representation: Different Number System (Decimal, Binary, Octal and hexadecimal) and their Inter Conversion.

Unit-II

Computer Software: Types of Software, Application Software and System Software, Compiler and Interpreter, Generations of languages, Low- and High-Level Languages. Computer Memory: Primary Memory & Secondary Memory. Storage Media. Introduction to Windows Operating System: All Directory Manipulation: Creating Directory, Sub Directory, Renaming, Coping and Deleting the Directory File Manipulation: Creating a File, Deleting, Coping, Renaming a File Using Accessories such as Calculator, Paint Brush, CD Player, etc..

Unit-III

MS-Word: History, Creating, Saving, Opening, Importing, Exporting and Inserting Document, Formatting Pages, Alignment, Paragraphs and Sections. Indents and Outdents, Creating Lists and Numberings Formatting Commands: Headings, Styles, Fonts and Size Editing, Viewing Text, Finding and Replacing text, Headers and Footers, Inserting Page 7 of 1 breaks, Page Numbers, Special Symbols and Dates Mail Merge, Preview and Printings Command.

MS-PowerPoint: History, Creating, Saving, Opening, Existing Presentation, Creating and Saving a Presentation using Auto Content Wizard, Design Template, Blank Presentation the Slide Sorter View, Slide Show, Inserting Pictures and Graphics and Printing Slides.

Unit-IV

MS-Excel: Introduction, Components of Excel History, Creating, Saving, Opening, Spreadsheet, Formatting Numbers and Text, Graph and Chart Formatting Commands, Menu Bar, Toolbars, Producing Charges, Protecting Cell Macro and Printing Operation, Spell Checking, Cell Editing, Calculation of Various Financial and Statistical Functions using Formulas.