Syllabus for
Bachelor of Commerce
Academic Year  (2023)

Course Description

Entrepreneurship is not just about start-ups: it is a topic that is rapidly growing in importance in government policy and in the behavior of established firms. The course provides students with an understanding of the role and personality of the entrepreneur, and a range of skills aimed at successful planning of entrepreneurial ventures. Material covered includes fostering creativity and open-mindedness, knowledge acquisition and management, innovation systems, screening and evaluating new venture concepts, market evaluation and developing a marketing plan, legal Issues Including intellectual property, preparation of venture budgets, and raising finance. The major piece of assessment is the writing of a comprehensive business plan for a new venture.

Evolution, Characteristics, Nature, Types, Functions of Entrepreneur - Distinction between an Entrepreneur and a Manager, Concept, Growth of Entrepreneurship in India, Role of Entrepreneurship in Economic Development. Emerging trends of contemporary entrepreneurship, Changing demands, unemployment, changing demographics, ease of entry in the informal sector.

Steps in the Entrepreneurial Process: Generating Ideas, Opportunity Identification, Business concepts, Resources (Financial, Physical and Human), Implementing and managing the venture, Harvesting the venture, Design Thinking, Systems Thinking, Agile thinking and Lean thinking Blue Ocean Strategy, Role and relevance of mentors, Incubation cell, Methods of brainstorming ideas.

Creativity, Principles of creativity, Source of New Idea, Ideas into Opportunities. Creative Problem Solving: Heuristics, Brainstorming, Synectics, Value Analysis Innovation and Entrepreneurship: Profits and Innovation, Principles of Innovation, Disruptive, Incremental and Open innovations, Nurturing and Managing Innovation, Globalization, Concept and Models of Innovation, Methods of protecting Innovation and creativity, Significance of Intellectual Property Rights, Patents & Copy right, Business Model Canvas, and Lean Management.

Essentials of Business Ownership: Types of ventures, Risk and Benefits, Market Research (venture opportunity screening), Feasibility Analysis, Introduction to the Business Plan, Developing the Business Model for starting a new venture, E-Commerce and Growing the Venture: The Internet and its impact on venture development, Approaches to E-Commerce, Strategies for E-Commerce Success. The nature of international entrepreneurship and their importance.

Different sources of financing for start-ups, stages of financing involve in start-ups, advantages and disadvantages of the different sources of financing, mezzanine finance, Specific financial assistance from government and financial institutions to promote entrepreneurship, Venture Valuation Methods.

2.       Kuratko, Donald F. Entrepreneurship: (2010)Theory, Process, Practice 9th Edition. Mason, Ohio: South-Western Cengage Learning.

Course Description:

The course covers various aspects of The Companies Act, 2013 relating to the formation of companies, documentation of companies, types of capital, issue of shares, transfer and transmission of shares, management of the company, statutory meetings and provision relating to meetings, winding up of a company and other latest amendments of the Act. As a prerequisite, students should have basic knowledge about different organisational structures and also the concept of a Company (Public and Private).

Course Learning Objective:

●        To impart students the basic knowledge of the regulatory framework of companies with reference to various provisions of Companies Act 2013there under including case laws.

●        To familiarize the students with the various documents related to companies.

●        To teach about company’s meetings, and audit process

●        To acquaint the students with the process of winding up a company.

Level of Knowledge: Conceptual

Jurisprudence of Company Law, Company and its Characteristics; types of companies including one-person company, small company and dormant company; association not for profit; illegal association and Limited Liability Partnership (LLP); Concepts of corporate veil, Circumstance of lifting a corporate veil; Doctrine of Ultra Vires; formation of company and LLP, on-line filing of documents, promoters, their legal position, pre-incorporation contract; on-line registration of a company.

Level of Knowledge: Conceptual

Memorandum of association and its contents; Articles of association and its contents; prospectus and its types; Misstatement inprospectus; Types of issue of shares for Public and Private companies, allotment and forfeiture of share, Transfer and Transmissionof shares; Member and their rights; Doctrine of constructive notice and indoor management.

Level of Knowledge: Conceptual

