Download Computer Application in Business by Dr.P.Pizwan Ahmed and more Study notes Computer Applications in PDF only on Docsity!
Computer Applications in Business
With Tally.ERP
(Computer Fundamentals, Windows7, MS-Word2007, MS-Excel2007, MS-
Access2007, MS-PowerPoint2007, Tally ERP.9, Internet, E-Commerce,
Networking)
(For BBA, B.Com (Bank Management), B.Com.(Applied), B.Com.(Cooperation),
M.Com. Courses)
By
Dr.P.Rizwan Ahmed, MCA., M.Sc., M.Phil., Ph.D,
Head of the Department
Department of Computer Applications &
Post Graduate Dept. of Information Technology
Mazharul Uloom College, Ambur - 635 802
Vellore Dist. Tamil Nadu.
Margham Publications
No.24, Rameswaram Road, T- Nager,
Chennai- 600 017 Phone:(044) 2432 2469
Web Site: www.margham.in E-mail: www.margham.tn@gmail.com
CONTENTS Preface Acknowledgement
Chapter 1 Introduction to Computers
1.1 Meaning of Computer 1.2 Characteristics of a Computer 1.3 Areas of Applications / Uses of Computers in different fields 1.4 Anatomy of Digital Computer 1.5 Component of a Computer 1.6 Input-Process-Output Cycle 1.7 Memory and Control Unit 1.7.1 Memory Unit 1.7.2 Control unit 1.8 Input and Output Devices 1.8.1 Input Devices 1.8.2 Output Devices 1.9 Hardware 1.10 Software 1.10.1 System Software 1.10.2 Application Software 1.11 Programming Languages / Computer Languages 1.11.1 Low Level or Machine language 1.11.2 Assembly Language 1.11.3 High level language 1.12 Computer Viruses, Bombs, Worms 1.12.1 Types of Viruses 1.12.2 Categories of Viruses Summary Review Question Chapter 2 Operating System 2.1 Introduction 2.2 Definition of Operating System 2.3 History of OS / Evolution of Operating Systems 2.4 Function of Operating System 2.5 Classification of Operating system 2.6 Introduction to Windows
3.20 Header and Footer 3.21 Footnotes and Endnotes 3.22 Formatting Document 3.23 Spelling and Grammar Check 3.24 Word Count 3.25 Thesaurus 3.26 Auto Correct 3.27 Working with Tables 3.27.1 Manipulating Tables 3.28 Mail Merge 3.29 Working with charts and Graphs 3.30 Printing a document Summary Review Question Chapter 4 MS Excel 2007 4.1 Introduction to Spreadsheet 4.2 Applications of Spread Sheet 4.3 MS Excel 4.4 Features of Excel 4.5 Starting Microsoft Excel 2007 4.6 What is on the Screen? 4.7 Building Worksheets 4.8 Entering data in work sheets 4.9 Using Auto Fill 4.10 Editing and Formatting Worksheets 4.10.1 Editing Worksheets 4.10.1.1 Editing a Constants 4.10.1.2 Editing Formula 4.10.1.3 Adding and Removing Rows and Columns 4.10.1.4 Hiding Rows and Columns 4.10.1.5 Resizing Column Widths and Row Heights 4.10.1.6 Sorting and filtering data 4.10.1.7 Find and Replace 4.10.2 Formatting Worksheet 4.11 Creating and Formatting different types of Charts 4.11.1 Types of Chart 4.11.2 Elements of Charts 4.11.3 Creating Charts 4.11.4 Formatting Charts 4.11.5 Printing Charts 4.12 Application of Financial and Statistical Function
4.12.1 Financial Functions 4.12.2 Statistical Functions 4.13 Analyzing and Organizing Data using Automatic Subtotal 4.14 Saving, Opening and Closing Workbooks 4.15 What is Pivot Table? 4.15.1 Introduction to Pivot Tables 4.16 Sorting and Filtering Data 4.16.1 Sorting Data 4.16.2 Filtering data using auto filter, Customs filters 4.17 Formulas 4.17.1Creating Formulas 4.17.2 Copying Formulas 4.18 Naming Ranges 4.19 Using Functions Summary Review Questions Chapter 5 Accounting Basics
5.1 Introduction of Accounting
5.2 Real, Personal and Nominal Accounts
5.3 Meaning and Definition of Accounting
5.4 Characteristics of Accounting
5.5 Objectives of Accounting
5.6 The Nature of Accounting
5.7 Importance and Advantages of Accounting
5.8 Limitation of Accounting
5.9 Process of Accounting
5.10 Methods of Accounting
5.10.1 Single Entry
5.10.2 Double Entry System
5.11 Types of Accounts
5.11.1 Personal Accounts
5.11.2 Real Accounts
5.11.3 Nominal Accounts
5.12 Golden Rule of Accounting
5.13 Accounting Records
5.14 Books of Account
5.14.1 Journal
5.14.2 Ledger
5.15 Financial Statements
5.15.1 Trial Balance
8.13 Uninstalling Tally.ERP 9 8.14 Getting Started with Tally.ERP 9 8.15 Quitting Tally.ERP 9 8.16 Components of Tally.ERP 9 Screen 8.17 Configuration of Tally screens and menus 8.18 Creation of Company Summary Review Questions Chapter 9 Groups and Ledgers 9.1 Groups 9.2 Pre defined Groups - in Tally.ERP 9 9.3 Creating a Group 9.3.1 Creating a Single Group 9.4 Creating Multiple Groups 9.5 Displaying a Group 9.6 Editing and Deleting Groups 9.7 Ledger 9.7.1 Creating a Ledger 9.7.2 Creating Ledger in Normal Mode 9.7.3 Creating Multiple Ledgers 9.7.4 Editing and Deleting Ledgers Summary Review Questions Chapter 10 Vouchers 10.1 Introduction to vouchers 10.2 Voucher Entry 10.3 Editing and Deleting Vouchers 10.4 Accounting Vouchers 10.4.1 Contra voucher 10.4.2 Payment voucher 10.4.3 Receipt voucher 10.4.4 Journal Voucher 10.4.5 Sales voucher / invoice 10.4.6 Credit note voucher 10.4.7 Purchase voucher 10.4.8 Debit note voucher 10.4.9 Memo voucher
10.4.10 Inventory Vouchers Summary Review Questions Chapter 11 Inventory Masters 11.1 Introduction to Inventory 11.2 Stock Categories 11.2.1 Creating Stock Category 11.2.2 Displaying and Altering Stock Categories 11.3 Stock Groups 11.3.1 Creating Stock Group 11.4 Stock Items 11.4.1 Creating a Stock Item 11.5 Configuration and features of Stock Item 11.6 Editing and Deleting Stocks 11.7 Purchase Order 11.8 Sales order Summary Review Questions Chapter 12 Introduction to Cost and Budget 12.1 Introduction to Cost Centre 12.2 Introduction to Cost Category 12.3 Cost Centre and Cost Category in Tally.ERP 12.3.1 Creating Cost Categories 12.3.2 Creating Cost Centres 12.4 Editing and Deleting Cost Centre 12.5 Editing and Deleting Cost Category 12.6 Usage of Cost Categories 12.7 Usage of Cost Centres 12.8 Introduction to Budget 12.9 Budgetary Control 12.10 Creating a Budget 12.11 Editing and Deleting Budget Summary Review Questions
14.11.3 Organization Chart 14.12 Handouts and Printing 14.12.1 Creating Handouts 14.12.2 Adding Headers and Footers 14.13 Inserting Sounds 14.14 Inserting Videos 14.15 Clip art 14.15.1 Inserting Clip Art 14.15.2 Editing a clip art image 14.16 Shapes 14.16.1 Drawing Shapes 14.16.2 Insert shapes 14.16.3 Copy Shapes 14.17 Create a Flow Chart 14.18 Printing in PowerPoint 14.19 Shortcuts Keys Summary Review Questions Chapter 15 Microsoft Access 2007 15.1 Introduction 15.2 Features of MS Access 15.3 Access Concepts and Terms 15.4 Starting and Quitting Access 15.4.1 Quitting Access 15.5 Components of Access Window 15.6 Data base and Tables 15.6.1 Creating a Database 15.6.2 Creating a table 15.6.3 Data Types 15.7 Editing Fields 15.7.1 Adding fields 15.7.2 Deleting a field 15.7.3 Renaming fields 15.7.4 Moving Fields 15.7.5 Resizing fields 15.8 Finding, Sorting, and Displaying Data 15.8.1 Query 15.8.2 Creating a simple query using the query wizard 15.8.3 Creating Query Using Design View 15.8.4 Save and Run Query 15.8.5 Sort a Query
15.8.6 Using Wild Cards in Queries 15.8.7 Sorting Query Result 15.8.8 Multilevel Sort 15.8.9 Finding and Replacing Data 15.9 Printing Summary Review Questions Chapter 16 Internet and its Applications 16.1 History of Internet 16.2 Internet 16.3 Uses of Internet / Application of Internet 16.4 Advantages of Internet 16.5 History of World Wide Web (WWW) 16.6 What is Web? 16.6.1 Types of Websites 16.7 Difference between internet and web 16.8 Internet Service Provider (ISP) 16.9 Internet Services 16.10 Internet Addressing / IP Address 16.10.1 Characteristics of IP address 16.11 Internet Protocol (IP) 16.12 Domain Name Addressing 16.13 Web Browser 16.14 Uniform Resource Locator (URL) 16.15 Domain Name System (DNS) 16.15.1 Generic Top Level Domain (gTLD) 16.15.2 Country code top- level domains (ccTLD) 16.16 Internet Explorer 16.17 Features of Internet Explorer 6 16.18 Browser Settings 16.18.1 Enable Microsoft Internet Explorer 6 16.18.2 To delete cookies in Internet Explorer 6 16.18.3 Increasing the size of the text 16.18.4 Changing the display on the screen 16.19 Instant Messaging (IM) 16.19.1 Popular IM Programs 16.20 Download and Upload 16.21 Online and Offline 16.22 Types of internet connections 16.23 Modem 16.23.1 Working principle of a modem 16.24 E-mail
17.9.5 Consumer to Consumer (C2C) 17.10 Difference between B2B, B2C and C2C 17.11 Applications of E-Commerce 17.12 Benefits of E-Commerce 17.13 Advantages of Electronic Commerce 17.14 Disadvantages of Electronic Commerce 17.15 e-Commerce Technologies 17.15.1 Cyber banking 17.15.2 Implementing online financial services 17.15.3 Role of electronic real estate market. 17.15.4 Online Job Market 17.16 Electronic Commerce Framework 17.16.1 Common Business Services 17.16.2 Messaging and information distribution services 17.16.3 Multimedia content and network publishing services 17.16.4 Information Services 17.16.5 Public Key and Privacy Issues 17.16.6 Technical Standard 17.17 Consumer Oriented Applications 17.18 Mercantile process Models 17.19 Mercantile models form the consumer’s perspective 17 .20 Mercantile models form the merchant’s perspective 17.21 Electronic Payment System 17.21.1Credit Cards 17.21.2 E-Cash 17.21.3 Smart Card 17.21.3.1 Smart card Applications 17.22 Difference between conventional and electronic payment systems 17.23 Digital Certificate 17.24 Electronic Fund Transfer (EFT) 17.24.1 Categories of EFT 17.24.2 Advantages of EFT 17.25 List of Banks in India using EFT 17.26 ATM and Online Banking 17.27 Online Banking 17.28 Encryption and decryption Summary Review Questions Chapter 18 Data Communicational and Network 18.1 Data Communication 18.1.1 Characteristics of Data Communication 18.1.2 Applications of Data Communications
18.2 Computer Network 18.3 The Uses of a Network 18.4 Types of Networks 18.4.1 Local Area Network (LAN 18.4.2 Wide Area Network (WAN) 18.4.3 Metropolitan Area Network (MAN) 18.5 Difference between LAN, MAN, WAN 18.6 Intranet and Extranet 18.7 How Networks Are Structured 18.7.1 Server-Based Networks 18.7.2 Client/Server Networks 18.7.3 Peer-to-Peer Networking 18.8 Network Topologies 18.9 Transmission Media 18.9.1 Guided Transmission Media 18.9.1.1Twisted Pair 18.9.1.2 Coaxial Cable 18.9.1.3 Fiber Optic Cable 18.9.2 Wireless Transmission / Unguided Communication Media 18.9.2.1 Radio Transmission 18.9.2.2 Microwave Transmission 18.9.2.3 Infrared 18.10 Network Hardware 3.10.1 Network Interface Card (NIC 18.10.2 Network Devices 18.11 Protocols Summary Review Questions APPENDIX I: Tally Exercises APPENDIX II: Tally Multiple Choice Questions and Answers APPENDIX III: Model Question Papers APPENDIX IV: Past University Question Papers
