SYLLABUS
B.Com. (Hons.): (Semester - III, Gauhati University) PAPER-COM-HC-3016: Computer Applications in Business
Marks : 100
Objective: To provide computer skills and knowledge for commerce students and to enhance the student understands of usefulness of information technology tools for business operations.
Units 1: Word Processing
6 Lectures, Practical Lab 6
Introduction to Word Processing, Word Processing Concepts, Use of Templates, Working with Word Document: Editing Text, Find and Replace Text, Formatting, Spell Check, Autocorrect, Autotext 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
6 Lectures, Practical Lab 6
Basics of Presentations Slides, Fonts, Drawing, Editing; Inserting: Tables, Images, Texts, Symbols, Media; Design; Transition; Animation; and Slideshow.
Creating Business Presentations using the above facilities
Units 3: Spreadsheet and its Business Applications
12 Lectures, Practical Lab 12
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
12 Lectures, Practical Lab 12
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.
Unit 5: Database Management System
16 Lectures, Practical Lab 16
Database Designs for Accounting and Business Applications: Reality-Expressing the Application; Creating Initial Design in Entity Relationship (ER) Model; Transforming ER Model to Relational Data Model Concepts; Implementing RDM Design Using an Appropriate DBMS.
SQL and Retrieval of Information : Basic Queries in SQL; Embedded Queries in SQL; Insert, Delete and Update Statements in SQL.
DBMS Software: Environment; Tables; Forms; Queries; Reports; Modules; Applying DBMS in the Areas of Accounting, Inventory, HRM and Its Accounting, Managing the data records of Employees, Suppliers and Customers.