Thursday, May 21, 2020

ASSAM UNIVERSITY SYLLABUS (NON - HONS): COMPUTER APPLICATIONS IN BUSINESS (3rd SEM - CBCS PATTERN)


B.Com: Semester III
Paper BC 3.4: COMPUTER APPLICATIONS IN BUSINESS
Marks: 100
Lectures: 26, Practical lab 52

Objective: To provide computer skills and knowledge for commerce students and to enhance the student understand to usefulness of information technology tools for business operations.
Unit 1: Word Processing
3 Lectures, Practical Lab 6                                 20
Introduction to Word Processing, Word Processing concept, 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, 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
3 Lectures, Practical Lab 6                               20
Basic of presentations: Slides, Fonts, Drawing, Editing; Inserting; Tables, Images, texts, Symbols, Media, Design; Transition; Animation and Slideshow.

Creating Business Documents using the above facilities
Unit 3: Spreadsheet and its Business Applications 10 Lectures Practical Lab 20
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
10 Lectures, Practical Lab 20
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.
Note:
1. The General Purpose Software referred in this course will be notified by the University Departments every three years. If the specific features, referred in the detailed course above, is not available in that software, to that extent it will be deemed to have been modified.
2. Teaching arrangement need to be made in the Computer Lab.
3. There shall be four lectures per class and 4 Practical Lab periods per batch to be taught in Computer Lab.

No comments:

Post a comment

Kindly give your valuable feedback to improve this website.

Popular Posts for the Day