Computer Applications in Business
B.Com (Annual) Part-I Paper-VI
hrs
Maximum Marks: 100 (Pass Marks: 40)
Duration of Examination: 3
Course Objectives:
1. Develop awareness of computers hardware and peripherals; concepts regarding
software its types, basic operations, basic OS concepts, OS installation.
2. Develop advanced user level skills in various Application Packages: MS Word, MS
Access, MS Excel, MS PowerPoint.
3.
Set up a computer for World Wide Web connection; Use e-mail to send / receive
messages and file attachments; Concepts of on-line discussion groups.
Course Contents:
Topics Covered
INTRODUCTION TO COMPUTERS
Computer, its characteristics, history, generations of computers
Computer Hardware and its peripherals. New hardware and
Source
Ch 1 Book 3
Ch 4 Book 3
peripherals installation. (Hands-On)
Basic Architecture of Computer System
Software its types, basic operations. General installation guidelines.
Ch 2,3
(Hands-On)
Book 3
Healthy Computing
Concepts on Computer Virus, Worms, Hacking, Spam
INTRODUCTION TO OS (MICROSOFT WINDOWS XP)
Basic concepts regarding System Software and OS
OS (Windows) Installation and Repair
Using Windows Environment. (Hands-On)
Windows XP Features
Windows XP Desktop, Desktop Properties
Start Menu, Task Bar, System Tray
Control Panel, its basic Icons
Date and Time Settings
Printing
Managing Files And Folders
Windows Explorer
Accessing Windows Explorer
Opening Documents / Files
Copying and Moving Files
Deleting Files and Folders
Controlling the View Detail Level
Customizing the Tool Bars
WORD PROCESSING BASICS
Ch 11 Book 3
Types of documents created with a word processing program(MS
Ch 2 Book 1
Word)
Ch 1 Book 2
An overview of the menus in MS Word
Principal features of a word processing program (Hands-On)
Create and format a business letter
Ch 2 Book 1
Create and format a schedule containing a table
Ch 2-1 Book 2
Select and use style features to create new documents
Ch 3-1 Book 2
Use the Help system to answer questions and troubleshoot problems
Use Important Add-on features like Mail Merge, Spell Check,
Thesaurus Select and use style features to create new documents
SPREADSHEET APPLICATIONS
Ch 3 Book 1
Spreadsheet basics, its vocabulary, principles
Ch 1-2 Book 2
Usage of functions, macros, sorting, formatting, generating charts,
Ch 2-2 Book 2
pivot tables.
Financial Management related Formulas Implementation.
Statistics related Formulas Implementation.
Cell Formatting, print previewing / printing of selected data
Insert and name worksheets
Import spreadsheet reports and charts into word processing documents
Set up and analyze itemized lists of numbers e-g- various types of
Ch 3-2 Book 2
budgets / financial statements
DATABASE APPLICATIONS
Ch 13 Book 3
Define the purpose, components of a database.
Ch 1-3 Book 2
Plan a simple two-table database.
Ch 1 Book 4
Cardinality of Relationship.
Ch 2-3 Book 2
Creating Tables.
Ch 5 Book 1
Creating Relations of the Tables.
Use wizards to enter and to search data.
Cardinality of Relationship.
Creating Tables.
Creating Relations of the Tables.
Use wizards to enter and to search data.
To create a report.
Enter data in a form.
Creating Module using Microsoft Access.
Using simple queries in wizard.
Privacy / Security issues related to databases.
Create Data Base Using Microsoft Sql Server 2000.
PRESENTATIONS THROUGH POWERPOINT
Ch 1-4 Book 2
Examine purpose, examples of a presentation; explain components of
Ch 4 Book 1
Ch 2-3 Book 2
Ch 3-3 Book 2
Ch 3-3 Book 2
a presentation
Outline a presentation and apply good design principles
Apply and modify a design template
Ch 2-4 Book 2
Add clip art, charts, sound to a presentation
Ch 4 Book 1
Formatting a slide show; Applying slide background, color, style,
transitions visual, text
Running a slide show
NETWORKS & NETWORKING BASICS
Use of Networks; Its Common Types
Data Communication Modes; Using Telephone Lines, Modems
Wireless Networks
Network Security
INTERNET & E-MAIL BASICS
Introduction to the Internet, the terminology, its advantages /
Ch 7 Book 3
Ch 8 Book 3
disadvantages
Internet Terminology
Security on the Internet Tools & Tips
IT Issues
Privacy
Ethics
Ch 9,10 Book 3
Recommended Text:
1. Kinkoph, Shery (2003) How to use Microsoft Office XP. Sams Publishing
2. Grauer, Robert T. & Barber, Maryam (2000) Exploring Office XP, Volume 1.
Prentice Hall Publishers
3. Capron, H.L. (2004) Computers, Tools For An Information Age, Prentice Hall
Publishers, 8th Ed
Further Reading:
4.
5.
6.
7.
Recardo, Kethrine Data Base Management Systems. Jones & Bartlett Publishers
Gralla, Preston (2003) How The Internet Works, Que Publishers, 2nd Ed
Crumlish, Christian (1997) The ABCs of the Internet, Sybex Inc, 2nd Ed
Sinha , P.K. (1992) Introduction To Computers BPB Publications
