Computer Applications in Business

This Computer Applications in Business book has been designed specially to meet the need of students of B.Com (Hons.) IV Semester of Ranchi University, Ranchi and Kolhan University, Chaibasa.

It serves as a textbook with very simple and elaborative language with a number of examples, pictures, diagrams, and tables. This will make the concepts more understandable, easy to learn and remember.

Commands and procedure to perform various tasks has been given in step by step manner. It will help readers to simple follow steps and perform practically on a computer in an easy manner. A sufficient number of questions have been given in the exercise part with answers to objective type questions. All this will provide a lot of practice for the exam. Chapter 1 is not directly a requirement of the syllabus but has been given so that students get familiarize with the fundamentals of computers.

Computer Applications in Business Syllabus For B.Com (Hons.) IV Semester of Ranchi University, Ranchi and Kolhan University, Chaibasa.

Unit-I: Word Processing:

Introduction to Word processing, Word Processing concepts, Use of Templates, Working with Word Document : (Opening an existing document/creating a new document, Saving, Selecting Text, Editing Text, Finding and Replacing Text, Closing, Formatting, Checking and correcting spellings). Bullets and numbering, Tabs, Paragraph Formatting, Indent, Page Formatting, Header, and footer, Mail merge including linking WITH Access Database, Tables: Formatting the table, Inserting, filling and formatting the table, Creating Documents in the areas: Mail merge including linking Access Database, Handling Tables, Inserting pictures and videos

Unit-II: Preparing Presentations:

Basics of presentations: Slides, Fonts, Drawing, Editing, Inserting: Tables, Images, Texts, Symbols, Media, Design; Transition, Animation, and Slideshow.

Unit-III: Spreadsheets and it’s Business Applications:

Spreadsheets concepts, Creating a workbook, Saving a workbook, Editing a work Book, Inserting, Deleting worksheets, Entering data in a cell, Formula Copying, Moving data from selected cells, Handling operators in a formula, Rearranging worksheet, Project involving multiple spreadsheets, Organizing Charts, and graphs, Printing worksheet. Generally used Spreadsheet functions: Mathematical, Statistical, Financial, Logical, Date and Time, Lookup and reference, Text functions.

Unit-IV: Creating a spreadsheet in the following areas:

• Loan & Lease Statement
• Ratio Analysis
• Payroll Statements
• Capital Budgeting
• Depreciation Accounting
• Graphical representation of data
• Frequency distribution and its statistical parameters
• Correlation and Regression

Unit-V: Database Management System:

Creating data Tables, Editing a Database using Forms, Performing queries, Generating Reports, Creating DBMS in the area of Accounting, Employees, Suppliers, and Customers

Computer Applications in Business Book Contents

1. Introduction to Computers
2. Word Processing
3. Preparing Presentations
4. Spreadsheets And It’s Business Application
5. Creating a Spreadsheet
6. Database Management System.