B. Com. (CBCS)
Semester –III
Skill Enhancement Elective
Course SEC 301
COMPUTER APPLICATIONS IN BUSINESS
(2 Credit) Lectures: 12, Practical: 28 Hours
Full Marks: 50
(Internal Assessment 10 + 40
End-Term)
Objectives: To provide computer skills and knowledge for commerce
students and to enhance the student understanding of the usefulness of
information technology tools for business operations.
Unit 1
Word Processing
5 L + 5 P
Introduction to word
Processing, Word processing concepts, Use of Templates, Working with word
document: Editing text, Find and replace text, Formatting, spell check,
Autocorrect, Auto text; Bullets and numbering, Tabs, Paragraph Formatting,
Indent, Page Formatting, Header and footer, Tables: Inserting, filling and
formatting a table; Inserting Pictures and Video; Mail Merge: including linking
with Database; Printing documents. Marks:
10
Creating Business Documents
using the above facilities.
Unit 2
Preparing Presentations
5 L + 5 P
Basics of presentations: Slides,
Fonts, Drawing, Editing; Inserting: Tables, Images, texts, Symbols, Media;
Design; Transition; Animation; and Slideshow. Creating Business Presentations
using above facilities. Marks: 10
Unit 3
Spreadsheet and its Business Applications
5 L + 5 P
Spreadsheet concepts, managing
worksheets; Formatting, Entering data, Editing, and Printing a worksheet;
Handling operators in formula, Project involving multiple spreadsheets,
Organizing Charts and graphs.
Generally used Spreadsheet functions:
Mathematical, Statistical, Financial, Logical, Date and Time, Lookup and
reference, Database, and Text functions. Marks:
10
Unit 4
Creating Business Spreadsheet
5 L + 5 P
Creating spreadsheet in the
area of: Loan and Lease statement; Ratio Analysis; Payroll statements; Capital
Budgeting; Depreciation Accounting; Graphical representation of data; Frequency
distribution and its statistical parameters; Correlation and Regression Marks: 10
Note:
1. There shall be a practical
examination of 40 Marks of 2 hrs duration. 4 sets of question papers will be
set for four batches of examinees. The course teacher will evaluate the practical examination.
External observer may be deputed by the Controller of Examination.
2. In-semester test will
comprise of a Viva -5 marks and Work Book- 5 Marks.
3. Teaching arrangement need
to be made in the computer Lab
4. There shall be 4 Practical Lab periods per
batch to be taught in computer Lab.
****