Computer Application in Business is a vital subject in management courses like PGDM, MBA, B.com, M.com, BBA. Here we have shared all the topics that are in the syllabus of Computer Application in Business in Master of Business Administration. CAB & MIS is a combination of two subjects that is Computer Application in Business and Management Information System. In Computer Application in Business (CAB), we study the fundamentals of the computer because it is used throughout many businesses and industries. Information system and information technology is a vital component of any successful business and is regarded as a major functional area like any other functional area of a business organization like marketing, finance, production, human resources (HR), etc.
Note: This exam date is subject to change based on seat availability. You can check final exam date on your hall ticket.
Title of Video and Reading text/Lecture/ppt
Introduction to word processing
Word Processing concepts, Use of Templates
Working with word documents:
Find and Replace Text
Working with word documents:
Bullets and numbering
Header and Footer
Filling and Formatting a table
Inserting Pictures and Video
Mail Merging including linking with Database
Creating Business Documents using the above facilities
Word Processing Exercise 1 – Writing a Letter
Word Processing Exercise 2 – Creating Business Reports
Mail Merge Documents
Basics of presentations:
Basics of presentations:
Creating Business Presentations using basic presentation facilities
Advanced Slide Master Features
Working with Notes and Handouts
Adding Objects to Presentation
Working with Presentation Properties
Formatting Charts and Tables
Finalizing Slide Shows
Spreadsheet and its Business Applications
Editing and Printing a worksheet
Customizing the Excel Interface and Converting Text
Spreadsheet and its Business Applications
Customizing Styles and Themes
Handling operators in formula
Project involving multiple spreadsheets
Using Advanced Filtering
Customizing Data Entry
Spreadsheet and its Business Applications
Organizing Charts and graphs Generally used Spreadsheet functions
Lookup and reference
Database, and Text functions
Working with Hyperlinks
Saving Excel Data in a Different File Format
Formatting Chart Elements
Inserting Functions and Using Logical Functions
Spreadsheet and its Business Applications
Creating Scenarios and Naming Ranges
· Finding and Fixing Errors in Formulas
Working with Templates
Spreadsheet and its Business Applications
· Enhancing Shapes with Text and Effects
· Drawing and Positioning Shapes
· Working with Subtotals
· Working with Absolute References and Using Financial Functions
· Creating and Interpreting Financial Statements
Spreadsheet and its Business Applications
· Formatting the Value Axis
· Working with Sparklines
· Creating Stacked Area Charts
· Hiding and Formatting Workbook
Creating Business Spread sheet
Creating spreadsheet in the area of:
Loan and Lease statement;
Creating spreadsheet in the area of:
Ratio Analysis; Payroll Analysis
Creating spreadsheet in the area of:
Creating spreadsheet in the area of:
Graphical representation of data;
Frequency distribution and its statistical parameters; Correlation and Regression
Creating Business Spread sheet
Creating spreadsheet in the area of:
Creating spreadsheet in the area of:
Creating spreadsheet in the area of:
Graphical representation of data;
Frequency distribution and its statistical parameters; Correlation and Regression
Creating spreadsheet in the area of:
Frequency distribution and its statistical parameters; Correlation and Regression
Creating Business Spreadsheet
Computing employee’s gross salary.
Making necessary deductions to calculate net salary, payroll accounting
Calculation of deprecation by various methods
Loan repayment, interest calculation.
Database Management System
Database Designs for Accounting and Business Applications: Reality - Expressing the Creating Relational data model concepts;
Implementing RDM design using an appropriate DBMS.
Embedded Queries in SQL;
Insert, Delete and Update statements in SQL
Database Management System
Applying DBMS in the areas of Accounting, Inventory, HRM and its accounting,
Managing the data records of Employees, Suppliers and Customers.
An Exercise using Open-Source Software like My SQL
Dr. M S Maheshan holds a Doctorate in Computer Science and Engineering with a specialization in Biometrics. He earned his Master’s Degree from SRM University in Chennai and is currently employed as the Assistant Registrar (Administration) at JSS Science and Technology University, where he manages administrative duties in addition to his academic role in the Department of Information Science & Engineering.
Prior to his current role, Dr. Maheshan was affiliated with Marwadi University in Gujarat and also fulfilled responsibilities associated with Gujarat Technological University.
Dr. Maheshan has spearheaded various workshops and conferences focusing on Data Mining and Analytics, Machine Learning, Android Application Development, and IoT. His teaching repertoire includes Management Information Systems and Business Analytics, alongside other technical subjects.
In addition, he has been actively involved as a member of the Scientific Committee for the Indo-US Conference on Emerging Trends in Health Care. Dr. Maheshan holds certifications from the British Council for an Upper-Intermediate level English Executive course and from Microsoft as a Technology Associate in Security Fundamentals. He is also an Associate Member of the Institute of Engineers (Membership Number: AM1716339).
Assessment/Assignment marks will be considered for Internal Marks and will carry 30 percent for overall Result.
End Term Exam- will have 100 questions and will carry 70 percent of overall Result.All students, who obtain 40% marks in in-course assessment and 40% marks in end-term proctored exam separately, will be eligible for certificate and credit transfer.
