Computer Application in Business

Explore the fundamentals of computing and its applications in business, from understanding hardware and software to leveraging web tools like Google Suite. Learn how computers enhance business operations through information systems, IT security, and internet services. Discover the intricacies of word processing, multimedia, and spreadsheets to create impactful business documents and presentations. Master advanced spreadsheet functions for financial analysis and data visualization, crucial for informed decision-making in today’s digital economy.

Computer Application in Business

1 Introduction to Computer

  1. Overview of Computers
  2. Evolution of Computers
  3. Classification of Computers
  4. Components of a Computer System: Hardware & Software
  5. Applications of Computers
  6. Advantages and Disadvantages of Computers

2 Application of Computers

  1. Role of Computers in Business Organisation
  2. Computers for Society
  3. Role of Computers in Business, Trade and Commerce
  4. Computer Role in Online Business
  5. Computer Role in Online Banking and Finance
  6. Importance of Computer Networks

3 Web Applications

  1. Web Browser
  2. Google Drive
  3. Google Docs
  4. Google Sheets
  5. Google Suite
  6. Google Forms
  7. Cloud Based System

4 Basics of Computer Software

  1. Software and its Types
  2. System Software
  3. Application Software
  4. Windows Operating System
  5. Android Operating System for Mobile
  6. Free and Open Software
  7. Google Play Store

5 Business Information System

  1. Data and Information
  2. Introduction to Business Information System
  3. Database Management System (DBMS)
  4. Decision Support System (DSS)
  5. Enterprise Resource Planning (ERP)
  6. Management Information System (MIS)
  7. General Data Protection Regulation (GDPR)

6 IT Security Measures in Business

  1. Why Systems Are Not Secure?
  2. Cyber Security
  3. Identity Theft
  4. Key Security Principles
  5. Six Essential Security Actions
  6. Applying Principles to Information Security Policy
  7. Security Self-Assessment
  8. Digitization
  9. CAPTCHA Code
  10. One Time Password (OTP)

7 Internet Services and E-mail Configuration

  1. About the Internet
  2. Types of Internet Services
  3. About E-mail and its Configuration
  4. Web Browsers
  5. World Wide Web (WWW)
  6. Uniform Resource Locator (URL)
  7. Domain Names

8 Plastic Money, E-Wallet and Online Pay

  1. Origin of Plastic Money
  2. Usage of Plastic Money
  3. E-Wallet
  4. Development of E-Wallet System
  5. E-Payment System in Commerce
  6. Mobile Wallets, Payment & Card Network
  7. Consumer Adoption in Mobile Wallet
  8. Effects of Demonetization on Digital Payment
  9. Success Story of Wallets

9 Basics of Word Processing

  1. Word Processing
  2. Salient Features of MS Word
  3. Let’s Start MS-Word
  4. Main Menu Options (Tabs in MS Word)
  5. Creating Documents by MS Word

10 Working with Word Processing

  1. File Management in MS Word
  2. Entering and Editing Text
  3. Character Formatting
  4. Line Spacing and Alignment
  5. Working with Tables and Graphics
  6. Working with Google Docs
  7. Comparison Between MS-Word and Google Docs

11 Advanced Tools Using Word Processing

  1. Meaning of Mail Merge
  2. Components of Mail Merge
  3. How to Merge Mail
  4. Equation Editor
  5. Tracking
  6. References

12 Creating Business Documentation

  1. Creating a Business Report
  2. Using MS-Word for Report Writing
  3. Report Finalization
  4. Sample Business Documentation
  5. Creating a Detailed Project Report (DPR)

13 Working with PowerPoint

  1. PowerPoint Basics – Inserting a New Slide
  2. Slide Views
  3. Inserting a Graph & Diagram
  4. Inserting Picture, Sound, and Video
  5. Saving PPT Files in External Memory & Cloud

14 Multimedia, Video-Making and You Tube

  1. Meaning of Multimedia
  2. Usage and Making Multimedia
  3. YouTube
  4. Google AdSense
  5. Future of Animation with Artificial Intelligence

15 Creating Business Presentation

  1. Making Presentation with Features of PowerPoint
  2. Making Business Presentation
  3. Making Research Proposal Presentation
  4. Making Project Presentation

16 Spreadsheets Concept

  1. Starting MS Excel
  2. Excel Screen Layout
  3. Excel Menu
  4. Making Worksheets
  5. Data Handling and Editing
  6. Formatting
  7. Cell Comments
  8. Naming Cells and Ranges
  9. Addressing and Its Types
  10. Organizing Charts and Graphs
  11. Project Involving Multiple Worksheets
  12. Printing a Worksheet
  13. How to Use Excel Help

17 Formulas and Functions

  1. Formulas
  2. Functions
  3. Mathematical Functions
  4. Statistical Functions
  5. Financial Functions
  6. Logical Functions
  7. Text and Formatting Functions

18 Graphical Presentations of Data

  1. Charts and Its Types
  2. Preparing Your Data
  3. Transforming Your Data into Charts
  4. Cross Tabulation and Charting

19 Advanced Options in Spreadsheets

  1. Sorting Data
  2. Filtering Data
  3. Searching Data
  4. Frequency Distribution Using Array Formulas
  5. Loading Data Analysis ToolPak
  6. Descriptive Statistics
  7. Correlation & Regression
  8. Hypothesis Testing

20 Creating Business Spreadsheets

  1. Loan & Lease Statements
  2. Ratio Analysis
  3. Payroll Statements
  4. Capital Budgeting
  5. Depreciation Accounting