3rd Semester Syllabus
3rd Semester Syllabus
2 Sem 3 P-5: Corporate 4 P-5: Income Tax Laws 4 Q3: Information 2 CC-2: Work Stress 2 20 Diploma
Accounting & Accounts Systems & E- Management /
Business Interview
Preparation and
Planning/
Behavioural
Economics
P-6: Statistical Methods 4 P-6: Managing Human 4
Resources
Sem 4 P-7: Contemporary 4 P-7: Institutional 4 Q-4: Goods and 2 VC-2: Digital 2 20
Audit Framework for Services Tax Literacy/
Business Entrepreneurship/
Data Analysis using
Spread Sheet
P-8: Macro Economics 4 P-8: Banking 4
Operations
Note:
1. Students will have to pass the Rashtra Gaurav for obtaining certificate, diploma, undergraduate degree or graduation honours with research, only once.
2. CC- Co-curricular course, select any one out of three.
3. VC- Vocational Course, select any one out of three.
B.Com. – Semester III
Unit I:
Meaning and kinds of shares, issue, forfeiture and re-issue of forfeited shares, Redemption of
Preference shares, Bonus shares. Meaning and kinds of Debentures – their issue and
redemption.
Unit II:
Concept of amalgamation and absorption; AS14 and Types of Amalgamation; Purchase
Consideration; Accounting in the Books of Transferor of Company; Accounting in the Books
of Transferee Company.
Unit III:
Concept of Reconstruction; Need of Reconstruction; Types of Reconstruction-Internal
Reconstruction and External reconstruction; Alteration in Share capital; Reduction in share
capital; Scheme of Accounting for Internal Reconstruction.
Unit IV:
Concept of Winding up of Companies; Preparation of Statement of Affairs and Deficiency
Account; Preparation of Liquidator's Final Statement of Account.
References:
Text Books
• Maheshwari, S. N.: Corporate Accounting, Vikas Publishing House, New Delhi
• Jaiswal B, Shimpi L & Srivastava SK: Corporate Accounting
• Jha, B. K. and Shah, M. S.: Corporate Accounting.
Suggested Readings
• Roth, Martin: Analysing Company Accounts
• Shukla, M. C., Grewal, T. S. and Gupta, S. C.: Advanced Accounts: S. Chand &
Co., New Delhi
• Moore, C. L. and Jaedicke, R. K. Managerial Accounting
Web References:
• Bloomfield, Stephen: Understanding and Interpreting Company Accounts: A
Practical guide
• Groves, R. E.V., Pendlebury, M.– Company Accounts: Analysis, Interpretation
and Understanding
Credit:04
T:4 Lectures per week
Course Outcome:
• The course content of this paper has been designed with the assumption that students
have no knowledge or rudimentary knowledge of Business Statistics.
• The purpose is to enhance student’s understanding of the fundamentals of statistics.
• In this paper the students will be imparted the knowledge about the measures of
descriptive as well analytical statistics and their application in different fields. These
fields may in clued business, trade, industry, macro-economic indicators, social
phenomenon, day today activities etc.
• Through the study of this paper, students will become acquainted with specific skills
of data collection, processing, presentation and application of statistical tools on these
data. This is how they will know the characteristics of data and learn analysis,
interpretation and prediction of unknown data.
Unit–I
Introduction: Nature and scope of statistics, Definition of statistics. Law of Statistical
Regularity: Law of Inertia of Large Numbers. Census and Sampling, Methods of
Sampling, Types and Characteristics of Statistical Unit. Methods and instruments of
data collection.
Unit–II
Classification and Tabulation – Objects, general rules for the construction of tables.
Measures of Central Tendency: Mean–Simple and Weighted, Mode, Harmonic and
Geometric Mean; Positional Averages- Median, Quartile and Percentiles.
Unit–III
Measures of Dispersion, Skewness and Kurtosis – Range, Quartile Deviation, Mean
Deviation, Standard Deviation and their coefficients; Measures of Skewness and
Kurtosis. Correlation Analysis–Scatter diagram, Karl Pearson’s coefficient of
correlation, Spearman’s ranking method.
Unit–IV
Regression Analysis – Linear regression, regression lines, regression equations.
Interpolation–Assumptions, Binomial, Newton’s advancing differences, Larganges’ methods
References:
Text Books:
J. K. Sharma, Business Statistics
S. C. Gupta, Fundamentals of Statistics
S. P. Gupta and Archana Gupta, Elementary Statistics
Anoop Kumar Singh, Statistical Methods (English)
Anoop Kumar Singh, Statistical Methods (Hindi)
Suggested Readings :
Richard Levin and David S. Rubin, Statistics for Management
M. R. Spiegel, Theory and Problems of Statistics, Schaum’s Outlines Series
Web References :
https://nptel.ac.in/courses/110/107/110107114/
https://nptel.ac.in/courses/111/105/111105077/
https://onlinecourses.nptel.ac.in/noc21_ma74/preview
https://ocw.mit.edu/courses/mathematics/18-650-statistics-for-
applications-fall-2016/
https://ocw.mit.edu/courses/sloan-school-of-management/15-075j-
statistical-thinking-and-data-analysis-fall-2011/
Unit-I: Basic Concepts: Income, agricultural income, casual income, assessment year,
previous year, gross total income, total income, person. Tax evasion, avoidance and
tax planning, Basics of Charge; Scope of total income, residence and tax liability,
income which does not form part of total income, deduction from Gross total income.
Unit-II: Heads of the Income: Salaries; Income from house property; Profit and gains
of business and profession. Capital gains; Income from other sources.
Unit-III: Deemed income: Aggregation of Income, Set-off and carry forward of losses; Tax
Authorities; Assessment procedures
References:
Text Books
Shukla S. K.– Income Tax: Laws and Accounts (Hindi & English)
Mehrotra, H. C.– Income Tax Law & Accounts
Suggested Readings
Dinker Pagare: Income Tax Law and Practice; Sultan Chand & Sons, New Delhi
Grish Ahuja & Ravi Gupta, Systematic approach to income tax, Sahitya Bhawan
publication, New Delhi.
Web References
Singhania V.K.– Students, Guide of Income Tax, Taxman, Delhi
Prasad, Bhagwati: Income Tax Law & Practice; Wiley Publication, New Delhi
Course Outcomes
Upon successful completion of this course the students will be able to:
Develop the basic understanding out the importance of HR function
LearnthevariousconceptsofHumanResourceManagementprocessesrequiredtoIn
duct and recruit the employees
Develop the basic knowledge of Training and Performance Appraisal of
employees
Learn important issues related to Compensation and Wage Administration
Unit I: Nature and Concept of HRM: Human Resource Management: Importance of HRM
and present - day challenges, Human Resource Planning: The process of Human Resource
Planning, Limitations
Unit II: Job Analysis: Process of Job-analysis and Design: Job Description, Job
Specification and Job Design. Recruitment, Selection and Placement: Factors affecting
Recruitment, Process of Recruitment, Sources of Recruitment. Process of Selection-
Stages; Socialization and Induction; Promotions, Demotions, Transfers and
Separations.
Unit III: Training & Development: Training objective, Process and methods,
Management Development, Performance Appraisal: Methods of Performance
Appraisal, Possible Errors in Appraisal Process, Planning for Performance
Improvement.
Textbooks
Bimal Jaiswal & Deepak Verma- Managing Human Resources, NRBC
C.B. Gupta, Human Resource Management- Text and Cases. Sultan
Chand and Sons,
J.P. Mahajan, Ravindra Singh, Human Resource Management. Vikas
Publishing.
L. M. Prasad, Human Resource Management. Sultan Chand and Sons
V. S. P Rao, Human Resource Management (CBCS). Taxmann
Reference Books
Web Resources
https://www.digitalhrtech.com/human-resource-basics/
https://www.hrdconnect.com/2019/05/22/what-is-hr-management-in-an-organisation/
https://open.lib.umn.edu/humanresourcemanagement/chapter/1-1-what-is-human-
resources/
https://www.inc.com/encyclopedia/human-resource-management.html
Minor – Q3: Information Systems and E-Business
Credit:04
Course Objectives
The course aims to develop basic understanding of Information Systems and E-
commerce, and the role in Business Organizations with a focus on the development
and application of various Information Systems using Information Technology.
Course Outcome
Upon successful completion of this course the students will be able to:
Develop the functional knowledge of Computer Systems
Develop the thorough understanding of various Information Systems with
particular focus on DSS, MIS, TP, EIS and, CRM Systems
Understand the basic knowledge of the applications of Data base Management
Systems and their development
Understand the concepts of E-Commerce with an application orientation
Unit II: Introduction to Information Systems, business applications and its benefits,
functional and cross functional Information Systems, Transaction Processing Systems,
Electronic Data Interchange, Online Analytical Processing, Management Information
Systems, Decision Support Systems, Executive Information Systems, Executive
Support Systems, Enterprise applications, Supply Chain Management Systems,
Customer Relationship Management Systems.
Unit III: Concept of Database and Database Management System, centralized and
distributed Database Systems, Planning and designing of Information Systems, System
Flow Charts, traditional System Development Life Cycle, modern System
Development Methods, Implementing Information Systems as planned organizational
change.
Unit IV: Concept of E-commerce, Digital Markets and Digital Goods, advantages and
disadvantages of transacting online, types of E-commerce and M-commerce, E-
commerce business models, e-payment systems, digital signatures.
Text Books:
Peter Norton– Introduction to Computers: McGraw Hill
Leon- Introduction to Computers: Vikas Publications
Satish Jain – Computers in Business Management: BPB Publications
Reference Books:
Kenneth C. Laudon – Management Information Systems: Pearson
James A. O’ Brien- Management Information Systems: Hill
Girdhar Joshi- Management Information Systems: Oxford
Waman S. Jawadekar -Management Information Systems: McGraw Hill
Web References
https://www.techopedia.com/definition/24142/information-system-is
https://opentextbook.site/informationsystems2019/chapter/chapter-1-what-is-
an-information-system-information-systems-introduction/
https://altametrics.com/en/information-systems/information-system-
types.html
Co-Curricular
Credit:02
T: 2 Lectures per week
References:
Text Books
1. John, W. Newstrom – Organisational Behaviour: Human Behaviour at Work.
2. Tapomoy, Deb – HRD: Theory and Practice
3. Saran, U. – Stress Management
Suggested Readings
1. Rao, VSP – Human Resource Management
2. Charlesworth, E.A. & Nathan, R.G. – Stress Management
3. Sumanthi, P. Kumar & Rohini, A.R. – Stress Management
Web References
1. Michie, S. – Causes & Management of Stress at Work
Course Objectives:
1. To assess personal strengths and weaknesses
2. To develop communication skills.
3. To develop resume writing skill and practice mock interviews.
4. To learn manage stress and time effectively.
Course Outcomes: After attending this course, the student shall be able to:
1. Identify personal strength and weaknesses.
2. Communicate effectively.
3. Craft effective resumes.
4. Understand the techniques for managing time and stress.
Unit I: Self-assessment: Personal strengths, weaknesses, skills, and interests; Communication Skills;
Verbal and non-verbal communication, Body Language; Diction and accent
Unit Il:Business writing skills: composing professional emails, letters, memos, notices and reports;
Resume and Cover Letter Writing skill; Negotiation skills: techniques and strategies.
Unit IlI:Mock Interviews: Practical Application through Simulated Interviews; Group Discussions;
General knowledge and General awareness, Dressing up and grooming; Multitasking ability.
Unit IV:Corporate etiquettes, netiquettes, Cross cultural communication, Time management and it’s
techniques;Stress Management and its techniques; Work ethics: importance of ethical conduct,
integrity, and professionalism in the workplace.
References:
1. Innes James. (2021). The Interview Book: How to Prepare and Perform at Your Best in Any
Interview.2 d Edition, Pearson:
2. Ferguson Cheryl. (2021). Interview Like Yourself... No, Really, 15 Edition, Wiley.
3. Baur Jean. (2021). The Essential Job Interview Handbook: A Quick and Handy Resource for
Every Job Seeker, 1st Edition, Adams Media.
4. Rogers Jenn. (2020). Job Interview Success: Be Your Own Coach, 1s’ Edition, Kogan Page.
5. Mathur D (2018). Mastering Interviews and Group Discussions, 4th Edition, CBS
6. Adler, R. B., & Elmhorst, J. M. (2018). Communicating at Work: Principles and Practices for
Business and the Professions. McGraw-Hill Education.
Course Objectives:
1. To assess personal strengths and weaknesses
2. To develop communication skills.
3. To develop resume writing skill and practice mock interviews.
4. To learn manage stress and time effectively.
Course Outcomes: After attending this course, the student shall be able to:
1. Identify personal strength and weaknesses.
2. Communicate effectively.
3. Craft effective resumes.
4. Understand the techniques for managing time and stress.
Unit I: Self-assessment: Personal strengths, weaknesses, skills, and interests; Communication Skills;
Verbal and non-verbal communication, Body Language; Diction and accent
Unit Il:Business writing skills: composing professional emails, letters, memos, notices and reports;
Resume and Cover Letter Writing skill; Negotiation skills: techniques and strategies.
Unit IlI:Mock Interviews: Practical Application through Simulated Interviews; Group Discussions;
General knowledge and General awareness, Dressing up and grooming; Multitasking ability.
Unit IV:Corporate etiquettes, netiquettes, Cross cultural communication, Time management and it’s
techniques;Stress Management and its techniques; Work ethics: importance of ethical conduct,
integrity, and professionalism in the workplace.
References:
1. Innes James. (2021). The Interview Book: How to Prepare and Perform at Your Best in Any
Interview.2 d Edition, Pearson:
2. Ferguson Cheryl. (2021). Interview Like Yourself... No, really! 15 Edition, Wiley.
3. Baur Jean. (2021). The Essential Job Interview Handbook: A Quick and Handy Resource for
Every Job Seeker, 1st Edition, Adams Media.
4. Rogers Jenn. (2020). Job Interview Success: Be Your Own Coach, 1s’ Edition, Kogan Page.
5. Mathur D (2018). Mastering Interviews and Group Discussions, 4th Edition, CBS
6. Adler, R. B., & Elmhorst, J. M. (2018). Communicating at Work: Principles and Practices for
Business and the Professions. McGraw-Hill Education.
Course outcomes-
After completion of this course, students will be able to:
get combined insights from psychology, judgement and decision making and economics and
hence generate a more accurate understanding of human behaviour.
Understand the subtle factors that govern customer choices.
Understand consumer and organisational/ business decision making.
Unit–I: Nature & Objectives of Auditing; Types of Audits, Auditing Techniques; Internal
Control & Internal Check Audit Programme, Audit Procedure, Routine checking, Test
checking
Unit–II: Vouching, Verification of Assets & Liabilities, Divisible Profit and Dividend,
Internal Audit, Investigation
Unit III: Government Audit, Audit of Limited Companies, Company Auditor: Appointment,
Remuneration, Powers, Duties and Liabilities, Audit report.
Unit–IV: Standards on Auditing, Audit of Special entities: Non-Profit Organisations,
Educational Institutions & Clubs, Cost Audit, Tax Audit and Management Audit
References:
Textbooks
Suggested Readings
Web References
Course Outcome:
Unit-I
Concept and scope of Macro-Economics; Macro-Economic Paradoxes: wage-
employment paradox and paradox of thrift, The Circular flow of Income and
expenditure.
The Analysis and Measurement of Economic Activity- National Income
Accounting: Concept and Definitions of National Income. Various components of
National Income, Methods of Measurement of National Income and Welfare.
Unit–II
Classical Macroeconomic Models – Say’s Law, Quantity Theory of Money, Wage-
Price Flexibility and Full employment.Aggregate Expenditure – Consumption
Function: Concepts of propensities of consumption and saving. Absolute Income
Hypothesis, Relative Income Hypothesis; Consumption Puzzle, and Permanent
Consumption Hypothesis. Investment Function: Types, Marginal Efficiency of
Capital (MEC) and Marginal Efficiency of Investment (MEI).
Unit–III
The Concept of Multiplier; National Income Determination in an Open Economy IS-LM
Analysis-Derivation of IS and LM Functions; Joint determination of National Income and
rate of Interest and Shift and IS and LM Curves
Unit-IV
Theory of Inflation – Meaning, types and measurement, Demand Pull and Cost Push
Inflation. The Philips Curve, Effects of Inflation, Anti-Inflation Policies– Monetary
and Fiscal Policies.Business Cycles – concept, types and phases; Keynes, Hawtrey,
Hicks Models.
References:
Text Books:
JV Vaishampayan, Macroeconomic Theory and Policy (Hindi&English)
K.L. Maheshwari & R.K. Maheshwari–Macro Economics
HL Ahuja, Macroeconomic Theory, S Chand Publication
DN Dwivedi, Macroeconomic Theory
Suggested Readings :
Dornbusch, Fischer and Startz, Macroeconomics
N. Gregory Mankiw. Macroeconomics
Richard T. Froyen, Macroeconomics
Errol D‘Souza, Macroeconomics
Web References :
https://nptel.ac.in/courses/109/104/109104073/
https://nptel.ac.in/noc/courses/noc15/SEM1/noc15-hs08/
https://onlinecourses.swayam2.ac.in/cec20_hs26/preview
https://onlinecourses.swayam2.ac.in/cec20_hs43/preview
https://ocw.mit.edu/courses/economics/14-02-principles-of-macroeconomics-
spring-2014/
https://ocw.mit.edu/courses/economics/14-05-intermediate-macroeconomics-
spring-2013/
http://hdl.handle.net/1721.1/86309
https://dbie.rbi.org.in/DBIE/dbie.rbi?site=home
Course Objectives
The course objective is to introduce the students with the institutional framework
which exists for monetary policies, credit availability for small as well as large and
rural as well as urban development, other developmental avenues for agricultural and
small industries, etc. Further, it is intended to apprise students with the Capital and
Investment related scenario and the institutions and people involved with stocks and
related domains. Finally, students will also discuss the latest trends and developments
like the insolvency and bankruptcy code, competitive commission, to name a few.
Course Outcomes
Upon successful completion of this course the students will be able understand how
the institutional framework for business will empower them to better locate
andemploytheopportunitiesavailableduringthecourseoffulfillingtheirdutiesinvarious
managerial roles. They would be able to take better decisions and design and provide
better value to both their respective organizations and the various stakeholders
involved. The knowledge of the institutional mechanisms will stand in good stead for
the budding entrepreneurs of tomorrow.
UNIT II: Regulatory bodies for financial and Investment markets in India: SEBI-roles
and functions, Important guidelines for Issue of capital Intermediaries /market
infrastructure institutions. Role and functions of Bankers to issue, Credit rating
agencies, Merchant banks, Mutual funds, Portfolio managers, Underwriters
UNIT III: Role and functions of Stock exchanges, Stock exchanges in India,
Prominent stock exchanges in India - BSE and NSE, Different types of instruments
and brokers: equity and equity derivatives, corporate debt market segment,
commodities derivatives market segment
Reference Books
Indian Economy: Performance & Policies, 8thEd.- Uma Kapila, Academic
Foundation, New Delhi
Global Business Environments & Strategies - A. Aregbeshola, J. Luiz, K.Ojah,
T.Oosthuizen, P. Palmer. P. Venter,
International Business Environment and Operations-John D.Daniels, Pearson
education
Web References: websites of RBI, SEBI, IRDA, BSE, NSE, IBEF etc.
Unit-II
Operational Aspect of commercial banks in India, relationship, Types of customer
account, Cheque & its types, Endorsement, Dishonour, Rights and liabilities of Paying
and collecting Banker, Time Value of money –calculation of interest on loan &
deposits, EMIs.
Unit-III
Negotiable Instruments, Bills of Exchange and Promissory notes, Rights and liabilities
of parties, Bills discounting and purchasing, Ancillary Services of the Bankers. E-
Banking
Unit-IV
Employment of funds by Commercial Banks, Types of securities, mode of creating
charge, Bank guarantees, Basel norms, financial sector reforms in India.
References:
Text Books:
Jaiswal Bimal: Banking Operations
Bhole L.M: Financial Institution & Markets
Desai Vasant: Financial Market & Institutions
Suggested Readings :
Current Annual RBI Bulletin
Current Economy Survey
Web References :
https://onlinecourses.swayam2.ac.in/imb21_mg18/preview
https://onlinecourses.swayam2.ac.in/imb20_mg39/preview
https://onlinecourses.nptel.ac.in/noc21_mg15/preview
https://onlinecourses.swayam2.ac.in/cec21_ge04/preview
https://onlinecourses.swayam2.ac.in/cec20_mg08/preview
http://www.universityofcalicut.info/SDE/Banking_on19May2016.pdf
http://egyankosh.ac.in/handle/123456789/21519
http://egyankosh.ac.in/handle/123456789/13620
References:
Text Books
1. Shukla, S.K. - GST in India (Hindi & English)
2. Singhania, V.K. - Students Guide to GST and Customs Law
3. Bansal, K.M. – Indirect Tax Laws
Suggested Readings
1. Bare Act of GST
Web References
1. Taxmann: Goods and Services Tax (Hindi & English)
VC-2 Vocational
VC-2 Digital Literacy
Credit:02 T:2Lectures per week
References:
Text Books
1. Saxena, S. - A First Course in Computers
2. Sinha, P.K. and Sinha, P. - Foundation of Computing
3. Bharihoka, D. - Fundaments of Information Technology
Suggested Readings
1. Rajaraman, V. Introduction to Information Technology
2. Hunt, R., Shelley, J. - Computers and Commonsense
Web References
1. Bergson, A. - The New Landscape of Digital Literacy.
VC-2 Entrepreneurship
Credit:02 T:2 Lectures per week
Course Objectives: This course aims to equip the students with practical knowledge and
skills essential for identifying, evaluating, and pursuing entrepreneurial opportunities. The
course emphasises the development of an entrepreneurial mindset, critical thinking, and
decision-making abilities necessary for initiating and managing a successful business venture.
Course Outcome:
Upon successful completion of this course the students will be able to:
1. Foster an entrepreneurial mindset, creativity, and resilience while promoting ethics,
social responsibility, and awareness of government support programs.
2. Identify and evaluate entrepreneurial opportunities effectively through market
research and financial analysis.
3. Develop comprehensive business plans integrating market, operational,
organisational, and financial aspects with sustainability principles.
4. Understand various financing options including bank funding, venture capital, and
crowdfunding, alongside self-funding strategies.
Unit 4: New ventures and financing of new ventureTypes of new ventures, Tax implications
of various forms of ventures, different phases of funding, Overview of financing options for
ventures: Bank funding, venture capital funding, lease financing, and crowdfunding
Understanding angel investors, venture capitalists, and other funding sources. Bootstrapping
and self-funding strategies for start-ups. Overview of government schemes and incentives for
start-ups.
Reference:
1. Kumari, P., & Kumari, S. (2024). A Textbook on Principles and Practices of
Entrepreneurship Development (February 14, 2024). Walnut Publication. ISBN-13:
979-8891710542
2. Kumar, D. (2024). Ecommerce Entrepreneurship: A Step-by-Step Guide for
Beginners (Zero to Winner'sBusiness Series Book 3). Kindle Edition.
3. Mathur, A. (2021). Entrepreneurship Development (July 2021 Edition). Taxmann.
ISBN-10: 9391596088, ISBN-13: 978-9391596088
4. Gupta, C. B. (2019). Entrepreneurship Development (Fourth Revised Edition). Sultan
Chand & Sons.
5. Bharathi, V., & Sivakumar, P. (2019). Entrepreneurship (Second Edition). Himalaya
Publishing House Desai, V. (2017). Entrepreneurship Development and Small
Business Enterprises (Second Revised Edition). Himalaya Publishing House
6. Drucker, P. F. (2006). Innovation and entrepreneurship: Practice and principles. USA:
Elsevier.
Course Objectives:
This course is designed to enable students to develop data analytical skills which are a pre-
requisite for a quality research and efficient business decision making. The use of
spreadsheets like Excel or Google sheet is widespread in the industry. It is a very powerful
data analysis tool and almost all big and small businesses use spreadsheets in their day-to-day
functioning. With greater human-computer interaction in each aspect of academia – teaching
and research, and work, this course will enable students with basic knowledge of data
analysis using spreadsheets.
Course Outcomes:
After studying this course, the students shall be:
1. Learn basic operations such as reading data into spreadsheet using various data formats,
organizing and manipulating data, to some of the more advanced functionality of spreadsheet.
2. Make meaningful representation of data in the form of charts and pivot tables.
3. Draw analysis on data using spreadsheets and use interpretation to make economic and
business decisions.
4. Manage data for generating queries, analysis and reports in the database.
5. Develop basic understanding of functions of spreadsheet.
Unit I
Introduction to Spreadsheets: Meaning of Spreadsheet, Uses of Excel software; Basic
introduction of various Tabs; Reading data into Excel using various formats; Basic functions
in Excel, arithmetic as well as various logical functions; Formatting rows and columns; Using
formulas in Excel and their copy and paste using absolute and relative referencing.
Unit II
Spreadsheet Functions to Organize Data: Arranging data using Columns & Rows, Changing
Column Width & Row Height, Autofitting Columns & Rows, Hiding/Unhiding Columns &
Rows, Components of a cell – Address, format, value, formula, Use of paste and paste
special. Using Formulas, Formula Functions – Sum, Average, if, Count, max, min, Proper,
Upper, Lower, Using AutoSum.
Unit III
Formula Functions: The IF, nested IF, VLOOKUP and the HLOOKUP functions of Excel.
Creating Charts- Line, Bar and Pie charts, Scatter plots, Histograms. Formatting Chart
Objects, Changing the Chart Type, Showing and Hiding the Legend, Showing and Hiding the
Data Table.
Unit IV
Pivot Tables -Creating Pivot Tables, manipulating a Pivot Table, Using the Pivot Table
Toolbar, Changing Data Field, Properties, displaying a Pivot Chart, Setting Pivot Table
Options, Adding Subtotals to PivotTables.
Text Books:
1. Microsoft Excel 2016 Data Analysis and Business Modelling, Wayne L. Winston, PHI>
2. Microsoft Excel 2016 Bible, John Walkenbach, Wiley.
3. Excel 2013 Charts and Graphs, Jelen, Pearson.
4. Excel 2013 Pivot Table Data Crunching, Jelen, Pearson.
Web Resources
1. https://support.microsoft.com/en-us/office/basic-tasks-in-excel-dc775dd1-fa52-430f-9c3c-
d998d1735fca
2. https://link.springer.com/book/10.1007/978-1-4842-6209-2
3. https://open.umn.edu/opentextbooks/textbooks/70