Syllabus: Program Code: 2AC
Syllabus: Program Code: 2AC
Syllabus: Program Code: 2AC
(Computer Applications)
Syllabus
AFFILIATED COLLEGES
BHARATHIAR UNIVERSITY
(A State University, Accredited with “A” Grade by NAAC,
Ranked 13th among Indian Universities by MHRD-NIRF,
World Ranking : Times - 801-1000, Shanghai - 901-1000, URAP - 982)
Coimbatore - 641 046, Tamil Nadu, India
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Page 1 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Page 2 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Page 3 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Page 4 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Page 5 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
SIXTH SEMESTER
Core XIX – Management
III 4 6 25 75 100
Information System
Core XX - Internet and Web
III 4 5 25 75 100
Designing
Core XXI - Computer
III Applications: Visual Basic & 4 4 40 60 100
Web Designing Practical-III
III Elective –II: 4 6 25 75 100
III Elective –III: 4 6 25/20 75/80 100
Skill based Subject- 4: Cyber
IV 3 3 20 55 75
Law
V Extension Activities @ 2 - - - 50
Total 25 30 0 160/155 415/420 625
Total 140 3500
ONLINE COURSE*
1. SWAYAM
Value added courses: Minimum 2 and Maximum 5 for each Department for entire program-It is
optional for affiliated colleges.
Job oriented certificate courses: Two courses(Each Department for entire program)- It is
optional for affiliated colleges
$ Includes 25% / 40% continuous internal assessment marks for theory and practical
papersrespectively. @ No University Examinations. Only Continuous Internal
Assessment(CIA)
# No Continuous Internal Assessment (CIA).Only UniversityExaminations.
Swatch Bharat Summer Internship- extra 2 credits would be given. It is mandatory.
List of Elective Papers (Colleges can choose any one of the paper as electives)
Elective – I A Income Tax Law & Practice
B Entrepreneurial Development
C Micro Finance
Elective – II A Business Finance
B Brand Management
C Supply Chain Management
Elective - III A Indirect Taxes
B Financial Markets
C Project Work
NOTE: The syllabus for the papers Advanced Accounting, Company Law, Business
Finance and Indirect Taxes are revised and furnished below. The existing syllabus is
to be followed for the remaining papers.
Page 6 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
First Semester
Page 7 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
SCHEME OF EXAMINATIONS: CBCS Pattern
SEMESTER-I
Course code TITLE OF THE COURSE L T P C
Core I PRINCIPLES OF ACCOUNTANCY 4 - - 4
Syllabus
Pre-requisite Basics knowledge on Accountancy 2020
Version
Course Objectives:
The main objectives of this course are to:
1. Provide a strong foundation in principles of accountancy concepts, various elements
of financial statements and relevant accounting.
2. Inculcate the knowledge of international financial reporting standards.
3. Make the students aware of Bill of Exchange.
4. Gain the knowledge about the preparation of final accounts.
5. Give an insight about the Account current statement and procedure for calculation of
average due date methods.
Page 8 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Reference Books
1 K.L.Narang, S.N.Maheswari - Advanced Accountancy-Kalyani publishers X
2 S.K.Maheswari, T.S.Reddy - Advanced Accountancy-Vikas publishers
3 A.Murthy -Financial Accounting – Margham Publishers
4 P.C.Tulsian - Advanced Accountancy – Tata McGraw Hill Companies.
5 A.Mukherjee, M.Hanif – Modern Accountancy. Vol.1- Tata McGraw Hill Companies
Page 9 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
SEMESTER-I
Page 10 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Reference Books
1 Introduction to computers-Alexis Leon and Mathews Leon
2 Information technology for management-Henry C.Lucas
Page 11 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
SEMESTER-I
Page 12 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Reference Books
1 G.K.Ranganath, C.S.Sampamgiram&Y.Rajan-A Text book Business Mathematics -
Himalaya Publishing House.
Page 13 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
SEMESTER-I
I - MS WORD 20 hours
1. Type Chairman‟s speech/ Auditor‟s report / Minutes/ Agenda and perform the following
operations: Bold, Underline, Font Size, style, Background color, Text color, Line spacing, Spell
Check, Alignment, Header & Footer, Inserting pages and page numbers, Find and Replace.
2. Prepare an invitation for the college function using Text boxes and clip parts.
3. Design an invoice and Account sales by using Drawing tool bar, Clip Art, Word Art,
Symbols, Borders and Shading.
4. Prepare a Class Time Table and perform the following operations: Inserting the table, Data
Entry, Alignment of Rows and Columns, Inserting and Deleting the Rows and Columns and
Change of Table Format.
5. Prepare a Shareholders meeting letter for 10 members using mail merge operation.
6. Prepare Bio-Data by using Wizard/ Templates.
Page 14 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
II - MS EXCEL 20 hours
1. Prepare a mark list of your class (minimum of 5 subjects) and perform the following
operations: Data Entry, Total, Average, Result and Ranking by using arithmetic and logical
functions and sorting.
2. Prepare Final Accounts (Trading, Profit & Loss Account and Business Sheet) by using
formula.
3. Draw the different type of charts (Line, Pie, Bar) to illustrate year-wise performance of sales,
purchase, profit of a company by using chart wizard.
4. Prepare a statement of Bank customer‟s account showing simple and compound interest
calculations for 10 different customers using mathematical and logical functions.
5. Prepare a Product Life Cycle which should contain the following stages: Introduction,
Growth, Maturity, Saturation, Decline.
Page 15 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Page 16 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
ELECTIVE PAPER
Page 17 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Distribution of Marks Theory 40% and Problem 60%
Text Book(s)
1 Gaur and Narang, “Income Tax Law and Practice” Kalyani publishers New Delhi
Reference Books
1 Dr. HC Mehrotra, “Income-tax Law and Accounts” Sahithya Bhavan publishers
Page 18 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
ELECTIVE PAPER
Page 19 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Unit:6 CONTEMPORARY ISSUES 2 hours
Expert lectures, online seminars – webinars
Page 20 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
ELECTIVE PAPER
Page 21 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Unit:4 PRICING OF MICROFINANCE PRODUCTS 15 hours
Pricing of Microfinance products: Purpose base, Activity base, Economic class base Open
biding, etc. Pricing saving products, Amount of savings base, Attendance at periodical meeting
Adding to corpus.Gender issues in Microfinance and Conflict resolution in Microfinance –
Client impact studies measuring impact of Microfinance and Micro enterprises
Page 22 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Second
Semester
Page 23 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
SEMESTER-II
Course code TITLE OF THE COURSE L T P C
Core III ADVANCED ACCOUNTING 4 - - 4
Syllabus
Pre-requisite Basic knowledge on Advanced Accounting 2020
Version
Course Objectives:
The main objectives of this course are to:
1. Provide a strong foundation in the Accounting procedures of Depreciation, Branch
accounts, Hire Purchase and Installment System, Single Entry and Partnership.
2. Make the students to solve the problems of branch accounts, hire purchase and
installment system.
3. Give an insight knowledge on single entry system.
4. Gain knowledge on Partnership Accounts, Division of Profits, Fixed and Fluctuating
Capital, Admission and Retirement of partners.
5. Make the students to understand Partnership and Insolvency of Partners.
Page 24 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Reference Books
1 T.S.Reddy&A.Murthy : Financial Accounting
2 R.L.Gupta&M.Radhasamy : Advanced Accountancy
Page 25 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
SEMESTER-II
I - MS ACCESS 30 hours
1. Prepare a payroll for employee database of an organization with the following Details:
Employee id, Employee name, Date of Birth, Department and Designation, Date of
appointment, Basic pay, Dearness Allowance, House Rent Allowance and other deductions if
any. Perform queries for different categories.
2. Create mailing labels for student database which should include atleast three Table must have
atleast two fields with the following details: Roll Number, Name, Course, Year, College Name,
University, Address, Phone Number.
3. Gather price, quantity and other descriptions for five products and enter in the Access table
and create an invoice in form design view.
4. Create forms for the simple table ASSETS.
5. Create report for the PRODUCT database.
II – TALLY AND INTERNET 30 hours
1. Create a new company, group, voucher and ledger and record minimum 10 transactions and
display the relevant results.
Page 26 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
2. Prepare trial balance, Profit and Loss A/c and Balance Sheet (with minimum of any five
adjustments).
3. Prepare inventory statement using (Calculate inventory by using all methods) a) FIFO b)
LIFO c) Simple Average Method d) Weighted Average Method
4. Create an e-mail id and check the mail inbox.
5. Learn how to use search engines and visit yahoo com, rediff.com, hotmail.com and
google.com
6. Visit your University and college websites and collect the relevant data.
Page 27 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
SEMESTER-II
Page 28 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Reference Books
1 Statistics-Theory, Methods & Application by D.C. Sancheti and V.K. Kapoor
2 Applied General Statistics by Frederick E.Croxton and Dudley J. Cowden
Page 29 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
ELECTIVE PAPER
Page 30 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Text Book(s)
1 Essentials of Business Finance - R.M. Sri Vatsava
2 Financial Management – Saravanavel
3 Financial Management - L.Y. Pandey
Reference Books
1 Financial Management - S.C. Kuchhal
2 Financial Management - M.Y. Khan and Jain
Page 31 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
ELECTIVE PAPER
Page 32 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Page 33 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
ELECTIVE PAPER
Page 34 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Text Book(s)
1 Rushton, A., Oxley, J & Croucher, P (2nd Edition, 2000). Handbook of Logistics and
Distribution
Reference Books
1 Simchi-Levi, David, Kamisnsky, Philip, and Simchi-Levi, Edith. (2nd Edition, 2004).
Page 35 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Third
Semester
Page 36 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
SEMESTER-III
Page 37 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Unit:5 MARKETING AND GOVERNMENT 13 hours
Marketing and Government –Bureau of Indian Standards –Agmark –Consumerism – Consumer
Protectin – Rights of consumers- Green Marketing –Forward Trading in Commodities
Reference Books
1 Marketing -William G.Zikmund& Michael D‟Amico
2 Marketing - R.S.N.Pillai&Bagavathi
Page 38 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
SEMESTER-III
Course code TITLE OF THE COURSE L T P C
Core VI DATABASE MANAGEMENT SYSTEM 4 - - 4
Syllabus
Pre-requisite Basic knowledge on DBMS 2020
Version
Course Objectives:
The main objectives of this course are to:
1. Enable the students to learn about the basic data base operations and processes.
2. Understand the Architectural Concept, Structural Embedded QL, Hierarchical
Approach and Network Concept.
3. Understand the relation approach and its key relation algebra.
4. Provide a detailed knowledge on hierarchical approach for knowing the detailed
description of the data.
5. Make the students to understand embedded SQL
Page 39 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Unit:4 HIERARCHICAL APPROACH 15 hours
Hierarchical Approach : IMS data structure - Physical Database, Database Description-
Hierarchical sequence - External level of IMS : Logical Databases, the program communication
block IMS Data manipulation : Defining the Program communication Block : DL / 1 Examples.
Reference Books
1 Bipin C Desai - An introduction to Database Systems
Page 40 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
SEMESTER-III
Page 41 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Reference Books
1 V.KSaxena&C.D.Vashist, “Cost Accounting”, Sultan Chand, New Delhi 2005.
2 M.N.Arora, “Cost Accounting”, Sultan Chand, NewDelhi 2005.
Page 42 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
SEMESTER-III
Page 43 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Unit:6 CONTEMPORARY ISSUES 2 hours
Expert lectures, online seminars – webinars
Reference Books
1 D.Gopalakrishna----Managerial Economics----Himalaya Publishing House
2 S.Sankaran---- Managerial Economics----Margham Publications
Page 44 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
SEMESTER-III
Queries:
a) Display all the records of the company which are in the ascending order of GP percent.
b) Display the name of the company whose supplier name is "Telco".
Page 45 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
c) Display the details of the company whose GP percent is greater than 20 and
order by GP Percent.
d) Display the detail of the company having the employee ranging from 300 to 1000.
e) Display the name of the company whose supplier is same as the Tata's.
2. Create a table named "Employee" with the following fields and insert the values.
Queries
a) Display the name of the employee whose salary is greater than Rs.10,000
b) Display the details of employees in ascending order according g to Employee Code.
c) Display the total salary of the employees whose grade is "A"
d) Display the details of the employee earning the highest salary.
e) Display the names of the employees who earn more than "Ravi"
3. Create a table "Product" with the following fields and insert the values:
Field
Field Name Field Type Size
Student Name Character 15
Gender Character 6
Roll No Character 10
Department Name Character 15
Address Character 25
Percentage Number 4 with 2 decimal places
Queries:
a) Calculate the average percentage of students.
b) Display the names of the students whose percentage is greater than 80.
c) Display the details of the student who got the highest percentage.
d) Display the details of the students whose percentage is between 50 and 70.
e) Display the details of the students whose percentage is greater than the
percentage of the roll no=12CA01.
Page 46 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
4. Create a table "Product" with the following fields and insert the values:
Queries:
a) Using update statements calculate the total amount and then select the record.
b) Select the records whose unit of measure is "Kg".
c) Select the records whose quantity is greater than 10 and less than or equal to 20.
d) Calculate the entire total amount by using sum operation.
e) Calculate the number of records whose unit price is greater than 50 with count operation.
5. Create the table PAYROLL with the following fields and insert the values:
Field
Field Name Field Type Size
Employee No Number 8
Employee Name Character 8
Department Character 10
Basic Pay Number 8 with 2 decimal places
HRA Number 6 with 2 decimal places
DA Number 6 with 2 decimal places
PF Number 6 with 2 decimal places
Net Pay Number 8 with 2 decimal places
Queries:
Page 47 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Publisher Name Var Char 10
Publisher city Var Char 12
Publisher State Var Char 10
Title of book Var Char 15
Book Code Var Char 5
Book Price Var Char 5
Queries:
Page 48 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Page 49 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
ELECTIVE PAPER
Page 50 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Page 51 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
ELECTIVE PAPER
Page 52 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Unit:6 CONTEMPORARY ISSUES 2 hours
Expert lectures, online seminars – webinars
Page 53 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Fourth
Semester
Page 54 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
SEMESTER-IV
Course code TITLE OF THE COURSE L T P C
Core IX MANAGEMENT ACCOUNTING 4 - - 4
Syllabus
Pre-requisite Basic knowledge on Management Accounting 2020
Version
Course Objectives:
The main objectives of this course are to:
1. Acquire knowledge on basic relationship between management accounting and other
types of managerial accounting.
2. Apply the different types of ratios for analyzing the performance of the companies.
3. Give an insight knowledge on Break Even Point analysis.
4. Analyze the working capital requirements of the company using the format.
5. Analyze the budgeting and budgetary control.
Page 55 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Budgets – Master Budget – Preparation of cash budget, sales budget, purchase budget, material
budget, flexible budget.
Reference Books
1 S.P. Jain and KL. Narang , “Cost and Management Accounting”, Kalyani Publishers, New
Delhi.
2 S.K.Bhattacharya, “Accounting and Management”, Vikas Publishing House.
Page 56 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
SEMESTER-IV
Page 57 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Overloading – Function Overloading – Function Overloading with Arguments – Special
Features of Function Overloading.
Reference Books
1 D.Ravichandran, “Programming with C++”, Tata McGraw-Hill Publishing Company
Limited, New Delhi, 2002.
Page 58 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
SEMESTER-IV
Course code TITLE OF THE COURSE L T P C
Core XI EXECUTIVE BUSINESS COMMUNICATION 3 - - 3
Syllabus
Pre-requisite Basics of Executive Business Communication 2020
Version
Course Objectives:
The main objectives of this course are to:
1. Acquire the basic knowledge on business communication.
2. Enable the students to create various forms of business letters.
3. Impart knowledge of the students on various secretarial correspondence letters.
4. Gain the knowledge on report writing.
5. Make the students to create their resumes.
Expected Course Outcomes:
On the successful completion of the course, student will be able to:
1 Understand the effectiveness of business communication K2
2 To gain the knowledge on creating various forms of letters K3
3 Understand the concept on banking and insurance correspondence K2
5 To create a resume K3
Page 59 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Text Book(s)
1 Rajendra Pal Korahill, “Essentials of Business Communication”, Sultan Chand & Sons, New
Delhi, 2006.
2 Ramesh, MS, & C. C Pattanshetti, “Business Communication”, R.Chand&Co, New Delhi,
2003.
3 Rodriquez M V, “Effective Business Communication Concept” Vikas Publishing Company
,2003.
Reference Books
1 Raghunathan V S , Santhanam V , Business Communication
2 Madhukar .R.K , “Business Communication”
Page 60 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
SEMESTER-IV
1. Acquire and apply the computer applications knowledge in different aspects of business
using oracle.
2. Make the students to apply the basic conceptsof storing and protecting the different
types of database of the business enterprises.
3. Develop the reusability of C++ program by applying the concept of Inheritance and
Polymorphism.
4. Apply the data files operation technique.
5. Apply the concepts of oracle and C++ program to solve the given problems in a
practical manner.
Page 61 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
12. Program to create the student file and prepare the marks slip by access in the file.
Page 62 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
SEMESTER-IV
Page 63 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Unit:5 STATE BANK AND COMMERCIAL BANKS 11 hours
State Bank of India – Its special place in the banking scene – Commercial banks and rural
financing – Regional Rural Banks - Place of Co-operative banks in the Indian Banking scene –
Development banking – IDBI – ICICI.
Reference Books
1 Indian Banking - Natarajan. S & Parameswaran R
2 Banking and Financial Systems - Santhanam .B
Page 64 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
SEMESTER-IV
Page 65 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Reference Books
1 Business Organization and Management - Y. K. Bhushan
2 Business Management – Chatterjee
Page 66 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
SEMESTER-IV
Page 67 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Reference Books
1 Ramaiya A, “Guide to the Companies Act”, Wadhwa & Co., Nagpur
2 Singh Avtar, “ Company Law”, Eastern Book Co., Lucknow
Page 68 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Fifth Semester
Page 69 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
SEMESTER-V
Course code TITLE OF THE COURSE L T P C
Core XIV PRINCIPLES OF AUDITING 4 - - 4
Pre-requisite Basic knowledge on Principles of Auditing Syllabus Version 2020
Course Objectives:
The main objectives of this course are to:
1. Acquire knowledge on basics of Auditing, qualities of auditor and audit programmes.
2. Get a detailed knowledge on internal control in auditing.
3. Acquire a detailed knowledge on verification of assets and liabilities.
4. Understand about joint stock companies.
5. Understand about investigation and e-auditing.
Expected Course Outcomes:
On the successful completion of the course, student will be able to:
1 Understand about the fundamental concepts Auditing. K1
2 Get a detailed knowledge on internal control in auditing. K2
3 Acquire a detailed knowledge on verification of assets and liabilities. K3
4 Gain knowledge about Joint stock companies. K2
Page 70 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Reference Books
1 Kamal Gupta, “Auditing “ , Tata Mcgriall Publications
2 DinkarPagaren , “Principles of Auditing”
Page 71 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
SEMESTER-V
Page 72 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Text Book(s)
1 S.P. Jain & K.L. Narang, “Advanced Accounting”, Kalyani Publications, New Delhi.
2 Gupta R.L. &RadhaswamyM. ,”Corporate Accounts “, Theory Method and Application-13th
Revised Edition 2006, Sultan Chand & Co., New Delhi.
3 Dr. M.A. Arulanandam, Dr. K.S. Raman, “Advanced Accountancy, Part-I”, Himalaya
Publications, New Delhi.2003.
Reference Books
1 Gupta R.L. &RadhaswamyM.,”Corporate Accounts “, Theory Method and Application-
13th Revised Edition 2006, Sultan Chand & Co., New Delhi.
2 Shukla M.C., Grewal T.S. & Gupta S.L., “Advanced Accountancy”, S. Chand & Co., New
Delhi.
3 Reddy & Murthy, “Financial Accounting”, MarghamPublicatuions, Chennai, 2004
Page 73 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
SEMESTER-V
Course code TITLE OF THE COURSE L T P C
Core XVI E-COMMERCE TECHNOLOGY 4 - - 4
Pre-requisite Basic Knowledge on E-Commerce Technology Syllabus Version 2020
Course Objectives:
The main objectives of this course are to:
1. Acquire the basic concept of E-Commerce
2. Enable the students on network security and firewall
3. Impart knowledge on electronic payment systems.
4. Understand security and the web.
5. Gain the knowledge on consumer oriented e-commerce.
Page 74 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Reference Books
1 Daniel Minoli, Emma Minoli “Web Commerce Technology Handbook”, Tata McGraw Hill
Publishing, New Delhi.
2 Dr.C.S.Rayudu,”E-Commerce &E-Business”,Himalaya Publishing House, New Delhi,
2004.
Page 75 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
SEMESTER-V
Page 76 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Boxes - Single Document Interface (SDI) – Multiple Document Interface (MDI) – Menus – Menu
Editor – Menu Creation.
Reference Books
1 N. Krishnan & N. Saravanan, “Visual Basic 6.0 in 30 days”, Scitech Publications, (India) Pvt
Ltd., Chennai, 2001.
Page 77 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
SEMESTER-V
4. Design a form to display an advertisement banner using image box control with string
function.
5. Design a form to compute cost of capital using finance function in visual basic using
check box.
6. Design a form to perform working capital analysis by declaring finance function using
flex grid control.
7. Design a form to display Break-even analysis using line and chart controls, by
declaring variables.
Page 78 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
10. Design a Pay Slip for an organization and create a data base using using SQL and
Data Control.
11. Design the form to display the highlights of the budget using option button and
animation.
12. Design a supermarket bill to display the sales invoice, and create a database using
Data Control, option button, , check box, date picker, etc.
13. Design the form to create a bank customer database by declaring simple array and
multiple arrays using Data Control.
14. Design a form to calculate minimum, maximum, reorder, reorder quantity, EOQ and
display the inventory control records using data object.
15. Design the form to display tree view and list of folders and files from a directory of an
organization.
Page 79 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
SEMESTER-V
Course code TITLE OF THE COURSE L T P C
Skill based Subject-3 BANKING AND INSURANCE LAW 3 - - 3
Basic Knowledge of Banking Insurance Syllabus
Pre-requisite 2020
Law Version
Course Objectives:
The main objectives of this course are to:
1. To enable the students to understand the Concepts of Banking and its Functions
2. To understand Negotiable Instrument Act.
3. To gain knowledge on the recent trends in Banking and Insurance sector and the regulating
provisions.
4. To Study the Objectives and functions of IRDA
Page 80 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Unit:5 IRDA 11-- hours
IRDA - Mission - Composition of Authority - Duties, Powers and Functions - Powers of
Authority - Duties, Powers and Functions- Powers of Central Government in IRDA Functioning
Reference Books
1 B.S Bodla, M.C. Garg & K.P. Singh,“Insurance - Fundamentals, Environment &
Procedures” , Deep & Deep Publications Pvt. Ltd., New Delhi, 2004.
2 M.N. Mishra, “Insurance – Principles and Practice”, S.Chand& Company Ltd., New Delhi,
2006
Page 81 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
SEMESTER-VI
Course code TITLE OF THE COURSE L T P C
Core XIX MANAGEMENT INFORMATION SYSTEM 4 - - 4
Basic knowledge in Management Information Syllabus
Pre-requisite 2020
System Version
Course Objectives:
The main objectives of this course are to:
1. To acquire knowledge on basic knowledge on MIS.
2. To know the different types of concepts.
3. To understand about Information Systems in Business.
4. To acquire the knowledge on DBMS.
5. To conceptualize the Functional Management Information System.
Expected Course Outcomes:
On the successful completion of the course, student will be able to:
1 Acquire knowledge on basic knowledge on MIS. K1
2 Know the different types of concepts. K1
3 Understand about Information Systems in Business. K2
4 Acquire the knowledge on DBMS. K2
5 Conceptualize the Functional Management Information System. K2
K1 - Remember; K2 - Understand; K3 - Apply; K4 - Analyze; K5 - Evaluate; K6 – Create
Page 82 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Reference Books
1 Dr. S.P. Rajagopalan, “Management Information System”, Margham Publications,
Chennai, 2006
Page 83 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Sixth
Semester
Page 84 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
SEMESTER-VI
Page 85 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Unit:4 LINKS 15 hours
Links - Link to another Web Page – Link within a Web Page – Link to an Image – Link to a File
– Email Link – Link to an FTP Site – Change Link Colors – Create Keyboard Shortcuts –
Change the Tab Order – Tables – Create a Table – Add a Border – Caption – Column Groups –
Row Groups – Color – Background Images – Aligning Data – Size of a Table – Size of a Cell –
Span Cells – Cell Spacing and Cell Padding – Borders – Text Wrapping – Nested Tables –
Wrap Text around a Table.
Reference Books
1 Eric Kramer, “HTML”.
2 John Zabour, Jeff Foust & David Kerven, “HTML 4 HOW- TO”.
Page 86 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
SEMESTER-VI
Page 87 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Page 88 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
SEMESTER-VI
Page 89 of 90
B. Com.Computer Application 2020-21 onwards - Affiliated Colleges - Annexure No.44A2
SCAA DATED: 23.09.2020
Unit:6 CONTEMPORARY ISSUES 2 hours
Expert lectures, online seminars – webinars
Page 90 of 90