BBA MS3SE11 Computer Application in Business.pdf

Syllabus Hours per Week Total Course Code Course Name L T P Hrs. Credits...

Syllabus Hours per Week Total Course Code Course Name L T P Hrs. Credits Computer Application in MS3SE11 Business 2 0 2 4 3 Course Contents: UNIT- I Basic Concepts: Characteristics of a Computer, Advantages of Computers, Limitation of Computers; Types of Computers; Applications of computers, Hardware, Firmware, Livewire; Software; System Software: Operating system, Translators, interpreter, compiler; function of operating system; Basic commands of operating system, Application software. UNIT- II Internet: Meaning of Internet; Growth of internet, Owner of Internet, Anatomy of Internet, Net Etiquette ; World Wide Web; Internet Protocols, Usage of Internet to society, Search Engines. UNIT- III Word Processing: Introduction to word Processing; Word processing concepts, Opening an existing document/creating a new document; saving, Selecting text, Editing text, Finding and replacing text, Formatting text, Bullets and numbering, Tabs, Paragraph Formatting, Page Setup. UNIT- IV Spreadsheet and its Business Applications: Spreadsheet concepts; Creating a work book, saving and editing a work book, inserting, deleting work sheets, entering data in a cell, formula Copying, Inserting Charts- LINE, PIE, BAR, Mathematical- ROUND ALL, SUM, SUMIF, COUNT, COUNTIF; Logical - IF, AND, OR,Statistical – AVERAGE, MAX, MIN, STDEV, FREQUENCY, Financial - PMT, PPMT, IPMT. UNIT- V Presentation Software & Practical applications: Creating a presentation; Editing, Sorting, Layout, Rehearse timing. Loan& Lease statement, Frequency distribution. Regression, Cumulative and calculation of Means, Mode and Median. Text Books 1. Sinha Pradeep K. and Sinha,Preeti Foundation of Computing, , BPB, Publication. 2. BharihokaDeepak, Fundaments of Information Technology, Excel Book, New Delhi Reference Books 1. RajaramanV., Introduction to Information Technology, PHI. New Delhi 2.HuntR., ShelleyJ., Computers and Commonsense, Prentice Hall of India New Delh