Management: Director and its Classification including Women directors, Independent director, Small shareholder’s director; Disqualifications, Director Identification Number (DIN); Their appointment; Legal positions, powers and duties; removal of directors; Key Managerial Personnel.

Meetings: Meetings of shareholders and board; Types of meeting, convening and conduct of meetings, Quorum, Agenda, proxyforms, Minutes book and Voting Methods including postal ballot, Circular Resolution, e-voting; Committees of Board of Directors -Audit Committee, Nomination and Remuneration Committee, Stakeholders Relationship Committee, Corporate Social Responsibility Committee, Grievance Redressal Committee.

Level of Knowledge: Conceptual

Dividends, Accounts, Audit: Provisions relating to payment of Dividend, Provisions relating to Books of Account, IEPF with relation to Dividends; Secretarial Audit and report; Board’s Report.

Level of Knowledge: Conceptual

Winding up - Meaning, Types, Procedure, Payment of Liabilities in the event of Winding up, Role of Official Liquidator; Administration of Company Law [including National Company Law Tribunal (NCLT), National Company Law Appellate Tribunal (NCLAT), Special Courts.

2.      MC Kuchhal.(2013) Modern Indian Company Law. Delhi:ShriMahavir Book Depot (Publishers)

3.      GK Kapoor and Sanjay Dhamija. (2014) Company Law. Delhi. Bharat Law House

4.      Anil Kumar. (2013) CorporateLaw.Delhi: Indian Book House

5.      ReenaChadha and SumantChadha (2014).CorporateLaws.Delhi: Scholar Tech Press

6.      Avtar Singh.(2014) Introduction to Company Law.Eastern Book Company

 1.      Company Law Study Material – Institute of Company Secretaries of India

2.      MC Kuchhal.(2013) Modern Indian Company Law. Delhi:ShriMahavir Book Depot (Publishers)

3.      GK Kapoor and Sanjay Dhamija. (2014) Company Law. Delhi. Bharat Law House

4.      Anil Kumar. (2013) CorporateLaw.Delhi: Indian Book House

5.      ReenaChadha and SumantChadha (2014).CorporateLaws.Delhi: Scholar Tech Press

6.      Avtar Singh.(2014) Introduction to Company Law.Eastern Book Company

Course Description:

This course provides a comprehensive understanding of corporate accounting practices and the presentation of financial statements as per legal requirements in the organisations. It provides an overview of the corporate practice in maintaining the books as per accounting standards, especially in company final accounts, underwriting of shares and debentures, valuation of goodwill and shares etc.

Level of Knowledge – Conceptual

Introduction – Meaning of underwriting – Underwriting commission – Types of underwriting – Marked and Unmarked applications – Calculation of underwriters liability– Journal Entries in the books of company on underwriters liability.

Level of Knowledge – Conceptual

Framework for preparation and presentation of Financial Statements – Compliance with Accounting standards- Form and contents of Statement of Profit or Loss and Balance Sheet as per SCHEDULE III (Division ii) – General Instructions for preparation of Statement of Profit and Loss and Balance Sheet – Disposal of company profits – dividend tax deducted at source -Declaration of dividends out of reserves-Transfer to Reserves etc., excluding calculation of managerial remuneration.

Level of Knowledge – Conceptual

Meaning of debentures – Types of debentures - Redemption of debentures- Methods of redemption – problems on conversion method -problems on buying own debentures from open market (including ex-interest and cum interest quotations) – problems on redemption using sinking fund method

Level of Knowledge - Basic

Valuation of Goodwill – Meaning of Goodwill – Need for Valuation of Goodwill – Factors Affecting Valuation of Goodwill – Methods of Valuation – Average Profit Method – Super Profit Method – Annuity Method-Capitalization Method-Valuation of Shares – Need for Valuation –Factors Affecting valuation of Shares- Net Asset Method – Yield Method – Fair Value-Practical Problems

Level of Knowledge - Conceptual

Meaning – Calculation of Profit with the help of Time –Sales – Weighted Ratio’s- Ascertainment of Profit or Loss Prior to Incorporation-Problems related to Trading and Profit and Loss Accounts based on sales ratios, time ratios and weighted ratios.

1.  S. Anil Kumar, B. Mariyappa and V. Rajesh Kumar (2017) Corporate Accounting (1^St Edition). Mumbai: Himalayan Publishing House.

2. M.C. Shukla, T.S. Grewal & S.C. Gupta (2016) Advanced Accountancy. New Delhi: S. Chand & Company Ltd.

3. R.L. Gupta & M. Radhaswamy (2014), Advanced Accountancy. New Delhi: S Chand & Sons.

4. Dr. Maheshwari S.N & Dr. Maheshwari S.K, Advanced Accountancy, (2017), Vol.1, Vol.-2.New Delhi: Vikas Publishing House Pvt. Ltd.

Course Description

The paper is offered to provide wide knowledge of the financial system and services available in India. It also equips students with a sound understanding of the Financial Markets. As a prerequisite, students should be familiar with the conceptual understanding of the financial system in the economy. It helps to learn different financial services and products. The students will also learn how the financial services firm’s works and the innovative products and services offered by them.

Level of Knowledge: Basic and Conceptual

Financial System, Financial Assets, Financial Intermediaries, Financial Markets, Classification, Components of Financial Market, Formal and Informal Financial Sectors, Financial Instruments, Multiplicity of Financial Instruments, New Financial Instruments. Key Elements of well-functioning Financial System, Financial Sector Reforms: Narasimham Committee Report 1991and 1998. Indicators of Financial Development.

Level of Knowledge: Basic and Conceptual

Definition, Money Market and Capital Market and their Features, Objectives, Features of a Developed Money Market, Importance of Money Market, Composition of Money Market, Money Market Instruments, Structure of Indian Money Market, Features of Indian Money Market, Call Money Market, Recent Developments, the role of RBI and Commercial Banks in the Indian Money market - The Impact of credit policy of RBI on financial markets, Inflation index, WPI & CPI

Level of Knowledge: Basic and Conceptual

Capital markets- meaning; Classification of the capital market; growth of stock exchange, stockbrokers, functions of the stock exchange, Margin trading, Forward trading, Sensex, Nifty, OTCEI (over the counter exchange of India), Depositories, SEBI as capital market regulator - Objectives, Functions, Powers, Organization, SEBI and government, SEBI guidelines on primary markets, secondary markets, book building, buyback of shares. Derivatives in India- Introduction to Financial and Commodity Derivatives.

Level of Knowledge: Conceptual

Meaning-features of financial services-Classification-scope-Fund-Based Activities-Non-fund-based Activities- Modern Activities  -Sources of Revenue- causes of Financial  Innovation – Financial  Services and  promotions of Industries – Innovation in finance – Fintech  – Insuretech – Regtech - Treds Platform- Distributed Ledger Technology/Artificial Intelligence in financial service – Regulatory Sandbox of RBI and IRDAI  - Automated wealth management/Robo- advisors- Challenges Facing the Financial  Service  sector-Present  Scenario. NBFC’s in India- Functions and Role.

Level of Knowledge: Conceptual

Definition- origin merchant  banking  in  India-merchant  banks  and  commercial  banks –services of merchant banks-qualities  required  of  merchant  bankers –merchant  bankers  as  lead  managers-guidelines-merchant  bankers  commission –Scope of Merchant  Banking in India – Prohibition of  Fraudulent  and Unfair  Trade Practices Relating to the Securities-Market regulation- Prohibition  on  Dealing /Communicating/Counselling  on Matters  Relating to Insider Trading- Issue of capital and Disclosure  Requirements  Regulations  -  SEBI  issue and Listing of Debt Securities  Regulation (Last amendment)

Level of Knowledge: Conceptual

Concept - Meaning-Features- Activities of VC Funds- Scope of Venture capital - Importance-Origin-Initiative in India - Venture capital Guidelines - Methods of Venture Financing - Factoring-Meaning - Modus operandi-Terms and conditions-Functions-Types of factoring- Factoring vs Discounting - Cost of factoring-Benefits – Factoring in India-International Factoring. Securitisation of Debt. Credit Rating in India. Credit Rating agencies in India.

2.       M Y Khan (2017).  Financial services. India:  Tata McGraw-Hill Education India

Course Description

This paper is offered as a core paper in the third semester. It develops and creates cost consciousness among the students and prepares students for careers in the areas of costing. Students will be aware of various aspects of cost, cost classification and also decision making skills in terms of cost benefit and profit. As a prerequisite, students should have a basic knowledge about the concepts relating to cost, costing, and cost accounting.

Level of Knowledge: Conceptual and Analytical

Meaning, objectives and advantages of cost accounting; Difference between cost accounting and financial accounting; Cost concepts and classifications; Elements of cost; Installation of a Costing system; Format of Cost Sheet - Tenders and Quotations (Problems on above).

Level of Knowledge: Conceptual and Analytical

(a)   Materials: Material/inventory control techniques. Accounting and control of purchases, storage and issue of materials. Materials Stock Level, Methods of pricing of materials issues — FIFO, LIFO, Simple and Weighted Average methods.

(b)   Labour: Accounting and Control of labour cost; time keeping and time booking. Concept and treatment of idle time, over time, labour turnover and fringe benefits. Methods of wage payment and the Incentive schemes- Halsey and Rowan only

Level of Knowledge: Conceptual and Analytical

Collections and Classification of Overheads - Allocation & Apportionment – Primary Distribution - Secondary Distribution - Reapportionment of Service Department Costs to Production Departments (Simultaneous Equation Method only); absorption of Overheads and Computation of Machine Hour Rate.

Level of Knowledge: Conceptual and Analytical

(a)   Job and Batch Costing - Meaning - Features of Job Costing - Types of Job Costing - Preparation of Job Cost Sheet - Batch Costing – Meaning - Its Application

(b)   Contract Costing -  Definition - Difference between Job Costing and Contract Costing - Contract Ledger - Ascertainment of Profit/Loss on Contract – Work In Progress and Balance Sheet - Cost Plus and Estimated Contracts

Level of Knowledge: Conceptual and Analytical

(a)   Process Costing - Normal Loss - Abnormal Loss/gain - (Including Inter-Process Profit and Equivalent Production) Preparation of Process Accounts and Joint and By-Products (theory only).

(b)   Operating Costing – Concept - Features - Performa of Operating Costing and Problems on Transport Costing Only

Level of Knowledge: Conceptual and Analytical

Target Costing, Life cycle Costing, Activity based Costing (including simple problems), Transfer pricing and Throughput Accounting – Theory of Constraint

2.      Arora M. N.(2016).Methods and Techniques of  Cost Accounting(4th ed.). India: Himalaya Publishing House.

Course Description

This paper aims to develop conceptual knowledge on the overview of marketing and understanding on Segmentation, Targeting and positioning approach. Importance of branding is to familiarize concepts of developing a brand as these days’ marketers feel the need to strongly position their brands in the mind of the consumers. The course also aims to provide better understanding on how marketing communication plays an important role in business. Rapid transformation in communication & information technology and need for higher level of customer orientation have made sales and distribution management extremely important which can be understood in par with marketing concept. Using real-world applications in the marketing domain, this course will help the student community to understand the tools and strategies used to make data-driven decisions for smooth marketing function.

Course learning Objectives

• To understand and appreciate the concept of marketing in theory and practice
• To understand and apply the STP of marketing (segmentation, targeting, positioning
• To have an elementary knowledge on customer satisfaction, loyalty and value chain concept
• To understand the role and scope of brands, brand equity and brand positioning
• Understanding the concept of sales management and the roles and responsibilities of salesmanship to explore the service marketing domain.

Level of Knowledge: Basic 

Defining Marketing in 21st Century – Importance – Scope – Marketing Mix. Issues and challenges in marketing in India-marketing for social cause. Building customer satisfaction, value, loyalty, retention.

Marketing strategy-types.Levels of Market Segmentation – Segmenting Consumer Markets – Bases for Segmenting Business Markets – Market Targeting – Case Study. Role & Scope of Brands – Brand Equity – Devising a Branding Strategy – Brand Positioning – Developing & Communicating a Positioning Strategy – Writing Positioning Statement – Differentiation Strategies – Case Study. Value position and USP.

Salesmanship: Meaning, Definition, Characteristics, Concept, Kinds, Nature, Evolution, and Psychology in Selling, Functions and Importance.Service Marketing Applications in Marketing of Financial Services- Need and scope - Regulating frame work of financial services Marketing of hospitality hospital, tourism and the regulatory frame work.

Marketing communication process-Promotional tools-factors in setting marketing communication  mix-measuring  communication  results-AIDA-DAGMAR.Integrated Marketing Communications (IMC).Ethics and social responsibility in IMC campaigns.

Introduction-Meaning of Marketing Research- Characteristics-Types-scope- Marketing Research process-Mystery marketing an overview. Introduction to Big data-Content marketing communities-Conversion rate optimization-Internet of Things (IoT) marketing applications-Mobile marketing-Paid search marketing- e commerce.

Marketing Analytics as an enabler of Marketing Strategy- Pricing and Revenue Management- Point-of-sale Data- Assortment Optimization- shelf-space optimization- Market Basket Analysis- Marketing Budget  Optimization  across  Channels-  Future  of  Marketing Analytics.

1.  Kotler, P. and Keller, K. (2012).Marketing management.Boston, Mass.: Prentice Hall/Pearson.
2. Clow, K., &Baack, D. (2012).Cases in marketing management.Thousand Oaks, Calif.: SAGE.

Students shall undertake 30 hours’ project work with any registered NGO across the country during summer vacation, at the end of the second semester. A project report in the prescribed format shall be submitted in the beginning of the third semester. Assessment will be based on evaluation of report. The project carries two credits that will be included in the third semester marks card.

Tenure: 20 May 2023 - 5 July 2023

Evaluation: 50 marks, which will be converted into 2 credits

*

 Report submission and viva will be evaluated for 50 marks

Course Description

This course is framed to help young adults (aged 18-26) develop healthy food habits, understand their bodies and that of the opposite gender, and improve their attitudes towards their health (physical and mental), hygiene, sexual and reproductive health; and become responsible social citizens and develop digital behaviours.

Healthy Eating Plate – Eating Disorders & its Types – Mental Disorders & its Types, Stress – Sleep – Signs of Suicide, Gatekeeper Training, First Aid, Fire and Safety, and CPR (Cardiopulmonary resuscitation)

Relationships between family and friends – types of friend circles, the importance of choosing the right friendships – Differences between Love-Lust-Infactuation – Gender Identity – LGBTQ – Dating – Consent – Personal skills (communication in relationships, negotiation, decision-making, art of listening), boundary setting, Domestic Violence, and Positive Parenting and Family Education Programs (Session for the parents), Counseling and Mentoring

The reproductive system of both girls and boys – Body Positivity – Menstrual Cycle – Safe sex – Recognize Boundaries – STI’S – Contraception – Teen Pregnancies – Making smart sexual decisions – sexual harassment issues – pornography addiction–Hookup Culture.

ATOD (Alcohol, Tobacco, and Other Drugs) - Types & Way of Intake & Effect on the Body – E-cigarette/Vaping – Illegal Drugs & Substance abuse/OTC (Over The Counter) - Early Detection

By: Erika Moen and Matthew Nolan

2.      The Complete Book of Sex Education

By: Dr. Rajan Bhonsle

3.      You Can Do It: Health, wellness, and healthy living for those who have tried everything else

By: Jasinda Wilder

4.      High: Everything You Want to Know About Drugs, Alcohol, and Addiction

By: David Sheff

5.      Essentials of medical pharmacology

By: KD Tripathi

Course Description

This is an introductory course that provides required knowledge about programming. The course covers problem solving techniques and logic building using tools like flowchart and algorithm.  This course also introduces the basic concepts of C programming language. Course includes a few exercises to make sure the student has not only gained the knowledge but can also apply and execute it.

Course Objectives​

This course will help the learner to

·       Understand the various number systems and their representation.

·       Analyze real life problem statements to enhance problem solving skills using flowchart and algorithm

·       Develop a program that is the foundation of any programming language

 Introduction, Basic block diagram and functions of various components of computer, Concept of Hardware and Software, Types of software, Compiler and Interpreter.

Basic Difference between Procedure Oriented Language and Object Oriented Language, Concepts of Machine level, Assembly level and High level programming, Flow charts and Algorithms.

Features of C language, structure of C program, comments, header files, data types, constants and variables, operators, expressions, evaluation of expressions, type conversion, precedence and associativity, I/O function.

Concept of array, One and Two dimensional arrays, declaration and initialization of arrays, String, String storage, Built-in string functions.

Simple statements, Decision making statements, Looping statements, Nesting of control structures, break and continue statement, goto statement.

2. Balagurusamy E., Programming in ANSI C, 6th Edition, Tata McGraw-Hill,2012.

3. Deitel H M and Deitel P J, C - How to Program, 5th Edition, Prentice-Hall, 2006.

The power of Excel goes beyond working with numbers and formulas. Automating the working of Excel is a much sought after skill for today’s smart working needs. The course is designed for any student who possesses working knowledge in MS Excel.

Course Objectives​

 This course will help the learner to

• Understand the various advanced formulas of Excel. 

• Analyze on macro recorder versus VBA.

• Develop a VBA program that is the foundation of any programming language

• Develop the real-world Macro/VBA projects from beginning to end.

Prerequisites

• Basic Excel Knowledge is a strict prerequisite for this course.

Templates, Efficiency, and Risk (Standard Deviation, Variance, and Coefficient of Variation), Data Validation; *Functions and Power functions, Array Formulae (Frequency Distribution, mode.mutt, mode.sngl), Tables, Advanced Range Names, What-if-analysis: Goal-seek, Data tables, and Scenario Manager; Data analysis ToolPak: Descriptive Statistics, Moving averages, Histogram, Covariance, correlation, and Regression analysis (only for projection); solver add- in. Problem Solving using Solver (optimal product mix, workforce scheduling, transportation, capital budgeting, financial planning), Integrating excel with other tools: MS word, outlook, PowerPoint, Access, Power BI.

Index and Match, Offset, Dynamic Charting, Database functions, Text functions, and Error functions: IfError, IsError, Aggregate, Circular Reference, Formula Auditing, Floating-Point Errors, Form Controls (Button, Combo, Check box, Spinner, List, Option), Visual Basic (only basic). Recording Macros, Absolute and relative macros, editing macros, Use of spinner buttons and command buttons; Sub Procedure, Function Procedure (creating New Functions); Working with Loops: Do_while loop, For_Next loop; Creating User Forms: Message Box, Input Box; If_Then_Else.

Conditional Formatting, Charts that Inspire (Waterfall, Column, Line, Combo, Thermometer, Scatter, Histogram) Slicers, Sparklines, Graphics Tricks and Techniques, Worksheet Automation using Macros: Absolute and relative macros, editing macros, Creating new functions using macros, Use of spinner buttons and command buttons.

Develop a macro - Recording The Macro - Examining The Macro - Saving Workbooks That Contain Macros - Format worksheets using macros - Perform calculations

1. Excel 2016 Power Programming with VBA, Michael Alexander, Dick Kusleika, Wiley. Financial Analysis and Modelling Using Excel and VBA, Chandan Sengupta, Second Edition, Wiley Student Edition.

1. MS Excel 2016, Data Analysis & Business Modelling, Wayne Winston, PHI.

Course Description:

Basic proficiency in Excel has become a prerequisite skill in most of the organizations. This course intends to make the students familiar with the basics of Microsoft excel.  The course introduces the students to financial and statistical analysis, further the course also deals with practical application of Microsoft excel in day to day business activities.  As a prerequisite, the students should have basic knowledge about computers and MS Office.

Spreadsheets - Workbook - Cell Referencing, Cell Addressing, File Menu; Home Menu, Conditional Formatting, Formatting as a Table, Cell Styles, AutoSum, Sort and Filter; Insert Menu, Inserting Tables and Pivot Tables, Smart Arts, Charts;   Page Layout, Review and View Menus; Converting Text to Columns, Removing Duplicates, Data Validation, Grouping and Ungrouping.

Financial Functions: Depreciation (DB, DDB, VDB), Simple Interest (PMT, NPER, INTRATE) - Present Value, Net Present Value, Future Value ( PV, NPV, FV) - Internal Rate of Return (IRR, MIRR); Logical Functions: AND, OR,NOT, IF, TRUE; Text Functions: UPPER, LOWER, LEFT, RIGHT, TRIM, T, TEXT, LEN, DOLLAR, EXACT; Practical exercises based on Financial, Logical and Text functions.

Statistical Functions: Mean, Median, Mode, Standard Deviation, Correlation, Skewness, F Test, Z Test, Chi-Square Analysis; Date & Time Functions: DATE, DATEVALUE, DAY, DAYS360, NOW, TIME, TIMEVALUE, WORKDAY, WEEKDAY, YEAR; Lookup and Reference Functions: HLOOKUP, VLOOKUP, TRANSPOSE, GETPIVOTDATA, HYPERLINK; Practical Exercises based on Statistical, Date & Time, Lookup and Reference functions.

Ratio Analysis, Cash Flow Statement, Payroll Processing, Marketing, Sales and Advertising Data Analytics, Social Media Marketing Analysis, Basic applications with Macros and VBAs; Trending business applications using MS Excel.

1. https://ptgmedia.pearsoncmg.com/images/9780735699236/.../9780735699236.pdf

2. www.excel-easy.com

3. https://excelexposure.com

4 .https://www.microsoft.com/en-in/education/products/office/default.aspx

5. www.excelmadeeasy.com

6. Excel is fun in YouTube

Course Description

This course provides working knowledge of auditing and inspection of accounts books of companies, firms etc. It also includes legal provisions in this connection as per the Companies Act in India. As a prerequisite, students should have basic knowledge about company, accounts, and audit.

Level of Knowledge: Basic & Conceptual

Origin of audit, meaning, definition, purpose and functions of audit, factors responsible for the growth of auditing, advantages and limitations of audit- Difference between book keeping, accountancy and audit, Objects of Audit– Main object & Secondary objectives, Errors, Location of errors, Position of Auditors in relation to errors & frauds,  different types of audit and their relative advantages, statutory audit- partial audit- cash audit- interim audit, balance sheet audit, cost audit and occasions audit; Investigation- Meaning, difference between Investigation and Auditing; Investigation regarding business purchase and investments, Professional ethics of an auditor

Level of Knowledge: Basic & Working

Preparations before audit- preparations by the auditor– considerations at the commencement of audit, audit program, audit files, audit note book, audit working papers. Procedure of audit - adoption of distinctive ticks–`-routine checking- Test checking.

Level of Knowledge: Basic & Working                             

(A) Internal Control: Meaning, Importance, Elements for internal control. Evaluation of internal control system - Internal control questionnaire;

(B) Internal Check: Meaning, definitions, fundamental principles, internal check as regards wages, cash sales, cash purchases, internal check in a store;

(C) Internal Audit: Meaning, importance advantages and limitations; Differences between Internal audit and statutory audit.

Level of Knowledge: Conceptual & Working

Meaning, definition, importance of vouching, routine checking and vouching, voucher types of vouchers, vouching of receipts, vocation of cash sales, receipts from debtors, bills receivable, proceeds from the sale of investments and buildings; Vouching of payments - vouching of cash purchases - payments of creditors, bills payables, purchase of building, plant and machinery and patent rights, vouching of deferred revenue expenditure - preliminary expenses, cost of issue of shares and debentures, under writing commission.

Level of Knowledge: Conceptual & Working      

Definition general principles, difference between verification and valuation - Auditor’s position as regards valuation of assets - Verification and valuation of fixed assets- good will- land and building - plant and machinery - patents and trademarks – investments - Current assets - cash in hand, cash at bank, sundry debtors, stock in trade and bills receivable, methods of valuing stock in trade, verification of liabilities, sundry creditors, bills payable, outstanding expenses and contingent liabilities.

Level of Knowledge: Conceptual & Working                  

Company Auditor:-Appointment, qualifications and removal, powers, duties and liabilities of an auditor- civil and criminal.

Audit of Limited Companies- Audit of financial statements – Balance sheet & Profit & Loss account, Contents of Audit Report – types of report audit reports. Audit of Share Capital and Transfer of Shares, Profits vs. divisible profits -  Kinds of reserves - specific, general capital and reserves, duties of an auditor, legal provision and reserves, provisions as to payment of dividend.