Computer Application in Business

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
  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. What is Google Docs?
  4. File Storage and Synchronization Service
  5. Setting Up of a Google Account
  6. Navigating Google Docs
  7. Creating New Google Docs Projects
  8. Google Sheets
  9. Google Slides
  10. Google Suite
  11. Sharing, Publishing and Collaborating
  12. Google Forms
  13. Cloud Based System

4 Basics of Computer Software

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

5 Business Information System

  1. Data and Information
  2. Introduction to Business Information System
  3. Database Management System (DBMS)
  4. Relational Data Base Management System (RDBMS)
  5. Decision Support System (DSS)
  6. Enterprise Resource Planning (ERP)
  7. Management Information System (MIS)
  8. The 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. Creating and Managing Tables
  4. Working with Graphics
  5. Working with Google Docs
  6. 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 Detailed Project Report

13 Working with PowerPoint

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

14 Multimedia, Video-Making and YouTube

  1. Meaning of Multimedia
  2. Advantages of Multimedia
  3. Usage and Making Multimedia
  4. Challenges Faced in Implementing Multimedia Tool in Business
  5. Doing Designing Using Graphics
  6. Animation
  7. Making Presentation Using Graphics
  8. Making Presentation Using Multimedia
  9. Making Presentation Using Animation
  10. YouTube
  11. Application of YouTube in Business
  12. Uploading a Video through YouTube
  13. Earning Advertisement Revenue from YouTube
  14. Google AdSense
  15. Creating a YouTube Personal Channel
  16. Subscribe Follow YouTube Channel
  17. Uploading Videos on Channel
  18. Create Playlist to Organize Videos
  19. 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 & Editing
  6. Formatting
  7. Cell Comments
  8. Naming Cells and Range
  9. Addressing and Its Types
  10. Organizing Charts and Graphs

17 Formulas and Functions

  1. Formulas
  2. Constructing Formulas
  3. Array Formulas
  4. Functions
  5. Inserting Functions
  6. Built-in Functions
  7. Mathematical Functions
  8. Statistical Functions
  9. Financial Functions
  10. Logical Functions
  11. Text and Formatting Functions
  12. Date and Time 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. Lookup
  5. Referencing
  6. Frequency Distribution Using Array Formulas
  7. Loading Data Analysis ToolPak
  8. Descriptive Statistics
  9. Correlation & Regression
  10. Hypothesis Testing

20 Creating Business Spreadsheets

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