Dirbguarh University - B.Com 3rd Sem Syllabus CBCS Pattern: Computer Apllications in Business [SEC 301]

B. Com. (CBCS) Semester -III
Skill Enhancement Elective Course
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 thestudent understanding of the usefulness of information technology tools for business operations.

Unit 1: Word Processing 5 L + 5 P (Marks: 10)
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, Creating Business Documents using the above facilities

Unit 2: Preparing Presentations 5 L + 5 P (Marks: 10)
Basics of presentations: Slides, Fonts, Drawing, Editing; Inserting: Tables, Images, texts, Symbols, Media; Design; Transition; Animation; and Slideshow. Creating Business Presentations using above facilities

Unit 3: Spreadsheet and its Business Applications 5 L + 5 P (Marks: 10)
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

Unit 4: Creating Business Spreadsheet 5 L + 5 P (Marks: 10)
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.

Important 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 10 practical examinations. 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.

Suggested Readings:
1. The study material available for Micro Soft Office Vr. 1

0/Post a Comment/Comments

Kindly give your valuable feedback to improve this website.